Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76764 | 76764 | 108377 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.0586299999 | 37.7219782266077 | -122.42607682199801 | (37.7219782266077, -122.426076821998) | |
| 77340 | 77340 | 112100 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 77857 | 77857 | 84000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.47208471659799 | (37.7451230278663, -122.472084716598) | |
| 78101 | 78101 | 96597 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 78478 | 78478 | 117133 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 78495 | 78495 | 121113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 78805 | 78805 | 97021 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 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) | |||||
| 78934 | 78934 | 122469 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 78997 | 78997 | 112099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 79119 | 79119 | 105692 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.41210193949699 | (37.7566645705002, -122.412101939497) | ||
| 79519 | 79519 | 116593 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 830x PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002569.0 | 2111577.0 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | |||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 79633 | 79633 | 101450 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 331X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5993377.6 | 2113262.5 | 37.7822348132756 | -122.46658867692301 | (37.7822348132756, -122.466588676923) | ||||
| 79710 | 79710 | 84511 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 670 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002290.0 | 2089910.0 | 37.7186246694004 | -122.434085914673 | (37.7186246694004, -122.434085914673) | ||
| 79926 | 79926 | 112059 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 36 | 5x6 | 5991981.6527 | 2110175.44232 | 37.7736779395689 | -122.471193003562 | (37.7736779395689, -122.471193003562) | ||
| 80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 80264 | 80264 | 116708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 81160 | 81160 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 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) | |||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 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) | |||||
| 81365 | 81365 | 116603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3388 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004272.63100633 | 2106610.91605823 | 37.7645938851901 | -122.42842248798901 | (37.7645938851901, -122.428422487989) | ||||
| 81426 | 81426 | 105758 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.41210193949699 | (37.7566645705002, -122.412101939497) | ||
| 81542 | 81542 | 102317 | Permitted Site 1 | Tree(s) :: 17 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6006607.7 | 2095553.8 | 37.7343654214358 | -122.419561552483 | (37.7343654214358, -122.419561552483) | |||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81799 | 81799 | 104075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.45967126156602 | (37.7391466176195, -122.459671261566) | |||
| 82303 | 82303 | 116707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 82373 | 82373 | 121115 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 82443 | 82443 | 121103 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.47260356904499 | (37.7623789807661, -122.472603569045) | |||
| 82474 | 82474 | 108629 | Undocumented 2 | :: 54 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | |||
| 82635 | 82635 | 122813 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 889 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) | ||||
| 82880 | 82880 | 112265 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 82893 | 82893 | 97042 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 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) | |||||
| 82930 | 82930 | 117116 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | ||||
| 83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 83077 | 83077 | 115602 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | ||||
| 83081 | 83081 | 111955 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5987872.34655427 | 2115783.06288074 | 37.78883633031629 | -122.48581921103799 | (37.7888363303163, -122.485819211038) | |||
| 83371 | 83371 | 99252 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1999X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 49094 | 5998316.3 | 2109969.5 | 37.7734768483436 | -122.44926573693998 | (37.7734768483436, -122.44926573694) | |
| 83486 | 83486 | 108472 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | |||
| 83695 | 83695 | 121305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 83697 | 83697 | 108792 | Permitted Site 1 | :: 54 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 83734 | 83734 | 121582 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6013716.0 | 2106401.0 | 37.764547352750604 | -122.39574546120899 | (37.7645473527506, -122.395745461209) | |||
| 83803 | 83803 | 98247 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | I think these were planted in 2010 by FUF. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | ||
| 83811 | 83811 | 110664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009804.95200969 | 2114873.04035134 | 37.78759124988321 | -122.40987086176399 | (37.7875912498832, -122.409870861764) | ||||
| 83862 | 83862 | 121571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 35 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006513.38590805 | 2108286.22014995 | 37.7693204178219 | -122.420791248972 | (37.7693204178219, -122.420791248972) | ||||
| 84052 | 84052 | 116204 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3773 Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996831.55660521 | 2114970.89612566 | 37.787124327034995 | -122.454763067438 | (37.787124327035, -122.454763067438) | ||||
| 84207 | 84207 | 111479 | Permitted Site 1 | Tree(s) :: 17 | 2x TRAINOR ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | |||
| 84451 | 84451 | 116202 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3773 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996831.55660521 | 2114970.89612566 | 37.787124327034995 | -122.454763067438 | (37.787124327035, -122.454763067438) | ||||
| 84597 | 84597 | 112264 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 84879 | 84879 | 122460 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 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) | |||||
| 85159 | 85159 | 108793 | Permitted Site 1 | :: 54 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85864 | 85864 | 114689 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 229 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001466.35447253 | 2104493.12773322 | 37.7586197563696 | -122.437976920317 | (37.7586197563696, -122.437976920317) | ||||
| 85902 | 85902 | 122812 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 889 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) | ||||
| 86060 | 86060 | 102208 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 86728 | 86728 | 113829 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1016 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 6007991.61880243 | 2101998.87406109 | 37.752140020820704 | -122.415232965268 | (37.7521400208207, -122.415232965268) | |||
| 86907 | 86907 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
| 86977 | 86977 | 122462 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 87492 | 87492 | 103023 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 40X Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |||
| 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) | |||||
| 87553 | 87553 | 114662 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 480 Myra Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5997245.35324946 | 2096954.8836891998 | 37.737680654693996 | -122.45203111514499 | (37.737680654694, -122.452031115145) | |||
| 87642 | 87642 | 104512 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 491-497 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003187.0 | 2102698.0 | 37.7537884621117 | -122.43189797261499 | (37.7537884621117, -122.431897972615) | |||
| 87952 | 87952 | 111303 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||||
| 88214 | 88214 | 110663 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009804.95200969 | 2114873.04035134 | 37.78759124988321 | -122.40987086176399 | (37.7875912498832, -122.409870861764) | ||||
| 88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 88648 | 88648 | 112055 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 762 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5991977.01623 | 2110291.17733 | 37.7739954484109 | -122.471217475469 | (37.7739954484109, -122.471217475469) | |||
| 88802 | 88802 | 97029 | Property Tree 7 | Rhamnus californica :: Coffeeberry Tree 232 | 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) | |||||
| 88806 | 88806 | 111450 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1399x EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008618.0 | 2097694.0 | 37.740354975205896 | -122.412762522808 | (37.7403549752059, -122.412762522808) | |||
| 88958 | 88958 | 110267 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 6003998.0 | 2099590.0 | 37.7453005605875 | -122.428871788215 | (37.7453005605875, -122.428871788215) | |||
| 89679 | 89679 | 113662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6012589.13870894 | 2106969.27475819 | 37.766044958315604 | -122.399682898168 | (37.7660449583156, -122.399682898168) | |||
| 90057 | 90057 | 111634 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | |||
| 90136 | 90136 | 108459 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | |||
| 90248 | 90248 | 97040 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 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) | |||||
| 90684 | 90684 | 116842 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1110 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 6003795.63291288 | 2101809.17317596 | 37.751382436857796 | -122.429729790926 | (37.7513824368578, -122.429729790926) | |||
| 90746 | 90746 | 121116 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 90906 | 90906 | 116979 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 353 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006230.67997214 | 2101075.55003457 | 37.7495056615479 | -122.42125700975201 | (37.7495056615479, -122.421257009752) | ||||
| 91027 | 91027 | 115600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 91124 | 91124 | 113402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | ||
| 91966 | 91966 | 115603 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | ||||
| 91973 | 91973 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1327 ULLOA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | ||
| 92381 | 92381 | 108167 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009908.0 | 2100009.0 | 37.7467837814289 | -122.40846544893999 | (37.7467837814289, -122.40846544894) | ||||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 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) | |||||
| 93718 | 93718 | 116732 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3290 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | |||
| 94048 | 94048 | 121095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 94150 | 94150 | 115595 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 94263 | 94263 | 122467 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 94644 | 94644 | 109077 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5993247.8 | 2113128.2 | 37.7818585707794 | -122.467027956142 | (37.7818585707794, -122.467027956142) | ||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 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) | |||||
| 95339 | 95339 | 115604 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 95438 | 95438 | 120638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 538 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | |||
| 95635 | 95635 | 116589 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 830x PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002569.0 | 2111577.0 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | |||
| 95949 | 95949 | 102764 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1X Mirabel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 3x3 | 6007238.4 | 2099828.6 | 37.746138579062396 | -122.41768390456801 | (37.7461385790624, -122.417683904568) | ||
| 95969 | 95969 | 121114 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 96064 | 96064 | 111890 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 176X PERALTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 25 | 3x3 | 6009847.0 | 2100071.0 | 37.7469506034955 | -122.408680755084 | (37.7469506034955, -122.408680755084) | ||
| 96333 | 96333 | 110665 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009804.95200969 | 2114873.04035134 | 37.78759124988321 | -122.40987086176399 | (37.7875912498832, -122.409870861764) | ||||
| 96494 | 96494 | 110186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 96862 | 96862 | 121558 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 6003675.0 | 2102779.0 | 37.754038521377794 | -122.430216135756 | (37.7540385213778, -122.430216135756) | |||
| 97030 | 97030 | 116198 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3773 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996831.55660521 | 2114970.89612566 | 37.787124327034995 | -122.454763067438 | (37.787124327035, -122.454763067438) | ||||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) |
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");