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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 11052 | 11052 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3X10 | Permit Number 778829 | 5992111.480830001 | 2087185.8440900003 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | ||
| 109370 | 109370 | 1414 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | |||
| 79080 | 79080 | 2058 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/08/1992 12:00:00 AM | 22 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | ||
| 125132 | 125132 | 2061 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 100546 | 100546 | 2062 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 120534 | 120534 | 2064 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 111836 | 111836 | 2071 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 126542 | 126542 | 2074 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 21 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125479 | 125479 | 2077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125618 | 125618 | 2079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 146288 | 146288 | 2099 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 125511 | 125511 | 2128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 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) | |||
| 140157 | 140157 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 99878 | 99878 | 6102 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 119405 | 119405 | 6105 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 120905 | 120905 | 9746 | Permitted Site 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 710X McAllister St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/21/1998 12:00:00 AM | 6 | 4x4 | 6005653.6676 | 2112008.06895 | 37.779491220069296 | -122.424029686189 | (37.7794912200693, -122.424029686189) | ||
| 144628 | 144628 | 9747 | DPW Maintained 3 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 710X McAllister St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/24/2011 12:00:00 AM | 3 | 4x4 | 6005653.6676 | 2112008.06895 | 37.779491220069296 | -122.424029686189 | (37.7794912200693, -122.424029686189) | ||
| 88044 | 88044 | 10731 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 103686 | 103686 | 10735 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 123207 | 123207 | 10738 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 145604 | 145604 | 10747 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 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) | |||
| 143311 | 143311 | 10754 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144510 | 144510 | 10758 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 43 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 95381 | 95381 | 10763 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 22 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 122783 | 122783 | 10768 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141855 | 141855 | 10769 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 114504 | 114504 | 10774 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 39 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 103746 | 103746 | 10775 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 92247 | 92247 | 10776 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 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) | |||
| 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) | |||
| 94567 | 94567 | 16912 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 474 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.774538702608396 | -122.42709732349701 | (37.7745387026084, -122.427097323497) | |||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 22233 | 22233 | 16926 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 514 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X3 | 6004391.58115 | 2110176.00513 | 37.774389487009 | -122.42826517381201 | (37.774389487009, -122.428265173812) | |||
| 123906 | 123906 | 16933 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 3X3 | 6004214.004269999 | 2110149.1693700003 | 37.7743057532085 | -122.42887753201401 | (37.7743057532085, -122.428877532014) | |||
| 139002 | 139002 | 16934 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 3X3 | 6004202.212169999 | 2110156.57626 | 37.774325423266895 | -122.428918851232 | (37.7743254232669, -122.428918851232) | |||
| 123607 | 123607 | 16942 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 103041 | 103041 | 16943 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 60904 | 60904 | 16944 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
| 10957 | 10957 | 17580 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003780.63082 | 2090335.5596900003 | 37.719877649504205 | -122.428963734788 | (37.7198776495042, -122.428963734788) | |||
| 11152 | 11152 | 17582 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.42902837176202 | (37.7199031291015, -122.429028371762) | |||
| 12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) | |||
| 12852 | 12852 | 17587 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 35 | 3X3 | 6003703.481380001 | 2090378.19842 | 37.7199903588363 | -122.42923345225901 | (37.7199903588363, -122.429233452259) | |||
| 11319 | 11319 | 17589 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503006 | -122.42930461652 | (37.720035114503, -122.42930461652) | |||
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 20727 | 20727 | 18395 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010583.3123699995 | 2102829.86253 | 37.7545670450388 | -122.406328995892 | (37.7545670450388, -122.406328995892) | |||
| 23146 | 23146 | 18396 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6010579.89975 | 2102879.8481400004 | 37.7547041035309 | -122.406344319459 | (37.7547041035309, -122.406344319459) | |||
| 18091 | 18091 | 18397 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3X3 | 6010576.96525 | 2102937.51144 | 37.7548622699958 | -122.406358530544 | (37.7548622699958, -122.406358530544) | |||
| 20353 | 20353 | 18398 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 3 | 3X3 | 6010574.371780001 | 2102982.33848 | 37.7549852100133 | -122.40637065790101 | (37.7549852100133, -122.406370657901) | ||
| 126196 | 126196 | 18399 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 138503 | 138503 | 18401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 22206 | 22206 | 18402 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010563.4475 | 2103210.4803400002 | 37.755611025734 | -122.40642451198299 | (37.755611025734, -122.406424511983) | |||
| 23324 | 23324 | 18403 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/14/1991 12:00:00 AM | 10 | 3X3 | 6010561.22501 | 2103261.37452 | 37.7557506454989 | -122.406435784089 | (37.7557506454989, -122.406435784089) | ||
| 21450 | 21450 | 18404 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3x3 | 6010558.96581 | 2103310.46639 | 37.755885314463605 | -122.40644705620001 | (37.7558853144636, -122.4064470562) | |||
| 23258 | 23258 | 18405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6010556.98057 | 2103355.2247200003 | 37.756008099814295 | -122.406457075558 | (37.7560080998143, -122.406457075558) | |||
| 20860 | 20860 | 18406 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3x3 | 6010555.16427 | 2103408.27395 | 37.7561536595775 | -122.406467094883 | (37.7561536595775, -122.406467094883) | |||
| 17355 | 17355 | 18407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6010549.786619999 | 2103464.28095 | 37.7563071414784 | -122.4064896391 | (37.7563071414784, -122.4064896391) | ||
| 128737 | 128737 | 18408 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | ||
| 92972 | 92972 | 18426 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 107467 | 107467 | 18427 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 99627 | 99627 | 18428 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 103504 | 103504 | 18429 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3x3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 112444 | 112444 | 18430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 142641 | 142641 | 18431 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 76011 | 76011 | 18432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 8439 | 8439 | 19025 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 2X2 | 5999621.132119999 | 2115414.4338700003 | 37.7885017807754 | -122.445143681435 | (37.7885017807754, -122.445143681435) | |||
| 90536 | 90536 | 19034 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 2X2 | 5999529.89099 | 2115397.3219999997 | 37.7884495878023 | -122.445458129536 | (37.7884495878023, -122.445458129536) | |||
| 100165 | 100165 | 21796 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 126832 | 126832 | 21800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 80999 | 80999 | 21801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 25 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 141869 | 141869 | 21804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 94842 | 94842 | 21807 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 78294 | 78294 | 24522 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 45 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 80242 | 80242 | 24613 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1735 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6x7 | 6006758.7391800005 | 2108085.91697 | 37.768784258651706 | -122.419928366315 | (37.7687842586517, -122.419928366315) | |||
| 79579 | 79579 | 25482 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 92671 | 92671 | 25483 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3X3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 1664 | 1664 | 26404 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996581.1026099995 | 2115987.02812 | 37.7898999837554 | -122.455703055979 | (37.7898999837554, -122.455703055979) | |||
| 8973 | 8973 | 26405 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996577.84585 | 2116013.8842599997 | 37.7899735365954 | -122.455716266094 | (37.7899735365954, -122.455716266094) | |||
| 8634 | 8634 | 26406 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996571.148159999 | 2116042.19518 | 37.79005088639771 | -122.45574148670099 | (37.7900508863977, -122.455741486701) | |||
| 5678 | 5678 | 26407 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.426030001 | 2116078.0273700003 | 37.7901491157315 | -122.455753496227 | (37.7901491157315, -122.455753496227) | |||
| 4439 | 4439 | 26408 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 34 Maple St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.99823 | 2116111.6508299997 | 37.7902410678174 | -122.45577816732599 | (37.7902410678174, -122.455778167326) | |||
| 8270 | 8270 | 26409 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.54746 | 2116120.98746 | 37.790266677821 | -122.45578040214599 | (37.790266677821, -122.455780402146) |
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");