Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
731 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||||
1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
3208 | 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) | ||||
5008 | 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) | |||||
18076 | 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) | |||||
22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
64871 | 64871 | 115154 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 245x ARLINGTON ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | ||||
79307 | 79307 | 107935 | DPW Maintained 3 | Tree(s) :: 17 | 1099X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6009025.86197 | 2112294.38137 | 37.7804671773494 | -122.41238403194401 | (37.7804671773494, -122.412384031944) | |||||
82353 | 82353 | 109678 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
82835 | 82835 | 113195 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 699X Noe St | 2 | Median : Yard 3 | Tree 1 | Private 1 | 6003039.779709999 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | |||||
83234 | 83234 | 109676 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
94540 | 94540 | 106114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1752X DOLORES ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6005197.0 | 2098194.1 | 37.741535528464496 | -122.424626562024 | (37.7415355284645, -122.424626562024) | |||||
97848 | 97848 | 115153 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 245x ARLINGTON ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | ||||
102484 | 102484 | 113196 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 4090X 20th St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6003325.9669699995 | 2104184.75857 | 37.7578786248615 | -122.43152352597099 | (37.7578786248615, -122.431523525971) | |||||
103039 | 103039 | 115155 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 245x ARLINGTON ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | ||||
103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
104474 | 104474 | 97692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.0484200001 | 37.732628603868704 | -122.425877544976 | (37.7326286038687, -122.425877544976) | ||||
104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
106565 | 106565 | 115156 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 245x ARLINGTON ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | ||||
109683 | 109683 | 109675 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
110459 | 110459 | 111240 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 745X SANCHEZ ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | |||||
116741 | 116741 | 97397 | DPW Maintained 3 | Butia capitata :: Pindo Palm 149 | 1203X Sunset Blvd | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
123876 | 123876 | 107934 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
128569 | 128569 | 97396 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
141517 | 141517 | 109677 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
142186 | 142186 | 107936 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
142749 | 142749 | 97395 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
146161 | 146161 | 109674 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
1041 | 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) | |||
11046 | 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) | |||
23395 | 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) | |||
24029 | 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) | ||||
26465 | 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) | ||||
26942 | 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) | |||
27546 | 27546 | 222774 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2950x Cesar Chavez St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6009463.63512 | 2100579.86171 | 37.748326346280706 | -122.41004232002301 | (37.7483263462807, -122.410042320023) | ||||
27784 | 27784 | 177494 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1002x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6001533.96245 | 2088133.73568 | 37.7137045060241 | -122.43657215399901 | (37.7137045060241, -122.436572153999) | ||||
28868 | 28868 | 208175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.758086113802904 | -122.473965364836 | (37.7580861138029, -122.473965364836) | |||
30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
31521 | 31521 | 175079 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1104x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003837.73065 | 2094453.4628599999 | 37.7311877286109 | -122.42905980937599 | (37.7311877286109, -122.429059809376) | |||
32237 | 32237 | 250565 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.48760963785601 | (37.7799715553521, -122.487609637856) | |||
32869 | 32869 | 189966 | DPW Maintained 3 | Cercis canadensis :: Eastern Redbud 299 | 900x Carolina St | 73 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012515.82864 | 2102790.5172099997 | 37.754566925442795 | -122.39964303739201 | (37.7545669254428, -122.399643037392) | ||||
34570 | 34570 | 251048 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5700x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989255.4598 | 2112633.0799 | 37.7802678632993 | -122.480803179963 | (37.7802678632993, -122.480803179963) | |||
39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
39879 | 39879 | 222824 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3200x Cesar Chavez St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6008202.20567 | 2100572.2127900003 | 37.7482345623906 | -122.41440378373001 | (37.7482345623906, -122.41440378373) | |||
40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
42524 | 42524 | 189228 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1300x De Haro St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012274.4793300005 | 2102155.74686 | 37.752810527903 | -122.40043310802 | (37.752810527903, -122.40043310802) | ||||
44686 | 44686 | 251075 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990994.9145 | 2112700.954 | 37.7805551774565 | -122.47479062026899 | (37.7805551774565, -122.474790620269) | |||
60953 | 60953 | 251054 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 6000x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988209.3153 | 2112595.4218 | 37.7801036030677 | -122.48441946896601 | (37.7801036030677, -122.484419468966) | |||
60954 | 60954 | 206815 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993562.9787 | 2100880.73772 | 37.7482484452101 | -122.465047796213 | (37.7482484452101, -122.465047796213) | ||||
67105 | 67105 | 197178 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.40043915236099 | (37.7526998195515, -122.400439152361) | ||||
70188 | 70188 | 194167 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1300x De Haro St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012274.0442699995 | 2102163.00717 | 37.7528304388731 | -122.40043512247802 | (37.7528304388731, -122.400435122478) | ||||
73883 | 73883 | 208307 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6002108.77199 | 2095420.81947 | 37.7337458465985 | -122.435106279748 | (37.7337458465985, -122.435106279748) | |||
74413 | 74413 | 251035 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5317x Geary Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990415.7605 | 2112675.5562 | 37.7804518645045 | -122.47679231146002 | (37.7804518645045, -122.47679231146) | |||
74497 | 74497 | 190073 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1700x Quesada Ave | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014423.28579 | 2095240.49948 | 37.7339422980969 | -122.392518409417 | (37.7339422980969, -122.392518409417) | ||||
76907 | 76907 | 180414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.73110669070989 | -122.42933162228 | (37.7311066907099, -122.42933162228) | |||
83067 | 83067 | 208306 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6002214.21615 | 2095390.4279 | 37.733668385273205 | -122.434739555986 | (37.7336683852732, -122.434739555986) | |||
133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
135340 | 135340 | 208309 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6002006.71588 | 2095443.8659400002 | 37.7338033312475 | -122.43546076552799 | (37.7338033312475, -122.435460765528) | |||
137930 | 137930 | 116541 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1041x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001548.78537 | 2088145.26253 | 37.7137369985308 | -122.436521745206 | (37.7137369985308, -122.436521745206) | |||
147232 | 147232 | 190067 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1150x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6015567.2875 | 2103497.11447 | 37.7566767169834 | -122.389139526978 | (37.7566767169834, -122.389139526978) | |||
149319 | 149319 | 197491 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900x Carolina St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012477.42612 | 2103497.4714900004 | 37.756505926715604 | -122.39982548288499 | (37.7565059267156, -122.399825482885) | ||||
151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
152127 | 152127 | 251023 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991490.4549 | 2112712.2313 | 37.780614844759995 | -122.473077150172 | (37.78061484476, -122.473077150172) | |||
153227 | 153227 | 250144 | DPW Maintained 3 | Magnolia x soulangiana :: Saucer Magnolia 92 | 2550x Lyon St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999230.56416 | 2117643.35138 | 37.794599499022105 | -122.446655413925 | (37.7945994990221, -122.446655413925) | ||||
153800 | 153800 | 222815 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6006246.77566 | 2100563.7677 | 37.7481013314143 | -122.42116501457 | (37.7481013314143, -122.42116501457) | |||
154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
158355 | 158355 | 188005 | DPW Maintained 3 | Araucaria columnaris :: Coral reef araucaria 185 | 1700x Quesada Ave | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014418.79198 | 2095243.03437 | 37.733949008825896 | -122.39253412326799 | (37.7339490088259, -122.392534123268) | ||||
158594 | 158594 | 251036 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990401.2433 | 2112674.4808 | 37.780448069653296 | -122.47684245414699 | (37.7804480696533, -122.476842454147) | |||
159827 | 159827 | 193548 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1300x De Haro St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.58863 | 2102171.1791 | 37.7528527402726 | -122.400444188549 | (37.7528527402726, -122.400444188549) | ||||
160097 | 160097 | 190072 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1700x Quesada Ave | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014428.21738 | 2095237.1411700002 | 37.7339333507341 | -122.392501124441 | (37.7339333507341, -122.392501124441) | ||||
164863 | 164863 | 129537 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306x Montgomery St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | |||
166322 | 166322 | 251051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988530.6021 | 2112606.8245 | 37.780153615018705 | -122.48330884168699 | (37.7801536150187, -122.483308841687) | |||
172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
173829 | 173829 | 197180 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012255.350880001 | 2102175.8421 | 37.752864638318 | -122.40050066956499 | (37.752864638318, -122.400500669565) | ||||
175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
178472 | 178472 | 251037 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990398.0172 | 2112670.1794 | 37.780436072061896 | -122.476853300249 | (37.7804360720619, -122.476853300249) | |||
180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
1039 | 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) | |||
27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
28285 | 28285 | 206831 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994089.87141 | 2101545.69318 | 37.7501046117408 | -122.463274075037 | (37.7501046117408, -122.463274075037) |
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");