Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 860 | 860 | 189218 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 72 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6016946.50299 | 2094945.8896700002 | 37.7332731602285 | -122.38377428587299 | (37.7332731602285, -122.383774285873) | |||
| 1983 | 1983 | 124970 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 4ft | 5999252.18429 | 2119704.33945 | 37.8002596566144 | -122.446728969472 | (37.8002596566144, -122.446728969472) | |||
| 2467 | 2467 | 192164 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 5ft | Permit Number 779453 | 6007314.84465 | 2109842.28548 | 37.7736381448041 | -122.418129368272 | (37.7736381448041, -122.418129368272) | ||
| 3816 | 3816 | 219559 | Undocumented 2 | Ulmus americana :: American Elm 119 | 4 Cortes Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 3ft | 5993189.55754 | 2099585.29183 | 37.7446699411581 | -122.46624493416799 | (37.7446699411581, -122.466244934168) | |||
| 4480 | 4480 | 220292 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6007965.909 | 2103878.5060799997 | 37.757299618008396 | -122.415454932923 | (37.7572996180084, -122.415454932923) | |||
| 4683 | 4683 | 176984 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2923 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 3ft | 5996996.89662 | 2087496.1826099998 | 37.7116950608382 | -122.452207850721 | (37.7116950608382, -122.452207850721) | |||
| 8321 | 8321 | 3077 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3X3 | 6000428.4213 | 2115122.0194 | 37.7877449317952 | -122.442329593525 | (37.7877449317952, -122.442329593525) | |||
| 9639 | 9639 | 114121 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9652 | 9652 | 114118 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9676 | 9676 | 114117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9702 | 9702 | 104171 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6002306.0 | 2096613.0 | 37.7370304975493 | -122.43450961762501 | (37.7370304975493, -122.434509617625) | |||
| 10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
| 12230 | 12230 | 950 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1478 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 6x12 | 6002141.00147 | 2093513.5892299998 | 37.7285108578791 | -122.43485850664 | (37.7285108578791, -122.43485850664) | |||
| 12326 | 12326 | 113363 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 126 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x6 | Permit Number 776810 | 5991720.20644 | 2088367.09772 | 37.7137826921811 | -122.470508741378 | (37.7137826921811, -122.470508741378) | ||
| 13772 | 13772 | 18354 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 491 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6010402.26226 | 2106030.70072 | 37.7633456989776 | -122.407180733903 | (37.7633456989776, -122.407180733903) | |||
| 13974 | 13974 | 97229 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 15x200 | 6016636.9425099995 | 2094930.8404400002 | 37.7332147213866 | -122.38484348356701 | (37.7332147213866, -122.384843483567) | |||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 17263 | 17263 | 5517 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 848 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 5x5 | 6004997.88514 | 2103403.44708 | 37.7558279467221 | -122.425685719428 | (37.7558279467221, -122.425685719428) | |||
| 17354 | 17354 | 16593 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 29 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6002857.53861 | 2108101.18794 | 37.768605630370296 | -122.433423411666 | (37.7686056303703, -122.433423411666) | |||
| 17566 | 17566 | 5520 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 861 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6X6 | 6005083.64012 | 2103377.03639 | 37.7557602745442 | -122.42538727132201 | (37.7557602745442, -122.425387271322) | |||
| 17697 | 17697 | 4413 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1108 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6x9 | 6004403.04195 | 2102416.52833 | 37.753084468576205 | -122.427672567341 | (37.7530844685762, -122.427672567341) | |||
| 18048 | 18048 | 19161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6003505.743559999 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | |||
| 19002 | 19002 | 7621 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6x9 | 6008480.6465300005 | 2099830.22389 | 37.7462128639419 | -122.413388474314 | (37.7462128639419, -122.413388474314) | |||
| 19120 | 19120 | 5561 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 987 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005127.60414 | 2102608.85255 | 37.75365350472929 | -122.42518057112301 | (37.7536535047293, -122.425180571123) | |||
| 20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
| 20574 | 20574 | 23101 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | |||
| 20607 | 20607 | 390 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3790X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2 | 5990465.39673 | 2090774.00996 | 37.720318843429496 | -122.475021373044 | (37.7203188434295, -122.475021373044) | |||
| 20730 | 20730 | 4823 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 66 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006092.06915 | 2097770.47064 | 37.74042284693579 | -122.421501634396 | (37.7404228469358, -122.421501634396) | |||
| 20920 | 20920 | 22851 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 135 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 5999814.579609999 | 2099082.6880900003 | 37.7436699310286 | -122.443300883346 | (37.7436699310286, -122.443300883346) | |||
| 21300 | 21300 | 2408 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2733 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6009836.697000001 | 2101416.76676 | 37.7506452050256 | -122.408811311795 | (37.7506452050256, -122.408811311795) | |||
| 21354 | 21354 | 19142 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 42 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3X3 | 6003449.87411 | 2108085.74485 | 37.7685968152119 | -122.431373470008 | (37.7685968152119, -122.431373470008) | |||
| 22096 | 22096 | 23652 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 217 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3X3 | 6006819.37366 | 2098398.07628 | 37.7421870937737 | -122.419031399973 | (37.7421870937737, -122.419031399973) | |||
| 23178 | 23178 | 11964 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6015715.011390001 | 2096321.03931 | 37.7369808923559 | -122.38812786163 | (37.7369808923559, -122.38812786163) | |||
| 23323 | 23323 | 4351 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 28 | 3X3 | 6001420.13833 | 2095958.4548400003 | 37.735182941645 | -122.437525573868 | (37.735182941645, -122.437525573868) | ||
| 23645 | 23645 | 131755 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1856 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6005252.93645 | 2117501.9314 | 37.7945533647075 | -122.425807142281 | (37.7945533647075, -122.425807142281) | |||
| 24149 | 24149 | 125090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3075 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6000094.70412 | 2115753.61769 | 37.789460110053795 | -122.44352957555 | (37.7894601100538, -122.44352957555) | |||
| 24163 | 24163 | 194035 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6012914.68454 | 2106566.8968 | 37.7649582598465 | -122.398528655089 | (37.7649582598465, -122.398528655089) | |||
| 24519 | 24519 | 206820 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 5994214.91647 | 2101031.13143 | 37.7486989587999 | -122.462804340247 | (37.7486989587999, -122.462804340247) | |||
| 24758 | 24758 | 209872 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 5995817.53285 | 2106359.94183 | 37.7634226953315 | -122.457648057512 | (37.7634226953315, -122.457648057512) | |||
| 25039 | 25039 | 199364 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 6ft | 6009993.3485 | 2108173.3882400002 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | |||
| 25310 | 25310 | 140942 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2040 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6001553.8791 | 2113243.0685 | 37.7826498950255 | -122.438301070072 | (37.7826498950255, -122.438301070072) | |||
| 25996 | 25996 | 194361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.786285536482296 | -122.38799801482 | (37.7862855364823, -122.38799801482) | |||
| 27018 | 27018 | 215471 | Undocumented 2 | Ulmus americana :: American Elm 119 | 50 Sola Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5994846.246 | 2100781.0539 | 37.7480486509235 | -122.46060310387101 | (37.7480486509235, -122.460603103871) | |||
| 27323 | 27323 | 211279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.44320928919201 | (37.7324367835174, -122.443209289192) | |||
| 27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
| 28252 | 28252 | 218356 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 355 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 0ft | 5993561.70957 | 2100014.8497 | 37.7458708634629 | -122.464989307038 | (37.7458708634629, -122.464989307038) | |||
| 28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 29200 | 29200 | 245084 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 122 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6000331.4821 | 2109497.9077 | 37.772297034891 | -122.44226108892 | (37.772297034891, -122.44226108892) | |||
| 29839 | 29839 | 191883 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1190 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6017587.33306 | 2094052.1604900002 | 37.730854558576496 | -122.381496607983 | (37.7308545585765, -122.381496607983) | |||
| 30404 | 30404 | 211568 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 14 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5993188.03849 | 2097444.68988 | 37.7387923005312 | -122.466094663748 | (37.7387923005312, -122.466094663748) | |||
| 30419 | 30419 | 124070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 501 Funston Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5991895.55651 | 2111444.2784599997 | 37.7771568387438 | -122.47158330000201 | (37.7771568387438, -122.471583300002) | |||
| 30667 | 30667 | 193640 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 7 | : 4 | Tree 1 | Private 1 | 28 | Width 6ft | 6012998.43724 | 2097039.27853 | 37.7388021399962 | -122.397570695448 | (37.7388021399962, -122.397570695448) | |||
| 32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
| 32828 | 32828 | 16168 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 425 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 28 | 3X3 | 5999268.01839 | 2094645.0590400002 | 37.7314540727301 | -122.444871826278 | (37.7314540727301, -122.444871826278) | ||
| 32897 | 32897 | 245304 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 371 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003869.89796 | 2096618.9998400002 | 37.737135624318 | -122.429102948069 | (37.737135624318, -122.429102948069) | |||
| 33192 | 33192 | 194377 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.789304668530896 | -122.388377800289 | (37.7893046685309, -122.388377800289) | |||
| 33366 | 33366 | 124269 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 9 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | ||||
| 33380 | 33380 | 222998 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6002164.76896 | 2103518.3821099997 | 37.7559830321046 | -122.435491759762 | (37.7559830321046, -122.435491759762) | ||||
| 34752 | 34752 | 183980 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1692 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 0ft | 5985341.0245 | 2103687.7125 | 37.7554781047189 | -122.493685471877 | (37.7554781047189, -122.493685471877) | |||
| 35345 | 35345 | 212007 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 San Fernando Way | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 8ft | 5992022.6744800005 | 2094535.4646599998 | 37.7307369974034 | -122.469912149146 | (37.7307369974034, -122.469912149146) | |||
| 35459 | 35459 | 206866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Junipero Serra Blvd | 132 | : 4 | Tree 1 | Private 1 | 28 | Width 0ft | 5991206.46725 | 2091692.32993 | 37.7228832440624 | -122.472526676182 | (37.7228832440624, -122.472526676182) | |||
| 36210 | 36210 | 196055 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 1698 Armstrong Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6013969.15001 | 2092819.20952 | 37.72726869807929 | -122.393919072915 | (37.7272686980793, -122.393919072915) | ||||
| 36367 | 36367 | 203642 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1700 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | |||
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 36793 | 36793 | 140742 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6001472.9963 | 2113178.7683 | 37.7824687423539 | -122.438576280753 | (37.7824687423539, -122.438576280753) | |||
| 36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
| 38072 | 38072 | 201205 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 700 Folsom St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 0ft | 6012507.9947 | 2113054.9902 | 37.782750423526295 | -122.400391060455 | (37.7827504235263, -122.400391060455) | |||
| 39036 | 39036 | 97437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 6004957.66 | 2117462.59015 | 37.794428653010606 | -122.426826033691 | (37.7944286530106, -122.426826033691) | ||||
| 39371 | 39371 | 37143 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Permit Number 39724 | 6003778.522480001 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | |||
| 39406 | 39406 | 209877 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 649 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 5995025.90678 | 2106103.92306 | 37.7626742273566 | -122.460367466183 | (37.7626742273566, -122.460367466183) | |||
| 39454 | 39454 | 187006 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2501 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984975.8458 | 2098059.5278 | 37.7400032741879 | -122.49453347011001 | (37.7400032741879, -122.49453347011) | |||
| 39647 | 39647 | 190975 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6011275.59974 | 2104245.89235 | 37.758493851126296 | -122.40403451598 | (37.7584938511263, -122.40403451598) | ||||
| 39928 | 39928 | 186152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984960.1712 | 2103307.566 | 37.754412039318 | -122.494974531355 | (37.754412039318, -122.494974531355) | |||
| 40186 | 40186 | 218289 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991265.0261699995 | 2095485.2551900002 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | ||||
| 40531 | 40531 | 186763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984864.2659 | 2106722.4222 | 37.7637826685387 | -122.49555804452801 | (37.7637826685387, -122.495558044528) | |||
| 40971 | 40971 | 231993 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 140 Albion St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6005880.971530001 | 2106406.6784900003 | 37.7641239776661 | -122.422845145987 | (37.7641239776661, -122.422845145987) | |||
| 41202 | 41202 | 191993 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1395 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6017281.31768 | 2093927.6967 | 37.7304959053633 | -122.382545906371 | (37.7304959053633, -122.382545906371) | |||
| 41343 | 41343 | 225368 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 52 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6006747.47175 | 2109298.4293299997 | 37.7721128946332 | -122.420053398561 | (37.7721128946332, -122.420053398561) | |||
| 41451 | 41451 | 205472 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5999475.13727 | 2093536.5919400002 | 37.7284222989294 | -122.444076160988 | (37.7284222989294, -122.444076160988) | ||||
| 41508 | 41508 | 181289 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 4ft | 5998212.96577 | 2088739.68043 | 37.715179010179 | -122.448094282435 | (37.715179010179, -122.448094282435) | |||
| 42492 | 42492 | 247161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2399 Market St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 5ft | 6002372.95372 | 2105936.54637 | 37.7626345492748 | -122.43494472103998 | (37.7626345492748, -122.43494472104) | |||
| 42763 | 42763 | 241020 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 2ft | 6008973.83234 | 2096817.1945900002 | 37.737967424348795 | -122.411470260845 | (37.7379674243488, -122.411470260845) | |||
| 42977 | 42977 | 105374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 127 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 5993372.2 | 2093864.2 | 37.7289717869451 | -122.46519792761299 | (37.7289717869451, -122.465197927613) | |||
| 42999 | 42999 | 225871 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6006494.401190001 | 2098665.31091 | 37.742902554819004 | -122.420174017412 | (37.742902554819, -122.420174017412) | |||
| 43004 | 43004 | 181400 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984903.9819 | 2104642.6861 | 37.7580746197396 | -122.495267299141 | (37.7580746197396, -122.495267299141) | |||
| 43364 | 43364 | 115743 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 44163 | 44163 | 224253 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 755 Sanchez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003620.8208099995 | 2103873.1752 | 37.757039798462294 | -122.430481566473 | (37.7570397984623, -122.430481566473) | |||
| 44276 | 44276 | 141130 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1750 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6002420.0697 | 2113015.4798 | 37.782074222256 | -122.43528814061199 | (37.782074222256, -122.435288140612) | |||
| 44619 | 44619 | 203266 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 3ft | 5995209.57464 | 2099663.22163 | 37.7450002594644 | -122.45926579939 | (37.7450002594644, -122.45926579939) | |||
| 44955 | 44955 | 245596 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 379 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003781.47913 | 2096549.5150400002 | 37.736939829299295 | -122.429403698427 | (37.7369398292993, -122.429403698427) | |||
| 45086 | 45086 | 209100 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 45 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5993050.40784 | 2097059.35291 | 37.737726320615295 | -122.466542521627 | (37.7377263206153, -122.466542521627) | |||
| 45201 | 45201 | 205498 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5992906.69703 | 2102511.7445400003 | 37.7526889062749 | -122.467435765149 | (37.7526889062749, -122.467435765149) | |||
| 46275 | 46275 | 223988 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 3770 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6004647.28322 | 2101937.7853900003 | 37.7517837647067 | -122.42679384156901 | (37.7517837647067, -122.426793841569) |
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");