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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 8 | 122650 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11 | 11 | 122658 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12 | 12 | 122660 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 13 | 13 | 122648 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 16 | 16 | 122649 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 3264 | 3264 | 253390 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 11396 | 11396 | 122654 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11418 | 11418 | 122651 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11649 | 11649 | 122647 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12297 | 12297 | 122656 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12338 | 12338 | 122652 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18303 | 18303 | 122659 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18304 | 18304 | 122653 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18306 | 18306 | 122645 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18307 | 18307 | 122655 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18312 | 18312 | 122646 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18314 | 18314 | 122661 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18321 | 18321 | 122657 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 165256 | 165256 | 49372 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005157.82583 | 2086153.99564 | 37.708473828664204 | -122.42390605733999 | (37.7084738286642, -122.42390605734) | |||
| 150446 | 150446 | 49391 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005169.44863 | 2086179.03953 | 37.7085432500485 | -122.42386766708599 | (37.7085432500485, -122.423867667086) | |||
| 69920 | 69920 | 49378 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005189.74904 | 2086240.2488 | 37.7087124637721 | -122.423801855593 | (37.7087124637721, -122.423801855593) | |||
| 71869 | 71869 | 49375 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005207.53082 | 2086275.43702 | 37.708810086982396 | -122.423742899628 | (37.7088100869824, -122.423742899628) | |||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 140658 | 140658 | 92758 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 144843 | 144843 | 92757 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 132408 | 132408 | 175130 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.603519999 | 2086651.0077400003 | 37.7095529054216 | -122.441347441633 | (37.7095529054216, -122.441347441633) | |||
| 60498 | 60498 | 175129 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000010.16428 | 2086668.02018 | 37.7095932687863 | -122.441733813766 | (37.7095932687863, -122.441733813766) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 94213 | 94213 | 87436 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3726X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5993141.944866001 | 2087637.371973 | 37.7118611458885 | -122.46554174995501 | (37.7118611458885, -122.465541749955) | ||
| 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) | ||
| 18687 | 18687 | 49144 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.714977603179705 | -122.45935873857901 | (37.7149776031797, -122.459358738579) | |||
| 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) | ||
| 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) | ||
| 139129 | 139129 | 87445 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.5231299999 | 37.7158786645875 | -122.44462672412901 | (37.7158786645875, -122.444626724129) | |||
| 17188 | 17188 | 28843 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.0124700002 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | ||
| 33913 | 33913 | 96284 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | |
| 72048 | 72048 | 96285 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.425009999 | 2090666.70864 | 37.721244132491606 | -122.40086075544501 | (37.7212441324916, -122.400860755445) | |
| 188625 | 188625 | 96283 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3229 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58766 | 6011911.44714 | 2090686.2999099998 | 37.721297592691 | -122.40088279510599 | (37.721297592691, -122.400882795106) | |
| 70521 | 70521 | 175131 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011901.5218 | 2090720.7857400002 | 37.7213917301239 | -122.400919526131 | (37.7213917301239, -122.400919526131) | |||
| 76923 | 76923 | 96282 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.0865599997 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) | |
| 153460 | 153460 | 175132 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3209 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011889.98271 | 2090759.5366599998 | 37.7214974885945 | -122.400962135093 | (37.7214974885945, -122.400962135093) | |||
| 105474 | 105474 | 87551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3195 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011859.438328 | 2090836.432048 | 37.7217069237885 | -122.401073119638 | (37.7217069237885, -122.401073119638) | ||||
| 110228 | 110228 | 87554 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/27/2012 12:00:00 AM | 3 | 3x3 | 6011804.054149 | 2091016.0998479999 | 37.7221971651364 | -122.401277188669 | (37.7221971651364, -122.401277188669) | ||
| 127570 | 127570 | 28674 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3130 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x3 | 6011742.0620525 | 2091064.4440916001 | 37.7223264497375 | -122.401494877675 | (37.7223264497375, -122.401494877675) | |||
| 114290 | 114290 | 114441 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2809 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011711.0 | 2091301.0 | 37.7229742506471 | -122.401618870695 | (37.7229742506471, -122.401618870695) | ||||
| 88009 | 88009 | 28705 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3028 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 3 | 3X3 | 6011599.0463446 | 2091533.0938880001 | 37.7236052850781 | -122.40202218213498 | (37.7236052850781, -122.402022182135) | ||
| 39249 | 39249 | 175137 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | |||
| 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) | ||
| 10876 | 10876 | 28683 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | ||
| 87948 | 87948 | 114440 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011605.0 | 2091859.0 | 37.724500488626 | -122.402024501601 | (37.724500488626, -122.402024501601) | ||||
| 73165 | 73165 | 175136 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 313 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5999930.3709 | 2092032.12822 | 37.7243173479397 | -122.442394436857 | (37.7243173479397, -122.442394436857) | |||
| 125440 | 125440 | 28681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.40246692394899 | (37.7251313079457, -122.402466923949) | |||
| 139235 | 139235 | 28680 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 2x3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.40246692394899 | (37.7251313079457, -122.402466923949) | ||
| 145774 | 145774 | 28679 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.40246692394899 | (37.7251313079457, -122.402466923949) | |||
| 92136 | 92136 | 28684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6011474.8425665 | 2092113.9713098 | 37.725193321952894 | -122.402492361636 | (37.7251933219529, -122.402492361636) | |||
| 87355 | 87355 | 28686 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2955 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011473.964837001 | 2092116.8636216999 | 37.725201214643995 | -122.402495599163 | (37.725201214644, -122.402495599163) | |||
| 83235 | 83235 | 87549 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 9x3 | 6011453.6953529995 | 2092165.7677830001 | 37.7253343637789 | -122.40256910651001 | (37.7253343637789, -122.40256910651) | |||
| 128007 | 128007 | 122701 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 145746 | 145746 | 122700 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 35576 | 35576 | 175135 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 144 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000350.62933 | 2092307.6786599997 | 37.7250978911274 | -122.440961425642 | (37.7250978911274, -122.440961425642) | |||
| 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) | ||
| 118445 | 118445 | 28665 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2832 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6011329.7470869 | 2092413.4297691002 | 37.7260074716945 | -122.403014998161 | (37.7260074716945, -122.403014998161) | |||
| 83551 | 83551 | 28663 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2826 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011313.9934641 | 2092464.2100286998 | 37.7261460240505 | -122.40307302798 | (37.7261460240505, -122.40307302798) | |||
| 10347 | 10347 | 87548 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2809 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2015 12:00:00 AM | 3 | 3x3 | 6011363.6591 | 2092480.1221 | 37.726192488710105 | -122.40290245438601 | (37.7261924887101, -122.402902454386) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 116745 | 116745 | 87547 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2713 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x3 | 6011213.1328839995 | 2092950.939207 | 37.7274768484357 | -122.40345592690399 | (37.7274768484357, -122.403455926904) | |||
| 10649 | 10649 | 87528 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 4x4 | 6011133.0386 | 2093058.8298 | 37.727768619555896 | -122.403740403083 | (37.7277686195559, -122.403740403083) | ||
| 12370 | 12370 | 27313 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6011127.7854 | 2093073.5386 | 37.7278087133965 | -122.403759598129 | (37.7278087133965, -122.403759598129) | ||
| 182547 | 182547 | 30769 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1642 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 7 | Permit Number 34649 | 6014556.9626 | 2093085.2912 | 37.7280319553097 | -122.391905589486 | (37.7280319553097, -122.391905589486) | |
| 10879 | 10879 | 27312 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2670 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011119.0302 | 2093108.0343 | 37.7279029423042 | -122.403792291485 | (37.7279029423042, -122.403792291485) | ||
| 40080 | 40080 | 175138 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6004374.522580001 | 2093135.8569099999 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 94522 | 94522 | 87542 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2623 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6011089.312198 | 2093349.0306330002 | 37.7285630077799 | -122.40391197969299 | (37.7285630077799, -122.403911979693) | |||
| 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) | ||
| 130108 | 130108 | 199670 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1907 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015203.4065 | 2093411.0787 | 37.7289623696233 | -122.389693539093 | (37.7289623696233, -122.389693539093) | |||
| 50896 | 50896 | 68389 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.728420898703604 | -122.43531143848 | (37.7284208987036, -122.43531143848) | |
| 80390 | 80390 | 91046 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972.0 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | ||
| 69148 | 69148 | 175140 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009153.39783 | 2093543.6982200001 | 37.72898917670221 | -122.41061831061 | (37.7289891767022, -122.41061831061) | |||
| 131057 | 131057 | 53151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.38631399173599 | (37.7293905172533, -122.386313991736) | ||
| 145230 | 145230 | 53153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.729432620466596 | -122.386379154297 | (37.7294326204666, -122.386379154297) | ||
| 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) | ||
| 38232 | 38232 | 175141 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009144.52669 | 2093573.47642 | 37.7290704439367 | -122.410651080984 | (37.7290704439367, -122.410651080984) | |||
| 162704 | 162704 | 175142 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009135.1326 | 2093603.39042 | 37.7291520547186 | -122.41068566890499 | (37.7291520547186, -122.410685668905) | |||
| 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) | ||
| 28374 | 28374 | 175143 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009125.76929 | 2093634.7983 | 37.729237769091505 | -122.41072025595 | (37.7292377690915, -122.41072025595) | |||
| 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");