Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108981 | 108981 | 103959 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 460X Lily St | 1 | unknown : Pot 31 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
| 126368 | 126368 | 105684 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 124771 | 124771 | 105685 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 2 | Front Yard : Pot 30 | Tree 1 | Private 1 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 113280 | 113280 | 105686 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 3 | Front Yard : Pot 30 | Tree 1 | Private 1 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 104863 | 104863 | 106838 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 735 Battery St | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | Permit Number 773117 | 6012413.67639 | 2118682.92207 | 37.798198135735895 | -122.40111294506201 | (37.7981981357359, -122.401112945062) | ||||
| 95825 | 95825 | 113796 | Section 143 8 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 331 TERESITA BLVD | 2 | Hanging basket : Cutout 29 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
| 94067 | 94067 | 91239 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 1 | Median : Hanging Pot 28 | Tree 1 | DPW 2 | 11/20/1989 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 123271 | 123271 | 93131 | Permitted Site 1 | Tree(s) :: 17 | 700 Brotherhood Way | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53178 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | ||||
| 122233 | 122233 | 93130 | Permitted Site 1 | Tree(s) :: 17 | 700 Brotherhood Way | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53178 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | ||||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 109026 | 109026 | 94201 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1227 Pierce St | 2 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086.0 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | |||
| 105405 | 105405 | 98743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Masonic Ave | 5 | Sidewalk: Property side : 26 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5998843.8 | 2112455.0 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | ||||
| 104230 | 104230 | 96185 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 2 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 93937 | 93937 | 96184 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 1 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 89488 | 89488 | 96348 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 4 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 05/09/2011 12:00:00 AM | Permit Number 767939 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 82961 | 82961 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 159181 | 159181 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1499@Newhall Evans Ave | 2 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.2738099997 | 37.7417009175609 | -122.38640138991501 | (37.7417009175609, -122.386401389915) | ||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 126156 | 126156 | 98308 | Significant Tree 6 | Tree(s) :: 17 | 1490 Fairfax Ave | 1 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3x3 | Permit Number 768575 | 6016246.6 | 2097899.9 | 37.7413455620636 | -122.386399955147 | (37.7413455620636, -122.386399955147) | ||
| 122098 | 122098 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 117221 | 117221 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 161 | 548 Page St | Front Yard : 25 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937.0 | 2109751.0 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | ||||
| 116206 | 116206 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | |||
| 110409 | 110409 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070@ 32nd Ave California St | 4 | Front Yard : 25 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
| 104638 | 104638 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 104145 | 104145 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261908999 | (37.740765720819, -122.41052261909) | |||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 95092 | 95092 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 150 | 2614 Sacramento St | Front Yard : 25 | Tree 1 | Private 1 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291.0 | 2115777.0 | 37.789649322620896 | -122.43593231943599 | (37.7896493226209, -122.435932319436) | ||||
| 89463 | 89463 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 1457 Willard St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | |||
| 77945 | 77945 | 95138 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 128 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 75158 | 75158 | 95137 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 127 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 66105 | 66105 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 401X Newhall St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6 | 3x3 | 6016081.14502 | 2097910.9401599998 | 37.741366715992896 | -122.386972815546 | (37.7413667159929, -122.386972815546) | |||
| 140734 | 140734 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 1820X Palou Ave | : Cutout 24 | Tree 1 | Rec/Park 3 | FUF 1 | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | ||||
| 125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
| 107188 | 107188 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 104123 | 104123 | 93976 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3261 Harrison St | : Cutout 24 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036.0 | 2099698.0 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | ||||
| 99206 | 99206 | 115258 | Permitted Site 1 | :: 54 | 2150 Jackson St | : Cutout 24 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003858.0 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | ||||
| 90667 | 90667 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 44829 | 44829 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 188821 | 188821 | 192368 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014962.221059999 | 2102496.55555 | 37.753895835135104 | -122.39116214813801 | (37.7538958351351, -122.391162148138) | ||||
| 188614 | 188614 | 197467 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 1 | : Yard 23 | Tree 1 | Private 1 | 13 | 6017027.60375 | 2102629.3032400003 | 37.7543747331295 | -122.38402874544799 | (37.7543747331295, -122.384028745448) | ||||
| 187327 | 187327 | 233306 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 174 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 26 | 6000631.47853 | 2100513.23992 | 37.7476444344533 | -122.44057883696999 | (37.7476444344533, -122.44057883697) | ||||
| 186761 | 186761 | 194527 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 16 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.39111409374901 | (37.7530595798584, -122.391114093749) | ||||
| 186405 | 186405 | 224262 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 91 Stanton St | 2 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6000293.691000001 | 2103856.2070400002 | 37.7568041715846 | -122.44198679486 | (37.7568041715846, -122.44198679486) | |||
| 185838 | 185838 | 209018 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | ||||
| 184577 | 184577 | 192373 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 18 | : Yard 23 | Tree 1 | Private 1 | 17 | 6015020.94183 | 2102357.50513 | 37.7535172906979 | -122.390949358625 | (37.7535172906979, -122.390949358625) | ||||
| 182983 | 182983 | 194593 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 21 | : Yard 23 | Tree 1 | Private 1 | 19 | 6014441.963140001 | 2105885.02123 | 37.763170945392496 | -122.393198423694 | (37.7631709453925, -122.393198423694) | ||||
| 181761 | 181761 | 192393 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1 24th St | 25 | : Yard 23 | Tree 1 | Private 1 | 3 | 6017132.65269 | 2102598.1255200002 | 37.7542949326738 | -122.38366328523001 | (37.7542949326738, -122.38366328523) | ||||
| 181215 | 181215 | 194529 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 23 | : Yard 23 | Tree 1 | Private 1 | 2 | 6014967.185409999 | 2102296.35434 | 37.753346400626 | -122.39113098750201 | (37.753346400626, -122.391130987502) | ||||
| 180257 | 180257 | 189221 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1310 Indiana St | 14 | : Yard 23 | Tree 1 | Private 1 | 1 | 6015010.96324 | 2102373.3642599997 | 37.7535602828051 | -122.39098497537901 | (37.7535602828051, -122.390984975379) | ||||
| 179643 | 179643 | 222664 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003149.42788 | 2104190.19818 | 37.7578835531891 | -122.432134460156 | (37.7578835531891, -122.432134460156) | |||
| 178126 | 178126 | 224454 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 4090 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6003124.6046 | 2104168.08557 | 37.7578214298263 | -122.432218730236 | (37.7578214298263, -122.432218730236) | |||
| 177343 | 177343 | 199556 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 17 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014441.57524 | 2105911.35616 | 37.7632432338158 | -122.39320160818599 | (37.7632432338158, -122.393201608186) | ||||
| 174582 | 174582 | 189679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 20 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017238.946959999 | 2102621.26617 | 37.7543643468473 | -122.383297299846 | (37.7543643468473, -122.383297299846) | ||||
| 174541 | 174541 | 234949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 176 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 21 | 6000647.81323 | 2100527.14319 | 37.74768353965921 | -122.44052334968599 | (37.7476835396592, -122.440523349686) | ||||
| 173611 | 173611 | 192357 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.39086983518801 | (37.7528860304727, -122.390869835188) | ||||
| 173331 | 173331 | 233230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 3 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010120.38838 | 2099686.6934 | 37.745910689944104 | -122.407708305 | (37.7459106899441, -122.407708305) | |||
| 172054 | 172054 | 222663 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003162.223809999 | 2104187.96649 | 37.7578781509761 | -122.43209004713002 | (37.7578781509761, -122.43209004713) | |||
| 171294 | 171294 | 223319 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003647.0575 | 2104227.27295 | 37.7580135529116 | -122.43041609403299 | (37.7580135529116, -122.430416094033) | |||
| 171136 | 171136 | 199548 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 4 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014382.11605 | 2105919.95745 | 37.7632635477036 | -122.39340786139499 | (37.7632635477036, -122.393407861395) | ||||
| 171000 | 171000 | 192369 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 8 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014983.64642 | 2102476.35721 | 37.7538415637469 | -122.391086641939 | (37.7538415637469, -122.391086641939) | ||||
| 170165 | 170165 | 197469 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 3 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017071.17305 | 2102662.5786200003 | 37.7544685090175 | -122.383880386982 | (37.7544685090175, -122.383880386982) | ||||
| 170055 | 170055 | 199552 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 8 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.39328625146099 | (37.7632720076265, -122.393286251461) | ||||
| 169576 | 169576 | 233228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010113.61596 | 2099694.13241 | 37.7459307367175 | -122.407732247644 | (37.7459307367175, -122.407732247644) | |||
| 168798 | 168798 | 196566 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 24th St | 23 | : Yard 23 | Tree 1 | Private 1 | 13 | 6017174.3189900005 | 2102601.55087 | 37.7543066409576 | -122.38351942967199 | (37.7543066409576, -122.383519429672) | ||||
| 167772 | 167772 | 245705 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003616.02573 | 2104184.50188 | 37.757894355861396 | -122.430520363245 | (37.7578943558614, -122.430520363245) | |||
| 167241 | 167241 | 194528 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 21 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014977.555240001 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | ||||
| 166837 | 166837 | 199547 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 3 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014373.91679 | 2105917.88241 | 37.763257394541796 | -122.39343607492201 | (37.7632573945418, -122.393436074922) | ||||
| 165472 | 165472 | 199546 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 2 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014366.09507 | 2105920.56167 | 37.7632643166198 | -122.393463315392 | (37.7632643166198, -122.393463315392) | ||||
| 165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
| 164374 | 164374 | 222115 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4090 20th St | 9 | : Yard 23 | Tree 1 | Private 1 | 15 | Width 3ft | 6003100.58415 | 2104168.90978 | 37.757822330949004 | -122.432301861758 | (37.757822330949, -122.432301861758) | |||
| 164257 | 164257 | 205447 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 321 Melrose Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 2 | 5997960.43745 | 2095528.68593 | 37.7338055912481 | -122.44945600530001 | (37.7338055912481, -122.4494560053) | ||||
| 164046 | 164046 | 194259 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 22 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014914.86206 | 2102424.38068 | 37.753695030018 | -122.391320882968 | (37.753695030018, -122.391320882968) | ||||
| 163941 | 163941 | 211530 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 321 Melrose Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 16 | 5997959.2212 | 2095523.47143 | 37.733791203898704 | -122.44945983462699 | (37.7337912038987, -122.449459834627) | ||||
| 163742 | 163742 | 189680 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 21 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017213.38014 | 2102597.10976 | 37.754296605427704 | -122.38338403586701 | (37.7542966054277, -122.383384035867) | ||||
| 163548 | 163548 | 189289 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 20 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014461.84726 | 2105889.9963 | 37.76318571047079 | -122.393129998769 | (37.7631857104708, -122.393129998769) | ||||
| 162701 | 162701 | 176100 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 19 | 6004405.409030001 | 2089175.08917 | 37.7167265950249 | -122.42672149649799 | (37.7167265950249, -122.426721496498) | ||||
| 162377 | 162377 | 194033 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 9 | : Yard 23 | Tree 1 | Private 1 | 18 | 6017162.02159 | 2102667.2446 | 37.7544863425722 | -122.383566530788 | (37.7544863425722, -122.383566530788) | ||||
| 162156 | 162156 | 193474 | Undocumented 2 | Mangifera indica :: Mango 549 | 1310 Indiana St | 25 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014936.17409 | 2102358.6880200002 | 37.7535158347022 | -122.391242588881 | (37.7535158347022, -122.391242588881) | ||||
| 161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
| 158947 | 158947 | 194032 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 25th St | 9 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015018.29801 | 2102168.6663599997 | 37.7529986327902 | -122.39094530450599 | (37.7529986327902, -122.390945304506) | ||||
| 158856 | 158856 | 177486 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 601 La Grande Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | 6004368.23495 | 2089081.7920799998 | 37.7164683196427 | -122.42684334834999 | (37.7164683196427, -122.42684334835) | ||||
| 157410 | 157410 | 233500 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 4090 20th St | 10 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.43231097188601 | (37.7578610449587, -122.432310971886) | |||
| 157392 | 157392 | 190908 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1 01st St | 32 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014392.80706 | 2105893.3505 | 37.7631910848138 | -122.393369022367 | (37.7631910848138, -122.393369022367) | ||||
| 156957 | 156957 | 233233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 6 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010125.251569999 | 2099665.5030400003 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | |||
| 156510 | 156510 | 233334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 91 Stanton St | 1 | : Yard 23 | Tree 1 | Private 1 | 15 | Width 3ft | 6000284.24588 | 2103856.40307 | 37.7568041715962 | -122.442019473547 | (37.7568041715962, -122.442019473547) | |||
| 156226 | 156226 | 223318 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003637.291809999 | 2104227.88023 | 37.75801466716629 | -122.43044991126101 | (37.7580146671663, -122.430449911261) | |||
| 154821 | 154821 | 237005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 16 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010090.49979 | 2099699.0653 | 37.7459429872721 | -122.40781252834101 | (37.7459429872721, -122.407812528341) | |||
| 154537 | 154537 | 233603 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 9 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010152.72418 | 2099634.5230799997 | 37.7457692517475 | -122.40759281407101 | (37.7457692517475, -122.407592814071) | |||
| 153814 | 153814 | 199510 | Undocumented 2 | Quercus engelmannii :: Engelmann oak 453 | 1 01st St | 14 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014434.26374 | 2105920.54159 | 37.7632680488164 | -122.39322753922801 | (37.7632680488164, -122.393227539228) | ||||
| 153691 | 153691 | 188436 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1310 Indiana St | 3 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014947.70455 | 2102543.51938 | 37.7540239822338 | -122.391215632613 | (37.7540239822338, -122.391215632613) | ||||
| 153276 | 153276 | 199557 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 18 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | ||||
| 153234 | 153234 | 209020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | ||||
| 152563 | 152563 | 234500 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 4090 20th St | 8 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003098.9698 | 2104154.51537 | 37.757782715804204 | -122.43230641682699 | (37.7577827158042, -122.432306416827) | |||
| 152462 | 152462 | 233605 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 12 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.745808231063705 | -122.407697037414 | (37.7458082310637, -122.407697037414) | |||
| 152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
| 151834 | 151834 | 194402 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 1310 Indiana St | 12 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014991.28899 | 2102382.99945 | 37.7535856472653 | -122.39105368718799 | (37.7535856472653, -122.391053687188) | ||||
| 151779 | 151779 | 241988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Franconia St | 18 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010085.85388 | 2099710.92257 | 37.745975284649 | -122.40782942930299 | (37.745975284649, -122.407829429303) |
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");