Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189032 | 189032 | 30841 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2586 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1995 12:00:00 AM | 22 | Permit Number 34689 | 6002395.11591 | 2116122.86039 | 37.790604880464294 | -122.43559684281799 | (37.7906048804643, -122.435596842818) | ||
| 186352 | 186352 | 47483 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 22 | Permit Number 45378 | 6002071.5211 | 2114540.3904 | 37.786241439117205 | -122.436603142325 | (37.7862414391172, -122.436603142325) | |
| 186122 | 186122 | 43982 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2000 12:00:00 AM | 11 | Permit Number 43545 | 5997823.8786 | 2113381.5676 | 37.7828173196945 | -122.451215205093 | (37.7828173196945, -122.451215205093) | ||
| 185884 | 185884 | 59890 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.77635658928261 | -122.447636289265 | (37.7763565892826, -122.447636289265) | |
| 185372 | 185372 | 101136 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000824.6116 | 2110666.7087 | 37.7755343608772 | -122.44063916358499 | (37.7755343608772, -122.440639163585) | |||
| 184426 | 184426 | 50822 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 240 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 14 | Permit Number 47343 | 6000834.361830001 | 2121507.8753 | 37.8053019385925 | -122.441383512537 | (37.8053019385925, -122.441383512537) | ||
| 182465 | 182465 | 46269 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2373 REVISED Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 44553 | 6003358.75375 | 2116535.0079099997 | 37.791791217540606 | -122.432292160763 | (37.7917912175406, -122.432292160763) | |||
| 181375 | 181375 | 94795 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.78516664988479 | -122.485198457494 | (37.7851666498848, -122.485198457494) | |
| 180477 | 180477 | 87050 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | ||
| 180368 | 180368 | 52048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2440 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2005 12:00:00 AM | 32 | Permit Number 48253 | 6002224.0088599995 | 2117083.39027 | 37.7932325277104 | -122.43625763230101 | (37.7932325277104, -122.436257632301) | ||
| 178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
| 177689 | 177689 | 97972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.265240001 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | |
| 177303 | 177303 | 106245 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 770844 | 6012052.957359999 | 2105766.02313 | 37.7627111948751 | -122.401452881641 | (37.7627111948751, -122.401452881641) | |||
| 176938 | 176938 | 66480 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 127 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 30 | Permit Number 29809 | 5994252.33765 | 2114707.89192 | 37.7862539074759 | -122.46366743555599 | (37.7862539074759, -122.463667435556) | ||
| 176755 | 176755 | 113087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5984726.14635 | 2112591.8256599996 | 37.77989028792871 | -122.49646888365601 | (37.7798902879287, -122.496468883656) | |||
| 175147 | 175147 | 38476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 19 | Permit Number 40477 | 5987961.29875 | 2115305.89755 | 37.78753135395029 | -122.485476422304 | (37.7875313539503, -122.485476422304) | ||
| 174887 | 174887 | 51878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2251 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 14 | Permit Number 48095 | 6002306.75433 | 2116015.7173900004 | 37.790305674209 | -122.43589489884701 | (37.790305674209, -122.435894898847) | ||
| 174114 | 174114 | 50990 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3880 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2004 12:00:00 AM | 15 | Permit Number 47473 | 5996258.47275 | 2115594.2107 | 37.7888028926924 | -122.45679089747699 | (37.7888028926924, -122.456790897477) | ||
| 173845 | 173845 | 62894 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3785 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1986 12:00:00 AM | 11 | Permit Number 23268 | 5996128.29576 | 2115858.76292 | 37.7895218062425 | -122.45726043444701 | (37.7895218062425, -122.457260434447) | ||
| 173830 | 173830 | 38477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40477 | 5987973.38245 | 2115305.78698 | 37.787531754358795 | -122.48543460753 | (37.7875317543588, -122.48543460753) | ||
| 173090 | 173090 | 109385 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41X 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5990496.07684 | 2114830.6827 | 37.7863739000635 | -122.47667195873301 | (37.7863739000635, -122.476671958733) | |||
| 170826 | 170826 | 66038 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 616 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1990 12:00:00 AM | 14 | Permit Number 29076 | 6004557.2069 | 2110631.4590000003 | 37.7756494221228 | -122.42772470084101 | (37.7756494221228, -122.427724700841) | ||
| 169164 | 169164 | 52614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | ||
| 167595 | 167595 | 59299 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2105 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1980 12:00:00 AM | 3 | Permit Number 18637 | 6003797.66413 | 2115784.10582 | 37.7897543079647 | -122.430719923706 | (37.7897543079647, -122.430719923706) | ||
| 166659 | 166659 | 61642 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 275 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1987 12:00:00 AM | 13 | Permit Number 24615 | 5987729.039059999 | 2114139.72181 | 37.7843158342142 | -122.48619434147899 | (37.7843158342142, -122.486194341479) | ||
| 164771 | 164771 | 32261 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2106 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 17 | Permit Number 35560 | 6000946.10358 | 2115697.23755 | 37.789353823655205 | -122.440579789342 | (37.7893538236552, -122.440579789342) | ||
| 164063 | 164063 | 51682 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2209 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 15 | 3x3 | Permit Number 47962 | 6001952.8314 | 2114287.6119999997 | 37.7855406286981 | -122.436995673401 | (37.7855406286981, -122.436995673401) | |
| 163234 | 163234 | 48683 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2002 12:00:00 AM | 24 | Permit Number 45963 | 5996485.35892 | 2115571.58061 | 37.7887537816114 | -122.456004271305 | (37.7887537816114, -122.456004271305) | ||
| 162465 | 162465 | 45658 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Permit Number 44353 | 6006595.78539 | 2119080.50195 | 37.7989635159037 | -122.421272856775 | (37.7989635159037, -122.421272856775) | |||
| 162032 | 162032 | 48681 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2002 12:00:00 AM | 9 | Permit Number 45963 | 5996443.821330001 | 2115574.81636 | 37.7887602819167 | -122.45614821859199 | (37.7887602819167, -122.456148218592) | ||
| 161977 | 161977 | 100371 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 836 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Permit Number 22564 | 6011703.37581 | 2118243.8311400004 | 37.7969528476575 | -122.403539900553 | (37.7969528476575, -122.403539900553) | |||
| 161959 | 161959 | 106246 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012056.26668 | 2105734.7777299997 | 37.762625586614796 | -122.40143923982299 | (37.7626255866148, -122.401439239823) | |||
| 161529 | 161529 | 103488 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001028.36335 | 2117564.6672900002 | 37.7944859830059 | -122.44042916637899 | (37.7944859830059, -122.440429166379) | |||
| 160965 | 160965 | 65714 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1990 12:00:00 AM | 16 | Permit Number 28646 | 5990406.783530001 | 2113406.96053 | 37.7824595769169 | -122.47687682313699 | (37.7824595769169, -122.476876823137) | ||
| 160004 | 160004 | 121403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1089 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6015119.7462 | 2089795.6867 | 37.719030579981705 | -122.38973034355601 | (37.7190305799817, -122.389730343556) | |||
| 159907 | 159907 | 88459 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999585.78852 | 2118019.58187 | 37.795652812882 | -122.445453362079 | (37.795652812882, -122.445453362079) | |
| 158503 | 158503 | 66481 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2290 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1991 12:00:00 AM | 17 | Permit Number 29638 | 6002649.70784 | 2117838.97461 | 37.7953313448215 | -122.434838746712 | (37.7953313448215, -122.434838746712) | ||
| 157835 | 157835 | 113089 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5984740.35768 | 2112618.32743 | 37.77996388666671 | -122.496421677178 | (37.7799638866667, -122.496421677178) | |||
| 157818 | 157818 | 35381 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 531 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 3 | Permit Number 38837 | 6011249.266919999 | 2105860.5302 | 37.76292581448371 | -122.404239227767 | (37.7629258144837, -122.404239227767) | |
| 156775 | 156775 | 68873 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | Permit Number 32844 | 5992095.21626 | 2114354.3372400003 | 37.7851586118271 | -122.47110467851499 | (37.7851586118271, -122.471104678515) | |
| 156403 | 156403 | 60095 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3343 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 10 | Permit Number 19596 | 5998235.21709 | 2116151.87187 | 37.7904473875938 | -122.449991880723 | (37.7904473875938, -122.449991880723) | |
| 155957 | 155957 | 30302 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2742 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | 11 | Permit Number 145 | 6003564.285630001 | 2117799.94535 | 37.7952760635006 | -122.431671372239 | (37.7952760635006, -122.431671372239) | ||
| 155131 | 155131 | 115073 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2263 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 24 | 3x3 | Permit Number 777001 | 6003883.69661 | 2116609.10432 | 37.7920244180358 | -122.430481149195 | (37.7920244180358, -122.430481149195) | |
| 154141 | 154141 | 101137 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 Grove St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000842.8876 | 2110669.9339 | 37.7755442571847 | -122.440576174035 | (37.7755442571847, -122.440576174035) | |||
| 153366 | 153366 | 48682 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2002 12:00:00 AM | 11 | Permit Number 45963 | 5996468.62014 | 2115578.3226799998 | 37.7887713327653 | -122.456062672367 | (37.7887713327653, -122.456062672367) | ||
| 152823 | 152823 | 99897 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Permit Number 768908 | 6004409.826309999 | 2116680.57597 | 37.7922504509529 | -122.42866583257401 | (37.7922504509529, -122.428665832574) | |||
| 150973 | 150973 | 55625 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2131 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1973 12:00:00 AM | 3 | Permit Number 11604 | 6003978.01114 | 2116943.7109 | 37.7929485047302 | -122.43017870178001 | (37.7929485047302, -122.43017870178) | ||
| 150459 | 150459 | 46252 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | 17 | Permit Number 44537 | 6000224.48541 | 2117800.1223 | 37.795086675274206 | -122.443227593983 | (37.7950866752742, -122.443227593983) | ||
| 150349 | 150349 | 103490 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001053.62878 | 2117568.22705 | 37.7944971957398 | -122.440342000495 | (37.7944971957398, -122.440342000495) | |||
| 150211 | 150211 | 31197 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 31 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 21 | Permit Number 34890 | 5998546.82061 | 2106872.64956 | 37.7649868672854 | -122.44824529389099 | (37.7649868672854, -122.448245293891) | ||
| 150120 | 150120 | 50188 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3134 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | 12 | Permit Number 46895 | 5999411.86905 | 2119620.94961 | 37.800039811041295 | -122.446170397871 | (37.8000398110413, -122.446170397871) | ||
| 148162 | 148162 | 31199 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 31 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 19 | Permit Number 34890 | 5998530.7281 | 2106872.07801 | 37.764984377947705 | -122.448300912461 | (37.7649843779477, -122.448300912461) | ||
| 147827 | 147827 | 59324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750286996 | -122.50053376884199 | (37.761245750287, -122.500533768842) | ||
| 147648 | 147648 | 49871 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2519SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50540 | 6001316.09409 | 2117246.4111 | 37.7936285135915 | -122.439410760611 | (37.7936285135915, -122.439410760611) | |
| 147463 | 147463 | 55934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1973 12:00:00 AM | 9 | Permit Number 11998 | 5986719.3111 | 2097252.7279 | 37.7378899014651 | -122.48844608721501 | (37.7378899014651, -122.488446087215) | ||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 145875 | 145875 | 99906 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 145588 | 145588 | 51623 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 25 Short St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101001 | (37.7576271269874, -122.44286268101) | ||||
| 145385 | 145385 | 102631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | |||
| 145168 | 145168 | 34879 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 211 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | ||||
| 145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 144923 | 144923 | 39248 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 144489 | 144489 | 94796 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 223 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5987953.6 | 2114461.6 | 37.7852127054212 | -122.48544107738199 | (37.7852127054212, -122.485441077382) | ||||
| 144283 | 144283 | 31198 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 31 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34890 | 5998547.5134992 | 2106873.34897224 | 37.764988827306794 | -122.448242947738 | (37.7649888273068, -122.448242947738) | ||||
| 144206 | 144206 | 23573 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6005485.556059999 | 2120793.85256 | 37.80360528368389 | -122.42523660667801 | (37.8036052836839, -122.425236606678) | |||
| 144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 143873 | 143873 | 32032 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3321 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191328999 | (37.7645444241082, -122.42687191329) | |||
| 143373 | 143373 | 99907 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 143326 | 143326 | 48496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2002 12:00:00 AM | Permit Number 45837 | 6001939.613107599 | 2108727.84798346 | 37.770274163526395 | -122.436643297557 | (37.7702741635264, -122.436643297557) | |||
| 142443 | 142443 | 53040 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | ||
| 142038 | 142038 | 99899 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||
| 141974 | 141974 | 50107 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 141603 | 141603 | 30853 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 141375 | 141375 | 99603 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 141366 | 141366 | 24933 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 141176 | 141176 | 32419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
| 141134 | 141134 | 12730 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 5990437.55256 | 2114717.69591 | 37.786060275243294 | -122.476866177185 | (37.7860602752433, -122.476866177185) | |||
| 140989 | 140989 | 30854 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 140687 | 140687 | 12731 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5990457.99077 | 2114717.95371 | 37.7860621686583 | -122.476795486066 | (37.7860621686583, -122.476795486066) | |||
| 140596 | 140596 | 87005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 140356 | 140356 | 100392 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 140019 | 140019 | 30857 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 138745 | 138745 | 32031 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3321 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191328999 | (37.7645444241082, -122.42687191329) | |||
| 138561 | 138561 | 49321 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 138494 | 138494 | 55211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.781268623734604 | -122.44372179014601 | (37.7812686237346, -122.443721790146) | |||
| 137974 | 137974 | 65997 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1606 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1990 12:00:00 AM | 15 | Permit Number 29028 | 6005744.05891 | 2118269.17743 | 37.7966877697727 | -122.424162385699 | (37.7966877697727, -122.424162385699) | ||
| 137748 | 137748 | 38478 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 21 | Permit Number 40477 | 5987978.37889 | 2115306.2666 | 37.787533362348704 | -122.48541735627501 | (37.7875333623487, -122.485417356275) | ||
| 136179 | 136179 | 88458 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 19 | 3x3 | Permit Number 51419 | 5999585.28862 | 2118036.11604 | 37.7956981827846 | -122.445456281295 | (37.7956981827846, -122.445456281295) | |
| 133118 | 133118 | 50674 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3305 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 12 | Permit Number 47252 | 5998947.7202699995 | 2115924.5252900003 | 37.789863897553396 | -122.447510304059 | (37.7898638975534, -122.447510304059) | ||
| 132893 | 132893 | 106248 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 770844 | 6012033.91664 | 2105711.7719799997 | 37.7625611708892 | -122.401514924078 | (37.7625611708892, -122.401514924078) | |||
| 130766 | 130766 | 88460 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999588.65387 | 2118008.6000099997 | 37.7956228231833 | -122.44544265745701 | (37.7956228231833, -122.445442657457) | |
| 130606 | 130606 | 34177 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 207 Maple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1997 12:00:00 AM | 16 | Permit Number 38003 | 5996588.86091 | 2115573.8906799997 | 37.788766064540006 | -122.455646338401 | (37.78876606454, -122.455646338401) | ||
| 130208 | 130208 | 30344 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 27 | 6001962.41405 | 2121647.90005 | 37.8057506067757 | -122.43748978443199 | (37.8057506067757, -122.437489784432) | |||
| 129552 | 129552 | 68096 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1993 12:00:00 AM | 8 | Permit Number 31841 | 6004611.786040001 | 2117244.74895 | 37.7938109545695 | -122.428007268927 | (37.7938109545695, -122.428007268927) | ||
| 128827 | 128827 | 6631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | ||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128368 | 128368 | 50103 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 128011 | 128011 | 30290 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) |
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");