Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189069 189069 195235 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1200x Evans Ave 30 Median : Yard 3 Tree 1 DPW 2     9     6017260.82922 2097339.16357 37.7398619829554 -122.382854057268 (37.7398619829554, -122.382854057268)
188999 188999 129349 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 35 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
188991 188991 218259 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1400x Portola Dr 17 Median : Yard 3 Tree 1 DPW 2     11     5992809.1507 2097219.8287299997 37.7381530219397 -122.46738832232 (37.7381530219397, -122.46738832232)
188939 188939 212143 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 650x Miramar Ave 1 Median : Yard 3 Tree 1 DPW 2     3     5995395.28868 2093711.39383 37.7286686754144 -122.45819295046199 (37.7286686754144, -122.458192950462)
188895 188895 212106 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1602x Monterey Blvd 4 Median : Yard 3 Tree 1 DPW 2     33 Width 10ft   5993007.603759999 2095365.5409099997 37.733073065562 -122.466567434662 (37.733073065562, -122.466567434662)
188426 188426 248776 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 10x Lyell St 3 Median : Yard 3 Tree 1 DPW 2     18 Width 10ft   6002998.16884 2095083.8511700002 37.73287107152721 -122.43200731937999 (37.7328710715272, -122.43200731938)
188330 188330 243923 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Bartlett St 2 Median : Yard 3 Tree 1 DPW 2     12 Width 10ft   6006672.06961 2103729.13284 37.7568166658685 -122.419918946309 (37.7568166658685, -122.419918946309)
188268 188268 211116 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 16 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   5994179.36475 2101243.69399 37.749280553969605 -122.46294269644501 (37.7492805539696, -122.462942696445)
188244 188244 224100 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 2x Gough St 4 Median : Yard 3 Tree 1 DPW 2     2 Width 10ft   6006621.45587 2109260.75005 37.772002335561794 -122.42048662356899 (37.7720023355618, -122.420486623569)
188176 188176 178034 DPW Maintained 3 Olea europaea :: Olive Tree 41 1378x Geneva Ave 2 Median : Yard 3 Tree 1 DPW 2     7     6002495.00651 2087816.3446 37.7128875861582 -122.433227774048 (37.7128875861582, -122.433227774048)
188023 188023 234407 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 100x Dolores St 8 Median : Yard 3 Tree 1 DPW 2     18     6004812.29017 2107562.9589 37.7672384899902 -122.426623750084 (37.7672384899902, -122.426623750084)
188008 188008 187747 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2x Dukes Ct 5 Median : Yard 3 Tree 1 DPW 2     15     6016140.5122 2096271.0286 37.7368671389145 -122.38665321539801 (37.7368671389145, -122.386653215398)
187917 187917 250143 DPW Maintained 3 Magnolia x soulangiana :: Saucer Magnolia 92 2550x Lyon St 11 Median : Yard 3 Tree 1 DPW 2     1     5999225.81293 2117634.10371 37.7945738359766 -122.446671188041 (37.7945738359766, -122.446671188041)
187874 187874 194313 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     12 Width 7ft   6015116.8381 2116756.98357 37.793060384871 -122.391624402345 (37.793060384871, -122.391624402345)
187741 187741 248647 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2x Lyell St 1 Median : Yard 3 Tree 1 DPW 2     23     6002988.020959999 2095088.4577900001 37.73288314494071 -122.432042732011 (37.7328831449407, -122.432042732011)
187703 187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
187642 187642 206837 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 25 Median : Yard 3 Tree 1 DPW 2     63 Width 9ft   5995840.17489 2099294.03492 37.7440227989188 -122.45705861128401 (37.7440227989188, -122.457058611284)
187602 187602 212146 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 650x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     4     5995392.59413 2093841.41892 37.7290255380777 -122.458211672548 (37.7290255380777, -122.458211672548)
187577 187577 205961 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 600x Wildwood Way 1 Median : Yard 3 Tree 1 DPW 2     16     5995381.06521 2093316.38835 37.7275832683311 -122.458213544042 (37.7275832683311, -122.458213544042)
187551 187551 188647 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 10 Median : Yard 3 Tree 1 DPW 2     17     6018073.116719999 2098111.74487 37.7420281826481 -122.38009915058001 (37.7420281826481, -122.38009915058)
187536 187536 209135 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 21 Median : Yard 3 Tree 1 DPW 2     21     6001010.142969999 2095737.8079 37.7345537777227 -122.438927266197 (37.7345537777227, -122.438927266197)
187319 187319 221285 DPW Maintained 3 Brahea edulis :: Guadalupe Palm 115 100x McCoppin St 4 Median : Yard 3 Tree 1 DPW 2     12 Width 7ft   6005941.9303 2109128.61885 37.771601217256396 -122.422827765695 (37.7716012172564, -122.422827765695)
187052 187052 251050 DPW Maintained 3 Pinus Spp :: Pine Spp 105 5800x Geary Blvd 1 Median : Yard 3 Tree 1 DPW 2     4 Width 10ft   5988878.2157 2112618.8979 37.780206989324796 -122.48210718666901 (37.7802069893248, -122.482107186669)
187030 187030 240286 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 5200x Diamond Heights Blvd 42 Median : Yard 3 Tree 1 DPW 2     2     6001709.51148 2098788.78469 37.742970816043204 -122.436727644972 (37.7429708160432, -122.436727644972)
186864 186864 197885 DPW Maintained 3 Syzygium paniculatum :: Brush Cherry 198 1498x Tennessee St 2 Median : Yard 3 Tree 1 DPW 2     7 Width 7ft   6015684.0853699995 2101943.48621 37.7524172561691 -122.388627146329 (37.7524172561691, -122.388627146329)
186834 186834 246885 DPW Maintained 3 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 3090x Market St 18 Median : Yard 3 Tree 1 DPW 2     8     5999879.22099 2105284.18163 37.760701410669206 -122.44352275418899 (37.7607014106692, -122.443522754189)
186747 186747 194316 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     26 Width 7ft   6014969.23068 2116866.2603700003 37.793352239169295 -122.392142782374 (37.7933522391693, -122.392142782374)
186731 186731 188739 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014439.36233 2086971.4204900002 37.7112379444543 -122.39188480373801 (37.7112379444543, -122.391884803738)
186713 186713 199575 DPW Maintained 3 Yucca gloriosa :: Spanish Dagger 224 1300x De Haro St 25 Median : Yard 3 Tree 1 DPW 2     27     6012270.74731 2102100.8941599997 37.752659706198294 -122.400442161487 (37.7526597061983, -122.400442161487)
186566 186566 132093 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     25 Width 10ft   6012902.31977 2119848.32419 37.8014252975988 -122.39950394556699 (37.8014252975988, -122.399503945567)
186558 186558 187746 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2x Dukes Ct 4 Median : Yard 3 Tree 1 DPW 2     16     6016141.394640001 2096265.75957 37.7368527200761 -122.38664979707501 (37.7368527200761, -122.386649797075)
186536 186536 132183 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 23 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6011446.11989 2119998.19994 37.801755545737294 -122.404553631656 (37.8017555457373, -122.404553631656)
186488 186488 249476 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Van Ness Ave 3 Median : Yard 3 Tree 1 DPW 2     16     6006383.25331 2114827.68427 37.78727435725771 -122.421706060208 (37.7872743572577, -122.421706060208)
186446 186446 231478 DPW Maintained 3 Malus :: Crab Apple 235 600x San Jose Ave 2 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6005969.94367 2099650.47553 37.745578028916995 -122.422057419928 (37.745578028917, -122.422057419928)
186445 186445 222811 DPW Maintained 3 Ceiba speciosa :: Silk floss 335 3400x Cesar Chavez St 13 Median : Yard 3 Tree 1 DPW 2     4 Width 10ft   6006785.0700900005 2100560.48159 37.748122639944704 -122.419303374748 (37.7481226399447, -122.419303374748)
186406 186406 211123 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 28 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5994165.13571 2101402.3094200003 37.7497152520618 -122.46300340698099 (37.7497152520618, -122.463003406981)
186368 186368 234408 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1700x Dolores St 6 Median : Yard 3 Tree 1 DPW 2     18     6005328.71951 2098210.15562 37.7415870517023 -122.424172262039 (37.7415870517023, -122.424172262039)
186361 186361 195681 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 102x King St 10 Median : Yard 3 Tree 1 DPW 2     8 Width 10ft   6015351.95562 2111719.9418200003 37.779242863700794 -122.390458762259 (37.7792428637008, -122.390458762259)
186293 186293 208310 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700x Bosworth St 5 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6001987.84098 2095447.80908 37.733813086200705 -122.43552630359301 (37.7338130862007, -122.435526303593)
186279 186279 126369 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 30 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011435.17205 2120070.79941 37.801954274322206 -122.404596630044 (37.8019542743222, -122.404596630044)
186146 186146 212139 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 602x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     6     5995385.05875 2093507.2159099998 37.728107464286204 -122.45821354403999 (37.7281074642862, -122.45821354404)
185898 185898 188406 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1300x De Haro St 6 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   6012288.20028 2102185.92507 37.75289415586 -122.400387777694 (37.75289415586, -122.400387777694)
185868 185868 132133 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     27 Width 10ft   6013516.34459 2118862.0699 37.7987514845508 -122.39730992891 (37.7987514845508, -122.39730992891)
185837 185837 189989 DPW Maintained 3 Cercis occidentalis :: Western Redbud 246 1427x Innes Ave 7 Median : Yard 3 Tree 1 DPW 2     4     6016321.76004 2096621.1016 37.737838401311706 -122.386050952014 (37.7378384013117, -122.386050952014)
185691 185691 217802 DPW Maintained 3 Eucalyptus Spp :: Eucalyptus 40 2x Sloat Blvd 2 Median : Yard 3 Tree 1 DPW 2     15     5991046.80022 2095992.48375 37.734681145124505 -122.47339209648001 (37.7346811451245, -122.47339209648)
185624 185624 212116 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2001x Monterey Blvd 1 Median : Yard 3 Tree 1 DPW 2     26 Width 10ft   5992083.71687 2095423.23256 37.7331781144806 -122.469765726035 (37.7331781144806, -122.469765726035)
185473 185473 242779 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006556.42632 2109149.52189 37.77169326466979 -122.420703668659 (37.7716932646698, -122.420703668659)
184948 184948 190916 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 900x Carolina St 61 Median : Yard 3 Tree 1 DPW 2     12     6012503.648130001 2102901.04205 37.754869723572895 -122.39969292101601 (37.7548697235729, -122.399692921016)
184668 184668 135610 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 450x The Embarcadero 21 Median : Yard 3 Tree 1 DPW 2     7     6014284.458430001 2117732.9706900003 37.7956939784573 -122.39457288004499 (37.7956939784573, -122.394572880045)
184580 184580 206812 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 66x Santa Monica Way 9 Median : Yard 3 Tree 1 DPW 2     15     5993679.09704 2097560.53952 37.739138713068 -122.464405236026 (37.739138713068, -122.464405236026)
184455 184455 220705 DPW Maintained 3 Brahea edulis :: Guadalupe Palm 115 3300x Cesar Chavez St 1 Median : Yard 3 Tree 1 DPW 2     13 Width 10ft   6007530.958190001 2100569.16609 37.748188465819794 -122.416724727984 (37.7481884658198, -122.416724727984)
184341 184341 222760 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 10x Benton Ave 8 Median : Yard 3 Tree 1 DPW 2     12     6004726.81144 2094996.18589 37.73272821244 -122.426024717968 (37.73272821244, -122.426024717968)
184299 184299 189334 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 1427x Innes Ave 27 Median : Yard 3 Tree 1 DPW 2     17     6016143.045059999 2096752.0834599999 37.73818815846639 -122.386677993501 (37.7381881584664, -122.386677993501)
184281 184281 199402 DPW Maintained 3 Eucalyptus Spp :: Eucalyptus 40 299x Cashmere St 20 Median : Yard 3 Tree 1 DPW 2     26     6016663.61896 2095979.5906099998 37.736095855134394 -122.384824290234 (37.7360958551344, -122.384824290234)
184176 184176 131158 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 13 Median : Yard 3 Tree 1 DPW 2     13     6007691.70139 2118146.70965 37.79646127913271 -122.417414400977 (37.7964612791327, -122.417414400977)
183989 183989 223863 DPW Maintained 3 Cussonia spicata :: Cabbage tree 325 3700x Cesar Chavez St 2 Median : Yard 3 Tree 1 DPW 2     9 Width 10ft   6005802.979169999 2100534.20381 37.7479951268836 -122.422697548374 (37.7479951268836, -122.422697548374)
183939 183939 246883 DPW Maintained 3 Pittosporum tobira :: Japanese Mockorange 243 3090x Market St 16 Median : Yard 3 Tree 1 DPW 2     10     5999870.066869999 2105328.2836599997 37.76082198187 -122.443557582215 (37.76082198187, -122.443557582215)
183887 183887 180412 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1104x Alemany Blvd 2 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   6003814.30975 2094445.54262 37.7311646556118 -122.42914021505501 (37.7311646556118, -122.429140215055)
183866 183866 136293 DPW Maintained 3 Quercus suber :: Cork Oak 76 1500x Van Ness Ave 5 Median : Yard 3 Tree 1 DPW 2     11     6006248.16207 2115803.32411 37.789945603663604 -122.42224279089899 (37.7899456036636, -122.422242790899)
183804 183804 198502 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 900x Carolina St 14 Median : Yard 3 Tree 1 DPW 2     9     6012462.6007 2103568.62023 37.75670045906929 -122.399881750743 (37.7567004590693, -122.399881750743)
183718 183718 246549 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   6005737.248 2109452.9268900002 37.77248013816789 -122.423558835368 (37.7724801381679, -122.423558835368)
183715 183715 211471 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 200x Terrace Dr 16 Median : Yard 3 Tree 1 DPW 2     14     5993818.60983 2096510.8522700001 37.736264574250995 -122.463846696775 (37.736264574251, -122.463846696775)
183680 183680 189166 DPW Maintained 3 Afrocarpus gracilior :: Fern Pine 70 1300x De Haro St 20 Median : Yard 3 Tree 1 DPW 2     1     6012257.93832 2102144.48011 37.752778669414 -122.40048951886999 (37.752778669414, -122.40048951887)
183462 183462 206813 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 198x San Anselmo Ave 5 Median : Yard 3 Tree 1 DPW 2     12     5993675.924 2096312.14772 37.7357107573442 -122.464325594759 (37.7357107573442, -122.464325594759)
183458 183458 194358 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016102.75205 2114084.3299 37.7857765633769 -122.388026462162 (37.7857765633769, -122.388026462162)
183025 183025 212126 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 400x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     7     5995367.13793 2092485.42648 37.725300846538 -122.458201574057 (37.725300846538, -122.458201574057)
182998 182998 128875 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1237x Robert C Levy Tunl 2 Median : Yard 3 Tree 1 DPW 2     2     6007636.05536 2118136.6748900004 37.7964305951503 -122.417606237154 (37.7964305951503, -122.417606237154)
182967 182967 213725 DPW Maintained 3 Prunus x yedoensis :: Yoshino Cherry 237 66x San Lorenzo Way 10 Median : Yard 3 Tree 1 DPW 2     4     5993679.6596 2097491.88512 37.7389502376721 -122.46439830763201 (37.7389502376721, -122.464398307632)
182808 182808 194353 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6016057.99648 2113605.1395799997 37.7844583353237 -122.388147851742 (37.7844583353237, -122.388147851742)
182720 182720 247577 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 300x Alemany Blvd 1 Median : Yard 3 Tree 1 DPW 2     44     6008700.9232 2095336.3735 37.7338860994661 -122.41230921050501 (37.7338860994661, -122.412309210505)
182641 182641 233932 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 150x Dolores St 2 Median : Yard 3 Tree 1 DPW 2     24     6004814.58298 2107439.6885599997 37.7669001488458 -122.426607040704 (37.7669001488458, -122.426607040704)
182585 182585 194343 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016001.634319999 2112937.23784 37.7826213045779 -122.38829621649799 (37.7826213045779, -122.388296216498)
182508 182508 222827 DPW Maintained 3 Ceiba speciosa :: Silk floss 335 3300x Cesar Chavez St 4 Median : Yard 3 Tree 1 DPW 2     5 Width 10ft   6007469.113419999 2100569.02723 37.748184605929204 -122.41693857595399 (37.7481846059292, -122.416938575954)
182470 182470 132107 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6011604.73213 2121437.1460700002 37.805715402812204 -122.40410608402901 (37.8057154028122, -122.404106084029)
182431 182431 218284 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 50x Junipero Serra Frontage West 0 Median : Yard 3 Tree 1 DPW 2     28     5991438.8932 2095398.7783700002 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523)
182339 182339 208308 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700x Bosworth St 3 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6002022.61443 2095440.5497 37.733795128547 -122.435405562425 (37.733795128547, -122.435405562425)
182277 182277 194342 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6016043.56926 2112825.74631 37.7823174973895 -122.38814335514999 (37.7823174973895, -122.38814335515)
182257 182257 212115 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1902x Monterey Blvd 3 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   5992194.67664 2095416.97281 37.7331673397011 -122.46938165614401 (37.7331673397011, -122.469381656144)
182169 182169 212152 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     6     5995399.05929 2094305.60657 37.730300456589106 -122.458222905079 (37.7303004565891, -122.458222905079)
182110 182110 194322 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     22 Width 7ft   6014773.3420400005 2117151.64182 37.7941249519603 -122.392840551058 (37.7941249519603, -122.392840551058)
182038 182038 234353 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 600x Dolores St 5 Median : Yard 3 Tree 1 DPW 2     22     6004972.999969999 2104631.70012 37.7591990347337 -122.425859204936 (37.7591990347337, -122.425859204936)
182030 182030 195476 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 450x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     8     6014549.96512 2117428.46755 37.7948726411219 -122.39363284927299 (37.7948726411219, -122.393632849273)
181994 181994 132108 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6011532.668269999 2121506.48507 37.8059017639302 -122.404360356561 (37.8059017639302, -122.404360356561)
181805 181805 217819 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1x Junipero Serra Blvd 6 Median : Yard 3 Tree 1 DPW 2     33     5991622.365809999 2095679.35409 37.733854682528204 -122.471379381376 (37.7338546825282, -122.471379381376)
181686 181686 246870 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3090x Market St 3 Median : Yard 3 Tree 1 DPW 2     11     5999943.44665 2105326.58667 37.7608215070397 -122.443303673043 (37.7608215070397, -122.443303673043)
181676 181676 186658 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 1401 Sunset Blvd 15 Median : Yard 3 Tree 1 DPW 2     1 Width 0ft   5984710.2715 2105562.1346 37.7605878254343 -122.49600505239401 (37.7605878254343, -122.496005052394)
181589 181589 250137 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2550x Lyon St 5 Median : Yard 3 Tree 1 DPW 2     12     5999214.14671 2117588.9485299997 37.7944491854404 -122.44670830396002 (37.7944491854404, -122.44670830396)
181577 181577 195680 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 102x King St 9 Median : Yard 3 Tree 1 DPW 2     9 Width 10ft   6015377.63395 2111744.49968 37.779311718508 -122.390371645854 (37.779311718508, -122.390371645854)
181413 181413 195720 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 250x King St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 10ft   6014817.65208 2111211.59026 37.7778173905846 -122.39227159046001 (37.7778173905846, -122.39227159046)
181397 181397 197883 DPW Maintained 3 Syzygium paniculatum :: Brush Cherry 198 1498x Tennessee St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 7ft   6015671.68668 2101942.82757 37.752414760540105 -122.388669977447 (37.7524147605401, -122.388669977447)
181312 181312 246539 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 5 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6005686.56992 2109401.16217 37.7723351440794 -122.423730454802 (37.7723351440794, -122.423730454802)
181114 181114 124134 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 3500x Geary Blvd 7 Median : Yard 3 Tree 1 DPW 2     2     5996034.43033 2112879.7174 37.7813367535062 -122.457369587843 (37.7813367535062, -122.457369587843)
181048 181048 196779 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 1200x Owen St 8 Median : Yard 3 Tree 1 DPW 2     4     6013679.35435 2108527.95824 37.7703854696435 -122.396021274189 (37.7703854696435, -122.396021274189)
180940 180940 197472 DPW Maintained 3 Salix lasiolepis :: Arroyo willow 213 1700x Quesada Ave 31 Median : Yard 3 Tree 1 DPW 2     2     6014448.1116 2095227.50583 37.7339079988375 -122.39243166978599 (37.7339079988375, -122.392431669786)
180863 180863 218285 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50x Junipero Serra Frontage West 0 Median : Yard 3 Tree 1 DPW 2     11     5991436.68421 2095414.89925 37.7331178131424 -122.47200206387 (37.7331178131424, -122.47200206387)
180749 180749 206822 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 11 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5994175.83574 2101201.51334 37.7491645333344 -122.462951839858 (37.7491645333344, -122.462951839858)
180628 180628 249479 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1300x Van Ness Ave 3 Median : Yard 3 Tree 1 DPW 2     13     6006342.53317 2115134.23147 37.7881137637835 -122.42186872687799 (37.7881137637835, -122.421868726878)
180599 180599 191725 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 950x Kansas St 6 Median : Yard 3 Tree 1 DPW 2     46     6011608.2265 2103816.01851 37.75733209161471 -122.40285390399201 (37.7573320916147, -122.402853903992)
180529 180529 190135 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2160x Palou Ave 2 Median : Yard 3 Tree 1 DPW 2     6     6011839.17334 2097531.5367900003 37.7400891579846 -122.40161349967899 (37.7400891579846, -122.401613499679)
180517 180517 135598 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 160x Drumm St 6 Median : Yard 3 Tree 1 DPW 2     2 Width 7ft   6013629.78784 2117826.7467900002 37.7959150479945 -122.396844751899 (37.7959150479945, -122.396844751899)

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