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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7885 | 7885 | 21612 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | |||
| 7897 | 7897 | 2622 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004719.8929 | 2115076.5886 | 37.787863848693796 | -122.427478675215 | (37.7878638486938, -122.427478675215) | |||
| 7957 | 7957 | 21757 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008462.5324 | 2121012.4644 | 37.8043732668186 | -122.414950085154 | (37.8043732668186, -122.414950085154) | |||
| 7977 | 7977 | 121363 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2235 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6003480.6040199995 | 2116883.14161 | 37.792754011941106 | -122.431895428424 | (37.7927540119411, -122.431895428424) | |||
| 8036 | 8036 | 116472 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 825 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009953.87046 | 2116097.82442 | 37.7909625570162 | -122.40944210258999 | (37.7909625570162, -122.40944210259) | |||
| 8052 | 8052 | 3037 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2611 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6001770.5365 | 2115308.215 | 37.7883325797422 | -122.437699479333 | (37.7883325797422, -122.437699479333) | |||
| 8080 | 8080 | 18902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2599 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002415.46801 | 2115750.47994 | 37.7895835752639 | -122.43549977541599 | (37.7895835752639, -122.435499775416) | |||
| 8090 | 8090 | 18971 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000776.930509999 | 2115571.586 | 37.7889991823101 | -122.44115608838301 | (37.7889991823101, -122.441156088383) | |||
| 8101 | 8101 | 18925 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2679 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002005.1865 | 2115691.57373 | 37.7893985235705 | -122.43691508526301 | (37.7893985235705, -122.436915085263) | |||
| 8133 | 8133 | 5227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 4 | 3X3 | 6001390.1765 | 2112022.1316 | 37.779288200344894 | -122.438779891576 | (37.7792882003449, -122.438779891576) | ||
| 8262 | 8262 | 18970 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000791.352940001 | 2115572.7233700003 | 37.789003126734706 | -122.441106270442 | (37.7890031267347, -122.441106270442) | |||
| 8285 | 8285 | 112347 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Perine Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002122.29425 | 2115555.10135 | 37.7890304607445 | -122.436500134475 | (37.7890304607445, -122.436500134475) | |||
| 8310 | 8310 | 110965 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x5 | 6003004.00297 | 2116485.50112 | 37.791635163595096 | -122.433516057127 | (37.7916351635951, -122.433516057127) | |||
| 8480 | 8480 | 5228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 2 | 3X3 | 6001391.6981 | 2112008.1837 | 37.77924998951 | -122.438773627985 | (37.77924998951, -122.438773627985) | ||
| 8530 | 8530 | 17824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1916 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1994 12:00:00 AM | 12 | 3X3 | 6004630.1566 | 2115406.5655 | 37.7887648065492 | -122.427812667349 | (37.7887648065492, -122.427812667349) | ||
| 8544 | 8544 | 110463 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000109.08248 | 2117133.8316 | 37.7932506355596 | -122.443579017584 | (37.7932506355596, -122.443579017584) | |||
| 8601 | 8601 | 103873 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1331 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006745.9342 | 2115531.8344 | 37.789228224750296 | -122.42050126058999 | (37.7892282247503, -122.42050126059) | ||
| 8652 | 8652 | 17853 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2107 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003780.8726 | 2115230.9219 | 37.7882344536868 | -122.430738528508 | (37.7882344536868, -122.430738528508) | |||
| 8688 | 8688 | 19233 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 605 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 6 | 3X3 | 6002090.2242 | 2110622.18 | 37.7754840861265 | -122.436257924088 | (37.7754840861265, -122.436257924088) | ||
| 8865 | 8865 | 21647 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1660 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 6004652.0562 | 2114715.3557 | 37.786868156632295 | -122.427687630429 | (37.7868681566323, -122.427687630429) | |||
| 9024 | 9024 | 17192 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004636.98078 | 2116874.21207 | 37.792794979656 | -122.42789367737801 | (37.792794979656, -122.427893677378) | |||
| 9065 | 9065 | 2324 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2298X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1996 12:00:00 AM | 6 | 3X3 | 6009641.4422065 | 2103972.2905262 | 37.7576511632266 | -122.409666876922 | (37.7576511632266, -122.409666876922) | ||
| 9116 | 9116 | 26550 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1997 12:00:00 AM | 9 | 3x3 | 6009840.2362842 | 2101212.306322 | 37.750084000170396 | -122.40878464955401 | (37.7500840001704, -122.408784649554) | ||
| 9144 | 9144 | 23646 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006680.626318 | 2098423.5908349 | 37.7422493368979 | -122.419512955866 | (37.7422493368979, -122.419512955866) | |||
| 9152 | 9152 | 3994 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 281 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002294.9936565 | 2106589.3936607 | 37.7644226821565 | -122.435261055898 | (37.7644226821565, -122.435261055898) | |||
| 9222 | 9222 | 3940 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002266.5 | 2107605.5 | 37.767211043352 | -122.435432299631 | (37.767211043352, -122.435432299631) | |||
| 9224 | 9224 | 3988 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 263 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002289.1914049005 | 2106695.3229 | 37.764713208493795 | -122.435288701865 | (37.7647132084938, -122.435288701865) | |||
| 9281 | 9281 | 26276 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1770 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185002 | 37.729396929882704 | -122.43943496951599 | (37.7293969298827, -122.439434969516) | |||
| 9312 | 9312 | 28298 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.475430001 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | ||
| 9362 | 9362 | 2360 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2450 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1999 12:00:00 AM | 8 | 3X3 | 6009684.705885201 | 2103070.313359 | 37.755176960826795 | -122.409453597226 | (37.7551769608268, -122.409453597226) | ||
| 9379 | 9379 | 18368 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 635 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1991 12:00:00 AM | 18 | 3X3 | 6010442.749915901 | 2105355.8900533 | 37.7614950871774 | -122.40699313368299 | (37.7614950871774, -122.406993133683) | ||
| 9383 | 9383 | 2322 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2290 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1996 12:00:00 AM | 9 | 3X3 | 6009654.0 | 2104017.0 | 37.7577746290621 | -122.40962660234301 | (37.7577746290621, -122.409626602343) | ||
| 9388 | 9388 | 6758 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1355 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046003 | 37.738846926957706 | -122.382978527185 | (37.7388469269577, -122.382978527185) | ||
| 9408 | 9408 | 3991 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 271 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002291.775341 | 2106648.1490788003 | 37.76458382743429 | -122.435276390167 | (37.7645838274343, -122.435276390167) | |||
| 9435 | 9435 | 6839 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1475 FAIRFAX AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6016157.0 | 2097767.0 | 37.740975685587394 | -122.386700497992 | (37.7409756855874, -122.386700497992) | ||
| 9452 | 9452 | 2383 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2600 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 8 | 3X3 | 6009707.0 | 2102117.0 | 37.752560624409 | -122.409309226081 | (37.752560624409, -122.409309226081) | ||
| 9523 | 9523 | 21636 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1630 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004948.4275 | 2114804.4986 | 37.7871296807328 | -122.42666860400298 | (37.7871296807328, -122.426668604003) | |||
| 9549 | 9549 | 14717 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 860 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6002499.3078 | 2111491.3684 | 37.77789389493321 | -122.434904982102 | (37.7778938949332, -122.434904982102) | |||
| 9816 | 9816 | 113835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 920X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007995.0 | 2102398.0 | 37.753236120336105 | -122.415249523598 | (37.7532361203361, -122.415249523598) | |||
| 9979 | 9979 | 173763 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 347 Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6004948.0 | 2106317.0 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | |||
| 10526 | 10526 | 1853 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1991 12:00:00 AM | 6 | 3X3 | 6011002.0813 | 2086868.5454799999 | 37.710764047595895 | -122.40375773612499 | (37.7107640475959, -122.403757736125) | ||
| 10641 | 10641 | 87649 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2132 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6011869.04727 | 2087711.09521 | 37.7131259154971 | -122.400820441523 | (37.7131259154971, -122.400820441523) | |||
| 11169 | 11169 | 13364 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 830 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X6 | 6009414.26867 | 2090086.5826 | 37.7195112854978 | -122.409472568024 | (37.7195112854978, -122.409472568024) | ||
| 11183 | 11183 | 107055 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 116 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003293.700669999 | 2094464.35217 | 37.7311868176017 | -122.430941393456 | (37.7311868176017, -122.430941393456) | |||
| 11351 | 11351 | 1825 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2122 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 3x3 | 6011914.69441 | 2087767.06521 | 37.7132821439374 | -122.400666598098 | (37.7132821439374, -122.400666598098) | ||
| 11397 | 11397 | 1847 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2401 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/1992 12:00:00 AM | 6 | 3X3 | 6011018.94328 | 2086899.6940900001 | 37.710850517399294 | -122.403701647223 | (37.7108505173993, -122.403701647223) | ||
| 11453 | 11453 | 1831 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011874.06348 | 2087549.91911 | 37.71268363791079 | -122.40079178733299 | (37.7126836379108, -122.400791787333) | |||
| 11505 | 11505 | 9312 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 201 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/19/1996 12:00:00 AM | 18 | 3X3 | 6011150.91065 | 2090494.63416 | 37.7207288659168 | -122.403498291618 | (37.7207288659168, -122.403498291618) | ||
| 11526 | 11526 | 1872 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010689.185380001 | 2086549.45702 | 37.709870410169 | -122.40481673101101 | (37.709870410169, -122.404816731011) | ||
| 11706 | 11706 | 1824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6011980.13832 | 2087849.66723 | 37.71351260240579 | -122.40044619853201 | (37.7135126024058, -122.400446198532) | |||
| 11791 | 11791 | 1865 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2555 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6010708.42536 | 2086342.04995 | 37.709301987375206 | -122.404735641836 | (37.7093019873752, -122.404735641836) | |||
| 11889 | 11889 | 87695 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2630 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6010495.31841 | 2086065.48531 | 37.7085306829266 | -122.40545271269501 | (37.7085306829266, -122.405452712695) | |||
| 12224 | 12224 | 95538 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6001061.1187 | 2087367.06647 | 37.711572521034604 | -122.438151583834 | (37.7115725210346, -122.438151583834) | ||||
| 12296 | 12296 | 19104 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.4617400002 | 37.721569360619604 | -122.40160216911 | (37.7215693606196, -122.40160216911) | ||
| 12308 | 12308 | 19103 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011731.72061 | 2090797.59755 | 37.7215931665719 | -122.40151188079099 | (37.7215931665719, -122.401511880791) | ||
| 12384 | 12384 | 1828 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2144 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011802.738969999 | 2087632.59723 | 37.7129066769684 | -122.40104411460199 | (37.7129066769684, -122.401044114602) | |||
| 12608 | 12608 | 13371 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 910 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 3X10 | 6009145.59882 | 2090004.2145 | 37.7192700621295 | -122.410395452309 | (37.7192700621295, -122.410395452309) | ||
| 12915 | 12915 | 87687 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010522.05865 | 2086133.85401 | 37.70871990477921 | -122.40536510614099 | (37.7087199047792, -122.405365106141) | |||
| 12947 | 12947 | 87653 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2180X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6011545.44829 | 2087485.71058 | 37.7124889994373 | -122.401923081412 | (37.7124889994373, -122.401923081412) | ||||
| 13179 | 13179 | 13362 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 735 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3X3 | 6009726.8800800005 | 2090058.8572200001 | 37.719452668580296 | -122.408390025292 | (37.7194526685803, -122.408390025292) | ||
| 13312 | 13312 | 20032 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3ST | ||||||||
| 13375 | 13375 | 26662 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.73881606509521 | -122.382981244792 | (37.7388160650952, -122.382981244792) | ||
| 13420 | 13420 | 85563 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.0442599999 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | ||
| 13422 | 13422 | 29844 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014896.13106 | 2099120.97008 | 37.74462351995 | -122.39115477280001 | (37.74462351995, -122.3911547728) | ||
| 13440 | 13440 | 100767 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 5 Bernice St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008552.5451 | 2108569.89126 | 37.7702140354665 | -122.41375794007601 | (37.7702140354665, -122.413757940076) | |||
| 13505 | 13505 | 96669 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1401 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015030.8283 | 2095408.9192 | 37.734438465157794 | -122.39042969561301 | (37.7344384651578, -122.390429695613) | |||
| 13517 | 13517 | 17430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1887 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013360.18498 | 2096350.84555 | 37.7369319827098 | -122.396271694904 | (37.7369319827098, -122.396271694904) | |||
| 13527 | 13527 | 17453 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1978 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6012900.1702 | 2096763.4249599997 | 37.7380392316108 | -122.39789111398599 | (37.7380392316108, -122.397891113986) | |||
| 13529 | 13529 | 29838 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014986.46906 | 2099054.93467 | 37.7444472132656 | -122.39083778516 | (37.7444472132656, -122.39083778516) | ||
| 13541 | 13541 | 17406 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1788 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 6 | 3x3 | 6013914.850190001 | 2096007.1900099998 | 37.736019223903796 | -122.39432990213001 | (37.7360192239038, -122.39432990213) | ||
| 13544 | 13544 | 85704 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 938 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010866.4915 | 2112368.00991 | 37.7807724621315 | -122.406021584247 | (37.7807724621315, -122.406021584247) | ||
| 13557 | 13557 | 85590 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1570 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015074.2477 | 2095138.5099 | 37.733698384584706 | -122.39026069321599 | (37.7336983845847, -122.390260693216) | ||
| 13562 | 13562 | 85705 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 938 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010851.34827 | 2112352.58315 | 37.780729256891 | -122.40607288515801 | (37.780729256891, -122.406072885158) | ||
| 13564 | 13564 | 29854 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014413.12367 | 2099481.40364 | 37.7455863790999 | -122.39285014143299 | (37.7455863790999, -122.392850141433) | ||
| 13572 | 13572 | 85710 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1076 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010030.29241 | 2111566.1673 | 37.7785239870252 | -122.40885782654199 | (37.7785239870252, -122.408857826542) | ||
| 13575 | 13575 | 85711 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1142 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009562.66342 | 2111118.44012 | 37.777268429139205 | -122.410443916749 | (37.7772684291392, -122.410443916749) | ||
| 13614 | 13614 | 110036 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1899x Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x105 | 6013794.5157699995 | 2098115.90007 | 37.741802613794 | -122.39489359088199 | (37.741802613794, -122.394893590882) | |||
| 13676 | 13676 | 6743 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016859.78768 | 2097310.83297 | 37.7397620268834 | -122.38423873174101 | (37.7397620268834, -122.384238731741) | |||
| 13696 | 13696 | 18312 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 150 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2001 12:00:00 AM | 3 | 4X4 | 6010232.50216 | 2107573.2091900003 | 37.7675715736855 | -122.40787665988 | (37.7675715736855, -122.40787665988) | ||
| 13697 | 13697 | 26609 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1485 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6011735.62232 | 2092555.2552599998 | 37.7264195519176 | -122.401621868778 | (37.7264195519176, -122.401621868778) | ||
| 13751 | 13751 | 85582 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1486 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015517.7847 | 2094813.6891 | 37.7328310842891 | -122.388704574636 | (37.7328310842891, -122.388704574636) | ||
| 13767 | 13767 | 106955 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Lydia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012806.82936 | 2092830.5845700002 | 37.7272352666734 | -122.397938034333 | (37.7272352666734, -122.397938034333) | |||
| 13768 | 13768 | 101791 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 795 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012441.6191 | 2112904.7771 | 37.7823342715514 | -122.400610137868 | (37.7823342715514, -122.400610137868) | |||
| 13782 | 13782 | 121585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 424 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6013758.73818 | 2105099.18568 | 37.760975233543 | -122.395506429391 | (37.760975233543, -122.395506429391) | ||
| 13786 | 13786 | 85847 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1556 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007771.67614 | 2109375.7232 | 37.7723827775814 | -122.41651605826401 | (37.7723827775814, -122.416516058264) | ||
| 13790 | 13790 | 17386 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1648 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 3 | 6x8 | 6014603.23708 | 2095493.0278200002 | 37.734645681237 | -122.391913910302 | (37.734645681237, -122.391913910302) | ||
| 13806 | 13806 | 17418 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1836 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013497.33408 | 2096318.8347200002 | 37.7368517182296 | -122.39579526375401 | (37.7368517182296, -122.395795263754) | |||
| 13809 | 13809 | 28891 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 525 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2011 12:00:00 AM | 3 | 3x3 | 6013294.03669 | 2111784.2420799998 | 37.779305042839106 | -122.397582515238 | (37.7793050428391, -122.397582515238) | ||
| 13860 | 13860 | 85609 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1551 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015130.3081 | 2095032.4348 | 37.7334102332415 | -122.390059466624 | (37.7334102332415, -122.390059466624) | ||
| 13886 | 13886 | 85845 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1488 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008105.12065 | 2109729.2869599997 | 37.773372326810396 | -122.41538767349701 | (37.7733723268104, -122.415387673497) | ||
| 13923 | 13923 | 29859 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1900X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014017.477000001 | 2099779.02044 | 37.7463815884414 | -122.394239070574 | (37.7463815884414, -122.394239070574) | ||
| 13944 | 13944 | 18360 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 530 Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2015 08:17:00 AM | 3 | 3X3 | 6010334.09693 | 2105739.38187 | 37.762541988345106 | -122.407395957864 | (37.7625419883451, -122.407395957864) | ||
| 13952 | 13952 | 28719 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1636 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6014663.94428 | 2095448.06679 | 37.734525597483895 | -122.391700880702 | (37.7345255974839, -122.391700880702) | ||
| 13956 | 13956 | 15145 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 806 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6011309.103209999 | 2113664.0112900003 | 37.784355723588206 | -122.404581625747 | (37.7843557235882, -122.404581625747) | |||
| 13973 | 13973 | 85703 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 934 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010909.37789 | 2112408.77368 | 37.7808867884374 | -122.40587609101401 | (37.7808867884374, -122.405876091014) | ||
| 13994 | 13994 | 111136 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 301 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6011714.08738 | 2112122.07313 | 37.7801445464617 | -122.40307201838199 | (37.7801445464617, -122.403072018382) | |||
| 14016 | 14016 | 85738 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 843 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011557.50766 | 2112935.25415 | 37.782368606777204 | -122.40367093449 | (37.7823686067772, -122.40367093449) | ||
| 14028 | 14028 | 85729 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1035 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010261.4115 | 2111695.5435099998 | 37.778892166773296 | -122.408067420501 | (37.7788921667733, -122.408067420501) | ||
| 14077 | 14077 | 101792 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 795 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012455.0203 | 2112918.9994 | 37.7823740700821 | -122.40056477473 | (37.7823740700821, -122.40056477473) | |||
| 14094 | 14094 | 85585 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1516 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015333.6646 | 2094945.596 | 37.733183067921 | -122.389350338061 | (37.733183067921, -122.389350338061) |
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");