trees
66 rows where Supervisor Districts = 1 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
3331 | 250313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 772728 | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.458160192637 | (37.7895320612144, -122.458160192637) | 11 | 6 | 1 | 54 | 31 | ||
5619 | 60093 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 15 | Permit Number 19594 | 5998249.44913 | 2116202.11644 | 37.7905861601801 | -122.449946261722 | (37.7905861601801, -122.449946261722) | 13 | 6 | 1 | 54 | 31 | |
5816 | 130501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.8044333562689 | -122.444923170372 | (37.8044333562689, -122.444923170372) | 13 | 9 | 1 | 57 | 17 | |||
7782 | 101433 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
8038 | 250803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | 11 | 6 | 1 | 55 | 33 | |||
12949 | 59480 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | 13 | 6 | 1 | 54 | 31 | ||
15344 | 65541 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2146 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | Permit Number 28438 | 6002328.18536025 | 2114391.9672646 | 37.78584848917 | -122.435704529297 | (37.78584848917, -122.435704529297) | 13 | 6 | 1 | 29490 | 27 | ||
16046 | 99287 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
18655 | 124424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.7884130822591 | -122.457294185036 | (37.7884130822591, -122.457294185036) | 11 | 6 | 1 | 54 | 31 | |||
18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
19308 | 64963 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.427680422256 | (37.7999204646826, -122.427680422256) | 13 | 9 | 1 | 57 | 17 | ||
19967 | 101427 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
29430 | 114806 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
30056 | 250762 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 231 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985862.1127 | 2114339.73432 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | 11 | 6 | 1 | 55 | 33 | |||
30326 | 99286 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
36191 | 251014 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.7895752475348 | -122.457847777179 | (37.7895752475348, -122.457847777179) | 11 | 6 | 1 | 54 | 31 | |||
36758 | 61440 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.37503 | 37.7971315285518 | -122.443200241996 | (37.7971315285518, -122.443200241996) | 13 | 9 | 1 | 57 | 17 | ||
37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
39540 | 251008 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995662.21487 | 2115838.76904 | 37.7894401289022 | -122.458871565395 | (37.7894401289022, -122.458871565395) | 11 | 6 | 1 | 54 | 31 | |||
44755 | 124423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996107.97218 | 2115471.34233 | 37.78845688642 | -122.457302712744 | (37.78845688642, -122.457302712744) | 11 | 6 | 1 | 54 | 31 | |||
46698 | 58912 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.65083 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | 13 | 9 | 1 | 57 | 17 | ||
63143 | 65844 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812 | -122.444757181443 | (37.798896470812, -122.444757181443) | 13 | 9 | 1 | 57 | 17 | ||
72078 | 251012 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995905.52497 | 2115874.18508 | 37.7895513543625 | -122.458032309042 | (37.7895513543625, -122.458032309042) | 11 | 6 | 1 | 54 | 31 | |||
73416 | 101431 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
79230 | 103152 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
80740 | 35236 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.8002300077587 | -122.418976495462 | (37.8002300077587, -122.418976495462) | 5 | 1 | 1 | 28858 | 32 | |
81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
84851 | 59876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504484 | (37.7976647031079, -122.43551504484) | 13 | 9 | 1 | 57 | 17 | ||
86489 | 126619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996924.84901 | 2116015.00596 | 37.789996524161 | -122.454515752993 | (37.789996524161, -122.454515752993) | 11 | 6 | 1 | 54 | 31 | |||
91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
92420 | 126617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.7987845877085 | -122.446078403512 | (37.7987845877085, -122.446078403512) | 13 | 9 | 1 | 57 | 17 | |||
93479 | 101426 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
94009 | 65540 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.7858324957202 | -122.435830346192 | (37.7858324957202, -122.435830346192) | 13 | 6 | 1 | 29490 | 27 | |
95218 | 103153 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
95847 | 251013 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995926.37639 | 2115877.04966 | 37.78956041774 | -122.457960373191 | (37.78956041774, -122.457960373191) | 11 | 6 | 1 | 54 | 31 | |||
107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
121213 | 250765 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 233 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985862.42802 | 2114310.4019 | 37.7846755054012 | -122.49266464526 | (37.7846755054012, -122.49266464526) | 11 | 6 | 1 | 55 | 33 | |||
122240 | 101428 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
123777 | 250310 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995676.88978 | 2115841.14336 | 37.7894474916527 | -122.458820964144 | (37.7894474916527, -122.458820964144) | 11 | 6 | 1 | 54 | 31 | |||
125743 | 35237 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.14978 | 2119525.96271 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | 5 | 1 | 1 | 28858 | 32 | |
125933 | 250314 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995896.25125 | 2115871.75264 | 37.7895441427054 | -122.458064218812 | (37.7895441427054, -122.458064218812) | 11 | 6 | 1 | 54 | 31 | |||
127353 | 23546 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.8015552343461 | -122.424759800825 | (37.8015552343461, -122.424759800825) | 13 | 9 | 1 | 57 | 17 | |||
129082 | 126622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5998235.51312 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | 13 | 6 | 1 | 54 | 31 | |||
132084 | 126621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | 11 | 6 | 1 | 54 | 31 | |||
139792 | 98913 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2088 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit No. 49312 | 6000424 | 2115788 | 37.7895732892814 | -122.442392720884 | (37.7895732892814, -122.442392720884) | 13 | 6 | 1 | 29490 | 27 | |||
140524 | 126616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.7971252072193 | -122.443251440404 | (37.7971252072193, -122.443251440404) | 13 | 9 | 1 | 57 | 17 | |||
141514 | 250901 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | 11 | 6 | 1 | 55 | 33 | |||
143284 | 32039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.8035619867255 | -122.433520856524 | (37.8035619867255, -122.433520856524) | 13 | 9 | 1 | 57 | 17 | |||
143730 | 114807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
147021 | 126623 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998899.76803 | 2116292.09263 | 37.7908703998933 | -122.447702685234 | (37.7908703998933, -122.447702685234) | 13 | 6 | 1 | 54 | 31 | |||
150027 | 126618 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3301 Van Ness Ave | 6 | : | Tree | Private 2 | 15 | Width 3ft | 6005157.45717 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | 13 | 9 | 1 | 28858 | 17 | |||
150139 | 31210 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.438384556872 | (37.7951689006516, -122.438384556872) | 13 | 9 | 1 | 57 | 27 | |||
158296 | 250316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995936.88043 | 2115877.74696 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | 11 | 6 | 1 | 54 | 31 | |||
167189 | 97724 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
168369 | 35391 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1998 12:00:00 AM | Permit Number 38846 | 6003139.07897357 | 2115258.4763002 | 37.7882737292741 | -122.432960994436 | (37.7882737292741, -122.432960994436) | 13 | 9 | 1 | 29490 | 27 | |||
171200 | 93707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53296 | 6004115 | 2118383 | 37.7969081825869 | -122.429807420143 | (37.7969081825869, -122.429807420143) | 13 | 9 | 1 | 57 | 17 | |||
177333 | 250315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995912.98237 | 2115873.60258 | 37.7895501834435 | -122.458006465223 | (37.7895501834435, -122.458006465223) | 11 | 6 | 1 | 54 | 31 | |||
180413 | 101429 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
181653 | 103151 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
182596 | 64939 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.59823 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | 13 | 9 | 1 | 57 | 17 | |
186379 | 101432 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 |
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) );