Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87279 | 87279 | 99175 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
| 105221 | 105221 | 99176 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
| 126915 | 126915 | 99178 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008617.0 | 2122137.0 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | ||||
| 135535 | 135535 | 126618 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3301 Van Ness Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6005157.457169999 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | |||
| 2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
| 95832 | 95832 | 98577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 301X Francisco St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6x7 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 129373 | 129373 | 109918 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6010269.5 | 2121152.3 | 37.80485859155171 | -122.408706764133 | (37.8048585915517, -122.408706764133) | ||||
| 79146 | 79146 | 110117 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
| 121075 | 121075 | 110116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
| 108609 | 108609 | 101519 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15X Bellair Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | |||
| 118270 | 118270 | 101520 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15X Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | |||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 116256 | 116256 | 32039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.803561986725505 | -122.43352085652398 | (37.8035619867255, -122.433520856524) | |||
| 158006 | 158006 | 126625 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.40330078161101 | (37.8033465696629, -122.403300781611) | |||
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
| 7271 | 7271 | 23546 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.801555234346104 | -122.424759800825 | (37.8015552343461, -122.424759800825) | |||
| 91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
| 112038 | 112038 | 64775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 517 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 25767 | 6010461.649147 | 2119569.81510368 | 37.8005242381712 | -122.407930145171 | (37.8005242381712, -122.407930145171) | ||
| 54737 | 54737 | 35236 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.80023000775871 | -122.418976495462 | (37.8002300077587, -122.418976495462) | |
| 38769 | 38769 | 35237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.149780001 | 2119525.9627099996 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | |
| 129241 | 129241 | 101288 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | ||||
| 53602 | 53602 | 64963 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.42768042225599 | (37.7999204646826, -122.427680422256) | ||
| 102057 | 102057 | 104050 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 145X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012363.0 | 2119165.0 | 37.7995189786281 | -122.40132219698201 | (37.7995189786281, -122.401322196982) | |||||
| 80600 | 80600 | 65894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 649 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.799327449486704 | -122.40980081755501 | (37.7993274494867, -122.409800817555) | ||
| 80439 | 80439 | 99116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 88976 | 88976 | 99115 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 144222 | 144222 | 99114 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 114409 | 114409 | 114807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004778.36642477 | 2119194.00734605 | 37.799172543824504 | -122.427569823594 | (37.7991725438245, -122.427569823594) | ||||
| 125939 | 125939 | 114806 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004778.36642477 | 2119194.00734605 | 37.799172543824504 | -122.427569823594 | (37.7991725438245, -122.427569823594) | ||||
| 92014 | 92014 | 103152 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
| 100915 | 100915 | 103153 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
| 143912 | 143912 | 103151 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
| 87287 | 87287 | 65844 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812004 | -122.44475718144301 | (37.798896470812, -122.444757181443) | ||
| 97475 | 97475 | 64063 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | |||
| 39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
| 5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
| 74423 | 74423 | 34453 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.346609999 | 2118811.2297099996 | 37.798272471441706 | -122.418286300874 | (37.7982724714417, -122.418286300874) | |
| 137467 | 137467 | 58912 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.650830001 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | ||
| 82620 | 82620 | 102901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 BATTERY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012523.0 | 2118543.0 | 37.797820041376205 | -122.400724815577 | (37.7978200413762, -122.400724815577) | ||||
| 126776 | 126776 | 102902 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012556.0 | 2118523.0 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | ||||
| 95201 | 95201 | 59876 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504483999 | (37.7976647031079, -122.43551504484) | ||
| 168890 | 168890 | 61440 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.3750299998 | 37.797131528551795 | -122.443200241996 | (37.7971315285518, -122.443200241996) | ||
| 178436 | 178436 | 126616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.797125207219295 | -122.443251440404 | (37.7971252072193, -122.443251440404) | |||
| 140873 | 140873 | 93707 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53296 | 6004115.0 | 2118383.0 | 37.7969081825869 | -122.42980742014299 | (37.7969081825869, -122.429807420143) | |||
| 62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
| 174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) | |||
| 39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
| 71439 | 71439 | 126629 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | |||
| 173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
| 133542 | 133542 | 126631 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013670.6132 | 2118002.8434900003 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | |||
| 79935 | 79935 | 52859 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
| 111594 | 111594 | 52857 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
| 118250 | 118250 | 52858 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
| 120604 | 120604 | 52860 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
| 116935 | 116935 | 84930 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500@Polk Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | |||||
| 125530 | 125530 | 98718 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | |||||
| 125474 | 125474 | 101895 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011780.0 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | ||||
| 79724 | 79724 | 48785 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 80543 | 80543 | 48790 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | ||
| 90236 | 90236 | 48791 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 127846 | 127846 | 48789 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 139967 | 139967 | 48788 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 115455 | 115455 | 31210 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.43838455687201 | (37.7951689006516, -122.438384556872) | |||
| 79197 | 79197 | 34147 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 80426 | 80426 | 34158 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 87183 | 87183 | 34152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 90068 | 90068 | 34157 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 94880 | 94880 | 34155 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 102524 | 102524 | 34150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 103405 | 103405 | 34156 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 104444 | 104444 | 34154 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 105201 | 105201 | 34148 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 106914 | 106914 | 34153 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 128323 | 128323 | 34159 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 128587 | 128587 | 34146 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 140363 | 140363 | 34149 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 141849 | 141849 | 34151 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 142937 | 142937 | 34145 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 120319 | 120319 | 64776 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.40654541205299 | (37.7933995175775, -122.406545412053) | ||
| 80356 | 80356 | 67032 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141362997 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | |||
| 88123 | 88123 | 97191 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 94873 | 94873 | 97190 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 95951 | 95951 | 97189 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 96990 | 96990 | 99016 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
| 30530 | 30530 | 101433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 87598 | 87598 | 101431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 95128 | 95128 | 101426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 104415 | 104415 | 101428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 126711 | 126711 | 101430 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 127861 | 127861 | 101427 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 139219 | 139219 | 101429 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 144556 | 144556 | 101432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 98701 | 98701 | 99964 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769385 | 6003671.0 | 2116729.0 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | ||||
| 51250 | 51250 | 99287 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
| 124761 | 124761 | 99286 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
| 120721 | 120721 | 65423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.40752190934299 | (37.7921784739149, -122.407521909343) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");