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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10478 | 10478 | 86216 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2619 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/18/2015 03:11:00 PM | 3 | 3x3 | 5988925.4466 | 2097480.2521 | 37.7386431021416 | -122.48083513933202 | (37.7386431021416, -122.480835139332) | ||
| 10481 | 10481 | 86342 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2347 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988550.1905 | 2099342.5621 | 37.743734698566996 | -122.482268986695 | (37.743734698567, -122.482268986695) | ||
| 10485 | 10485 | 86147 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 8 | 3x3 | 5988673.7063 | 2106118.8136 | 37.7623476572695 | -122.482338285023 | (37.7623476572695, -122.482338285023) | ||
| 10499 | 10499 | 86552 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | ||
| 10507 | 10507 | 115755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 6000910.63041 | 2087495.48281 | 37.711916563873 | -122.438680905912 | (37.711916563873, -122.438680905912) | |||
| 10521 | 10521 | 108564 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 208 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772581 | 6010035.655230001 | 2093553.92933 | 37.7290666937725 | -122.407568987434 | (37.7290666937725, -122.407568987434) |
| 10533 | 10533 | 86042 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1311 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987382.8738 | 2106304.4567 | 37.7627822108774 | -122.48681636863701 | (37.7627822108774, -122.486816368637) | ||
| 10540 | 10540 | 86470 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | ||
| 10561 | 10561 | 86012 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1642 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987499.1098 | 2104097.2319 | 37.7567285504541 | -122.486252307696 | (37.7567285504541, -122.486252307696) | ||
| 10563 | 10563 | 86468 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | ||
| 10564 | 10564 | 116803 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.3953900002 | 37.728878425184796 | -122.416877747635 | (37.7288784251848, -122.416877747635) | ||
| 10588 | 10588 | 29186 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984375.9268 | 2102211.0253 | 37.751367022759105 | -122.49691404116001 | (37.7513670227591, -122.49691404116) | ||
| 10590 | 10590 | 82568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004119.416680001 | 2089176.12127 | 37.7167132553824 | -122.427710104164 | (37.7167132553824, -122.427710104164) | |
| 10594 | 10594 | 47511 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54X Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45390 | 6003674.452380001 | 2094589.01838 | 37.7315506895908 | -122.429633955464 | (37.7315506895908, -122.429633955464) | |
| 10600 | 10600 | 86037 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1215 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987357.4179 | 2106982.0087 | 37.76464109793461 | -122.48695417155899 | (37.7646410979346, -122.486954171559) | ||
| 10602 | 10602 | 86245 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2306 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988589.4098 | 2099609.5524 | 37.744470064859 | -122.48215293338001 | (37.744470064859, -122.48215293338) | ||
| 10614 | 10614 | 25398 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 855 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 20 | 3X3 | 6000161.72104 | 2089444.17614 | 37.7172246045192 | -122.441409081159 | (37.7172246045192, -122.441409081159) | ||
| 10633 | 10633 | 78424 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 12 | 3x3 | 6001367.33803 | 2089018.36243 | 37.716124024086 | -122.43721136872499 | (37.716124024086, -122.437211368725) | |
| 10646 | 10646 | 86167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988635.288 | 2105938.085 | 37.761849190827796 | -122.48245791496599 | (37.7618491908278, -122.482457914966) | ||
| 10654 | 10654 | 86358 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2467 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988579.1256 | 2098528.4885 | 37.741501149228895 | -122.482109310709 | (37.7415011492289, -122.482109310709) | ||
| 10692 | 10692 | 86045 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1359 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987391.0989 | 2106016.5765 | 37.7619922504501 | -122.48676678064899 | (37.7619922504501, -122.486766780649) | ||
| 10697 | 10697 | 43158 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 251 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779279 | 6006275.83968 | 2092663.4534200002 | 37.7264104651465 | -122.420503806033 | (37.7264104651465, -122.420503806033) | |
| 10718 | 10718 | 2162 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2000 12:00:00 AM | 3 | 3x100 | 6009718.66444 | 2090180.91439 | 37.7197873521964 | -122.40842702879299 | (37.7197873521964, -122.408427028793) | ||
| 10734 | 10734 | 29192 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984182.3495 | 2102207.3027 | 37.751345456571606 | -122.497583168809 | (37.7513454565716, -122.497583168809) | ||
| 10750 | 10750 | 25354 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 5999152.66634 | 2090412.41545 | 37.719825631818296 | -122.44496645924102 | (37.7198256318183, -122.444966459241) | ||
| 10768 | 10768 | 25389 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1161 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2003 12:00:00 AM | 3 | 3X3 | 6001515.64851 | 2088443.1982900002 | 37.7145531809608 | -122.436657591376 | (37.7145531809608, -122.436657591376) | ||
| 10769 | 10769 | 86235 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2390 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988605.4776 | 2099097.5817 | 37.743065262537606 | -122.48205987633999 | (37.7430652625376, -122.48205987634) | ||
| 10786 | 10786 | 86557 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1839 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987812.6165 | 2102765.0103 | 37.7530888972888 | -122.48507035960199 | (37.7530888972888, -122.485070359602) | ||
| 10799 | 10799 | 86031 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1330 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987427.8702 | 2106214.9477 | 37.7625390669723 | -122.48665417119601 | (37.7625390669723, -122.486654171196) | ||
| 10813 | 10813 | 86175 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1501 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988665.5721 | 2105055.9898 | 37.7594289581926 | -122.482288545178 | (37.7594289581926, -122.482288545178) | ||
| 10815 | 10815 | 25377 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 25 | 3X3 | 6002148.44357 | 2087979.2462400002 | 37.7133152120062 | -122.434437247081 | (37.7133152120062, -122.434437247081) | ||
| 10834 | 10834 | 86046 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1375 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987395.4534 | 2105935.2927 | 37.7617693213048 | -122.486745751332 | (37.7617693213048, -122.486745751332) | ||
| 10835 | 10835 | 86336 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2315 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988542.5761 | 2099546.1228 | 37.7442931797412 | -122.482310226394 | (37.7442931797412, -122.482310226394) | ||
| 10854 | 10854 | 34134 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 10855 | 10855 | 86473 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1786 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987851.8695 | 2103141.0168 | 37.754123596233896 | -122.484962200288 | (37.7541235962339, -122.484962200288) | ||
| 10859 | 10859 | 25378 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 25 | 3X3 | 6002172.85724 | 2087963.34277 | 37.7132729303733 | -122.43435172877301 | (37.7132729303733, -122.434351728773) | ||
| 10862 | 10862 | 34464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 10897 | 10897 | 86179 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1567 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988681.1149 | 2104657.7064 | 37.7583362836656 | -122.48220561148099 | (37.7583362836656, -122.482205611481) | ||
| 10906 | 10906 | 86356 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2451 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988574.7261 | 2098626.6308 | 37.7417703663751 | -122.482131710751 | (37.7417703663751, -122.482131710751) | ||
| 10907 | 10907 | 34118 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) | |
| 10915 | 10915 | 27240 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 261 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6002975.310190001 | 2093743.15075 | 37.729188515926 | -122.431990645067 | (37.729188515926, -122.431990645067) | ||
| 10939 | 10939 | 75321 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 9x4 | 5988672.5581 | 2099700.4669999997 | 37.7447245283024 | -122.481872085268 | (37.7447245283024, -122.481872085268) | |
| 10953 | 10953 | 29189 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984268.6471 | 2102206.6258 | 37.751348656090705 | -122.497284696389 | (37.7513486560907, -122.497284696389) | ||
| 10955 | 10955 | 109923 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 214 state st | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 10958 | 10958 | 86016 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1558 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987478.2324 | 2104678.8878 | 37.758324402436706 | -122.486367210591 | (37.7583244024367, -122.486367210591) | ||
| 10970 | 10970 | 86228 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2458 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 09:49:00 AM | 3 | 3x3 | 5988622.1052 | 2098596.1728 | 37.7416894923046 | -122.481965660758 | (37.7416894923046, -122.481965660758) | ||
| 10988 | 10988 | 86017 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1554 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987479.1031 | 2104708.0563 | 37.758404541939704 | -122.48636634081001 | (37.7584045419397, -122.48636634081) | ||
| 11002 | 11002 | 27001 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1250 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2006 12:00:00 AM | 3 | 3X3 | 6008978.70345 | 2094131.6576900003 | 37.7305937920652 | -122.41126376212 | (37.7305937920652, -122.41126376212) | ||
| 11025 | 11025 | 97251 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003227.5697 | 2092233.02297 | 37.7250563415646 | -122.43101082650499 | (37.7250563415646, -122.431010826505) |
| 11057 | 11057 | 46152 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 11062 | 11062 | 27097 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 707 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006020.66402 | 2093592.0564299999 | 37.7289458221845 | -122.42145185693899 | (37.7289458221845, -122.421451856939) | ||
| 11070 | 11070 | 34466 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 11077 | 11077 | 25379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 25 | 3x3 | Permit Number 770716 | 6002169.48596 | 2087962.88023 | 37.7132714689796 | -122.434363348013 | (37.7132714689796, -122.434363348013) | |
| 11079 | 11079 | 86049 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987407.2223 | 2105592.1823 | 37.7608279203014 | -122.486679852889 | (37.7608279203014, -122.486679852889) | ||
| 11101 | 11101 | 86030 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1334 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987428.353999999 | 2106187.8531 | 37.7624647008461 | -122.486650508346 | (37.7624647008461, -122.486650508346) | ||
| 11105 | 11105 | 83902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50518 | 5999574.303230001 | 2091368.33238 | 37.7224744158531 | -122.44357764611601 | (37.7224744158531, -122.443577646116) | |
| 11107 | 11107 | 34137 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 11138 | 11138 | 86554 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1815 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987806.6182 | 2102907.2902 | 37.753479210173104 | -122.48510154092199 | (37.7534792101731, -122.485101540922) | ||
| 11176 | 11176 | 27002 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1250 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2006 12:00:00 AM | 3 | 3X3 | 6008993.49949 | 2094137.8061400002 | 37.7306115042086 | -122.411213043957 | (37.7306115042086, -122.411213043957) | ||
| 11193 | 11193 | 25385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1231 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2011 12:00:00 AM | 3 | 3x3 | 6001822.88806 | 2088260.8804099998 | 37.71407003188121 | -122.435582613755 | (37.7140700318812, -122.435582613755) | ||
| 11195 | 11195 | 86041 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1311 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987381.4223 | 2106332.0351 | 37.7628578489584 | -122.48682341409099 | (37.7628578489584, -122.486823414091) | ||
| 11203 | 11203 | 86362 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2515 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988589.3475 | 2098190.8048 | 37.740574552712495 | -122.482049235281 | (37.7405745527125, -122.482049235281) | ||
| 11205 | 11205 | 86472 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1810 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987855.0174 | 2102938.1418 | 37.7535667395127 | -122.484936431442 | (37.7535667395127, -122.484936431442) | ||
| 11217 | 11217 | 86160 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1243 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988606.9006 | 2106860.534 | 37.764380333066704 | -122.482623693004 | (37.7643803330667, -122.482623693004) | ||
| 11233 | 11233 | 108547 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.783340001 | 2093999.82608 | 37.7298475310412 | -122.43479722051799 | (37.7298475310412, -122.434797220518) |
| 11234 | 11234 | 86140 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1498 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5988707.3318 | 2105163.5964 | 37.7597268457952 | -122.482152004776 | (37.7597268457952, -122.482152004776) | ||
| 11237 | 11237 | 86156 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1200 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5988641.366 | 2107071.9218 | 37.7649627512857 | -122.482519978732 | (37.7649627512857, -122.482519978732) | ||
| 11241 | 11241 | 19489 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 355X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010833.1058 | 2090397.5651099999 | 37.7204445776412 | -122.40459002092301 | (37.7204445776412, -122.404590020923) | |||
| 11242 | 11242 | 86137 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1562 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988721.4289 | 2104700.9347 | 37.7584573217104 | -122.48206935636699 | (37.7584573217104, -122.482069356367) | ||
| 11262 | 11262 | 34121 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 11277 | 11277 | 105244 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2398X 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 5989539.9051 | 2099080.116 | 37.7430716095087 | -122.47882763740299 | (37.7430716095087, -122.478827637403) | |||
| 11278 | 11278 | 86234 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2390 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 10:01:00 AM | 3 | 3x3 | 5988605.4776 | 2099073.5645 | 37.7429993176153 | -122.48205811726999 | (37.7429993176153, -122.48205811727) | ||
| 11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
| 11326 | 11326 | 29184 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984418.9064 | 2102213.7327 | 37.7513769749163 | -122.496765614764 | (37.7513769749163, -122.496765614764) | ||
| 11333 | 11333 | 26173 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1815 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/1997 12:00:00 AM | 16 | 2X3 | 6005106.30691 | 2086667.8505900002 | 37.709881856719605 | -122.42412063198299 | (37.7098818567196, -122.424120631983) | ||
| 11335 | 11335 | 106714 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6011615.93031 | 2088323.1081400001 | 37.7147922585389 | -122.401738295884 | (37.7147922585389, -122.401738295884) | |||
| 11347 | 11347 | 117512 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1890 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 5987869.5321 | 2102444.0363 | 37.752210904135104 | -122.484849991664 | (37.7522109041351, -122.484849991664) | |||
| 11348 | 11348 | 86053 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1475 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987418.7989 | 2105258.6641 | 37.7599128454564 | -122.48661532550699 | (37.7599128454564, -122.486615325507) | ||
| 11360 | 11360 | 86227 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2462 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988623.1204 | 2098567.7454 | 37.741611497154295 | -122.48196006863701 | (37.7416114971543, -122.481960068637) | ||
| 11362 | 11362 | 86054 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1479 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987418.7989 | 2105231.1006 | 37.759837163621 | -122.48661330160101 | (37.759837163621, -122.486613301601) | ||
| 11363 | 11363 | 29188 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984306.5503 | 2102207.9795 | 37.7513545943317 | -122.497153724675 | (37.7513545943317, -122.497153724675) | ||
| 11375 | 11375 | 86564 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2223 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/2007 12:00:00 AM | 3 | 3x3 | 5987901.655 | 2100154.5167 | 37.745926365714 | -122.484570984669 | (37.745926365714, -122.484570984669) | ||
| 11381 | 11381 | 86339 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2327 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988544.098999999 | 2099469.1319 | 37.744081871591604 | -122.48229932084101 | (37.7440818715916, -122.482299320841) | ||
| 11382 | 11382 | 86159 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1235 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988606.1347 | 2106890.404 | 37.7644623033717 | -122.482628531005 | (37.7644623033717, -122.482628531005) | ||
| 11393 | 11393 | 86174 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1447 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988652.5492 | 2105476.5603 | 37.760582973373396 | -122.48236439922701 | (37.7605829733734, -122.482364399227) | ||
| 11395 | 11395 | 86226 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2478 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988626.5047 | 2098472.3105 | 37.7413496547381 | -122.481941377708 | (37.7413496547381, -122.481941377708) | ||
| 11401 | 11401 | 97248 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003299.02479 | 2092188.3041400001 | 37.724937602283504 | -122.430760624301 | (37.7249376022835, -122.430760624301) |
| 11408 | 11408 | 86344 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2363 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988553.5748 | 2099249.4961 | 37.7434793606693 | -122.48225046766399 | (37.7434793606693, -122.482250467664) | ||
| 11447 | 11447 | 86138 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1522 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988713.1719 | 2104932.6191 | 37.759092984260796 | -122.482114885465 | (37.7590929842608, -122.482114885465) | ||
| 11449 | 11449 | 35191 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11473 | 11473 | 40673 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | 3x3 | Permit Number 41658 | 6004193.53589 | 2093779.4786099999 | 37.7293572530177 | -122.427781722549 | (37.7293572530177, -122.427781722549) |
| 11492 | 11492 | 86474 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1774 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987847.9041 | 2103231.0884 | 37.754370677583 | -122.484982521185 | (37.754370677583, -122.484982521185) | ||
| 11542 | 11542 | 86026 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1400X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987446.3624 | 2105678.3641 | 37.761066833582504 | -122.48655081434099 | (37.7610668335825, -122.486550814341) | ||
| 11554 | 11554 | 25391 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1155 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1996 12:00:00 AM | 6 | 3X3 | 6001499.28642 | 2088453.12896 | 37.7145795185128 | -122.4367148557 | (37.7145795185128, -122.4367148557) | ||
| 11571 | 11571 | 86048 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1415 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987405.936000001 | 2105630.5874 | 37.7609332951993 | -122.486687121684 | (37.7609332951993, -122.486687121684) | ||
| 11581 | 11581 | 29191 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984218.2223 | 2102206.6258 | 37.7513457006698 | -122.497459068477 | (37.7513457006698, -122.497459068477) | ||
| 11589 | 11589 | 86020 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1538 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987475.185 | 2104787.7256 | 37.7586230637425 | -122.48638574025499 | (37.7586230637425, -122.486385740255) | ||
| 11604 | 11604 | 116262 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 35 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x4 | 6005278.18089 | 2092026.4994299999 | 37.724605255111896 | -122.42390739821998 | (37.7246052551119, -122.42390739822) | ||
| 11606 | 11606 | 86171 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988646.5907 | 2105660.3546 | 37.7610872760647 | -122.48239847368299 | (37.7610872760647, -122.482398473683) |
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");