Street_Tree_List

Data source: data.sfgov.org

175 rows where qSiteInfo = 23 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, qAddress, qCaretaker, DBH, PlotSize

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
108835 113062 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2X Cranleigh Dr 3 : Yard 23 Tree 1 DPW 2   08/18/2016 09:59:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
119367 113063 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2X Cranleigh Dr 4 : Yard 23 Tree 1 DPW 2   08/18/2016 09:56:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
122547 176099 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 491 La Grande Ave 1 : Yard 23 Tree 1 Private 1     43     6004400.9540099995 2089156.27858 37.716674693347 -122.42673555649999 (37.716674693347, -122.4267355565)
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)
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)
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)
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)
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)
123420 178181 Undocumented 2 Pinus radiata :: Monterey Pine 3 491 La Grande Ave 5 : Yard 23 Tree 1 Private 1     23     6004429.890380001 2089255.59598 37.7169490333536 -122.42664260617501 (37.7169490333536, -122.426642606175)
136962 188006 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1310 Indiana St 5 : Yard 23 Tree 1 Private 1     3     6014970.94657 2102528.93122 37.7539852160557 -122.39113423586399 (37.7539852160557, -122.391134235864)
150778 188007 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1310 Indiana St 2 : Yard 23 Tree 1 Private 1     9     6015000.133780001 2102555.57956 37.7540600063901 -122.391035161147 (37.7540600063901, -122.391035161147)
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)
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)
98922 188568 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 24th St 24 : Yard 23 Tree 1 Private 1     38     6017120.705080001 2102612.3766799998 37.7543334029878 -122.38370559563499 (37.7543334029878, -122.383705595635)
73756 188569 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 24th St 26 : Yard 23 Tree 1 Private 1     5     6017110.36972 2102585.1726599997 37.754258135118796 -122.383739444343 (37.7542581351188, -122.383739444343)
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)
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)
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)
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)
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)
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)
137382 189292 Undocumented 2 Cordyline australis :: Dracena Palm 141 1 01st St 33 : Yard 23 Tree 1 Private 1     5     6014376.229280001 2105886.6133 37.763171664875294 -122.393425888311 (37.7631716648753, -122.393425888311)
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)
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)
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)
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)
137284 189677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 14 : Yard 23 Tree 1 Private 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
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)
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)
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)
73004 190635 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 28 : Yard 23 Tree 1 Private 1     9     6014407.37845 2105898.42582 37.7632058300952 -122.393318979581 (37.7632058300952, -122.393318979581)
70245 190636 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 30 : Yard 23 Tree 1 Private 1     8     6014391.99798 2105898.86804 37.763206189822796 -122.393372206868 (37.7632061898228, -122.393372206868)
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)
150675 190752 Undocumented 2 Juglans regia :: Walnut: English 348 1 24th St 5 : Yard 23 Tree 1 Private 1     9     6017117.58441 2102700.05767 37.7545739842169 -122.383722492107 (37.7545739842169, -122.383722492107)
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)
130707 190965 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 24th St 17 : Yard 23 Tree 1 Private 1     6     6017293.94065 2102634.4333599997 37.754403540203796 -122.38310803210899 (37.7544035402038, -122.383108032109)
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)
137271 191088 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1 01st St 19 : Yard 23 Tree 1 Private 1     18     6014455.34951 2105889.6924799997 37.7631845152826 -122.393152451232 (37.7631845152826, -122.393152451232)
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)
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)
115484 191739 Undocumented 2 Eucalyptus gunnii :: Cider Gum 337 1 24th St 13 : Yard 23 Tree 1 Private 1     30     6017219.14558 2102678.7213 37.754521012359206 -122.383369778001 (37.7545210123592, -122.383369778001)
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)
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)
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)
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)
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)
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)
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)
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)
74435 192364 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 23 : Yard 23 Tree 1 Private 1     8     6014928.1243 2102399.042 37.7536261914184 -122.391273247671 (37.7536261914184, -122.391273247671)
70325 192365 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 21 : Yard 23 Tree 1 Private 1     8     6014917.078430001 2102437.6688900003 37.7537316396243 -122.391314147037 (37.7537316396243, -122.391314147037)
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)
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)
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)
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)
148293 192370 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 9 : Yard 23 Tree 1 Private 1     8     6015014.73228 2102443.11605 37.7537520155509 -122.390976815833 (37.7537520155509, -122.390976815833)
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)
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)
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)
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)
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)
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)
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)
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)
75041 194131 Undocumented 2 Olea europaea :: Olive Tree 41 1310 Indiana St 4 : Yard 23 Tree 1 Private 1     37     6014985.85621 2102536.5970099997 37.754007092062004 -122.391083210127 (37.754007092062, -122.391083210127)
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)
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)
134605 194275 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1 01st St 34 : Yard 23 Tree 1 Private 1     8     6014376.659969999 2105881.88915 37.76315871732 -122.39342406806101 (37.76315871732, -122.393424068061)
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)
75684 194428 Undocumented 2 Pinus contorta :: Shore Pine 423 1310 Indiana St 13 : Yard 23 Tree 1 Private 1     1     6014998.917640001 2102376.22038 37.7535674566975 -122.391026831646 (37.7535674566975, -122.391026831646)
66429 194526 Undocumented 2 Pistacia chinensis :: Chinese Pistache 150 1 25th St 15 : Yard 23 Tree 1 Private 1     5     6014989.61274 2102184.78595 37.7530413020381 -122.39104563107401 (37.7530413020381, -122.391045631074)
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)
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)
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)
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)
147367 194594 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1 01st St 22 : Yard 23 Tree 1 Private 1     10     6014433.28496 2105898.16367 37.7632065495547 -122.393229358544 (37.7632065495547, -122.393229358544)
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)
74692 196073 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 5 : Yard 23 Tree 1 Private 1     9     6014983.580569999 2102134.9117099997 37.752904023218605 -122.391063005979 (37.7529040232186, -122.391063005979)
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)
130498 196075 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 17 : Yard 23 Tree 1 Private 1     6     6014963.469190001 2102214.24517 37.753120740043705 -122.391138100256 (37.7531207400437, -122.391138100256)
133863 196076 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 18 : Yard 23 Tree 1 Private 1     6     6014971.87416 2102223.03647 37.753145345506795 -122.39110964840401 (37.7531453455068, -122.391109648404)
151585 196077 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 19 : Yard 23 Tree 1 Private 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
132015 196092 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 24 : Yard 23 Tree 1 Private 1     10     6014425.82588 2105887.0502299997 37.7631756200823 -122.393254379501 (37.7631756200823, -122.393254379501)
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)
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)
132022 196279 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 6 : Yard 23 Tree 1 Private 1     5     6014984.46572 2102135.07494 37.7529045205317 -122.39105995634701 (37.7529045205317, -122.391059956347)
66873 196280 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 11 : Yard 23 Tree 1 Private 1     12     6015022.69172 2102195.1938 37.7530717153135 -122.39093196394501 (37.7530717153135, -122.390931963945)
130300 196281 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 12 : Yard 23 Tree 1 Private 1     12     6015018.372359999 2102200.19302 37.7530852024401 -122.39094725063102 (37.7530852024401, -122.390947250631)
137606 196282 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 13 : Yard 23 Tree 1 Private 1     12     6015015.25562 2102205.64875 37.75310000977571 -122.39095841029499 (37.7531000097757, -122.390958410295)
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)
134718 196565 Undocumented 2 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 1 24th St 22 : Yard 23 Tree 1 Private 1     9     6017179.65065 2102592.91539 37.7542832244069 -122.38350039013599 (37.7542832244069, -122.383500390136)
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)
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)
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)
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)
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)
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)
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)
134619 199515 Undocumented 2 Yucca elephantipes :: Giant Yucca 211 1 01st St 11 : Yard 23 Tree 1 Private 1     3     6014438.12631 2105919.24405 37.7632647006382 -122.393214088968 (37.7632647006382, -122.393214088968)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 70.179ms · Data source: data.sfgov.org