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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12324 | 12324 | 27008 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.7501400001 | 37.731652881356396 | -122.407965571349 | (37.7316528813564, -122.407965571349) | ||
| 12392 | 12392 | 27007 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1424 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009909.30958 | 2094487.23688 | 37.731622285542706 | -122.408071569962 | (37.7316222855427, -122.408071569962) | ||
| 12497 | 12497 | 27237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 279 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3 | 3X3 | 6003060.07524 | 2093688.7909799998 | 37.7290440614247 | -122.43169372578501 | (37.7290440614247, -122.431693725785) | ||
| 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) |
| 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) | |||
| 12620 | 12620 | 27251 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6005015.49022 | 2093543.0573099998 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | |||
| 12688 | 12688 | 27048 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | ||
| 12790 | 12790 | 27106 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 559 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6005090.492430001 | 2093546.0118 | 37.7287669038667 | -122.42466425684299 | (37.7287669038667, -122.424664256843) | ||
| 12809 | 12809 | 93466 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1649 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:27:00 PM | 3 | 3x3 | 5988055.4179 | 2098939.1633 | 37.7425982798609 | -122.483950196784 | (37.7425982798609, -122.483950196784) | ||
| 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) | ||
| 12863 | 12863 | 27284 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | ||
| 12904 | 12904 | 117426 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.920059999 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | ||
| 12933 | 12933 | 27010 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1462 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010153.37045 | 2094576.2882400001 | 37.7318804638018 | -122.407234074496 | (37.7318804638018, -122.407234074496) | ||
| 12940 | 12940 | 27051 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1008 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 6 | 3x3 | 6007619.46607 | 2093557.16905 | 37.7289400449304 | -122.415922196353 | (37.7289400449304, -122.415922196353) | ||
| 13061 | 13061 | 27046 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 790 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6006496.082169999 | 2093583.10222 | 37.728948030017904 | -122.419807663316 | (37.7289480300179, -122.419807663316) | ||
| 13067 | 13067 | 83533 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.43185274573099 | (37.724446620113, -122.431852745731) |
| 13068 | 13068 | 109689 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.7354700002 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) |
| 13072 | 13072 | 27052 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1016 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007658.95865 | 2093571.8872599998 | 37.7289826781912 | -122.415786708996 | (37.7289826781912, -122.415786708996) | ||
| 13205 | 13205 | 27117 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.5126900002 | 37.7286092859714 | -122.42783625385701 | (37.7286092859714, -122.427836253857) | ||
| 13263 | 13263 | 835 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:55:00 AM | 3 | 3X3 | 5981242.3727 | 2105595.8151 | 37.7604765764936 | -122.5080012238 | (37.7604765764936, -122.5080012238) | ||
| 13749 | 13749 | 68842 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.39337550020399 | (37.7588942535933, -122.393375500204) |
| 13879 | 13879 | 50774 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 14988 | 14988 | 27169 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.9927599998 | 37.73612947627829 | -122.39905085001999 | (37.7361294762783, -122.39905085002) | ||
| 16132 | 16132 | 88474 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2350 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011695.42869 | 2099760.86607 | 37.7462023967426 | -122.402267215055 | (37.7462023967426, -122.402267215055) | |
| 17806 | 17806 | 25338 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 297x Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2015 02:44:00 PM | 3 | 3X3 | 5994177.957230001 | 2087395.7640200001 | 37.7112574471386 | -122.46194351998699 | (37.7112574471386, -122.461943519987) | ||
| 19267 | 19267 | 89545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5328 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982088.22815 | 2111702.2127400003 | 37.7772927805161 | -122.505528495685 | (37.7772927805161, -122.505528495685) | ||
| 20660 | 20660 | 88463 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 21386 | 21386 | 19350 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774109 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | |
| 22291 | 22291 | 95431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) |
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 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) | ||
| 24382 | 24382 | 96110 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 714 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767765 | 5982615.54512 | 2110891.71154 | 37.7750983990599 | -122.503644329704 | (37.7750983990599, -122.503644329704) |
| 24388 | 24388 | 63507 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.43653782327401 | (37.7196774559426, -122.436537823274) | ||
| 24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
| 24816 | 24816 | 47267 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296001 | (37.7617374028544, -122.48229953296) | |
| 25321 | 25321 | 227575 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | |||
| 25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
| 25668 | 25668 | 118581 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982478.43556 | 2112606.9372400003 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | |||
| 25776 | 25776 | 227129 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001319.20971 | 2096463.3667400002 | 37.7365635736601 | -122.43791067344401 | (37.7365635736601, -122.437910673444) | |||
| 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) | |||
| 26189 | 26189 | 83205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | |
| 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) | ||
| 26337 | 26337 | 227551 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.75989588789739 | -122.432585790315 | (37.7598958878974, -122.432585790315) | |||
| 26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
| 26796 | 26796 | 47678 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | |
| 26976 | 26976 | 82736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.755115968323395 | -122.49732843264 | (37.7551159683234, -122.49732843264) |
| 27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
| 27198 | 27198 | 140780 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.44355075738399 | (37.7796937331341, -122.443550757384) | |||
| 27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
| 27395 | 27395 | 227153 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008266.03922 | 2099383.96222 | 37.7449754768472 | -122.41409899629299 | (37.7449754768472, -122.414098996293) | |||
| 28135 | 28135 | 41812 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | |
| 28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
| 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) | |||
| 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) | |||
| 30112 | 30112 | 207019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 234 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5998513.62611 | 2093807.4558 | 37.7291111292533 | -122.447419626323 | (37.7291111292533, -122.447419626323) | |||
| 30724 | 30724 | 92441 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) |
| 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) | |||
| 31529 | 31529 | 52954 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.1163299999 | 37.7224704120511 | -122.43945112037399 | (37.7224704120511, -122.439451120374) | |
| 32789 | 32789 | 227562 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | |||
| 33050 | 33050 | 95911 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) |
| 33294 | 33294 | 206990 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992691.68575 | 2106051.40057 | 37.7623954627053 | -122.46843680950501 | (37.7623954627053, -122.468436809505) | |||
| 33778 | 33778 | 52557 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | |
| 34085 | 34085 | 207020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.722484173480204 | -122.45506152367201 | (37.7224841734802, -122.455061523672) | |||
| 34279 | 34279 | 227550 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | |||
| 34972 | 34972 | 244513 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | |||
| 35420 | 35420 | 182699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.755839910949895 | -122.480728726959 | (37.7558399109499, -122.480728726959) | |||
| 35959 | 35959 | 118588 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982305.68238 | 2112631.11012 | 37.779856054488604 | -122.50484511221701 | (37.7798560544886, -122.504845112217) | |||
| 36288 | 36288 | 31158 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 600 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2001 12:00:00 AM | 1 | Permit Number 34860 | 5993522.80361 | 2089878.90243 | 37.71803781197371 | -122.464388049089 | (37.7180378119737, -122.464388049089) | |
| 36328 | 36328 | 119240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | |||
| 36351 | 36351 | 119164 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | |||
| 36879 | 36879 | 69182 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.50497015556499 | (37.7610044592096, -122.504970155565) | |
| 36946 | 36946 | 227079 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6006194.41732 | 2099504.07308 | 37.7451886989034 | -122.42127082879601 | (37.7451886989034, -122.421270828796) | |||
| 37096 | 37096 | 207011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.731209264673296 | -122.437660309391 | (37.7312092646733, -122.437660309391) | |||
| 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) | |||
| 37433 | 37433 | 184723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | |||
| 37552 | 37552 | 227586 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003707.3650400005 | 2095900.15245 | 37.735152630897495 | -122.42961364516898 | (37.7351526308975, -122.429613645169) | |||
| 37870 | 37870 | 247053 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 507 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002585.442419999 | 2099146.1836099997 | 37.744001891474 | -122.43372445791599 | (37.744001891474, -122.433724457916) | |||
| 38388 | 38388 | 227552 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002586.755890001 | 2105341.84005 | 37.7610137667981 | -122.43416274071998 | (37.7610137667981, -122.43416274072) | |||
| 38391 | 38391 | 251001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 232 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | |||
| 38736 | 38736 | 100491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.786793659691895 | -122.45844035359801 | (37.7867936596919, -122.458440353598) | |
| 39095 | 39095 | 84344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.4392099995 | 2112041.1140799997 | 37.778557929673205 | -122.485786324881 | (37.7785579296732, -122.485786324881) | |
| 40644 | 40644 | 227097 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009272.782269999 | 2099754.5666099996 | 37.7460495695343 | -122.41064401410601 | (37.7460495695343, -122.410644014106) | |||
| 40793 | 40793 | 78252 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.571219999 | 2090471.0211200002 | 37.7202064317688 | -122.43160757344299 | (37.7202064317688, -122.431607573443) | |
| 40870 | 40870 | 129385 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | |||
| 41516 | 41516 | 46433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011103.47209 | 2089684.5822599998 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | |
| 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) | |||
| 41903 | 41903 | 73594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.787580529660794 | -122.41454729843399 | (37.7875805296608, -122.414547298434) | |
| 41920 | 41920 | 227112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | |||
| 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) | |||
| 42710 | 42710 | 227127 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000615.36032 | 2102512.03507 | 37.7531317270504 | -122.44077792887501 | (37.7531317270504, -122.440777928875) | |||
| 43034 | 43034 | 140758 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.781568928755895 | -122.442554464995 | (37.7815689287559, -122.442554464995) | |||
| 43413 | 43413 | 251006 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 348 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.780042954548705 | -122.50708351880199 | (37.7800429545487, -122.507083518802) | |||
| 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) | |||
| 44275 | 44275 | 227553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | |||
| 44702 | 44702 | 227100 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004326.55063 | 2108840.26945 | 37.770718202624295 | -122.428394902803 | (37.7707182026243, -122.428394902803) | |||
| 45140 | 45140 | 191227 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Texas St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013759.687999999 | 2106121.42545 | 37.763782132758706 | -122.39557476618201 | (37.7637821327587, -122.395574766182) | |||
| 45203 | 45203 | 83910 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1515 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50152 | 5982467.7611 | 2104767.4351 | 37.7582742066085 | -122.50370189101801 | (37.7582742066085, -122.503701891018) | |
| 46405 | 46405 | 176898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.42278201629601 | (37.7267157831975, -122.422782016296) | |||
| 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) | |||
| 47267 | 47267 | 47826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 2 | Permit Number 45588 | 5982100.44481 | 2110341.3807200002 | 37.773557052971704 | -122.50538534555099 | (37.7735570529717, -122.505385345551) |
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");