Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189121 189121 214450 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 45 Dorantes Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994111.5037 2100039.81972 37.7459711108718 -122.463090021601 (37.7459711108718, -122.463090021601)
189117 189117 206706 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1479 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991135.602940001 2105348.51695 37.760375526938205 -122.473767390769 (37.7603755269382, -122.473767390769)
189097 189097 205746 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 33 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993900.499 2101145.1165299998 37.748993818619795 -122.46389985751999 (37.7489938186198, -122.46389985752)
189081 189081 205253 Undocumented 2 Cordyline australis :: Dracena Palm 141 1976 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991298.99836 2101963.32187 37.7510901338258 -122.47295542976299 (37.7510901338258, -122.472955429763)
189078 189078 187940 Undocumented 2 Acer rubrum :: Red Maple 6 300 Main St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6015048.62855 2115342.19505 37.7891719160015 -122.39176144464899 (37.7891719160015, -122.391761444649)
189064 189064 185387 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2300 Sunset Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 0ft   5985052.012999999 2099287.3331 37.743378953957794 -122.494360600593 (37.7433789539578, -122.494360600593)
189062 189062 250894 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 250 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986839.6011 2114252.83409 37.784574529539796 -122.489279763454 (37.7845745295398, -122.489279763454)
189055 189055 250836 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 283 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986490.348619999 2114051.42085 37.7840011137113 -122.49047321958 (37.7840011137113, -122.49047321958)
189054 189054 233323 Undocumented 2 Pinus radiata :: Monterey Pine 3 51 Prentiss St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6008877.2756900005 2098293.43084 37.7420154302758 -122.41190839527201 (37.7420154302758, -122.411908395272)
189051 189051 118424 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 5421 Anza St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5981802.00316 2111639.4369 37.7771035681701 -122.50651396642 (37.7771035681701, -122.50651396642)
189046 189046 118637 Undocumented 2 Ilex spp :: Holly Species 163 489 45th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5981892.63195 2112480.11557 37.779417159851604 -122.506262811826 (37.7794171598516, -122.506262811826)
189034 189034 122230 Undocumented 2 Prunus spp :: Cherry 84 700 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5991662.29598 2110580.8797299997 37.774772683199394 -122.472327258665 (37.7747726831994, -122.472327258665)
189030 189030 128980 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 199 McAllister St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   6008492.62721 2112417.9062099997 37.7807764092316 -122.414237490093 (37.7807764092316, -122.414237490093)
189029 189029 140863 Undocumented 2 :: 54 106 JORDAN AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5996246.41 2113718.2127 37.7836512118011 -122.45669690496901 (37.7836512118011, -122.456696904969)
189021 189021 182962 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2050 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5989686.5492 2098375.4265 37.741145229321496 -122.47826907299999 (37.7411452293215, -122.478269073)
189016 189016 182660 Undocumented 2 :: 54 1890 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986007.8679 2102386.3122 37.75194380463171 -122.49128357776199 (37.7519438046317, -122.491283577762)
189015 189015 132607 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 300 Laurel St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5998069.1356 2115417.33363 37.7884210360372 -122.450513532469 (37.7884210360372, -122.450513532469)
189012 189012 126364 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 1100 Filbert St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6007584.0296 2119571.97409 37.8003686400458 -122.41788805230699 (37.8003686400458, -122.417888052307)
188974 188974 250864 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 170 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986515.92946 2114612.51535 37.7855432117965 -122.49042601236 (37.7855432117965, -122.49042601236)
188965 188965 182974 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2501 19th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5990445.6911 2097993.6128 37.7401409062913 -122.475616387366 (37.7401409062913, -122.475616387366)
188962 188962 182197 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1584 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 0ft   5985008.2078 2104414.5267 37.7574542590905 -122.494890024235 (37.7574542590905, -122.494890024235)
188959 188959 217849 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Woodacre Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33     5991387.06493 2095679.62189 37.7338418033391 -122.47219289908001 (37.7338418033391, -122.47219289908)
188944 188944 184944 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983563.2069 2101275.9659 37.748751952115505 -122.49965537495702 (37.7487519521155, -122.499655374957)
188930 188930 250562 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 445 El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5987191.81534 2115294.08526 37.7874540598079 -122.488137777348 (37.7874540598079, -122.488137777348)
188929 188929 203816 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1625 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5993083.51125 2095334.29452 37.7329916508262 -122.466302734486 (37.7329916508262, -122.466302734486)
188924 188924 218143 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 72 Ridge Ln 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5997148.20318 2090029.45832 37.718659516001 -122.451867536453 (37.718659516001, -122.451867536453)
188911 188911 203784 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2050 09th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5993499.63978 2101506.86367 37.7499639748735 -122.465312293131 (37.7499639748735, -122.465312293131)
188900 188900 250817 Undocumented 2 Maytenus boaria :: Mayten 22 45 Sea View Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986236.9897 2114116.07021 37.7841638208535 -122.491354496716 (37.7841638208535, -122.491354496716)
188898 188898 131794 Undocumented 2 Olea europaea :: Olive Tree 41 3456 Baker St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5999255.89477 2120717.3179 37.8030412345399 -122.446789058571 (37.8030412345399, -122.446789058571)
188884 188884 186847 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2700 Sunset Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 0ft   5985140.3975 2096462.5634 37.73562806681571 -122.493846870805 (37.7356280668157, -122.493846870805)
188874 188874 175294 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 760 Mansell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6009619.4023 2090150.4820700001 37.7196982320664 -122.408767998643 (37.7196982320664, -122.408767998643)
188855 188855 240220 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 116 Crescent Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 10ft   6006143.46511 2095809.04412 37.735040105008004 -122.421184684532 (37.735040105008, -122.421184684532)
188849 188849 247498 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 348 Scott St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   6002258.2648 2109741.2734 37.7730748820821 -122.43561359709 (37.7730748820821, -122.43561359709)
188846 188846 208565 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1839 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993732.590419999 2102966.8371900003 37.7539861198715 -122.46461274467899 (37.7539861198715, -122.464612744679)
188837 188837 211917 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 175 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993542.1892099995 2096437.97139 37.7360485283247 -122.464797098516 (37.7360485283247, -122.464797098516)
188815 188815 228381 Undocumented 2 Grevillea robusta :: Silk Oak Tree 145 1102 York St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 7ft   6009986.01041 2102705.0422400003 37.754190885624794 -122.408385829946 (37.7541908856248, -122.408385829946)
188804 188804 212067 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 61 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 6ft   5994377.39833 2097689.28912 37.7395324551634 -122.46200017816601 (37.7395324551634, -122.462000178166)
188796 188796 179936 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 549 Lisbon St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6001958.43764 2090299.0614099998 37.7196741221424 -122.435259802998 (37.7196741221424, -122.435259802998)
188792 188792 201569 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 600 Donahue St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   6020624.73776 2092976.30056 37.728067680971606 -122.370921308297 (37.7280676809716, -122.370921308297)
188785 188785 208967 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993630.4889400005 2097044.9006700001 37.737720095508706 -122.46453586883001 (37.7377200955087, -122.46453586883)
188784 188784 184377 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Rivera St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5988408.1936 2100317.5308 37.7464034445307 -122.48283140934299 (37.7464034445307, -122.482831409343)
188770 188770 215509 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 265 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994040.687530001 2096338.7929099998 37.7358049370452 -122.46306640808201 (37.7358049370452, -122.463066408082)
188760 188760 218430 Undocumented 2 Maytenus boaria :: Mayten 22 81 Lopez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993974.36108 2100474.97529 37.7471580370095 -122.463595814708 (37.7471580370095, -122.463595814708)
188742 188742 246420 Undocumented 2 Ceratonia siliqua :: Carob 97 400 Duncan St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.42939827552401 (37.7460188154337, -122.429398275524)
188721 188721 119033 Undocumented 2 Prunus blireiana :: Flowering Plum 102 745 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5982267.74264 2110681.1609400003 37.7744998336605 -122.50483182972499 (37.7744998336605, -122.504831829725)
188717 188717 226559 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Dolores St 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   6004935.37263 2104529.68791 37.758916806783795 -122.425982076637 (37.7589168067838, -122.425982076637)
188710 188710 125209 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2008 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6004952.53327 2116801.7834099997 37.7926139551121 -122.426796690615 (37.7926139551121, -122.426796690615)
188705 188705 186849 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2700 Sunset Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985134.8973 2096609.0061 37.7360298376031 -122.493876675464 (37.7360298376031, -122.493876675464)
188685 188685 207791 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 255 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5993127.95212 2096331.51719 37.7357323401679 -122.466221537416 (37.7357323401679, -122.466221537416)
188670 188670 194430 Undocumented 2 Pinus coulteri :: Coulter pine 435 800 Vermont St 44 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 5ft   6011313.02989 2104102.06211 37.7581010164682 -122.403894943896 (37.7581010164682, -122.403894943896)
188649 188649 123336 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 723 04th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994711.02171 2110605.04952 37.7750150216931 -122.461782919201 (37.7750150216931, -122.461782919201)
188630 188630 196518 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014492.91389 2101810.6998099997 37.7519865663454 -122.39273715780399 (37.7519865663454, -122.392737157804)
188629 188629 208416 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 41 San Monica Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993629.2663199995 2097570.14805 37.7391622231523 -122.46457822422701 (37.7391622231523, -122.464578224227)
188621 188621 194462 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2000 25th St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     6012536.20636 2101883.40971 37.7520773412124 -122.399508883748 (37.7520773412124, -122.399508883748)
188619 188619 211936 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 55 Marcela Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5994719.6585800005 2100681.91633 37.7477691605281 -122.461033650677 (37.7477691605281, -122.461033650677)
188618 188618 120450 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 5 West Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5988889.9604 2114983.8966900003 37.786701292081 -122.482239876772 (37.786701292081, -122.482239876772)
188552 188552 211046 Undocumented 2 Pinus Spp :: Pine Spp 105 251 Wildwood Way 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 3ft   5995705.57302 2093291.07499 37.727532405390896 -122.457089894179 (37.7275324053909, -122.457089894179)
188544 188544 212503 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993861.6339300005 2101357.5005200002 37.7495747312094 -122.464049667463 (37.7495747312094, -122.464049667463)
188521 188521 250295 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   6008359.254290001 2112041.46764 37.7797353063774 -122.41467224575199 (37.7797353063774, -122.414672245752)
188512 188512 201577 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   6020588.137 2092854.48102 37.727731178034894 -122.37103941895799 (37.7277311780349, -122.371039418958)
188509 188509 132606 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 301 Laurel St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   5998067.828869999 2115435.37525 37.7884704987534 -122.450519354702 (37.7884704987534, -122.450519354702)
188474 188474 218968 Undocumented 2 Fraxinus spp :: Ash Spp 83 150 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993617.45125 2101661.58733 37.7503955999976 -122.464916133678 (37.7503955999976, -122.464916133678)
188462 188462 135018 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6012602.08363 2120098.20385 37.802094667483004 -122.400560466418 (37.802094667483, -122.400560466418)
188455 188455 218334 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 2 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 0ft   5993385.371119999 2099847.32805 37.745400722182296 -122.46558688764699 (37.7454007221823, -122.465586887647)
188447 188447 218307 Undocumented 2 Maytenus boaria :: Mayten 22 465 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5992940.20866 2099905.7467 37.7455354388055 -122.46713042103998 (37.7455354388055, -122.46713042104)
188436 188436 207812 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 635 Hearst Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5997216.39115 2094387.61086 37.7306298809467 -122.451946087746 (37.7306298809467, -122.451946087746)
188435 188435 186529 Undocumented 2 :: 54 1500 37th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984686.823 2104775.4574 37.7584264560006 -122.496028111274 (37.7584264560006, -122.496028111274)
188425 188425 130511 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 3870 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5996298.86533 2115600.22493 37.7888217253879 -122.456651580816 (37.7888217253879, -122.456651580816)
188369 188369 211679 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 118 Ashton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994177.1078 2090720.2532400002 37.7203856540458 -122.462187404445 (37.7203856540458, -122.462187404445)
188366 188366 184365 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2246 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5981748.9474 2099793.4739 37.7445748198756 -122.505819075039 (37.7445748198756, -122.505819075039)
188355 188355 199591 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 2250 26th St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6011839.26664 2101391.56211 37.7506879632992 -122.401884448303 (37.7506879632992, -122.401884448303)
188352 188352 188681 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     6018210.72448 2096306.49238 37.7370789094531 -122.379497963675 (37.7370789094531, -122.379497963675)
188349 188349 182371 Undocumented 2 Cordyline australis :: Dracena Palm 141 1510 33rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5985921.5907 2104932.1472 37.7589289271259 -122.491769330525 (37.7589289271259, -122.491769330525)
188345 188345 228521 Undocumented 2 Ilex aquifolium :: European Holly 277 310 Liberty St 55 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6003807.77119 2103922.75586 37.757186523762 -122.429838557529 (37.757186523762, -122.429838557529)
188344 188344 183795 Undocumented 2 :: 54 2290 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985480.5542 2099650.3252 37.744400702172605 -122.492905567796 (37.7444007021726, -122.492905567796)
188334 188334 188246 Undocumented 2 Azara microphylla :: Little-Leaf Azara 295 1634 Jerrold Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6015049.72094 2097263.61753 37.739532135895296 -122.39049392936899 (37.7395321358953, -122.390493929369)
188332 188332 143031 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6010830.5748 2120664.6828 37.8035511239121 -122.406730709589 (37.8035511239121, -122.406730709589)
188331 188331 232208 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 6 Park Hill Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6001153.48827 2107682.20045 37.7673583696159 -122.439287533699 (37.7673583696159, -122.439287533699)
188319 188319 220213 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 483 Valley St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6002841.26892 2099164.12546 37.744065668695995 -122.43284115011801 (37.744065668696, -122.432841150118)
188296 188296 182616 Undocumented 2 :: 54 1856 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987553.0951 2102630.1854 37.7527035840583 -122.485957928463 (37.7527035840583, -122.485957928463)
188251 188251 211079 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2319 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 3ft   5992294.50858 2099658.84702 37.7448202223807 -122.469345163475 (37.7448202223807, -122.469345163475)
188246 188246 249930 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 345 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 0ft   6011183.60917 2120017.47195 37.8017937876064 -122.40546340291999 (37.8017937876064, -122.40546340292)
188229 188229 122233 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 664 14th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 3ft   5991642.185219999 2110940.40215 37.7757586700444 -122.47242304061399 (37.7757586700444, -122.472423040614)
188211 188211 182131 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2600 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   5987946.7845 2098317.4825 37.740884983303204 -122.484280230772 (37.7408849833032, -122.484280230772)
188195 188195 183817 Undocumented 2 :: 54 2133 Rivera St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986490.2175 2100252.0265 37.74611180538629 -122.48945864467301 (37.7461118053863, -122.489458644673)
188184 188184 208970 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 20 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 6ft   5993484.40904 2097144.7715200002 37.7379858937365 -122.46504818472499 (37.7379858937365, -122.465048184725)
188169 188169 202581 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 625 King St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6012003.845430001 2108517.57719 37.7702636034108 -122.40181616639099 (37.7702636034108, -122.401816166391)
188156 188156 250298 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008400.93583 2112028.98514 37.7797033741539 -122.414527167109 (37.7797033741539, -122.414527167109)
188145 188145 213572 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995340.05175 2100264.05702 37.7466575040536 -122.45885812859801 (37.7466575040536, -122.458858128598)
188133 188133 183803 Undocumented 2 :: 54 2222 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986396.7617 2100091.5728 37.7456657864188 -122.489770000258 (37.7456657864188, -122.489770000258)
188120 188120 205124 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1253 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5994307.62301 2097874.46117 37.740036874108704 -122.462254855373 (37.7400368741087, -122.462254855373)
188118 188118 212997 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1627 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993679.49927 2104412.68352 37.757952979968294 -122.464901340744 (37.7579529799683, -122.464901340744)
188117 188117 247634 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 351 Bradford St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6009494.55377 2096596.6066 37.7373909310424 -122.409654297605 (37.7373909310424, -122.409654297605)
188074 188074 211219 Undocumented 2 Pinus radiata :: Monterey Pine 3 440 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 3ft   5994968.20619 2100269.78375 37.7466518473211 -122.460144338116 (37.7466518473211, -122.460144338116)
188062 188062 240266 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 517 Powhattan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6008451.38564 2098131.73505 37.741547546287705 -122.413369559781 (37.7415475462877, -122.413369559781)
188058 188058 206537 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 401 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994067.3294 2101503.80633 37.7499883024325 -122.46334898679 (37.7499883024325, -122.46334898679)
188050 188050 250293 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008341.16975 2112039.72315 37.7797295003499 -122.414734684778 (37.7797295003499, -122.414734684778)
188045 188045 191393 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 845 Vermont St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     6011318.33835 2104379.19174 37.758862249405 -122.40389608603901 (37.758862249405, -122.403896086039)
188022 188022 198621 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015788.5708800005 2108619.95844 37.7707552061109 -122.388731850804 (37.7707552061109, -122.388731850804)
188013 188013 230932 Undocumented 2 Maytenus boaria :: Mayten 22 1580 Masonic Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999846.04507 2107075.6039400003 37.7656183190495 -122.443766197974 (37.7656183190495, -122.443766197974)

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