Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126502 | 126502 | 48735 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 36 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1969 12:00:00 AM | Permit Number 46015 | 6001979.18448022 | 2107865.24554965 | 37.7679079189757 | -122.436444672891 | (37.7679079189757, -122.436444672891) | |||
| 9804 | 9804 | 59226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | ||
| 83879 | 83879 | 9675 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.77542115275671 | -122.42282218301399 | (37.7754211527567, -122.422822183014) | ||
| 98939 | 98939 | 44172 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 59 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43639 | 6003760.97911216 | 2095401.48581894 | 37.733786440894 | -122.42939273268401 | (37.733786440894, -122.429392732684) | |||
| 110961 | 110961 | 68840 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1506 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | Permit Number 32793 | 6009553.56622839 | 2100554.07443475 | 37.748260580194895 | -122.4097295193 | (37.7482605801949, -122.4097295193) | |||
| 120352 | 120352 | 44127 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1455 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2000 12:00:00 AM | Permit Number 43631 | 6007204.94423628 | 2110535.86362082 | 37.7755363583765 | -122.41855872358101 | (37.7755363583765, -122.418558723581) | |||
| 9044 | 9044 | 55522 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | Permit Number 11483 | 6003594.27279224 | 2105459.16759406 | 37.7613930510814 | -122.430686551957 | (37.7613930510814, -122.430686551957) | |||
| 102509 | 102509 | 33718 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 25 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37786 | 6004139.32588988 | 2108866.31797637 | 37.7707791293659 | -122.42904437383699 | (37.7707791293659, -122.429044373837) | |
| 124200 | 124200 | 33719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 27 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37787 | 6004127.51235208 | 2108864.68166901 | 37.7707739677449 | -122.429085120408 | (37.7707739677449, -122.429085120408) | ||
| 85575 | 85575 | 63094 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2780 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1986 12:00:00 AM | 3x3 | Permit Number 23579 | 6001505.6405737 | 2115674.07424093 | 37.789322069479 | -122.438642199545 | (37.789322069479, -122.438642199545) | ||
| 139075 | 139075 | 59431 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.735573337111795 | -122.432419698468 | (37.7355733371118, -122.432419698468) | |
| 139910 | 139910 | 48952 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | |
| 120420 | 120420 | 113553 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3x3 | 6009263.0 | 2115423.0 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | |||
| 92780 | 92780 | 41199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 93983 | 93983 | 41198 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 94306 | 94306 | 41194 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 118500 | 118500 | 41193 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 122099 | 122099 | 41200 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 126809 | 126809 | 41196 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 140702 | 140702 | 41192 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 118352 | 118352 | 39111 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | |
| 125237 | 125237 | 52226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 423 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2005 12:00:00 AM | Permit Number 48405 | 5997634.34727934 | 2115023.86499621 | 37.787315780851294 | -122.451989424725 | (37.7873157808513, -122.451989424725) | |||
| 84958 | 84958 | 50566 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 108815 | 108815 | 50571 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 140910 | 140910 | 50573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 93660 | 93660 | 48875 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | Permit Number 46082 | 6002579.05689486 | 2108874.6714316 | 37.770713622438706 | -122.43444196581801 | (37.7707136224387, -122.434441965818) | |||
| 145114 | 145114 | 66879 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.75928799185029 | -122.439106757133 | (37.7592879918503, -122.439106757133) | ||
| 145732 | 145732 | 48866 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | |||
| 114837 | 114837 | 57622 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | Permit Number 16516 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | |||
| 127933 | 127933 | 92818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883.0 | 2096019.0 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | ||
| 113651 | 113651 | 57604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 16491 | 5999828.22001193 | 2094390.77346711 | 37.730787818817504 | -122.44291685523399 | (37.7307878188175, -122.442916855234) | ||
| 111267 | 111267 | 58321 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1978 12:00:00 AM | 12 | 3x3 | Permit Number 17346 | 6002930.0 | 2119911.0 | 37.801036497901 | -122.43401707700701 | (37.801036497901, -122.434017077007) | |
| 92438 | 92438 | 33008 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | ||
| 123284 | 123284 | 59335 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 201 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1980 12:00:00 AM | 4x4 | Permit Number 18682 | 6003287.79827449 | 2108952.35112135 | 37.7709671172915 | -122.431995967048 | (37.7709671172915, -122.431995967048) | ||
| 138898 | 138898 | 13036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:35:00 AM | 3 | 3X3 | 6010019.32094 | 2120615.54911 | 37.80337079145 | -122.40953463326599 | (37.80337079145, -122.409534633266) | ||
| 8687 | 8687 | 13035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:33:00 AM | 3 | 3X3 | 6010007.9078 | 2120594.4895 | 37.8033123274611 | -122.40957264178199 | (37.8033123274611, -122.409572641782) | ||
| 113925 | 113925 | 13023 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 440 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2015 08:29:00 AM | 3 | 4X4 | 6010228.79362 | 2120718.91833 | 37.803666352876704 | -122.408817039093 | (37.8036663528767, -122.408817039093) | ||
| 88161 | 88161 | 86905 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775.0 | 2106383.0 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | ||
| 83639 | 83639 | 66275 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | ||
| 79022 | 79022 | 61158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) |
| 87064 | 87064 | 58078 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401.0 | 2105218.0 | 37.7605494356876 | -122.44171341046699 | (37.7605494356876, -122.441713410467) | |||
| 101647 | 101647 | 58071 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4545 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1977 12:00:00 AM | 13 | Permit Number 17041 | 6000791.5456109 | 2105188.83821507 | 37.760491609105294 | -122.44036060348101 | (37.7604916091053, -122.440360603481) | ||
| 119029 | 119029 | 57580 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 6 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1976 12:00:00 AM | 10 | Permit Number 16447 | 6003825.41823987 | 2107112.36179244 | 37.7659454174839 | -122.430005049505 | (37.7659454174839, -122.430005049505) | ||
| 6631 | 6631 | 13008 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.803418967602205 | -122.40768869648399 | (37.8034189676022, -122.407688696484) | ||
| 5440 | 5440 | 13266 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.44206111460501 | (37.7991775301158, -122.442061114605) | ||
| 80462 | 80462 | 13254 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | ||
| 92303 | 92303 | 13285 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.810330001 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | ||
| 78463 | 78463 | 115215 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | |
| 118084 | 118084 | 115216 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | ||
| 7836 | 7836 | 13005 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | ||
| 8862 | 8862 | 13007 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.40778071851601 | (37.8034055135257, -122.407780718516) | ||
| 3424 | 3424 | 13006 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | ||
| 87402 | 87402 | 32646 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 89861 | 89861 | 32647 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 78930 | 78930 | 57108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.752087986316106 | -122.42645196024401 | (37.7520879863161, -122.426451960244) | |
| 114654 | 114654 | 95413 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523.0 | 2095666.0 | 37.734442568942704 | -122.433691689524 | (37.7344425689427, -122.433691689524) | |
| 78160 | 78160 | 44063 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 81682 | 81682 | 44064 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 84916 | 84916 | 44061 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 92282 | 92282 | 9941 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 5x6 | Resulted descion 9/7/16 -DE | 6010050.959969999 | 2119172.47111 | 37.7994102279433 | -122.40932324608299 | (37.7994102279433, -122.409323246083) | |
| 141365 | 141365 | 18421 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 934 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010443.4204228 | 2103802.0898928 | 37.75722873830139 | -122.40688129976499 | (37.7572287383014, -122.406881299765) | ||
| 95819 | 95819 | 64020 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2344 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 778144 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | ||
| 94689 | 94689 | 62276 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 124 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 13 | 21x6 | Permit Number 22414 | 6003841.87853288 | 2108837.79837285 | 37.77068397982129 | -122.430071215032 | (37.7706839798213, -122.430071215032) | |
| 87672 | 87672 | 107653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 93269 | 93269 | 107652 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 103594 | 103594 | 107654 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 92883 | 92883 | 18465 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | ||
| 112718 | 112718 | 15263 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51766 | 6007587.5132074 | 2110099.4827033 | 37.774359690705296 | -122.417204392502 | (37.7743596907053, -122.417204392502) | |
| 97086 | 97086 | 39773 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 112 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.745486997298705 | -122.424877067697 | (37.7454869972987, -122.424877067697) |
| 46254 | 46254 | 23132 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | ||
| 77503 | 77503 | 23131 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.643569999 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | ||
| 13244 | 13244 | 113373 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2015 12:00:00 AM | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | |||
| 97954 | 97954 | 58284 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1978 12:00:00 AM | 4x4 | Permit Number 17298 | 6007189.64621742 | 2107366.09742219 | 37.7668320707182 | -122.418386841574 | (37.7668320707182, -122.418386841574) | ||
| 3707 | 3707 | 253520 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 78377 | 78377 | 48697 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 83408 | 83408 | 48709 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 87592 | 87592 | 48702 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 91195 | 91195 | 48704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 100703 | 100703 | 48700 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 100767 | 100767 | 48699 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 108395 | 108395 | 48698 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 111454 | 111454 | 48701 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 120886 | 120886 | 48703 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 79031 | 79031 | 4709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.6629099995 | 2120633.4675 | 37.8033402849031 | -122.41445215852801 | (37.8033402849031, -122.414452158528) | ||
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 103882 | 103882 | 12428 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1710 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6004482.43729 | 2114709.16781 | 37.7868415701808 | -122.428274031584 | (37.7868415701808, -122.428274031584) | ||
| 107677 | 107677 | 12427 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1710 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6004482.43729 | 2114709.16781 | 37.7868415701808 | -122.428274031584 | (37.7868415701808, -122.428274031584) | ||
| 143768 | 143768 | 20245 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.588541901 | 2114476.0123893 | 37.7860901257054 | -122.43504834161101 | (37.7860901257054, -122.435048341611) | ||
| 104023 | 104023 | 57425 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/1976 12:00:00 AM | 20 | 6x10 | Permit Number 16267 | 6004690.36073914 | 2101363.26470881 | 37.750208699935996 | -122.426603966833 | (37.750208699936, -122.426603966833) | |
| 134152 | 134152 | 57410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | ||
| 86731 | 86731 | 100705 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 97528 | 97528 | 100707 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 108521 | 108521 | 100706 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 139052 | 139052 | 100710 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 141840 | 141840 | 100708 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 144198 | 144198 | 57306 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3265 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 5.5x9 | Permit Number 30983 | 6005094.29272651 | 2106604.42467206 | 37.764622522827295 | -122.42558011640699 | (37.7646225228273, -122.425580116407) | ||
| 92746 | 92746 | 57298 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | 5x5 | Permit Number 16120 | 6006015.66145192 | 2106707.62529636 | 37.764957905287105 | -122.422400676647 | (37.7649579052871, -122.422400676647) | |
| 129220 | 129220 | 57300 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3178 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 14 | 3x3 | Permit Number 16122 | 6005671.4432239 | 2106688.52693537 | 37.764886042110895 | -122.423589884437 | (37.7648860421109, -122.423589884437) | |
| 89324 | 89324 | 57802 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.753239209170204 | -122.44075659160102 | (37.7532392091702, -122.440756591601) |
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");