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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 23829 | 23829 | 191740 | Undocumented 2 | Eucalyptus gunnii :: Cider Gum 337 | 1 24th St | 16 | : Yard 23 | Tree 1 | Private 1 | 26 | 6017295.65111 | 2102637.55401 | 37.7544122033759 | -122.383102334025 | (37.7544122033759, -122.383102334025) | ||||
| 24708 | 24708 | 199517 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 13 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014420.56618 | 2105901.8129 | 37.763215862946 | -122.39327360428801 | (37.763215862946, -122.393273604288) | ||||
| 24928 | 24928 | 223320 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.3788 | 2104219.57182 | 37.7579901597246 | -122.430552770305 | (37.7579901597246, -122.430552770305) | |||
| 25470 | 25470 | 223317 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | |||
| 25729 | 25729 | 233231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | |||
| 25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
| 26291 | 26291 | 178180 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 491 La Grande Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 20 | 6004422.927759999 | 2089235.71163 | 37.716894041605 | -122.42666525741001 | (37.716894041605, -122.42666525741) | ||||
| 28022 | 28022 | 189675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 10 | : Yard 23 | Tree 1 | Private 1 | 8 | 6017194.50129 | 2102669.93128 | 37.754495514781496 | -122.383454393407 | (37.7544955147815, -122.383454393407) | ||||
| 28405 | 28405 | 199554 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 10 | : Yard 23 | Tree 1 | Private 1 | 17 | 6014431.6868199995 | 2105923.15598 | 37.763275084200295 | -122.39323663496599 | (37.7632750842003, -122.393236634966) | ||||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
| 30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
| 31493 | 31493 | 188360 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 1310 Indiana St | 19 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014888.31128 | 2102546.96867 | 37.7540301569914 | -122.391421271577 | (37.7540301569914, -122.391421271577) | ||||
| 31965 | 31965 | 192372 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 11 | : Yard 23 | Tree 1 | Private 1 | 18 | 6015021.64054 | 2102392.08058 | 37.753612266314796 | -122.39094935864401 | (37.7536122663148, -122.390949358644) | ||||
| 31996 | 31996 | 237002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6010115.457330001 | 2099644.6115099997 | 37.745794866235 | -122.40772238927 | (37.745794866235, -122.40772238927) | |||
| 32102 | 32102 | 189290 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 23 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014424.75736 | 2105899.2532900004 | 37.7632090676603 | -122.39325892915501 | (37.7632090676603, -122.393258929155) | ||||
| 32348 | 32348 | 233229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 2 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010110.29265 | 2099690.9553400003 | 37.745921827136996 | -122.407743515268 | (37.745921827137, -122.407743515268) | |||
| 32540 | 32540 | 210191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Melrose Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 5997966.64829 | 2095534.3479400002 | 37.7338214930658 | -122.44943494048799 | (37.7338214930658, -122.449434940488) | ||||
| 33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
| 35549 | 35549 | 192359 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 3 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015007.494080001 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | ||||
| 35640 | 35640 | 192367 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 6 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014979.384930001 | 2102511.0329 | 37.75393653934321 | -122.39110380282101 | (37.7539365393432, -122.391103802821) | ||||
| 36486 | 36486 | 192371 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 10 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015009.21329 | 2102415.55606 | 37.7536760354269 | -122.390993975811 | (37.7536760354269, -122.390993975811) | ||||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 37053 | 37053 | 218147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Ashton Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | ||||
| 37555 | 37555 | 237003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010106.165469999 | 2099668.32603 | 37.7458594609566 | -122.40775619120001 | (37.7458594609566, -122.4077561912) | |||
| 37605 | 37605 | 237004 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6010095.49496 | 2099684.36191 | 37.7459028946219 | -122.40779421904101 | (37.7459028946219, -122.407794219041) | |||
| 38165 | 38165 | 223321 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.59341 | 2104210.2360400003 | 37.757964538052796 | -122.430551361954 | (37.7579645380528, -122.430551361954) | |||
| 38615 | 38615 | 177876 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4117 San Bruno Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.40219173226299 | (37.7124588649577, -122.402191732263) | |||
| 38723 | 38723 | 191689 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 01st St | 27 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014402.09171 | 2105890.67407 | 37.7631842517621 | -122.393336722306 | (37.7631842517621, -122.393336722306) | ||||
| 38976 | 38976 | 199555 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014446.64039 | 2105914.6589900004 | 37.763252584054605 | -122.393184320496 | (37.7632525840546, -122.393184320496) | ||||
| 39362 | 39362 | 214005 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 50 Circular Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 17 | 6000114.23279 | 2093911.68117 | 37.7294886448689 | -122.441893693449 | (37.7294886448689, -122.441893693449) | ||||
| 40295 | 40295 | 233234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 7 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6010136.86006 | 2099655.53222 | 37.7458260502241 | -122.40764915121099 | (37.7458260502241, -122.407649151211) | |||
| 40383 | 40383 | 192366 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 20 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014913.1297 | 2102461.68379 | 37.7537973602844 | -122.39132948139 | (37.7537973602844, -122.39132948139) | ||||
| 41043 | 41043 | 199551 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 7 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.39331641112899 | (37.7632704697891, -122.393316411129) | ||||
| 43379 | 43379 | 223787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4404 20th St | 9 | : Yard 23 | Tree 1 | Private 1 | 44 | Width 3ft | 6003650.35726 | 2104229.2336 | 37.75801912330729 | -122.430404821951 | (37.7580191233073, -122.430404821951) | |||
| 44358 | 44358 | 245707 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003651.76342 | 2104178.89616 | 37.7578809883279 | -122.430396367393 | (37.7578809883279, -122.430396367393) | |||
| 44764 | 44764 | 205937 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 50 Circular Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000127.5419 | 2093913.2935099998 | 37.7294938303644 | -122.44184779835501 | (37.7294938303644, -122.441847798355) | ||||
| 45680 | 45680 | 176101 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 26 | 6004411.36222 | 2089192.97967 | 37.716776055035794 | -122.426702192554 | (37.7167760550358, -122.426702192554) | ||||
| 46299 | 46299 | 233305 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 170 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 17 | 6000606.984180001 | 2100509.57943 | 37.7476329887819 | -122.44066327429199 | (37.7476329887819, -122.440663274292) | ||||
| 48394 | 48394 | 197468 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 2 | : Yard 23 | Tree 1 | Private 1 | 14 | 6017037.26149 | 2102635.05439 | 37.754391058511295 | -122.38399574663299 | (37.7543910585113, -122.383995746633) | ||||
| 48813 | 48813 | 199516 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 12 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014441.55665 | 2105919.02201 | 37.7632642815347 | -122.393202208925 | (37.7632642815347, -122.393202208925) | ||||
| 48818 | 48818 | 222665 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6003145.04093 | 2104185.04238 | 37.7578691478694 | -122.432149263871 | (37.7578691478694, -122.432149263871) | |||
| 49162 | 49162 | 234414 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 280 | 2 | : Yard 23 | Tree 1 | Private 1 | 23 | Width 3ft | 6005979.042880001 | 2094923.96665 | 37.7326006076366 | -122.421690307661 | (37.7326006076366, -122.421690307661) | |||
| 49572 | 49572 | 189393 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 24th St | 15 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.38314741343201 | (37.7544303427117, -122.383147413432) | ||||
| 50679 | 50679 | 199427 | Undocumented 2 | Ficus Spp. :: 253 | 1 25th St | 14 | : Yard 23 | Tree 1 | Private 1 | 3 | 6015002.60045 | 2102216.7826799997 | 37.7531298789641 | -122.391002952844 | (37.7531298789641, -122.391002952844) | ||||
| 51964 | 51964 | 192363 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014946.149019999 | 2102349.52066 | 37.753491216648705 | -122.39120745237899 | (37.7534912166487, -122.391207452379) | ||||
| 53317 | 53317 | 189283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015000.28938 | 2102358.87265 | 37.753519899631904 | -122.391020875425 | (37.7535198996319, -122.391020875425) | ||||
| 54292 | 54292 | 192358 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015008.12096 | 2102140.25985 | 37.752920069827 | -122.39097851376499 | (37.752920069827, -122.390978513765) | ||||
| 56490 | 56490 | 196563 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 25th St | 22 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014971.47986 | 2102285.2089 | 37.7533160359259 | -122.391115357305 | (37.7533160359259, -122.391115357305) | ||||
| 56522 | 56522 | 194260 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 24 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014928.75103 | 2102386.78077 | 37.7535925594679 | -122.391270223251 | (37.7535925594679, -122.391270223251) | ||||
| 56524 | 56524 | 191026 | Undocumented 2 | Cussonia spicata :: Cabbage tree 325 | 1 01st St | 36 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014407.16325 | 2105848.78864 | 37.7630695252734 | -122.39331625017 | (37.7630695252734, -122.39331625017) | ||||
| 58003 | 58003 | 189678 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 19 | : Yard 23 | Tree 1 | Private 1 | 15 | 6017295.34569 | 2102596.83049 | 37.7543003681831 | -122.38310055604299 | (37.7543003681831, -122.383100556043) | ||||
| 58033 | 58033 | 189291 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 31 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014386.77773 | 2105894.3895799997 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | ||||
| 59106 | 59106 | 189293 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 35 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014389.3663800005 | 2105866.30731 | 37.7631166389548 | -122.39337903001801 | (37.7631166389548, -122.393379030018) | ||||
| 59596 | 59596 | 199511 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014447.50245 | 2105911.75995 | 37.7632446718137 | -122.393181136026 | (37.7632446718137, -122.393181136026) | ||||
| 60000 | 60000 | 192362 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 20 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | ||||
| 60677 | 60677 | 192360 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 8 | : Yard 23 | Tree 1 | Private 1 | 5 | 6015020.29565 | 2102164.4791599996 | 37.75298724647129 | -122.39093810360399 | (37.7529872464713, -122.390938103604) | ||||
| 61562 | 61562 | 189676 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 11 | : Yard 23 | Tree 1 | Private 1 | 11 | 6017209.44087 | 2102637.39107 | 37.754406991811294 | -122.383400462871 | (37.7544069918113, -122.383400462871) | ||||
| 63043 | 63043 | 209019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000764.3171 | 2095528.5679900001 | 37.7339652640682 | -122.43976216978201 | (37.7339652640682, -122.439762169782) | ||||
| 63729 | 63729 | 190751 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 4 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017101.49687 | 2102687.7625599997 | 37.7545393351402 | -122.38377727163 | (37.7545393351402, -122.38377727163) |
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");