Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50165 | 50165 | 115003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691.0 | 37.737359123084005 | -122.42753146953999 | (37.737359123084, -122.42753146954) | |||
| 100042 | 100042 | 115001 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.742688023212295 | -122.46631133896999 | (37.7426880232123, -122.46631133897) | |||
| 123218 | 123218 | 60670 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.42751133803101 | (37.737354818402, -122.427511338031) | ||
| 89281 | 89281 | 102176 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) |
| 74210 | 74210 | 92968 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 633 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 53126 | 6011005.62443 | 2105237.5214299997 | 37.7612015551355 | -122.40503803797199 | (37.7612015551355, -122.405038037972) | |
| 58949 | 58949 | 108642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 167 Judson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | |
| 80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
| 55894 | 55894 | 98181 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 574 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2011 12:00:00 AM | 4 | 2.5x5 | 6009895.13755 | 2111712.30885 | 37.7789176859509 | -122.409335696583 | (37.7789176859509, -122.409335696583) | ||
| 164377 | 164377 | 47424 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 843 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2009 12:00:00 AM | 6 | Permit Number 53122 | 5984459.81108 | 2110102.97332 | 37.7730410098098 | -122.497206468755 | (37.7730410098098, -122.497206468755) | ||
| 11838 | 11838 | 86566 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2291 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987915.7374 | 2099735.4596 | 37.7447765661609 | -122.484491558794 | (37.7447765661609, -122.484491558794) | ||
| 79532 | 79532 | 86562 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2207 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987900.988811 | 2100267.110901 | 37.746235480683 | -122.48458154567899 | (37.746235480683, -122.484581545679) | ||
| 92704 | 92704 | 86563 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2215 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987902.745463 | 2100215.048221 | 37.7460926326953 | -122.484571653291 | (37.7460926326953, -122.484571653291) | ||
| 81402 | 81402 | 32754 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 518 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41062 | 5995930.70396007 | 2088752.73433833 | 37.7150841234911 | -122.45598366275699 | (37.7150841234911, -122.455983662757) | ||
| 123043 | 123043 | 39687 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 511 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41072 | 5993229.85433358 | 2090575.93816202 | 37.71993481287579 | -122.46545124689699 | (37.7199348128758, -122.465451246897) | ||
| 123832 | 123832 | 39605 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4731 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41008 | 5998534.61450841 | 2105650.4500048 | 37.7616303166929 | -122.448199498117 | (37.7616303166929, -122.448199498117) | ||
| 85058 | 85058 | 114963 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 284 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776075 | 5994159.8 | 2088442.0 | 37.714129118114 | -122.462082099319 | (37.714129118114, -122.462082099319) | |||
| 99924 | 99924 | 114976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 231 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775532 | 5994424.6 | 2091464.1 | 37.722442325741795 | -122.46138580684601 | (37.7224423257418, -122.461385806846) | |||
| 124494 | 124494 | 114973 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776087 | 5996468.6 | 2094435.0 | 37.7307171398869 | -122.454534722301 | (37.7307171398869, -122.454534722301) | |||
| 127574 | 127574 | 113586 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6011271.0 | 2095434.0 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | |||
| 129086 | 129086 | 83288 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 164 Marietta Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 776115 | 5998661.46033678 | 2097891.48861403 | 37.740333360985105 | -122.447202361917 | (37.7403333609851, -122.447202361917) | ||
| 24063 | 24063 | 62130 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54059 | 6001174.82097 | 2092290.03948 | 37.72509636588129 | -122.438111025319 | (37.7250963658813, -122.438111025319) |
| 133246 | 133246 | 95115 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 111 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54042 | 6004702.49074 | 2094193.2145 | 37.730522057645395 | -122.426051658966 | (37.7305220576454, -122.426051658966) |
| 156956 | 156956 | 95119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54046 | 6002860.87365 | 2094458.65897 | 37.731146651186705 | -122.432437345509 | (37.7311466511867, -122.432437345509) |
| 10423 | 10423 | 86471 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1814 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987856.6219 | 2102916.0794 | 37.7535062555598 | -122.48492926433501 | (37.7535062555598, -122.484929264335) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 11622 | 11622 | 86462 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1874 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x12 | 5987866.4109 | 2102544.1995 | 37.7524857435744 | -122.484868132588 | (37.7524857435744, -122.484868132588) | ||
| 11723 | 11723 | 86466 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1838 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987861.6361 | 2102765.0521 | 37.753091867307 | -122.48490084539499 | (37.753091867307, -122.484900845395) | ||
| 11748 | 11748 | 86465 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1842 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987862.4384 | 2102740.1818 | 37.7530236268855 | -122.484896246512 | (37.7530236268855, -122.484896246512) | ||
| 11879 | 11879 | 86555 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1819 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987809.0175 | 2102882.3372 | 37.7534108357177 | -122.48509141307 | (37.7534108357177, -122.48509141307) | ||
| 11890 | 11890 | 86455 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2274 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987957.131 | 2099832.7559 | 37.745046126390704 | -122.484355563995 | (37.7450461263907, -122.484355563995) | ||
| 11980 | 11980 | 86461 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1878 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987868.3971 | 2102516.6759 | 37.75241028685029 | -122.48485924507 | (37.7524102868503, -122.48485924507) | ||
| 12105 | 12105 | 86556 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1823 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987809.2575 | 2102855.2249 | 37.7533364066252 | -122.485088594036 | (37.7533364066252, -122.485088594036) | ||
| 12123 | 12123 | 86469 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1826 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987859.0288 | 2102838.2592 | 37.7532927224365 | -122.48491523213 | (37.7532927224365, -122.48491523213) | ||
| 12358 | 12358 | 86559 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102488.6083 | 37.7523305587422 | -122.48501523391501 | (37.7523305587422, -122.485015233915) | ||
| 12463 | 12463 | 86457 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2254 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987953.7171 | 2099943.2812 | 37.7453494007747 | -122.484375473288 | (37.7453494007747, -122.484375473288) | ||
| 12493 | 12493 | 86464 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1850 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987865.2759 | 2102688.9112 | 37.752883016880396 | -122.484882672992 | (37.7528830168804, -122.484882672992) | ||
| 12623 | 12623 | 86458 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2226 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987945.6091 | 2100121.6579 | 37.7458387037388 | -122.48441658969999 | (37.7458387037388, -122.4844165897) | ||
| 12638 | 12638 | 86460 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2214 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987944.7556 | 2100194.2034 | 37.746037844721705 | -122.48442486087099 | (37.7460378447217, -122.484424860871) | ||
| 12823 | 12823 | 86467 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1834 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987860.8339 | 2102786.7134 | 37.7531512966831 | -122.484905208537 | (37.7531512966831, -122.484905208537) | ||
| 12908 | 12908 | 86553 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1811 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987806.7158 | 2102929.3806 | 37.7535398701446 | -122.48510282406299 | (37.7535398701446, -122.485102824063) | ||
| 12966 | 12966 | 86459 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2218 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987944.3289 | 2100172.8665 | 37.7459792344128 | -122.48442477163799 | (37.7459792344128, -122.484424771638) | ||
| 13229 | 13229 | 86456 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2270 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987955.8508 | 2099858.787 | 37.7451175263471 | -122.484361899482 | (37.7451175263471, -122.484361899482) | ||
| 77317 | 77317 | 86478 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.420576001 | 2103380.975618 | 37.7547814420453 | -122.48504014631399 | (37.7547814420453, -122.485040146314) | ||
| 126019 | 126019 | 86481 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1738 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987831.7029 | 2103459.302005 | 37.7549963468497 | -122.485055291033 | (37.7549963468497, -122.485055291033) | ||
| 128356 | 128356 | 86551 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1801X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987806.717124 | 2103025.494361 | 37.7538037727045 | -122.48510987088699 | (37.7538037727045, -122.485109870887) | ||
| 45342 | 45342 | 52510 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | ||
| 85909 | 85909 | 52511 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | ||
| 97854 | 97854 | 52494 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 216@ CORTLAND Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48603 | 6008067.92679753 | 2097603.39470446 | 37.7400753030702 | -122.414658053624 | (37.7400753030702, -122.414658053624) | ||
| 143173 | 143173 | 52512 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | ||
| 106636 | 106636 | 46186 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 770 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44513 | 5997141.27698608 | 2107948.77875482 | 37.767861189020294 | -122.453184384627 | (37.7678611890203, -122.453184384627) | ||
| 117710 | 117710 | 46167 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533001 | (37.7645737153289, -122.45591064533) | |||
| 126993 | 126993 | 46166 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533001 | (37.7645737153289, -122.45591064533) | |||
| 140958 | 140958 | 46133 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533001 | (37.7645737153289, -122.45591064533) | ||
| 7013 | 7013 | 18868 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2245 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2014 12:05:00 PM | 3 | 3X4 | 6004021.14791 | 2115967.48717 | 37.7902704855414 | -122.42995977804199 | (37.7902704855414, -122.429959778042) | ||
| 82416 | 82416 | 84666 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002909.03785492 | 2101853.22745181 | 37.75145315539 | -122.432798884354 | (37.75145315539, -122.432798884354) |
| 92065 | 92065 | 84581 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 741 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.43844332058201 | (37.7516459775241, -122.438443320582) | ||
| 99726 | 99726 | 84662 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4010 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003093.38123031 | 2101863.40239846 | 37.7514915468728 | -122.432162129841 | (37.7514915468728, -122.432162129841) |
| 111695 | 111695 | 84580 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 741 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.43844332058201 | (37.7516459775241, -122.438443320582) | ||
| 118156 | 118156 | 59582 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3911 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003738.17259187 | 2101846.91300121 | 37.7514828076554 | -122.42993118714199 | (37.7514828076554, -122.429931187142) |
| 126421 | 126421 | 102119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4040 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002911.0 | 2101847.0 | 37.751436167563895 | -122.4327916542 | (37.7514361675639, -122.4327916542) |
| 127499 | 127499 | 102118 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4010 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003103.5 | 2101879.6 | 37.7515365953655 | -122.432128294524 | (37.7515365953655, -122.432128294524) |
| 140202 | 140202 | 84567 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3961 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003430.22054121 | 2101829.9153452 | 37.751418691406 | -122.430994909235 | (37.751418691406, -122.430994909235) |
| 16036 | 16036 | 11224 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018109.81504 | 2094815.3391900002 | 37.7329789308191 | -122.379743287027 | (37.7329789308191, -122.379743287027) | ||
| 18624 | 18624 | 86546 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1755 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987795.350523001 | 2103353.4798009996 | 37.754703670103204 | -122.485173242268 | (37.7547036701032, -122.485173242268) | ||
| 84531 | 84531 | 86548 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1775 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987799.879981 | 2103222.935856 | 37.7543454955224 | -122.485148000658 | (37.7543454955224, -122.485148000658) | ||
| 87157 | 87157 | 86550 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1789 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987803.0506029995 | 2103131.5550430003 | 37.7540947731582 | -122.485130331666 | (37.7540947731582, -122.485130331666) | ||
| 100120 | 100120 | 86538 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1711 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987785.385714 | 2103640.676502 | 37.755491654145004 | -122.485228774674 | (37.755491654145, -122.485228774674) | ||
| 105654 | 105654 | 86545 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987794.444631 | 2103379.5885799997 | 37.754775304988605 | -122.48517829062 | (37.7547753049886, -122.48517829062) | ||
| 116316 | 116316 | 86547 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1763X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987797.162306 | 2103301.262218 | 37.7545604002604 | -122.485163145595 | (37.7545604002604, -122.485163145595) | ||
| 138889 | 138889 | 86549 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1783 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987801.691765 | 2103170.718248 | 37.7542022256 | -122.48513790407699 | (37.7542022256, -122.485137904077) | ||
| 144034 | 144034 | 86540 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1723 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987788.103389 | 2103562.350121 | 37.7552767493975 | -122.485213629356 | (37.7552767493975, -122.485213629356) | ||
| 144106 | 144106 | 86541 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1727 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987789.009281 | 2103536.241329 | 37.7552051144841 | -122.485208580935 | (37.7552051144841, -122.485208580935) | ||
| 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 | |||||||||
| 15869 | 15869 | 46153 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 81319 | 81319 | 46136 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 443 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | ||
| 107801 | 107801 | 46135 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 443 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | ||
| 143146 | 143146 | 46134 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 443 Carl St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | ||
| 145270 | 145270 | 39706 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 737 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 41091 | 5997212.1036903 | 2094974.32927434 | 37.7322406239966 | -122.45200322394399 | (37.7322406239966, -122.452003223944) | ||
| 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) |
| 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) |
| 12729 | 12729 | 108568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773759 | 6006239.22183 | 2092782.68354 | 37.7267357814247 | -122.420638852723 | (37.7267357814247, -122.420638852723) |
| 97487 | 97487 | 108543 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773705 | 6001182.06594 | 2092854.3647 | 37.7266462863625 | -122.43812638687 | (37.7266462863625, -122.43812638687) |
| 93158 | 93158 | 108512 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1621 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773655 | 5991123.731240001 | 2104364.3519200003 | 37.7576725829923 | -122.473736652625 | (37.7576725829923, -122.473736652625) |
| 103878 | 103878 | 82199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 387-389 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773788 | 5992147.2323199995 | 2112897.41844 | 37.7811613217497 | -122.47081855790701 | (37.7811613217497, -122.470818557907) | |
| 120605 | 120605 | 108515 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1411 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773663 | 5990815.147469999 | 2105785.21755 | 37.7615560250548 | -122.474907562892 | (37.7615560250548, -122.474907562892) |
| 15421 | 15421 | 11222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3X4 | 6018123.812969999 | 2094772.15079 | 37.7328611160499 | -122.379691892563 | (37.7328611160499, -122.379691892563) | ||
| 107398 | 107398 | 59326 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 130 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2015 12:00:00 AM | Permit Number 775294 | 5998173.48699395 | 2105389.83328333 | 37.760894077181895 | -122.449429707195 | (37.7608940771819, -122.449429707195) | ||
| 110079 | 110079 | 108416 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2835-2899X 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771183 | 6004957.0 | 2100749.0 | 37.748537141608296 | -122.425638197277 | (37.7485371416083, -122.425638197277) |
| 81420 | 81420 | 98167 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1397 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3x3 | Permit Number 768055 | 5999068.7 | 2104521.7 | 37.7585615677968 | -122.446271120644 | (37.7585615677968, -122.446271120644) | ||
| 98080 | 98080 | 98166 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1395 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3x3 | Permit Number 768055 | 5999068.7 | 2104521.7 | 37.7585615677968 | -122.446271120644 | (37.7585615677968, -122.446271120644) | ||
| 185337 | 185337 | 98165 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 760 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768065 | 5987585.510559999 | 2110747.9701 | 37.7749946773759 | -122.48644178693998 | (37.7749946773759, -122.48644178694) | |
| 137952 | 137952 | 52431 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2542 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 7 | Permit Number 48546 | 6002698.45058 | 2117031.83608 | 37.7931179181104 | -122.434612346877 | (37.7931179181104, -122.434612346877) | |
| 9723 | 9723 | 173650 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) |
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");