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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60843 | 60843 | 227110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008268.06848 | 2099378.0671099997 | 37.7449594041621 | -122.41409156248001 | (37.7449594041621, -122.41409156248) | |||
| 82242 | 82242 | 176908 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007885.162769999 | 2093698.9537400003 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | |||
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 104761 | 104761 | 28817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1075 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008023.971390001 | 2093752.9516900002 | 37.7295003553203 | -122.414537636128 | (37.7295003553203, -122.414537636128) | |||
| 10990 | 10990 | 109578 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.72600848708289 | -122.434372977031 | (37.7260084870829, -122.434372977031) |
| 12537 | 12537 | 109577 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) |
| 28609 | 28609 | 227574 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.43384779545299 | (37.764968555288, -122.433847795453) | |||
| 53372 | 53372 | 82870 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.3997599995 | 2094273.0498 | 37.730850041273996 | -122.41939224306401 | (37.730850041274, -122.419392243064) |
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 55448 | 55448 | 60297 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.39815254670201 | (37.7662525295396, -122.398152546702) | |
| 69248 | 69248 | 39552 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.39823478562401 | (37.7662512051775, -122.398234785624) | ||
| 150547 | 150547 | 200836 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.766265411985295 | -122.398001493496 | (37.7662654119853, -122.398001493496) | |||
| 49602 | 49602 | 92857 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | |||
| 84032 | 84032 | 92858 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
| 105500 | 105500 | 92859 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
| 179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
| 162744 | 162744 | 37654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1108 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51611 | 5992123.06102 | 2110701.1817099997 | 37.775129656063 | -122.47074215707899 | (37.775129656063, -122.470742157079) | |
| 104217 | 104217 | 191223 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | |||
| 12102 | 12102 | 27527 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1114 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2015 07:52:00 AM | 3 | 3X3 | 6008222.66754 | 2093785.3034 | 37.729600346979794 | -122.41385300921101 | (37.7296003469798, -122.413853009211) | ||
| 54143 | 54143 | 88190 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1118 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631.0 | 2110372.0 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | |||
| 101190 | 101190 | 51233 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
| 103063 | 103063 | 51232 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
| 103150 | 103150 | 51230 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1130 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | |||
| 43875 | 43875 | 227122 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001978.98288 | 2100703.16052 | 37.7482425519531 | -122.435932838524 | (37.7482425519531, -122.435932838524) | |||
| 125524 | 125524 | 37416 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.748467612799104 | -122.435948474317 | (37.7484676127991, -122.435948474317) | ||
| 179235 | 179235 | 191222 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013778.5148599995 | 2106149.81223 | 37.76386112381729 | -122.39551163825001 | (37.7638611238173, -122.39551163825) | |||
| 58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
| 112698 | 112698 | 88255 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220.0 | 2108137.0 | 37.7684397634087 | -122.44946678758998 | (37.7684397634087, -122.44946678759) | |||
| 107208 | 107208 | 67239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 3x9 | Permit Number 30703 | 6003792.49486353 | 2108815.33294247 | 37.770619498227 | -122.430240430849 | (37.770619498227, -122.430240430849) | |
| 170816 | 170816 | 227585 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003798.52213 | 2108785.73673 | 37.7705385756322 | -122.430217470683 | (37.7705385756322, -122.430217470683) | |||
| 47223 | 47223 | 207040 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996029.169869999 | 2093727.8612799998 | 37.728750294270604 | -122.456002788314 | (37.7287502942706, -122.456002788314) | |||
| 179922 | 179922 | 227114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1168 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008645.7783699995 | 2101760.1601299997 | 37.7515213083843 | -122.412953897625 | (37.7515213083843, -122.412953897625) | |||
| 64001 | 64001 | 69398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.4410400002 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | |
| 11369 | 11369 | 83554 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.5974299998 | 37.728188908672294 | -122.428695428367 | (37.7281889086723, -122.428695428367) |
| 11687 | 11687 | 83518 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) |
| 12350 | 12350 | 83555 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.8249699995 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) |
| 134106 | 134106 | 94712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) |
| 37145 | 37145 | 176886 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002169.33644 | 2093633.7193099998 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | |||
| 81515 | 81515 | 94694 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
| 96167 | 96167 | 94695 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
| 168844 | 168844 | 92401 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.764319978357896 | -122.494515603708 | (37.7643199783579, -122.494515603708) |
| 71244 | 71244 | 227084 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1217 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010060.56336 | 2102014.9446799997 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | |||
| 22968 | 22968 | 115802 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192748999 | (37.7636499175412, -122.50814192749) | ||
| 39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
| 56854 | 56854 | 88482 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014826.8932300005 | 2096240.8429 | 37.7367114428676 | -122.391192904038 | (37.7367114428676, -122.391192904038) | |
| 116014 | 116014 | 88480 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837.0 | 2096254.0 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | ||
| 149498 | 149498 | 65594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | ||
| 150165 | 150165 | 88483 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.5284900002 | 37.7367412859786 | -122.39116233337201 | (37.7367412859786, -122.391162333372) | |
| 174850 | 174850 | 60223 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.5919699995 | 2117542.6242 | 37.7949000677337 | -122.41136858440399 | (37.7949000677337, -122.411368584404) | |
| 138846 | 138846 | 115174 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688.0 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | |||
| 10468 | 10468 | 27000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1236 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6008836.56983 | 2094066.26048 | 37.7304062528391 | -122.411750521985 | (37.7304062528391, -122.411750521985) | ||
| 50178 | 50178 | 206987 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992091.43933 | 2106913.6178900003 | 37.7647281934706 | -122.47057562128799 | (37.7647281934706, -122.470575621288) | |||
| 120684 | 120684 | 88438 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Mason St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421.0 | 2117567.0 | 37.794966684082105 | -122.41138965638599 | (37.7949666840821, -122.411389656386) | |||
| 49141 | 49141 | 83685 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | |
| 53126 | 53126 | 83686 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.292880001 | 2117660.17543 | 37.795221808298294 | -122.411440210903 | (37.7952218082983, -122.411440210903) | |
| 76000 | 76000 | 83687 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.651880001 | 2117634.8999400004 | 37.7951527646548 | -122.41141642115801 | (37.7951527646548, -122.411416421158) | |
| 29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
| 49815 | 49815 | 191231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014752.47592 | 2096139.2766099998 | 37.7364284325307 | -122.391443100815 | (37.7364284325307, -122.391443100815) | |||
| 117474 | 117474 | 88087 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | |||
| 153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
| 31111 | 31111 | 207007 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993382.1086800005 | 2093854.3174299998 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | |||
| 103543 | 103543 | 105757 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | |
| 64011 | 64011 | 176891 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004014.42285 | 2094241.1944400002 | 37.730614887467205 | -122.428433829062 | (37.7306148874672, -122.428433829062) | |||
| 152401 | 152401 | 176892 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004016.19178 | 2094155.9191400001 | 37.7303808407035 | -122.428421637873 | (37.7303808407035, -122.428421637873) | |||
| 161078 | 161078 | 206986 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1284 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992719.06604 | 2106665.13626 | 37.7640822005694 | -122.468386764944 | (37.7640822005694, -122.468386764944) | |||
| 41737 | 41737 | 183303 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | |||
| 42609 | 42609 | 227117 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003535.84775 | 2095026.7825099998 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | |||
| 122625 | 122625 | 59404 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | Permit Number 770892 | 6003547.68037437 | 2095024.45734525 | 37.732739127589895 | -122.43010328255899 | (37.7327391275899, -122.430103282559) | |||
| 25925 | 25925 | 206997 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531523998 | (37.7640822509305, -122.46838531524) | |||
| 83380 | 83380 | 101252 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992716.9 | 2106688.9 | 37.764147324412605 | -122.46839598557699 | (37.7641473244126, -122.468395985577) | ||||
| 73895 | 73895 | 176887 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002286.64114 | 2092541.4001799999 | 37.725849714484404 | -122.434285547657 | (37.7258497144844, -122.434285547657) | |||
| 138540 | 138540 | 176888 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002306.40089 | 2092528.2983099998 | 37.7258148612434 | -122.43421630345301 | (37.7258148612434, -122.434216303453) | |||
| 158472 | 158472 | 82807 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 130 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52471 | 6006613.173690001 | 2094127.5012599998 | 37.730449426586794 | -122.41944147464301 | (37.7304494265868, -122.419441474643) | |
| 47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) | |||
| 57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
| 164675 | 164675 | 250554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | |||
| 118548 | 118548 | 48663 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.76389107150929 | -122.468357408335 | (37.7638910715093, -122.468357408335) | ||
| 128684 | 128684 | 48661 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.76389107150929 | -122.468357408335 | (37.7638910715093, -122.468357408335) | ||
| 175666 | 175666 | 49818 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) |
| 134831 | 134831 | 176914 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009346.093669999 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | |||
| 13204 | 13204 | 27035 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009326.50967 | 2094276.52484 | 37.731011066700894 | -122.410071562372 | (37.7310110667009, -122.410071562372) | ||
| 45759 | 45759 | 206989 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | |||
| 188573 | 188573 | 206988 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.70798 | 2106532.5962799997 | 37.76371854889079 | -122.468361066814 | (37.7637185488908, -122.468361066814) | |||
| 26324 | 26324 | 50815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 131 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2004 12:00:00 AM | 4 | Permit Number 47338 | 5993943.23893 | 2114634.67726 | 37.7860350644754 | -122.464731509757 | (37.7860350644754, -122.464731509757) | ||
| 148929 | 148929 | 63095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | ||
| 12859 | 12859 | 27036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1328 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009383.50137 | 2094296.42093 | 37.7310688913025 | -122.409875935553 | (37.7310688913025, -122.409875935553) | ||
| 161455 | 161455 | 227116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | |||
| 102581 | 102581 | 27315 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1330X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009430.10492 | 2094285.00827 | 37.7310401662886 | -122.409714013149 | (37.7310401662886, -122.409714013149) | ||
| 174682 | 174682 | 31938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1335 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50210 | 5981495.7067 | 2105969.8095 | 37.761518381611 | -122.507152818801 | (37.761518381611, -122.507152818801) | |
| 11736 | 11736 | 26988 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1339 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6009367.01038 | 2094339.1416200001 | 37.731185268979395 | -122.409935962601 | (37.7311852689794, -122.409935962601) | ||
| 1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
| 1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
| 1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
| 1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
| 1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
| 1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
| 1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
| 1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
| 135392 | 135392 | 181684 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.48999290967501 | (37.7620704697574, -122.489992909675) | |||
| 12597 | 12597 | 26986 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1349 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009414.0618 | 2094354.93302 | 37.7312312656966 | -122.409774411069 | (37.7312312656966, -122.409774411069) |
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");