Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3

View and edit SQL

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
3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
731 251375 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 3 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 6 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 2 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 5 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 1 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 7 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 4 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
1022 186874 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2700 Sunset Blvd 23 Median : Yard 3 Tree 1 DPW 2     13 Width 0ft   5985204.8462 2096382.2812 37.7354114037883 -122.493618136413 (37.7354114037883, -122.493618136413)
1039 186954 DPW Maintained 3 Tree(s) :: 17 2800 Sunset Blvd 28 Median : Yard 3 Tree 1 DPW 2     2 Width 0ft   5985211.8854 2096092.27 37.734615522028896 -122.493572437422 (37.7346155220289, -122.493572437422)
1041 187245 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 2401 Sunset Blvd 28 Median : Yard 3 Tree 1 DPW 2     1 Width 0ft   5984968.6731 2098517.9713 37.741261616740005 -122.494592058244 (37.74126161674, -122.494592058244)
1052 187279 DPW Maintained 3 Pinus Spp :: Pine Spp 105 2401 Sunset Blvd 62 Median : Yard 3 Tree 1 DPW 2     4 Width 0ft   5984952.4466 2098301.7622 37.7406670151021 -122.494632227246 (37.7406670151021, -122.494632227246)
1059 186952 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2800 Sunset Blvd 26 Median : Yard 3 Tree 1 DPW 2     3 Width 0ft   5985204.8226 2096075.4539 37.734568936321295 -122.493595616872 (37.7345689363213, -122.493595616872)
1098 251438 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Santiago St 1 Median : Yard 3 Tree 1 DPW 2                    
3018 128709 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4x Columbus Ave 1 Median : Yard 3 Tree 1 Private 1     19 Width 9ft   6011726.08303 2117794.9108 37.795721488711294 -122.403429729102 (37.7957214887113, -122.403429729102)
3208 253368 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 236 Moncada Way 1 Median : Yard 3 Tree 1 DPW 2       10x10   5992398.0 2093455.0 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982)
3898 212122 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     3     5995365.2918 2092257.6675200001 37.724675368963105 -122.45819147914699 (37.7246753689631, -122.458191479147)
5008 253723 DPW Maintained 3 Calocedrus decurrens :: Incense Cedar 177 1X Glenview Dr   Median : Yard 3 Tree 1 DPW 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
9919 173741 Undocumented 2 Tree(s) :: 17 2500X Lyon St 8 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9921 173736 Undocumented 2 Tree(s) :: 17 2500X Lyon St 3 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9923 173740 Undocumented 2 Tree(s) :: 17 2500X Lyon St 7 Median : Yard 3 Tree 1 Private 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9924 173738 Undocumented 2 Tree(s) :: 17 2500X Lyon St 5 Median : Yard 3 Tree 1 Private 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9925 173735 Undocumented 2 Tree(s) :: 17 2500X Lyon St 2 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9926 173734 Undocumented 2 Tree(s) :: 17 2500X Lyon St 1 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9927 173742 Undocumented 2 Tree(s) :: 17 2500X Lyon St 9 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9929 173737 Undocumented 2 Tree(s) :: 17 2500X Lyon St 4 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9931 173739 Undocumented 2 Tree(s) :: 17 2500X Lyon St 6 Median : Yard 3 Tree 1 Private 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
10203 106598 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1001X SAN JOSE AVE 11 Median : Yard 3 Tree 1 DPW 2     21     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
10408 106060 DPW Maintained 3 Calocedrus decurrens :: Incense Cedar 177 12X Canyon Dr 3 Median : Yard 3 Tree 1 DPW 2     24     6003183.55845 2086355.5239400002 37.7089155261884 -122.430743733243 (37.7089155261884, -122.430743733243)
11046 116538 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 1 Median : Yard 3 Tree 1 DPW 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
11659 106061 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 12X Canyon Dr 1 Median : Yard 3 Tree 1 DPW 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
13314 187669 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 554 Valley St 1 Median : Yard 3 Tree 1 Private 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
18076 107933 DPW Maintained 3 Tree(s) :: 17 3098X Market St 1 Median : Yard 3 Tree 1 DPW 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
19556 99478 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 650X Miramar Ave 4 Median : Yard 3 Tree 1 Private 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
19618 102860 DPW Maintained 3 Calocedrus decurrens :: Incense Cedar 177 10X CRANLEIGH DR 1 Median : Yard 3 Tree 1 DPW 2   03/06/2013 12:00:00 AM 6     5991339.0 2095700.0 37.7338949747581 -122.472360557436 (37.7338949747581, -122.472360557436)
22808 195725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 250x King St 9 Median : Yard 3 Tree 1 DPW 2     5 Width 10ft   6014714.95739 2111115.10019 37.7775467477219 -122.39262009845 (37.7775467477219, -122.39262009845)
22823 251110 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 5 Median : Yard 3 Tree 1 DPW 2                    
22825 251109 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 3 Median : Yard 3 Tree 1 DPW 2                    
22828 251115 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 19 Median : Yard 3 Tree 1 DPW 2                    
22831 251116 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 20 Median : Yard 3 Tree 1 DPW 2                    
22832 251108 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 2 Median : Yard 3 Tree 1 DPW 2                    
22833 251113 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 15 Median : Yard 3 Tree 1 DPW 2                    
22838 251111 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 7 Median : Yard 3 Tree 1 DPW 2                    
22839 251114 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 16 Median : Yard 3 Tree 1 DPW 2                    
22840 251107 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1700X Quesada Ave 1 Median : Yard 3 Tree 1 DPW 2                    
23395 208305 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 600x Bosworth St 6 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   6002233.89157 2095386.08451 37.7336575763338 -122.43467122191299 (37.7336575763338, -122.434671221913)
23423 195472 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 450x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     7     6014582.56054 2117381.49578 37.7947454787808 -122.39351677468099 (37.7947454787808, -122.393516774681)
23725 234421 DPW Maintained 3 Phoenix spp :: Date palm (species unknown) 319 1500x Dolores St 7 Median : Yard 3 Tree 1 DPW 2     13     6005260.39309 2099383.33918 37.7448044887417 -122.42449194134701 (37.7448044887417, -122.424491941347)
23771 116544 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 7 Median : Yard 3 Tree 1 DPW 2     5 3x3   6001586.02621 2088182.95127 37.713842599620904 -122.436395723209 (37.7138425996209, -122.436395723209)
23773 222832 DPW Maintained 3 Ceiba speciosa :: Silk floss 335 3250x Cesar Chavez St 4 Median : Yard 3 Tree 1 DPW 2     6 Width 10ft   6007936.88236 2100571.1337200003 37.7482166910686 -122.415321190215 (37.7482166910686, -122.415321190215)
23802 132129 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013671.61354 2118630.60451 37.79812457884061 -122.39675640879999 (37.7981245788406, -122.3967564088)
23869 212124 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 6 Median : Yard 3 Tree 1 DPW 2     5     5995365.62659 2092320.18392 37.72484704325171 -122.45819484441999 (37.7248470432517, -122.45819484442)
23986 204965 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 400x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     15     5995367.63483 2092532.42925 37.725429933419 -122.458203256674 (37.725429933419, -122.458203256674)
24029 250142 DPW Maintained 3 Magnolia spp :: Magnolia 89 2550x Lyon St 10 Median : Yard 3 Tree 1 DPW 2     1     5999229.6006 2117622.80882 37.7945430395703 -122.44665726921801 (37.7945430395703, -122.446657269218)
24045 211638 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 605x Saint Francis Blvd 1 Median : Yard 3 Tree 1 DPW 2     12     5993404.24438 2096035.5287900001 37.7349355669295 -122.465244802603 (37.7349355669295, -122.465244802603)
24175 221317 DPW Maintained 3 Brahea edulis :: Guadalupe Palm 115 3500x Cesar Chavez St 17 Median : Yard 3 Tree 1 DPW 2     11 Width 10ft   6005983.198059999 2100540.62132 37.74802291412821 -122.422074813715 (37.7480229141282, -122.422074813715)
24270 188526 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1427x Innes Ave 12 Median : Yard 3 Tree 1 DPW 2     13     6016254.90623 2096663.3838099998 37.7379507994938 -122.386285047323 (37.7379507994938, -122.386285047323)
24347 222775 DPW Maintained 3 Ceiba speciosa :: Silk floss 335 2950x Cesar Chavez St 9 Median : Yard 3 Tree 1 DPW 2     3     6009484.1227400005 2100580.43593 37.7483290712363 -122.40997151459 (37.7483290712363, -122.40997151459)
24383 116552 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 8 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838)
24462 211631 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 605x Saint Francis Blvd 2 Median : Yard 3 Tree 1 DPW 2     21     5993552.90123 2096075.99565 37.735055250506704 -122.464733785358 (37.7350552505067, -122.464733785358)
24494 233935 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 150x Dolores St 9 Median : Yard 3 Tree 1 DPW 2     30     6004826.52958 2107279.95522 37.766462234780604 -122.426554344032 (37.7664622347806, -122.426554344032)
24519 206820 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 2 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   5994214.91647 2101031.13143 37.7486989587999 -122.462804340247 (37.7486989587999, -122.462804340247)
24528 220701 DPW Maintained 3 Brahea edulis :: Guadalupe Palm 115 3200x Cesar Chavez St 8 Median : Yard 3 Tree 1 DPW 2     14 Width 10ft   6008127.92361 2100571.71997 37.7482290360503 -122.41466061482001 (37.7482290360503, -122.41466061482)
24677 111241 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 745X SANCHEZ ST 4 Median : Yard 3 Tree 1 DPW 2     6     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
24818 191371 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900x Carolina St 66 Median : Yard 3 Tree 1 DPW 2     13     6012518.79145 2102845.53786 37.7547181653131 -122.39963665401699 (37.7547181653131, -122.399636654017)
24866 189991 DPW Maintained 3 Cercis occidentalis :: Western Redbud 246 1427x Innes Ave 18 Median : Yard 3 Tree 1 DPW 2     20     6016204.83732 2096710.6252 37.7380777432808 -122.386461454743 (37.7380777432808, -122.386461454743)
24947 206807 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 11x Saint Francis Blvd 1 Median : Yard 3 Tree 1 DPW 2     12     5991689.221530001 2095992.9314700002 37.734719554257296 -122.471171081279 (37.7347195542573, -122.471171081279)
25048 132103 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645)
25072 126288 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2500x Van Ness Ave 7 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6005772.33142 2119211.18315 37.7992758747311 -122.424131583019 (37.7992758747311, -122.424131583019)
25183 249466 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 900x Van Ness Ave 4 Median : Yard 3 Tree 1 DPW 2     25     6006522.49711 2113836.87509 37.7845616899264 -122.421153924138 (37.7845616899264, -122.421153924138)
25207 214407 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 200x Terrace Dr 11 Median : Yard 3 Tree 1 DPW 2     8     5993812.00581 2096497.7556200002 37.7362282335302 -122.463868579087 (37.7362282335302, -122.463868579087)
25236 194362 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016123.073030001 2114362.8388099996 37.786542411639 -122.38797559828899 (37.786542411639, -122.387975598289)
25336 197493 DPW Maintained 3 Schinus molle :: California Pepper 138 950x Kansas St 7 Median : Yard 3 Tree 1 DPW 2     25     6011595.701219999 2103803.27065 37.7572963894245 -122.402896325021 (37.7572963894245, -122.402896325021)
25390 132077 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
25391 132190 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 44 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132)
25560 131008 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 150x Drumm St 3 Median : Yard 3 Tree 1 DPW 2     4 Width 7ft   6013685.844769999 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539)
25604 250134 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 2550x Lyon St 2 Median : Yard 3 Tree 1 DPW 2     15     5999224.86929 2117537.18532 37.7943076699218 -122.446667476532 (37.7943076699218, -122.446667476532)
25644 126371 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 37 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046)
25864 211289 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 100x Idora Ave 8 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995366.53481 2099407.6063200003 37.744307426259205 -122.45870456127399 (37.7443074262592, -122.458704561274)
25922 197195 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 1700x Quesada Ave 52 Median : Yard 3 Tree 1 DPW 2     5     6014229.96459 2095381.0032900001 37.734317354963395 -122.393196613328 (37.7343173549634, -122.393196613328)
25946 126425 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1306x Montgomery St 27 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6011438.821769999 2120037.4711599997 37.8018629670555 -122.40458165273701 (37.8018629670555, -122.404581652737)
25996 194361 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
26160 194311 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     21 Width 7ft   6015171.2298099995 2116694.38601 37.79289152546961 -122.39143182424401 (37.7928915254696, -122.391431824244)
26183 195467 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 450x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     8     6014580.603680001 2117309.91593 37.7945488285163 -122.393518533752 (37.7945488285163, -122.393518533752)
26272 221314 DPW Maintained 3 Brahea edulis :: Guadalupe Palm 115 3500x Cesar Chavez St 7 Median : Yard 3 Tree 1 DPW 2     14 Width 10ft   6006208.09255 2100562.38879 37.7480953644201 -122.421298681694 (37.7480953644201, -122.421298681694)
26428 195683 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 102x King St 12 Median : Yard 3 Tree 1 DPW 2     10 Width 10ft   6015319.49651 2111685.54707 37.7791466227626 -122.390568648644 (37.7791466227626, -122.390568648644)
26465 213721 DPW Maintained 3 Prunus x yedoensis :: Yoshino Cherry 237 66x Santa Monica Way 2 Median : Yard 3 Tree 1 DPW 2     1     5993647.57824 2097426.08398 37.7387677148629 -122.46450445281401 (37.7387677148629, -122.464504452814)
26492 242374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006546.0037 2109148.1970900004 37.771689039651896 -122.42073962714899 (37.7716890396519, -122.420739627149)
26676 247028 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 550x Valley St 6 Median : Yard 3 Tree 1 DPW 2     10     6002355.441269999 2099181.9915400003 37.744087157999296 -122.43452230856701 (37.7440871579993, -122.434522308567)
26820 212114 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1902x Monterey Blvd 2 Median : Yard 3 Tree 1 DPW 2     36 Width 10ft   5992265.63325 2095412.1953200002 37.7331583221951 -122.46913599464399 (37.7331583221951, -122.469135994644)
26840 194523 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 900x Carolina St 72 Median : Yard 3 Tree 1 DPW 2     3     6012512.869530001 2102814.17539 37.7546317206991 -122.399654931846 (37.7546317206991, -122.399654931846)
26925 208266 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 4 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5996189.57852 2098600.11131 37.7421375150253 -122.455800307749 (37.7421375150253, -122.455800307749)
26942 129350 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 38 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
26953 223749 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 5200x Diamond Heights Blvd 33 Median : Yard 3 Tree 1 DPW 2     52     6001564.8370199995 2098920.55277 37.743324397105 -122.43723732135099 (37.743324397105, -122.437237321351)
27106 195241 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400x Evans Ave 17 Median : Yard 3 Tree 1 DPW 2     5     6016370.1217 2098002.92096 37.7416352733631 -122.38598003597299 (37.7416352733631, -122.385980035973)
27134 194292 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 43 Median : Yard 3 Tree 1 DPW 2     38     6014354.24031 2095291.86255 37.734079495961396 -122.392760714642 (37.7340794959614, -122.392760714642)
27156 194439 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 900x Carolina St 32 Median : Yard 3 Tree 1 DPW 2     12     6012481.17054 2103301.60211 37.755968320994704 -122.3997987802 (37.7559683209947, -122.3997987802)
27253 124144 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 4100x Geary Blvd 6 Median : Yard 3 Tree 1 DPW 2     14     5994110.98895 2112812.2270400003 37.7810407796467 -122.464018802579 (37.7810407796467, -122.464018802579)
27255 193544 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 900x Carolina St 10 Median : Yard 3 Tree 1 DPW 2     22     6012476.687390001 2103624.0786200003 37.75685352098429 -122.39983692765499 (37.7568535209843, -122.399836927655)
27286 132113 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.39797700193701 (37.7996825238869, -122.397977001937)

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