trees
953 rows where qSpecies_id = 60 sorted by qLegalStatus_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
953 | 4237 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4018 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003765.90932 | 2100430.48709 | 37.747595203776 | -122.429734255035 | (37.747595203776, -122.429734255035) | 2 | 4 | 5 | 63 | 22 | |||
1169 | 12272 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | 7 | 9 | 11 | 28852 | 10 | ||
1204 | 72270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | 9 | 7 | 6 | 28861 | 5 | |||
1684 | 65960 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.7404829512667 | -122.484029196034 | (37.7404829512667, -122.484029196034) | 1 | 8 | 3 | 29491 | 35 | |
2149 | 204638 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180 Staples Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5998850.55813 | 2093801.2422 | 37.7291133164211 | -122.446254382837 | (37.7291133164211, -122.446254382837) | 9 | 7 | 4 | 28861 | 40 | |||
2325 | 204652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 01:08:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.7193758368067 | -122.451924066956 | (37.7193758368067, -122.451924066956) | 9 | 8 | 6 | 28861 | 24 | ||
2438 | 262446 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | 6001156 | 2093630 | 37.7287745209628 | -122.438272037819 | (37.7287745209628, -122.438272037819) | 9 | 7 | 6 | 28861 | 25 | |||
2629 | 204636 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 5998882.21711 | 2093801.6387 | 37.7291162131397 | -122.446144964113 | (37.7291162131397, -122.446144964113) | 9 | 7 | 4 | 28861 | 40 | |||
3037 | 73418 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983001.5767 | 2098246.6338 | 37.7404012697688 | -122.50137340388 | (37.7404012697688, -122.50137340388) | 1 | 8 | 3 | 29491 | 35 | |||
3060 | 70445 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982997.1409 | 2098317.8833 | 37.7405966408958 | -122.501394010052 | (37.7405966408958, -122.501394010052) | 1 | 8 | 3 | 29491 | 35 | |||
3893 | 78349 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | 11 | 6 | 2 | 55 | 26 | |||
4049 | 185126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | 1 | 8 | 3 | 64 | 35 | |||
4319 | 71268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | 15 | 5 | 11 | 29492 | 16 | |||
4688 | 204667 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.450748183599 | (37.7330989075759, -122.450748183599) | 9 | 7 | 4 | 59 | 40 | |||
4922 | 152652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6008666.19749 | 2102064.94601 | 37.75235932814 | -122.412904832409 | (37.75235932814, -122.412904832409) | 2 | 4 | 7 | 28859 | 19 | |||
5060 | 141961 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | 7 | 9 | 11 | 28852 | 41 | |||
5527 | 204642 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995680.91746 | 2091957.81811 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | 9 | 8 | 4 | 28861 | 24 | |||
5780 | 261485 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
5884 | 44280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.82633 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | 10 | 3 | 8 | 58 | 1 | ||
6272 | 222570 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.436434178217 | (37.7496020939667, -122.436434178217) | 2 | 4 | 5 | 28862 | 22 | |||
7037 | 222537 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 540 28th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6002401.94091 | 2099473.87361 | 37.7448912373558 | -122.43438238755 | (37.7448912373558, -122.43438238755) | 2 | 7 | 5 | 63 | 22 | |||
8029 | 70268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002561.31186 | 2089826.69987 | 37.7184113400032 | -122.433142152308 | (37.7184113400032, -122.433142152308) | 9 | 7 | 6 | 28861 | 5 | |||
8402 | 164235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2443 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5991051.37597 | 2098768.01272 | 37.7423023040997 | -122.473578669836 | (37.7423023040997, -122.473578669836) | 1 | 8 | 4 | 29491 | 40 | |||
8829 | 141965 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | 7 | 9 | 11 | 28852 | 41 | |||
8978 | 71997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | 11 | 6 | 2 | 55 | 26 | |||
9074 | 27096 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 707 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6006037.72373 | 2093592.89407 | 37.7289490840269 | -122.421392939642 | (37.7289490840269, -122.421392939642) | 9 | 7 | 6 | 28861 | 5 | ||
9301 | 27189 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 262 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002929.54622 | 2093714.91608 | 37.7291083953197 | -122.432146839331 | (37.7291083953197, -122.432146839331) | 9 | 7 | 6 | 28861 | 25 | ||
10040 | 188312 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012939.88574 | 2105717.83125 | 37.7626283178769 | -122.398381909999 | (37.7626283178769, -122.398381909999) | 14 | 3 | 8 | 28856 | 29 | |||
10903 | 204646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 111 Ashton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994133.91606 | 2090657.47285 | 37.7202107871682 | -122.462332152117 | (37.7202107871682, -122.462332152117) | 9 | 8 | 6 | 28861 | 24 | |||
11071 | 27211 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003731.93996 | 2093466.46517 | 37.7284716654181 | -122.429355189899 | (37.7284716654181, -122.429355189899) | 9 | 7 | 6 | 28861 | 5 | ||
11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
11333 | 222507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.408160091111 | (37.7518194273238, -122.408160091111) | 2 | 4 | 7 | 28859 | 19 | |||
11406 | 72840 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | 1 | 8 | 3 | 29491 | 35 | |||
12104 | 204637 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5998869.73196 | 2093802.12764 | 37.7291168426482 | -122.446188161278 | (37.7291168426482, -122.446188161278) | 9 | 7 | 4 | 28861 | 40 | |||
12444 | 260536 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5983685.38782 | 2106695.21091 | 37.7636388518254 | -122.499633347112 | (37.7636388518254, -122.499633347112) | 1 | 8 | 3 | 56 | 35 | ||||
12538 | 38150 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 12:00:00 AM | 3 | 3x5 | Permit Number 780230 | 6010281.37407 | 2093721.85483 | 37.7295415331127 | -122.406731343599 | (37.7295415331127, -122.406731343599) | 10 | 3 | 7 | 309 | 28 |
12817 | 221354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.414009391436 | (37.7572740646699, -122.414009391436) | 2 | 4 | 7 | 28859 | 19 | |||
12947 | 252892 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
13343 | 69152 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.7640417272514 | -122.48906697906 | (37.7640417272514, -122.48906697906) | 1 | 8 | 3 | 56 | 35 | |
13532 | 170412 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 418 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6002130.67335 | 2093947.3581 | 37.7297013021565 | -122.434925220129 | (37.7297013021565, -122.434925220129) | 9 | 7 | 6 | 28861 | 25 | ||
14406 | 165740 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 119 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007607.32013 | 2098066.61783 | 37.7413213218322 | -122.41628344773 | (37.7413213218322, -122.41628344773) | 2 | 7 | 7 | 28859 | 2 | |||
14860 | 144376 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 390 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5986872.03276 | 2113312.07102 | 37.7819933565565 | -122.489098375585 | (37.7819933565565, -122.489098375585) | 11 | 6 | 2 | 55 | 26 | |||
15317 | 261202 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 699x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007339 | 2095419 | 37.7340364554683 | -122.417023656077 | (37.7340364554683, -122.417023656077) | 2 | 7 | 7 | 28859 | 2 | ||||
15684 | 204670 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999483.78605 | 2094717.68964 | 37.7316658109241 | -122.4441310961 | (37.7316658109241, -122.4441310961) | 9 | 7 | 4 | 63 | 40 | |||
15869 | 261717 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1983 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2020 12:00:00 AM | 3 | 4x4 | 5987209 | 2101791 | 37.7503793489945 | -122.487086227612 | (37.7503793489945, -122.487086227612) | 1 | 8 | 3 | 29491 | 35 | |
16342 | 71996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989363.9833 | 2113075.99146 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | 11 | 6 | 2 | 55 | 26 | |||
16761 | 72980 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.485044488235 | (37.7550761133303, -122.485044488235) | 1 | 8 | 3 | 56 | 35 | |||
16961 | 261483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
17042 | 116875 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | 10 | 3 | 8 | 28856 | 29 | |||
17381 | 78348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986606.5677 | 2110833.25993 | 37.7751717483754 | -122.489834389598 | (37.7751717483754, -122.489834389598) | 11 | 6 | 2 | 55 | 26 | |||
17436 | 153178 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 855 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6010194.64784 | 2104257.6801 | 37.7584657635091 | -122.407773780163 | (37.7584657635091, -122.407773780163) | 10 | 4 | 7 | 28859 | 19 | |||
17491 | 256739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1315 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 5989553.93379 | 2106395.50264 | 37.763158533492 | -122.479314183035 | (37.763158533492, -122.479314183035) | 1 | 8 | 3 | 56 | 35 | ||
17506 | 32483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.38914 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | 15 | 5 | 5 | 28862 | 3 | |
17548 | 252893 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
17900 | 262447 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 31 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001222 | 2093679 | 37.7289128173751 | -122.4380473805 | (37.7289128173751, -122.4380473805) | 9 | 7 | 6 | 28861 | 25 | ||
18161 | 56725 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015793.5491 | 2095580.2933 | 37.7349513047544 | -122.387804649295 | (37.7349513047544, -122.387804649295) | 10 | 3 | 8 | 58 | 1 | ||||
18261 | 204610 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1410 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990554.31015 | 2105766.55939 | 37.7614896754309 | -122.475808320295 | (37.7614896754309, -122.475808320295) | 1 | 8 | 4 | 56 | 12 | |||
18692 | 175790 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 79 Colby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | 9 | 3 | 7 | 309 | 28 | |||
19095 | 182316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2700X Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986474 | 2105095 | 37.7594083467555 | -122.489870843925 | (37.7594083467555, -122.489870843925) | 1 | 8 | 3 | 56 | 35 | |
19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
19519 | 222582 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001750.89139 | 2104845.17495 | 37.7596025695234 | -122.437018068443 | (37.7596025695234, -122.437018068443) | 2 | 4 | 5 | 28862 | 3 | |||
19828 | 27132 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.68156 | 2095938.36762 | 37.7357362666047 | -122.400161784365 | (37.7357362666047, -122.400161784365) | 10 | 3 | 8 | 58 | 1 | ||
19959 | 27186 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 246 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2x3 | 6002844.31593 | 2093767.70456 | 37.7292485078886 | -122.432445255941 | (37.7292485078886, -122.432445255941) | 9 | 7 | 6 | 28861 | 25 | ||
20019 | 66828 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | 15 | 6 | 2 | 54 | 16 | |
20379 | 221335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1641 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010542.34793 | 2100138.19824 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | 2 | 7 | 7 | 28859 | 2 | |||
20518 | 188347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 83 Scotia Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | 10 | 3 | 8 | 58 | 1 | |||
21788 | 26984 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1381 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009547.85305 | 2094416.1727 | 37.7314069136466 | -122.409316188794 | (37.7314069136466, -122.409316188794) | 9 | 3 | 7 | 309 | 28 | ||
22092 | 30745 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 486X Page St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) | 7 | 9 | 11 | 28852 | 10 |
22182 | 246011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | 15 | 5 | 11 | 29492 | 9 | |
22794 | 188356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017138.82287 | 2095616.15283 | 37.7351241988078 | -122.383156012747 | (37.7351241988078, -122.383156012747) | 10 | 3 | 8 | 58 | 1 | |||
22864 | 175789 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1038 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007776.24891 | 2093611.02457 | 37.7290967338157 | -122.415383996168 | (37.7290967338157, -122.415383996168) | 9 | 3 | 7 | 309 | 5 | |||
22879 | 248397 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | 15 | 5 | 11 | 29492 | 9 | |||
22997 | 26483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846 | (37.7426474144589, -122.43907493846) | 2 | 7 | 5 | 63 | 7 | ||
23954 | 221341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.425437478672 | (37.7469275767478, -122.425437478672) | 2 | 7 | 5 | 63 | 22 | |||
24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
24194 | 32579 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.7638481208517 | -122.492272911774 | (37.7638481208517, -122.492272911774) | 1 | 8 | 3 | 56 | 35 | |
24217 | 221347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558 | (37.7378588087266, -122.41024559558) | 10 | 7 | 7 | 28859 | 2 | |||
24389 | 221356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008902.61993 | 2103693.22479 | 37.7568434827621 | -122.412202312603 | (37.7568434827621, -122.412202312603) | 2 | 4 | 7 | 28859 | 19 | |||
24479 | 188293 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 1 | : | Tree | Private 2 | 19 | Width 5ft | 6008175.89918 | 2108871.24729 | 37.7710203298423 | -122.415082093787 | (37.7710203298423, -122.415082093787) | 8 | 2 | 9 | 28853 | 19 | |||
24510 | 204663 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000334.21865 | 2095199.11319 | 37.7330361672695 | -122.44122551784 | (37.7330361672695, -122.44122551784) | 9 | 7 | 5 | 63 | 40 | ||||
24546 | 22552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | 2 | 7 | 5 | 63 | 7 | ||
24772 | 221325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006242.86506 | 2104074.32841 | 37.7577403028851 | -122.42142781086 | (37.7577403028851, -122.42142781086) | 2 | 4 | 5 | 28859 | 19 | |||
24955 | 26493 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.7761801200302 | -122.426279843947 | (37.7761801200302, -122.426279843947) | 7 | 9 | 11 | 28852 | 10 | |||
25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
25180 | 30744 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.01831 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) | 7 | 9 | 11 | 28852 | 10 |
25487 | 222564 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007476.41433 | 2100201.58357 | 37.7471760989928 | -122.416887300207 | (37.7471760989928, -122.416887300207) | 2 | 7 | 7 | 28859 | 2 | |||
25949 | 30741 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
26108 | 204620 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | 1 | 8 | 4 | 56 | 12 | |||
26763 | 54426 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.7588416315494 | -122.400163199892 | (37.7588416315494, -122.400163199892) | 10 | 3 | 8 | 28856 | 29 | |
26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
27137 | 188340 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2080 Silver Ave | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6012583.47847 | 2096093.49596 | 37.7361821046275 | -122.398939075088 | (37.7361821046275, -122.398939075088) | 10 | 3 | 8 | 58 | 1 | |||
27809 | 188319 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101 | (37.7571363191045, -122.39902607101) | 10 | 3 | 8 | 28856 | 29 | |||
28325 | 26998 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.412124661535 | (37.7303936047791, -122.412124661535) | 9 | 3 | 7 | 309 | 28 | ||
28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
28920 | 204622 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.464883245465 | (37.7599558699739, -122.464883245465) | 1 | 8 | 4 | 56 | 12 | |||
29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
29876 | 204614 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | 1 | 8 | 4 | 56 | 12 | |||
29975 | 175763 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.7248656727096 | -122.40377805363 | (37.7248656727096, -122.40377805363) | 10 | 3 | 7 | 309 | 28 | |||
30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );