Data source: data.sfgov.org
This data as json, CSV (advanced)
PlotSize ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
70403 | 70403 | 233232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 5 | : Yard 23 | Tree 1 | Private 1 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | |||
132015 | 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) | ||||
147367 | 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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
66873 | 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 | 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 | 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 | 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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
69201 | 69201 | 234493 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3278 Market St | 1 | : Yard 23 | Tree 1 | Private 1 | 14 | Width 3ft | 5999564.06934 | 2104457.47233 | 37.758413493117104 | -122.444553299888 | (37.7584134931171, -122.444553299888) | |||
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) | ||||
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) | ||||
70813 | 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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
74715 | 74715 | 234488 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4090 20th St | 7 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003119.17834 | 2104176.3954 | 37.7578439389691 | -122.43223808994101 | (37.7578439389691, -122.432238089941) | |||
75344 | 75344 | 233331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4404 20th St | 10 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003656.39078 | 2104225.45781 | 37.7580090976571 | -122.430383686085 | (37.7580090976571, -122.430383686085) | |||
132798 | 132798 | 245706 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003635.70774 | 2104190.5874799998 | 37.7579121804175 | -122.430452728819 | (37.7579121804175, -122.430452728819) | |||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
137271 | 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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
76538 | 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) | ||||
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) | ||||
146754 | 146754 | 240351 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4090 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | |||
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) | |||
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) | |||
123420 | 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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
129806 | 129806 | 234413 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 280 Justin Dr | 1 | : Yard 23 | Tree 1 | Private 1 | 26 | Width 3ft | 6005966.47626 | 2094899.24737 | 37.7325320253145 | -122.42173199844 | (37.7325320253145, -122.42173199844) | |||
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) | ||||
115484 | 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) | ||||
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) | |||
75041 | 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) | ||||
98922 | 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) | ||||
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) | ||||
122547 | 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) | ||||
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) |
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");