Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20896 | 20896 | 523 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2813 24th St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777511 | 6009929.7366 | 2102188.669 | 37.752769888235704 | -122.408544016423 | (37.7527698882357, -122.408544016423) | |
| 129276 | 129276 | 586 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6008691.81998 | 2102185.56005 | 37.7526919453923 | -122.412824751929 | (37.7526919453923, -122.412824751929) | ||
| 17525 | 17525 | 654 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3255X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007301.1492800005 | 2102040.7128 | 37.7522160715366 | -122.417623684893 | (37.7522160715366, -122.417623684893) | ||
| 19003 | 19003 | 658 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3266 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007255.021480001 | 2102083.69856 | 37.7523315048963 | -122.417786249056 | (37.7523315048963, -122.417786249056) | ||
| 82637 | 82637 | 671 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3300X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.41846908204701 | (37.7523068461089, -122.418469082047) | ||
| 93372 | 93372 | 672 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3300X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.41846908204701 | (37.7523068461089, -122.418469082047) | ||
| 18419 | 18419 | 852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008391.48003 | 2095227.15251 | 37.7335688330362 | -122.413371331432 | (37.7335688330362, -122.413371331432) | ||
| 21659 | 21659 | 853 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 370 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008364.22406 | 2095210.3079400002 | 37.7335210511394 | -122.4134643726 | (37.7335210511394, -122.4134643726) | ||
| 20255 | 20255 | 854 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008336.69687 | 2095197.2977599998 | 37.7334837823442 | -122.41355862243499 | (37.7334837823442, -122.413558622435) | ||
| 21413 | 21413 | 860 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902000001 | 2095033.6674400002 | 37.7330190549875 | -122.41449709467501 | (37.7330190549875, -122.414497094675) | ||
| 21927 | 21927 | 861 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.41458540809799 | (37.7329747750588, -122.414585408098) | ||
| 21317 | 21317 | 862 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008011.36344 | 2095005.6880599998 | 37.732939390338004 | -122.414669840947 | (37.732939390338, -122.414669840947) | |||
| 11390 | 11390 | 887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1132 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2016 12:00:00 AM | 3 | 3x4 | 6003641.7751 | 2094429.9895799998 | 37.731112181982205 | -122.429735588731 | (37.7311121819822, -122.429735588731) | ||
| 9232 | 9232 | 903 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 6003354.20402 | 2094344.7552 | 37.7308618593504 | -122.430723691407 | (37.7308618593504, -122.430723691407) | ||
| 13076 | 13076 | 921 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1252 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 6002917.86629 | 2094183.9473299999 | 37.730395586884 | -122.432220700641 | (37.730395586884, -122.432220700641) | ||
| 145366 | 145366 | 1004 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1810X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6001283.16417 | 2091702.46996 | 37.7234891944335 | -122.43769443354799 | (37.7234891944335, -122.437694433548) | ||
| 13022 | 13022 | 1124 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.0726700001 | 37.715367165446 | -122.44525144000099 | (37.715367165446, -122.445251440001) | ||
| 120312 | 120312 | 1128 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | ||
| 95494 | 95494 | 1203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3111X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 90255 | 90255 | 1204 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 93119 | 93119 | 1205 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 94366 | 94366 | 1221 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3600X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 102281 | 102281 | 1264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3995X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 3 | 3x3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
| 21229 | 21229 | 2361 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009745.3225 | 2103030.00614 | 37.7550696824471 | -122.409241122079 | (37.7550696824471, -122.409241122079) | ||
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 9126 | 9126 | 2365 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6009712.991769 | 2102766.5035063997 | 37.7543443518018 | -122.409334337085 | (37.7543443518018, -122.409334337085) | |||
| 22267 | 22267 | 2366 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.754276171914704 | -122.40935049224501 | (37.7542761719147, -122.409350492245) | |||
| 22140 | 22140 | 2381 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2599X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2016 12:00:00 AM | 6 | 3X3 | 6009783.37246 | 2102329.05064 | 37.753147146843794 | -122.409060076881 | (37.7531471468438, -122.409060076881) | ||
| 18574 | 18574 | 2384 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2603 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6009796.778530001 | 2102081.51983 | 37.752468233345496 | -122.408996251977 | (37.7524682333455, -122.408996251977) | ||
| 18833 | 18833 | 2391 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2647 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009810.4696 | 2101915.90023 | 37.7520142456811 | -122.40893722139799 | (37.7520142456811, -122.408937221398) | ||
| 19852 | 19852 | 2400 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2705 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 7 | 3X3 | 6009830.21758 | 2101529.52797 | 37.750954459389895 | -122.40884167290301 | (37.7509544593899, -122.408841672903) | ||
| 17211 | 17211 | 2422 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2837 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 3 | 3X3 | 6009869.07173 | 2100846.12379 | 37.7490801589169 | -122.408659105156 | (37.7490801589169, -122.408659105156) | ||
| 21770 | 21770 | 2424 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2843 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1994 12:00:00 AM | 3 | 3X3 | 6009873.38674 | 2100822.7763099996 | 37.7490162935621 | -122.408642536922 | (37.7490162935621, -122.408642536922) | ||
| 23108 | 23108 | 2426 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6009874.246230001 | 2100776.83629 | 37.748890200541 | -122.408636324408 | (37.748890200541, -122.408636324408) | |||
| 21890 | 21890 | 4154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3718 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 6 | 3X3 | 6005698.2411400005 | 2100539.02617 | 37.748002458148 | -122.423060071381 | (37.748002458148, -122.423060071381) | ||
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 99429 | 99429 | 6293 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 24 | 5x7 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | |
| 79248 | 79248 | 7375 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2907X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6009449.897223599 | 2102159.1699056 | 37.7526620055733 | -122.410201312287 | (37.7526620055733, -122.410201312287) | ||
| 1377 | 1377 | 8105 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 780 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 8 | 3X3 | 6004061.6732 | 2111513.0828 | 37.7780421005615 | -122.42950176141899 | (37.7780421005615, -122.429501761419) | ||
| 236 | 236 | 8118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.777736949412606 | -122.430681932079 | (37.7777369494126, -122.430681932079) | ||
| 85434 | 85434 | 8222 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 105020 | 105020 | 8224 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 104454 | 104454 | 8231 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 2 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 87619 | 87619 | 8233 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2008 12:00:00 AM | 4 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 90665 | 90665 | 8236 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 113610 | 113610 | 8237 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 115022 | 115022 | 8239 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 79340 | 79340 | 8240 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 94543 | 94543 | 8241 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 140469 | 140469 | 8242 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 101619 | 101619 | 8243 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 116842 | 116842 | 8244 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 100234 | 100234 | 8245 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 86646 | 86646 | 8246 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 129060 | 129060 | 8249 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1515 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016234.0 | 2097322.0 | 37.7397580688138 | -122.38640323868799 | (37.7397580688138, -122.386403238688) | ||
| 123779 | 123779 | 8251 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1515 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2014 12:00:00 AM | 3 | 3x3 | 6016234.0 | 2097322.0 | 37.7397580688138 | -122.38640323868799 | (37.7397580688138, -122.386403238688) | ||
| 93822 | 93822 | 8255 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1525 GALVEZ AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:01:00 AM | 3 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 14738 | 14738 | 8260 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015944.99866 | 2097559.42208 | 37.74039397959 | -122.38741905015301 | (37.74039397959, -122.387419050153) | ||
| 15672 | 15672 | 8261 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015960.32543 | 2097546.41144 | 37.7403591038818 | -122.387365148376 | (37.7403591038818, -122.387365148376) | ||
| 15760 | 15760 | 8264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6016042.026869999 | 2097486.66692 | 37.74019958213879 | -122.38707848858401 | (37.7401995821388, -122.387078488584) | ||
| 15549 | 15549 | 8265 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | 3x3 | 6016061.13265 | 2097468.88208 | 37.7401518065476 | -122.387011187809 | (37.7401518065476, -122.387011187809) | ||
| 15125 | 15125 | 8266 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016120.90063 | 2097426.65215 | 37.740039161084496 | -122.38680158822599 | (37.7400391610845, -122.386801588226) | ||
| 139982 | 139982 | 9750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | ||
| 94226 | 94226 | 9751 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | ||
| 84517 | 84517 | 14652 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 116615 | 116615 | 14653 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 109241 | 109241 | 14667 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 716 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | ||
| 115466 | 115466 | 14755 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 950X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 0 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | ||
| 3726 | 3726 | 14780 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.42862680452801 | (37.7789575666093, -122.428626804528) | ||
| 87832 | 87832 | 14784 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1067 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 4X4 | 6004083.630320299 | 2111809.5297481003 | 37.7788573137505 | -122.429446949988 | (37.7788573137505, -122.429446949988) | ||
| 101439 | 101439 | 14797 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1135 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | 0 | 4X4 | 6003741.3117055 | 2111761.9657456 | 37.77870732769679 | -122.43062777021099 | (37.7787073276968, -122.430627770211) | ||
| 23350 | 23350 | 14857 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 3x3 | 6002635.4903 | 2111607.9304 | 37.7782216761893 | -122.43444221569099 | (37.7782216761893, -122.434442215691) | ||
| 113872 | 113872 | 14858 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3x3 | 6002643.52073 | 2111588.23646 | 37.778168057391206 | -122.434413027102 | (37.7781680573912, -122.434413027102) | ||
| 11051 | 11051 | 16382 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.0721099998 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | ||
| 145286 | 145286 | 22539 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1441X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X6 | 6002335.8535400005 | 2093628.68187 | 37.728837937275 | -122.43419311802099 | (37.728837937275, -122.434193118021) | ||
| 6537 | 6537 | 22773 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1741 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001679.7734 | 2112097.4839 | 37.7795115699514 | -122.43778345572599 | (37.7795115699514, -122.437783455726) | |||
| 114320 | 114320 | 24838 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 6 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 103568 | 103568 | 24842 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 122078 | 122078 | 24846 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 200X Alemany Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/29/1998 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 11049 | 11049 | 24848 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/2013 12:00:00 AM | 3 | 3x3 | 6010497.60503 | 2095014.35127 | 37.7331025516429 | -122.406074827698 | (37.7331025516429, -122.406074827698) | ||
| 12783 | 12783 | 24849 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 3 | 2x2 | 6010506.727580001 | 2094990.7524400002 | 37.7330382644924 | -122.40604162653 | (37.7330382644924, -122.40604162653) | ||
| 9188 | 9188 | 24853 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2434 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 5 | 3x3 | 6010702.6993234 | 2094455.8290061 | 37.7315804365911 | -122.40532643981899 | (37.7315804365911, -122.405326439819) | ||
| 142268 | 142268 | 24854 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2442 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6010724.9783872 | 2094386.6708818001 | 37.7313917885461 | -122.40524454808399 | (37.7313917885461, -122.405244548084) | ||
| 13147 | 13147 | 24862 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2626 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 4 | 3x3 | 6011036.3806 | 2093380.4977 | 37.728646452424705 | -122.40409718178101 | (37.7286464524247, -122.404097181781) | ||
| 10401 | 10401 | 24863 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213002 | (37.7283158506885, -122.40395790213) | ||
| 138429 | 138429 | 24864 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2646 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1996 12:00:00 AM | 3 | 3X3 | 6011078.0001009 | 2093234.4353165 | 37.728247720930796 | -122.403943025563 | (37.7282477209308, -122.403943025563) | ||
| 138403 | 138403 | 24865 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2658 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2000 12:00:00 AM | 8 | 3X3 | 6011093.914859099 | 2093183.5451124 | 37.7281088761684 | -122.403884427694 | (37.7281088761684, -122.403884427694) | ||
| 11275 | 11275 | 24866 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1996 12:00:00 AM | 3 | 3X3 | 6011160.2152 | 2093140.3949 | 37.727994098496204 | -122.403652189094 | (37.7279940984962, -122.403652189094) | ||
| 11114 | 11114 | 24872 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011136.5589 | 2093211.8894 | 37.728189086016705 | -122.40373899855601 | (37.7281890860167, -122.403738998556) | ||
| 12270 | 12270 | 24873 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2585 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011029.3172 | 2093570.939 | 37.7291689698102 | -122.40413499793101 | (37.7291689698102, -122.404134997931) | ||
| 82518 | 82518 | 24875 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2559 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3x3 | 6010991.150909299 | 2093686.6170284 | 37.7294844648724 | -122.404275081222 | (37.7294844648724, -122.404275081222) | ||
| 11321 | 11321 | 24880 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.73089595245371 | -122.40485560772899 | (37.7308959524537, -122.404855607729) | ||
| 91672 | 91672 | 24886 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2750 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X2 | 6011218.493881401 | 2092777.6374656002 | 37.727001297273205 | -122.403425206874 | (37.7270012972732, -122.403425206874) | |||
| 12098 | 12098 | 24887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2770 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 3 | 4x4 | 6011241.1722 | 2092707.2223 | 37.7268092184902 | -122.40334185639401 | (37.7268092184902, -122.403341856394) | ||
| 10848 | 10848 | 24888 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2774 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 8 | 4x4 | 6011251.1604 | 2092677.7834 | 37.7267289432293 | -122.403305257203 | (37.7267289432293, -122.403305257203) | ||
| 126081 | 126081 | 24903 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2810 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2001 12:00:00 AM | 3 | 3X3 | 6011300.929484299 | 2092506.3204878997 | 37.7262609211022 | -122.403121150432 | (37.7262609211022, -122.403121150432) | ||
| 96658 | 96658 | 24904 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2840 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2001 12:00:00 AM | 3 | 3X3 | 6011333.0 | 2092357.0 | 37.725852708866796 | -122.402999785692 | (37.7258527088668, -122.402999785692) | ||
| 18757 | 18757 | 25477 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009744.3885699995 | 2103075.41158 | 37.7551943032962 | -122.40924755584999 | (37.7551943032962, -122.40924755585) | ||
| 18132 | 18132 | 25478 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2002 12:00:00 AM | 6 | 3X3 | 6009740.95146 | 2103104.50441 | 37.7552739931277 | -122.40926149534401 | (37.7552739931277, -122.409261495344) | ||
| 9403 | 9403 | 25513 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2575 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X4 | 6011006.096908799 | 2093637.3368888001 | 37.72934998707171 | -122.404219944137 | (37.7293499870717, -122.404219944137) |
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");