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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127275 | 127275 | 234411 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 10x Benton Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004755.33467 | 2095032.93123 | 37.7328307189427 | -122.42592872073601 | (37.7328307189427, -122.425928720736) | ||||
153921 | 153921 | 231443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10x Benton Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6004814.81075 | 2095028.31001 | 37.7328213911887 | -122.425722767894 | (37.7328213911887, -122.425722767894) | ||||
167787 | 167787 | 234517 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 10x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004828.724280001 | 2095028.54608 | 37.7328228256069 | -122.425674682059 | (37.7328228256069, -122.425674682059) | ||||
174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
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) | ||||
32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
64206 | 64206 | 190913 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 10x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017428.5626 | 2095806.2606900001 | 37.73566220385221 | -122.38216748876002 | (37.7356622038522, -122.38216748876) | ||||
134097 | 134097 | 189485 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Garlington Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016768.7449900005 | 2094679.8943900003 | 37.7325329624249 | -122.384370330438 | (37.7325329624249, -122.384370330438) | |||
53230 | 53230 | 248775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6002997.286669999 | 2095073.79392 | 37.732843406592295 | -122.432009651347 | (37.7328434065923, -122.432009651347) | |||
135595 | 135595 | 248774 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6003001.138169999 | 2095064.3103599998 | 37.7328175852443 | -122.43199565878 | (37.7328175852443, -122.43199565878) | |||
163293 | 163293 | 248777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6002988.77776 | 2095086.3960799999 | 37.7328775268597 | -122.43203996838699 | (37.7328775268597, -122.432039968387) | |||
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) | |||
33003 | 33003 | 194020 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011361.40113 | 2093925.29225 | 37.7301604996095 | -122.403011863611 | (37.7301604996095, -122.403011863611) | ||||
38678 | 38678 | 194023 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6011366.79301 | 2093982.63877 | 37.730318262277606 | -122.402997255042 | (37.7303182622776, -122.402997255042) | |||
38839 | 38839 | 194025 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6011395.816869999 | 2093961.4424599998 | 37.730261682333605 | -122.402895424807 | (37.7302616823336, -122.402895424807) | |||
73605 | 73605 | 194022 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011349.26404 | 2093964.0599200001 | 37.7302662697704 | -122.403056549132 | (37.7302662697704, -122.403056549132) | |||
131420 | 131420 | 194026 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6011390.96705 | 2093942.9768299998 | 37.730210708757504 | -122.40291089314199 | (37.7302107087575, -122.402910893142) | |||
150276 | 150276 | 194024 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6011380.0136 | 2093972.7166799998 | 37.7302917565413 | -122.4029508518 | (37.7302917565413, -122.4029508518) | |||
173363 | 173363 | 194027 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6011379.88735 | 2093929.83608 | 37.730174008312 | -122.40294827345501 | (37.730174008312, -122.402948273455) | ||||
174310 | 174310 | 194021 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6011358.20125 | 2093944.86355 | 37.730214059626 | -122.403024302127 | (37.730214059626, -122.403024302127) | ||||
25390 | 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) | |||
32862 | 32862 | 132075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | |||
37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
48115 | 48115 | 132100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.802820809805496 | -122.400753698321 | (37.8028208098055, -122.400753698321) | |||
49479 | 49479 | 132094 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012848.0944 | 2119927.2949200002 | 37.8016391096046 | -122.39969713882601 | (37.8016391096046, -122.399697138826) | |||
56654 | 56654 | 132101 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | |||
59618 | 59618 | 132097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012695.81427 | 2120154.0888900002 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | |||
61544 | 61544 | 132098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.802442786052396 | -122.40041578348699 | (37.8024427860524, -122.400415783487) | |||
75574 | 75574 | 132078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012663.130340001 | 2120132.51785 | 37.8021922897941 | -122.40035162582899 | (37.8021922897941, -122.400351625829) | |||
76777 | 76777 | 132095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.801847701082394 | -122.39987323058901 | (37.8018477010824, -122.399873230589) | |||
129992 | 129992 | 132099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.40060816104099 | (37.8026555899447, -122.400608161041) | |||
135157 | 135157 | 132081 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012501.69351 | 2120366.8481099997 | 37.802826700352995 | -122.400926752172 | (37.802826700353, -122.400926752172) | |||
150555 | 150555 | 132096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | |||
164266 | 164266 | 132076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012766.891340001 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | |||
176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
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) | |||
169889 | 169889 | 249473 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006432.644069999 | 2114489.3949 | 37.7863482830936 | -122.42151114382901 | (37.7863482830936, -122.421511143829) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
33156 | 33156 | 234362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | ||||
63890 | 63890 | 234360 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | ||||
132937 | 132937 | 234364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005148.136969999 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | ||||
151204 | 151204 | 234363 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | ||||
154721 | 154721 | 234361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005142.97819 | 2101556.59196 | 37.75076510982829 | -122.42505254004699 | (37.7507651098283, -122.425052540047) | ||||
158301 | 158301 | 234365 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | ||||
27523 | 27523 | 197764 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015565.1078 | 2103547.1261299998 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | |||
29638 | 29638 | 197767 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015569.446690001 | 2103464.9174599997 | 37.756588430534 | -122.38912981161002 | (37.756588430534, -122.38912981161) | |||
49253 | 49253 | 197768 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | |||
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) | |||
151971 | 151971 | 194274 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6015578.255919999 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | ||||
152917 | 152917 | 194273 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6015573.17514 | 2103426.7647700002 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | |||
162901 | 162901 | 197765 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 8ft | 6015567.051530001 | 2103517.02147 | 37.756731364291 | -122.389141732999 | (37.756731364291, -122.389141732999) | |||
173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
174960 | 174960 | 200449 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1150x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6015546.9238599995 | 2103710.0991 | 37.7572603985698 | -122.389224824085 | (37.7572603985698, -122.389224824085) | |||
178786 | 178786 | 197766 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6015570.19786 | 2103483.2933099996 | 37.756638928352 | -122.38912849679701 | (37.756638928352, -122.389128496797) | |||
24947 | 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) | ||||
158032 | 158032 | 206808 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5991782.03455 | 2095997.5477200001 | 37.734737597362205 | -122.470850534124 | (37.7347375973622, -122.470850534124) | ||||
70908 | 70908 | 195237 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017245.0547 | 2097350.40694 | 37.7398919834226 | -122.38290938175699 | (37.7398919834226, -122.382909381757) | ||||
71743 | 71743 | 195234 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017566.91027 | 2097112.20997 | 37.7392557202661 | -122.38177996546999 | (37.7392557202661, -122.38177996547) | ||||
76154 | 76154 | 195239 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017229.97011 | 2097361.8640799997 | 37.739922608954394 | -122.38296233565 | (37.7399226089544, -122.38296233565) | ||||
149614 | 149614 | 195238 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6017232.2408 | 2097349.7546 | 37.7398894842228 | -122.382953641924 | (37.7398894842228, -122.382953641924) | ||||
162122 | 162122 | 195236 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017248.0064199995 | 2097338.05613 | 37.7398582336715 | -122.382898316528 | (37.7398582336715, -122.382898316528) | ||||
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) | ||||
34485 | 34485 | 196775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013724.81339 | 2108580.1885900004 | 37.7705314116112 | -122.395867690649 | (37.7705314116112, -122.395867690649) | ||||
47301 | 47301 | 196777 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6013719.28205 | 2108540.3195 | 37.7704216322684 | -122.39588402954901 | (37.7704216322684, -122.395884029549) | ||||
71354 | 71354 | 196776 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013727.65184 | 2108557.08318 | 37.770468127221996 | -122.39585625305901 | (37.770468127222, -122.395856253059) | ||||
134720 | 134720 | 196778 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6013693.538240001 | 2108528.6115 | 37.770388052484 | -122.395972257526 | (37.770388052484, -122.395972257526) | ||||
136493 | 136493 | 196773 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6013682.900640001 | 2108609.73036 | 37.7706101949263 | -122.396014738786 | (37.7706101949263, -122.396014738786) | ||||
136588 | 136588 | 196772 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013659.43182 | 2108608.5315799997 | 37.770605597593395 | -122.396095834269 | (37.7706055975934, -122.396095834269) | ||||
154551 | 154551 | 196774 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013709.1698900005 | 2108600.73146 | 37.7705869474505 | -122.395923241791 | (37.7705869474505, -122.395923241791) | ||||
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) | ||||
47529 | 47529 | 132102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6012409.883230001 | 2120572.1173400003 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | |||
65398 | 65398 | 132082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012375.04896 | 2120549.1986599998 | 37.803320325622295 | -122.40137783233999 | (37.8033203256223, -122.40137783234) | |||
70617 | 70617 | 132083 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012328.94165 | 2120621.527 | 37.8035163490725 | -122.401542475719 | (37.8035163490725, -122.401542475719) | |||
176923 | 176923 | 132084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012274.61558 | 2120706.35336 | 37.8037462301721 | -122.401736440606 | (37.8037462301721, -122.401736440606) | |||
35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
49786 | 49786 | 249475 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006389.52859 | 2114780.4065099997 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | ||||
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) | ||||
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) | |||||
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) | |||||
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) | |||||
35780 | 35780 | 128877 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.0884300005 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | ||||
38785 | 38785 | 136006 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007669.82361 | 2118117.1353700003 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | ||||
44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
147922 | 147922 | 131159 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1237x Robert C Levy Tunl | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6007700.78305 | 2118156.69801 | 37.7964892156499 | -122.41738368460199 | (37.7964892156499, -122.417383684602) | ||||
151682 | 151682 | 128876 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | ||||
154063 | 154063 | 131160 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1237x Robert C Levy Tunl | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6007730.43085 | 2118156.7577 | 37.7964910475791 | -122.41728110074301 | (37.7964910475791, -122.417281100743) | ||||
158482 | 158482 | 131157 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1237x Robert C Levy Tunl | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6007693.00329 | 2118120.33005 | 37.7963889205679 | -122.417408025681 | (37.7963889205679, -122.417408025681) | ||||
164473 | 164473 | 136005 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | ||||
164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
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) | ||||
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) | ||||
110134 | 110134 | 117310 | Permitted Site 1 | Tree(s) :: 17 | 126X Juan Bautista Cir | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777998 | 5989282.4 | 2089642.3 | 37.7171428191075 | -122.479027821944 | (37.7171428191075, -122.479027821944) | |
10408 | 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) | ||||
11659 | 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) | ||||
29933 | 29933 | 188870 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300x De Haro St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.40039382202299 | (37.7524393767806, -122.400393822023) | ||||
30213 | 30213 | 194449 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1300x De Haro St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6012259.687999999 | 2102130.23115 | 37.752739642445505 | -122.40048246731399 | (37.7527396424455, -122.400482467314) |
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");