Street_Tree_List

Data source: data.sfgov.org

175 rows where qSiteInfo = 23 sorted by PlotSize

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
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 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)
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 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 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 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 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 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 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 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 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 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)
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)
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 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 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 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 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 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 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)
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 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 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)
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 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)
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 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 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 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 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)
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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)
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)
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)
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)
70813 199550 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 6 : Yard 23 Tree 1 Private 1     15     6014401.0054 2105922.09622 37.7632704697749 -122.393342678542 (37.7632704697749, -122.393342678542)
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)
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)
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)
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)
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)
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)
76142 234859 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 160 Carnelian Way 1 : Yard 23 Tree 1 Private 1     8     6000570.21064 2100519.3738 37.7476577875765 -122.44079113720801 (37.7476577875765, -122.440791137208)
76538 199553 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 9 : Yard 23 Tree 1 Private 1     20     6014424.93308 2105923.01259 37.7632743152759 -122.393259984074 (37.7632743152759, -122.393259984074)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
138227 199545 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 1 : Yard 23 Tree 1 Private 1     12     6014356.43896 2105915.99545 37.7632512422621 -122.39349639336099 (37.7632512422621, -122.393496393361)
139126 199549 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 5 : Yard 23 Tree 1 Private 1     9     6014392.26095 2105920.87265 37.7632666242892 -122.39337283731399 (37.7632666242892, -122.393372837314)
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)
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)
150305 234860 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 160 Carnelian Way 2 : Yard 23 Tree 1 Private 1     6     6000574.359 2100517.55086 37.7476530184698 -122.44077666170799 (37.7476530184698, -122.440776661708)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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 91.136ms · Data source: data.sfgov.org