Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49427 | 49427 | 85218 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989075.71612 | 2111192.27037 | 37.7763013532486 | -122.481319447652 | (37.7763013532486, -122.481319447652) | ||
| 172073 | 172073 | 85219 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 2 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.796080001 | 2111176.31145 | 37.77625759727871 | -122.481314542866 | (37.7762575972787, -122.481314542866) | ||
| 25060 | 25060 | 85220 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 3 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.776221041753296 | -122.48131384215401 | (37.7762210417533, -122.481313842154) | ||
| 42670 | 42670 | 85223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013205.26566 | 2109218.0492700003 | 37.7722539164092 | -122.397709569661 | (37.7722539164092, -122.397709569661) | ||
| 43035 | 43035 | 89163 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 370 03rd St | 2 | : 4 | Tree 1 | Private 1 | 16 | 6013087.00779 | 2113212.8469599998 | 37.783216133267295 | -122.39839898634399 | (37.7832161332673, -122.398398986344) | ||||
| 28493 | 28493 | 92501 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 2 | : 4 | Tree 1 | Private 1 | 24 | 6013077.25048 | 2110692.4491 | 37.7762951549369 | -122.398255852047 | (37.7762951549369, -122.398255852047) | ||||
| 157200 | 157200 | 92502 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 3 | : 4 | Tree 1 | Private 1 | 23 | 6013059.80814 | 2110709.8757599997 | 37.776342032988296 | -122.39831741332199 | (37.7763420329883, -122.398317413322) | ||||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 79586 | 79586 | 94645 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 30 Middle Point Rd | 34 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 113544 | 113544 | 94646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Middle Point Rd | 35 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 8599 | 8599 | 96031 | Permitted Site 1 | Psidium guajava :: Guava tree 252 | 1116 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 20 | Permit Number 767346 | 6007512.843169999 | 2119899.46213 | 37.8012638333238 | -122.418157616905 | (37.8012638333238, -122.418157616905) | ||
| 137822 | 137822 | 103130 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 418 28th Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | 5987189.392469999 | 2113118.1924900003 | 37.781479539688505 | -122.487986220863 | (37.7814795396885, -122.487986220863) | ||||
| 140036 | 140036 | 105148 | Permitted Site 1 | Tree(s) :: 17 | 185 Stratford Dr | : 4 | Tree 1 | Private 1 | 12/26/2013 12:00:00 AM | Permit Number 770387 | 5990916.9 | 2091282.3 | 37.7217406386467 | -122.473497746062 | (37.7217406386467, -122.473497746062) | ||||
| 108522 | 108522 | 113066 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 7 | : 4 | Tree 1 | DPW 2 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 117769 | 117769 | 115188 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 5 | : 4 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
| 148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 177222 | 177222 | 125447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005068.7625400005 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | |||
| 162716 | 162716 | 125448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | |||
| 139878 | 139878 | 125543 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 511 Webster St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | |||
| 147214 | 147214 | 125801 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | |||
| 61886 | 61886 | 125802 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002006.97076 | 2121237.2158 | 37.8046255099126 | -122.43730616445299 | (37.8046255099126, -122.437306164453) | |||
| 159810 | 159810 | 125803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154103999 | (37.8046010303654, -122.43730154104) | |||
| 51174 | 51174 | 125804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002009.77145 | 2121217.59748 | 37.804571802419 | -122.43729506680799 | (37.804571802419, -122.437295066808) | |||
| 58530 | 58530 | 125936 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 3640 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 6ft | 6002183.33436 | 2120790.5318400003 | 37.803409058151104 | -122.43666384886801 | (37.8034090581511, -122.436663848868) | |||
| 62032 | 62032 | 125937 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 3640 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 6ft | 6002179.26509 | 2120811.82356 | 37.8034672883377 | -122.43667945570401 | (37.8034672883377, -122.436679455704) | |||
| 35739 | 35739 | 126050 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2743 Baker St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 5999540.91098 | 2118277.28381 | 37.7963578318958 | -122.44562718666799 | (37.7963578318958, -122.445627186668) | |||
| 73817 | 73817 | 126076 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5999384.46531 | 2119405.9114599996 | 37.799447808926395 | -122.446249747728 | (37.7994478089264, -122.446249747728) | |||
| 76540 | 76540 | 126077 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999388.2562 | 2119380.27509 | 37.7993776348198 | -122.44623478482299 | (37.7993776348198, -122.446234784823) | |||
| 148847 | 148847 | 126085 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.56752 | 2121160.52429 | 37.8043072893028 | -122.443842552202 | (37.8043072893028, -122.443842552202) | |||
| 130235 | 130235 | 126086 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.67456 | 2121159.0969700003 | 37.8043033763715 | -122.443842079173 | (37.8043033763715, -122.443842079173) | |||
| 151133 | 151133 | 126087 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000117.09871 | 2121156.78395 | 37.804297049633895 | -122.443840445091 | (37.8042970496339, -122.443840445091) | |||
| 162732 | 162732 | 126095 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002627.04146 | 2121100.74155 | 37.8042860176436 | -122.435150585742 | (37.8042860176436, -122.435150585742) | |||
| 62525 | 62525 | 126096 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002623.69745 | 2121110.92365 | 37.8043137851175 | -122.43516288665899 | (37.8043137851175, -122.435162886659) | |||
| 176293 | 176293 | 126098 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002372.64115 | 2121214.12462 | 37.8045828883414 | -122.436039075449 | (37.8045828883414, -122.436039075449) | |||
| 188530 | 188530 | 126099 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6002384.275669999 | 2121216.1923599998 | 37.8045892267643 | -122.435998961207 | (37.8045892267643, -122.435998961207) | |||
| 47905 | 47905 | 126466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1454 Jefferson St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002229.507119999 | 2121606.26883 | 37.80565147990821 | -122.43656248897499 | (37.8056514799082, -122.436562488975) | |||
| 179927 | 179927 | 126580 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 641 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6004785.6384 | 2110864.8252 | 37.7763031076359 | -122.42695112400101 | (37.7763031076359, -122.426951124001) | |||
| 135535 | 135535 | 126618 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3301 Van Ness Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6005157.457169999 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | |||
| 62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
| 64318 | 64318 | 126640 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 619 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004870.87553 | 2110876.4929299997 | 37.776339963657996 | -122.42665709607401 | (37.776339963658, -122.426657096074) | |||
| 178435 | 178435 | 127063 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001387.77011 | 2119526.14518 | 37.799892144171096 | -122.43932624052601 | (37.7998921441711, -122.439326240526) | |||
| 56968 | 56968 | 127064 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6001385.25853 | 2119550.33485 | 37.799958419693105 | -122.43933666636299 | (37.7999584196931, -122.439336666363) | |||
| 54954 | 54954 | 127069 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 9 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6001380.49031 | 2119587.4899 | 37.800060166303396 | -122.439355830906 | (37.8000601663034, -122.439355830906) | |||
| 174125 | 174125 | 127070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 10 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6001375.8548 | 2119619.21037 | 37.8001469985396 | -122.43937414650499 | (37.8001469985396, -122.439374146505) | |||
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 160847 | 160847 | 129100 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.42803626308701 | (37.7764530246232, -122.428036263087) | |||
| 163454 | 163454 | 129101 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | |||
| 183146 | 183146 | 129102 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | |||
| 186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
| 59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
| 135341 | 135341 | 129188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5999731.06738 | 2120400.48948 | 37.80219844206879 | -122.44512192772899 | (37.8021984420688, -122.445121927729) | |||
| 151827 | 151827 | 129189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.44214075790701 | (37.8043326933704, -122.442140757907) | |||
| 59064 | 59064 | 129190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6000610.9168300005 | 2121141.44631 | 37.8042830912635 | -122.44213045078699 | (37.8042830912635, -122.442130450787) | |||
| 37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
| 45702 | 45702 | 129197 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6001606.6144900005 | 2120894.2374 | 37.8036610149183 | -122.43866704197501 | (37.8036610149183, -122.438667041975) | |||
| 164147 | 164147 | 129198 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3537 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002132.11244 | 2120360.66499 | 37.8022258462139 | -122.436810313348 | (37.8022258462139, -122.436810313348) | |||
| 65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
| 176649 | 176649 | 129200 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6002139.18705 | 2121127.02263 | 37.8043304639385 | -122.436840724815 | (37.8043304639385, -122.436840724815) | |||
| 59790 | 59790 | 129202 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1425 Jefferson St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6002378.47119 | 2121561.31201 | 37.8055365042628 | -122.436043759126 | (37.8055365042628, -122.436043759126) | |||
| 34884 | 34884 | 129516 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000442.909 | 2118797.59081 | 37.797837912738295 | -122.44254346802 | (37.7978379127383, -122.44254346802) | |||
| 161949 | 161949 | 129517 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000445.055869999 | 2118784.6129 | 37.7978024012088 | -122.442535107006 | (37.7978024012088, -122.442535107006) | |||
| 165862 | 165862 | 129518 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.797767715271796 | -122.44253092607 | (37.7977677152718, -122.44253092607) | |||
| 47655 | 47655 | 129519 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.25144 | 2118762.17983 | 37.79774087408789 | -122.442529358545 | (37.7977408740879, -122.442529358545) | |||
| 160826 | 160826 | 129520 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6000447.31564 | 2118755.2398900003 | 37.7977218795107 | -122.442525177605 | (37.7977218795107, -122.442525177605) | |||
| 154077 | 154077 | 129903 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 629 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6004507.997690001 | 2110701.28424 | 37.7758383613946 | -122.427899904274 | (37.7758383613946, -122.427899904274) | |||
| 136963 | 136963 | 129904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 629 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004505.63522 | 2110719.21091 | 37.7758874499876 | -122.42790935434799 | (37.7758874499876, -122.427909354348) | |||
| 136272 | 136272 | 129905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 639 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6004490.10271 | 2110798.8146 | 37.77610514348439 | -122.42796875907301 | (37.7761051434844, -122.427968759073) | |||
| 28758 | 28758 | 129906 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 536 Fell St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6004841.59685 | 2110577.9768 | 37.7755186559901 | -122.426737115928 | (37.7755186559901, -122.426737115928) | |||
| 185111 | 185111 | 131064 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1877 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.79954355884429 | -122.430529985984 | (37.7995435588443, -122.430529985984) | |||
| 179485 | 179485 | 131091 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6004549.167669999 | 2120777.63137 | 37.8035078001114 | -122.428475867867 | (37.8035078001114, -122.428475867867) | |||
| 173357 | 173357 | 131092 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004551.929269999 | 2120763.26288 | 37.803468504236605 | -122.42846528646601 | (37.8034685042366, -122.428465286466) | |||
| 49854 | 49854 | 132449 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1341 Bay St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6004363.25375 | 2120796.06015 | 37.803547878401496 | -122.429120545984 | (37.8035478784015, -122.429120545984) | |||
| 60248 | 60248 | 132692 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6004034.33386 | 2110586.13369 | 37.7754953788337 | -122.42953021415701 | (37.7754953788337, -122.429530214157) | |||
| 133462 | 133462 | 132693 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004037.31415 | 2110564.45743 | 37.775436029895396 | -122.429518358411 | (37.7754360298954, -122.429518358411) | |||
| 185552 | 185552 | 132694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004042.51589 | 2110539.7014200003 | 37.775368350495 | -122.42949859848801 | (37.775368350495, -122.429498598488) | |||
| 187655 | 187655 | 132695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004047.336680001 | 2110514.9536 | 37.775300672009394 | -122.42948015697901 | (37.7753006720094, -122.429480156979) | |||
| 165604 | 165604 | 132696 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6004050.64298 | 2110490.61597 | 37.775234034053895 | -122.429466983726 | (37.7752340340539, -122.429466983726) | |||
| 156378 | 156378 | 132713 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3055 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 1ft | 6000438.0294 | 2118824.18177 | 37.797910646325896 | -122.442562262934 | (37.7979106463259, -122.442562262934) | |||
| 26744 | 26744 | 132714 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3055 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 1ft | 6000441.38415 | 2118807.53005 | 37.797865116340105 | -122.4425494584 | (37.7978651163401, -122.4425494584) | |||
| 153622 | 153622 | 132757 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3601 Laguna St | 10 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6003537.25934 | 2121091.9719700003 | 37.8043135827752 | -122.432000078959 | (37.8043135827752, -122.432000078959) | |||
| 175863 | 175863 | 132765 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3700 Buchanan St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6003091.99833 | 2121255.71658 | 37.804737929664505 | -122.433552648755 | (37.8047379296645, -122.433552648755) | |||
| 35577 | 35577 | 132766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3700 Buchanan St | 10 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003086.27955 | 2121288.8809599997 | 37.804828665860704 | -122.433574810742 | (37.8048286658607, -122.433574810742) | |||
| 171797 | 171797 | 133602 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004721.40466 | 2110909.40027 | 37.776421867615106 | -122.42717650218701 | (37.7764218676151, -122.427176502187) | |||
| 55191 | 55191 | 133603 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 662 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004673.73333 | 2110903.67068 | 37.776403439601395 | -122.427341002593 | (37.7764034396014, -122.427341002593) | |||
| 41040 | 41040 | 133604 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 680 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004598.25031 | 2110892.9208299997 | 37.776369653876 | -122.42760135363599 | (37.776369653876, -122.427601353636) | |||
| 123746 | 123746 | 135581 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 22 Drumm St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 7ft | 6013732.77285 | 2117082.9490900002 | 37.7938784864461 | -122.39643624024099 | (37.7938784864461, -122.396436240241) | |||
| 25791 | 25791 | 135673 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 3639 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002560.08245 | 2121134.92796 | 37.8043760820531 | -122.435384749408 | (37.8043760820531, -122.435384749408) | |||
| 62751 | 62751 | 136028 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 701 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6004477.21749 | 2110912.17552 | 37.7764156757853 | -122.428021412563 | (37.7764156757853, -122.428021412563) | |||
| 186749 | 186749 | 136029 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 3743 Scott St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000599.31455 | 2121234.7075799997 | 37.804538500507995 | -122.44217730004101 | (37.804538500508, -122.442177300041) | |||
| 148444 | 148444 | 136275 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 699 Webster St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6003966.4578 | 2111069.2225599997 | 37.7768179785099 | -122.429799478365 | (37.7768179785099, -122.429799478365) | |||
| 180320 | 180320 | 136367 | Undocumented 2 | Schinus molle :: California Pepper 138 | 689 Hayes St | 5 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6004762.56149 | 2110859.02755 | 37.7762858838177 | -122.427030540428 | (37.7762858838177, -122.427030540428) | |||
| 60287 | 60287 | 136528 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3271 Baker St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 5999283.78896 | 2120122.72812 | 37.8014102447475 | -122.44664972480601 | (37.8014102447475, -122.446649724806) | |||
| 49744 | 49744 | 136530 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3719 Scott St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6000612.037330001 | 2121116.27495 | 37.804214041307795 | -122.442124765264 | (37.8042140413078, -122.442124765264) | |||
| 48018 | 48018 | 136642 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3035 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6000450.1684 | 2118732.62208 | 37.797659939602106 | -122.442513681577 | (37.7976599396021, -122.442513681577) | |||
| 95681 | 95681 | 136647 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1490 Jefferson St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002197.32767 | 2121601.5200400003 | 37.805636612315105 | -122.436673510277 | (37.8056366123151, -122.436673510277) | |||
| 37484 | 37484 | 136656 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1425 Jefferson St | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6002391.3756099995 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | |||
| 54943 | 54943 | 136661 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1307 Bay St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6004511.51487 | 2120814.19666 | 37.8036060681264 | -122.42860877508801 | (37.8036060681264, -122.428608775088) |
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");