Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 87112 | 87112 | 108316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 87416 | 87416 | 108318 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 90642 | 90642 | 108476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 100581 | 100581 | 108317 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 104770 | 104770 | 108475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 114895 | 114895 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 11 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
| 119669 | 119669 | 108477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 127092 | 127092 | 116522 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW for City Agency 2 | 8 | 3x3 | 5993416.0 | 2113304.0 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | ||
| 140493 | 140493 | 115828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||
| 79 | 79 | 251205 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4X4 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||||
| 2153 | 2153 | 251201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||
| 2158 | 2158 | 251202 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2159 | 2159 | 251203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2162 | 2162 | 251204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 3862 | 3862 | 253583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3870 | 3870 | 253584 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3871 | 3871 | 253582 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 7699 | 7699 | 105527 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 228 Collins St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 5998178.2908 | 2113055.0752 | 37.7819411428258 | -122.449965554893 | (37.7819411428258, -122.449965554893) | |||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 79727 | 79727 | 99261 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.805250324017294 | -122.42371770971 | (37.8052503240173, -122.42371770971) | ||
| 87494 | 87494 | 99512 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 154 Miraloma Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/15/2012 12:00:00 AM | Permit Number 768163 | 5994585.5 | 2096588.5 | 37.73652193950829 | -122.461200886189 | (37.7365219395083, -122.461200886189) | |||
| 90228 | 90228 | 111728 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 MANOR DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993477.0 | 2093271.0 | 37.7273490481485 | -122.464792568508 | (37.7273490481485, -122.464792568508) | ||||
| 111860 | 111860 | 102661 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3399X Wawona St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | ||||
| 120972 | 120972 | 93739 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1701 43rd Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53320 | 5982802.7 | 2103504.9 | 37.7548273283639 | -122.502450103836 | (37.7548273283639, -122.502450103836) | ||
| 144479 | 144479 | 10750 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 9985 | 9985 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 9994 | 9994 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9999 | 9999 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10006 | 10006 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10214 | 10214 | 173907 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6012443.0 | 2099218.0 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | |||||
| 43480 | 43480 | 111380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) | ||
| 79313 | 79313 | 112817 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 296X CHRISTOPHER DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 36 | 30x10 | 5995574.0 | 2103248.0 | 37.7548641056896 | -122.45826510241699 | (37.7548641056896, -122.458265102417) | |||
| 79421 | 79421 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 81556 | 81556 | 99518 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 85342 | 85342 | 99520 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | |||
| 86503 | 86503 | 117100 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 677 ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 778379 | 5994251.0 | 2098113.0 | 37.7406885817292 | -122.46246793072201 | (37.7406885817292, -122.462467930722) | |||
| 86553 | 86553 | 116461 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 AERIAL WAY | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5992280.0 | 2102576.0 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | ||||
| 88741 | 88741 | 108365 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/23/2016 12:00:00 AM | 3 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||
| 90956 | 90956 | 99523 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 33 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 92845 | 92845 | 114978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 96017 | 96017 | 115668 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 193 VALMAR TER | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004786.0 | 2092223.0 | 37.72511700396829 | -122.425622784245 | (37.7251170039683, -122.425622784245) | ||||
| 103702 | 103702 | 108362 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||||
| 107894 | 107894 | 111381 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) | ||
| 108958 | 108958 | 99522 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 26 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | |||
| 117455 | 117455 | 115667 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 193 VALMAR TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 3x3 | 6004786.0 | 2092223.0 | 37.72511700396829 | -122.425622784245 | (37.7251170039683, -122.425622784245) | |||
| 118061 | 118061 | 99521 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 118399 | 118399 | 115436 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 121695 | 121695 | 111379 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) | ||
| 122754 | 122754 | 99519 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 141087 | 141087 | 108363 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||||
| 142206 | 142206 | 116462 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 AERIAL WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5992280.0 | 2102576.0 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | ||||
| 142520 | 142520 | 108364 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||||
| 144359 | 144359 | 115437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 144816 | 144816 | 99524 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 92559 | 92559 | 92776 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 109480 | 109480 | 92778 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 81069 | 81069 | 113145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990980.0 | 2092843.0 | 37.726029586770395 | -122.473393404688 | (37.7260295867704, -122.473393404688) | ||||
| 87877 | 87877 | 113532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
| 93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 95633 | 95633 | 114816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x10 | 5995779.0 | 2095603.0 | 37.7338846095715 | -122.45700321324699 | (37.7338846095715, -122.457003213247) | ||||
| 99139 | 99139 | 74759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 103044 | 103044 | 113533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
| 106304 | 106304 | 87292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 107674 | 107674 | 106774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155X Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5990905.0300199995 | 2094685.3067400001 | 37.7310837571916 | -122.47378690918801 | (37.7310837571916, -122.473786909188) | |||
| 107836 | 107836 | 113531 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 28 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | |||
| 109255 | 109255 | 92815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.72657814349439 | -122.46787650278 | (37.7265781434944, -122.46787650278) | ||
| 116856 | 116856 | 109176 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 335 COLON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 26 | 5995818.3 | 2094822.2 | 37.7317429788493 | -122.45681088999399 | (37.7317429788493, -122.456810889994) | ||||
| 126772 | 126772 | 87291 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 127907 | 127907 | 109177 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 320 COLON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 5995887.7 | 2094797.5 | 37.7316791433679 | -122.45656917602899 | (37.7316791433679, -122.456569176029) | ||||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 2652 | 2652 | 37819 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003953.55423 | 2090513.34715 | 37.7203756014419 | -122.428378663762 | (37.7203756014419, -122.428378663762) |
| 2660 | 2660 | 37827 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003888.33038 | 2090432.03853 | 37.7201486548235 | -122.428598328547 | (37.7201486548235, -122.428598328547) |
| 118354 | 118354 | 104317 | Private 5 | Pyrus calleryana :: Ornamental Pear 9 | 13011305 SANCHEZ ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003956.0 | 2100665.0 | 37.748249883960796 | -122.429093651106 | (37.7482498839608, -122.429093651106) | |||
| 78646 | 78646 | 107392 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 79285 | 79285 | 107390 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
| 94242 | 94242 | 107394 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 117322 | 117322 | 107388 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 10052 | 10052 | 121312 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10061 | 10061 | 121311 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) |
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");