Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 112402 | 112402 | 115026 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 103877 | 103877 | 121142 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 46243 | 46243 | 224511 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | |||
| 20215 | 20215 | 24447 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006347.0218400005 | 2102851.3253900004 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | |||
| 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) | |
| 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) | ||||
| 129073 | 129073 | 33817 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
| 84518 | 84518 | 101285 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | |||
| 185146 | 185146 | 224624 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | |||
| 157746 | 157746 | 112160 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | |||
| 20707 | 20707 | 24450 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.42065118602301 | (37.7507621663522, -122.420651186023) | |||
| 71668 | 71668 | 224681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006415.878380001 | 2101496.97772 | 37.7506732449771 | -122.42064649965499 | (37.7506732449771, -122.420646499655) | |||
| 33917 | 33917 | 224641 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.41932373541901 | (37.7460721011655, -122.419323735419) | |||
| 72056 | 72056 | 199433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1400 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.39245332546601 | (37.7354971746608, -122.392453325466) | |||
| 151509 | 151509 | 116039 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6008038.315669999 | 2116541.7615900002 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | |||
| 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) | |||
| 16970 | 16970 | 23100 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6006427.47457 | 2101357.7543900004 | 37.7502916230775 | -122.42059651712098 | (37.7502916230775, -122.420596517121) | |||
| 49218 | 49218 | 224525 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006711.819209999 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | |||
| 173739 | 173739 | 224639 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.42145535528601 | (37.7413561822494, -122.421455355286) | |||
| 137425 | 137425 | 218836 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991107.229069999 | 2098459.95547 | 37.741459692423796 | -122.473363085249 | (37.7414596924238, -122.473363085249) | |||
| 182314 | 182314 | 218832 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | |||
| 91896 | 91896 | 33764 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
| 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) | |||
| 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) | ||||
| 106430 | 106430 | 98025 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1633 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988173.0 | 2098960.0 | 37.742662336498604 | -122.48354516443199 | (37.7426623364986, -122.483545164432) | ||||
| 14200 | 14200 | 26002 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | |||
| 137655 | 137655 | 199434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014431.27107 | 2095902.0652700001 | 37.7357592658851 | -122.39253706224501 | (37.7357592658851, -122.392537062245) | |||
| 121898 | 121898 | 33589 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | |||
| 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) | |||
| 128320 | 128320 | 121150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |||
| 48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
| 154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
| 122713 | 122713 | 60714 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 20367 | 6005264.975818 | 2105333.47768938 | 37.761142446432096 | -122.424899339668 | (37.7611424464321, -122.424899339668) | ||
| 124466 | 124466 | 53067 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | |||
| 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) | ||||
| 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) | |||
| 175285 | 175285 | 226493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008772.32666 | 2104949.6501700003 | 37.7602860290962 | -122.41274173856002 | (37.7602860290962, -122.41274173856) | |||
| 165442 | 165442 | 224493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | |||
| 125826 | 125826 | 104403 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
| 186397 | 186397 | 218803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.46913081273199 | (37.7439598068059, -122.469130812732) | |||
| 83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 53817 | 53817 | 224489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998519.39636 | 2106289.8820599997 | 37.763385166627295 | -122.44829817853399 | (37.7633851666273, -122.448298178534) | |||
| 122027 | 122027 | 224650 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.744941615564706 | -122.417820274 | (37.7449416155647, -122.417820274) | |||
| 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) | ||||
| 41825 | 41825 | 226490 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008822.75268 | 2104167.00903 | 37.758139904958206 | -122.412512013916 | (37.7581399049582, -122.412512013916) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 106386 | 106386 | 116389 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
| 43555 | 43555 | 224584 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.41366542593799 | (37.76534068665, -122.413665425938) | |||
| 129826 | 129826 | 224588 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008276.684169999 | 2106776.8374099997 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | |||
| 179949 | 179949 | 224528 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 281 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006752.8545699995 | 2102173.9944599997 | 37.7525511643191 | -122.41952923228901 | (37.7525511643191, -122.419529232289) | |||
| 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) | ||||
| 25337 | 25337 | 250803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | |||
| 106522 | 106522 | 33651 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
| 19625 | 19625 | 571 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.006130001 | 2102184.0831400002 | 37.752708212935794 | -122.411572138748 | (37.7527082129358, -122.411572138748) | ||
| 43163 | 43163 | 249545 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006121.634219999 | 2114038.6036799997 | 37.7850929805917 | -122.42255511555099 | (37.7850929805917, -122.422555115551) | |||
| 19766 | 19766 | 5379 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 299 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004899.9834 | 2106715.40982 | 37.764916280383 | -122.426260083162 | (37.764916280383, -122.426260083162) | |||
| 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) | |||
| 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) | ||||
| 18516 | 18516 | 580 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | |||
| 187298 | 187298 | 111610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.71833459814221 | -122.403290521257 | (37.7183345981422, -122.403290521257) | |||
| 111715 | 111715 | 33610 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.774180301661794 | -122.42598546011699 | (37.7741803016618, -122.425985460117) | |||
| 19855 | 19855 | 602 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | |||
| 108270 | 108270 | 33611 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.774176257824394 | -122.42601725751001 | (37.7741762578244, -122.42601725751) | |||
| 37859 | 37859 | 224591 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3117 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006001.0018 | 2106651.39278 | 37.7648026771212 | -122.42244738485701 | (37.7648026771212, -122.422447384857) | |||
| 78322 | 78322 | 33615 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
| 154231 | 154231 | 226486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008522.957719999 | 2105665.90861 | 37.7622387108737 | -122.41365485348801 | (37.7622387108737, -122.413654853488) | |||
| 184726 | 184726 | 224575 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008614.79517 | 2105624.76629 | 37.7621309001374 | -122.413334311737 | (37.7621309001374, -122.413334311737) | |||
| 157050 | 157050 | 224532 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.41486962353301 | (37.7523850181574, -122.414869623533) | |||
| 178689 | 178689 | 226475 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008399.696219999 | 2105072.76604 | 37.760603155239295 | -122.41403920664301 | (37.7606031552393, -122.414039206643) | |||
| 156993 | 156993 | 218813 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.91715 | 2088155.78665 | 37.7134420721779 | -122.45611952571801 | (37.7134420721779, -122.456119525718) | |||
| 152736 | 152736 | 224534 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.41573136650601 | (37.752340521521, -122.415731366506) | |||
| 1962 | 1962 | 224700 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | |||
| 2012 | 2012 | 224703 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | |||
| 32870 | 32870 | 224543 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006596.438630001 | 2103760.0556900003 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | |||
| 150231 | 150231 | 224709 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006609.601919999 | 2103216.71936 | 37.755406177257704 | -122.42009861917299 | (37.7554061772577, -122.420098619173) | |||
| 163095 | 163095 | 224546 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3287 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006409.4351 | 2103750.6223 | 37.7568608711517 | -122.420828760756 | (37.7568608711517, -122.420828760756) | |||
| 157131 | 157131 | 176402 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998803.89987 | 2087884.3075400002 | 37.7128641138726 | -122.44599027982201 | (37.7128641138726, -122.445990279822) | |||
| 152250 | 152250 | 176426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.719374784604895 | -122.40058089900299 | (37.7193747846049, -122.400580899003) | |||
| 75837 | 75837 | 126622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998235.513119999 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | |||
| 155012 | 155012 | 224558 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3349 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007935.385009999 | 2104420.8922200003 | 37.7587871703981 | -122.415598898179 | (37.7587871703981, -122.415598898179) | |||
| 103906 | 103906 | 48039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 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) | ||||
| 35607 | 35607 | 224556 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | |||
| 141164 | 141164 | 63515 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3379 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24124 | 6007714.38800344 | 2104402.20456648 | 37.758723433411 | -122.416361886265 | (37.758723433411, -122.416361886265) | ||
| 68273 | 68273 | 224547 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | |||
| 55616 | 55616 | 226483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3470 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006409.05576 | 2104966.19294 | 37.7601985241524 | -122.420916373596 | (37.7601985241524, -122.420916373596) | |||
| 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) | |||
| 33898 | 33898 | 224685 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | |||
| 65026 | 65026 | 224689 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | |||
| 154959 | 154959 | 126619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996924.84901 | 2116015.0059599997 | 37.789996524161 | -122.45451575299299 | (37.789996524161, -122.454515752993) | |||
| 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) | |||
| 47472 | 47472 | 218808 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | ||||
| 24936 | 24936 | 250316 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995936.88043 | 2115877.7469599997 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | |||
| 159330 | 159330 | 250313 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.45816019263701 | (37.7895320612144, -122.458160192637) | |||
| 25991 | 25991 | 251008 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995662.214869999 | 2115838.76904 | 37.7894401289022 | -122.45887156539499 | (37.7894401289022, -122.458871565395) | |||
| 141220 | 141220 | 34143 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.41368889061701 | (37.7637880127631, -122.413688890617) |
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");