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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22832 | 22832 | 251108 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22838 | 22838 | 251111 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
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) | |||
23423 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
27329 | 27329 | 194334 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | |||
27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
27382 | 27382 | 220720 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6009105.68993 | 2100578.18161 | 37.7483016643881 | -122.411279971504 | (37.7483016643881, -122.411279971504) | |||
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) | |||
27503 | 27503 | 208879 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100x Idora Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 9ft | 5995727.40355 | 2099320.3409700003 | 37.74408855195821 | -122.457450449475 | (37.7440885519582, -122.457450449475) | |||
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) | |||
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) | ||||
27563 | 27563 | 197474 | DPW Maintained 3 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 1700x Quesada Ave | 47 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6014305.55494 | 2095325.1628400001 | 37.7341682275767 | -122.392931365507 | (37.7341682275767, -122.392931365507) | ||||
27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
27702 | 27702 | 191370 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 63 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012517.15762 | 2102887.31193 | 37.75483277672829 | -122.399645237162 | (37.7548327767283, -122.399645237162) | ||||
27755 | 27755 | 211070 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5995378.929819999 | 2093188.4321700002 | 37.7272318087773 | -122.45821166894699 | (37.7272318087773, -122.458211668947) | ||||
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) | ||||
27830 | 27830 | 195766 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014104.3852699995 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | |||
27904 | 27904 | 210220 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993632.14987 | 2096264.78649 | 37.7355781918881 | -122.464473499973 | (37.7355781918881, -122.464473499973) | ||||
27977 | 27977 | 195679 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015392.54447 | 2111760.15634 | 37.779355535273105 | -122.390321157906 | (37.7793555352731, -122.390321157906) | |||
27995 | 27995 | 211600 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | ||||
28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
28194 | 28194 | 195471 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014542.5915 | 2117352.94839 | 37.794664873444795 | -122.393653075045 | (37.7946648734448, -122.393653075045) | ||||
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) | |||
28390 | 28390 | 195474 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014565.75221 | 2117404.86556 | 37.794808712796396 | -122.393576570627 | (37.7948087127964, -122.393576570627) | ||||
28399 | 28399 | 211132 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 5994073.5471 | 2101557.9336599996 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | |||
28694 | 28694 | 246559 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.42360165389299 | (37.7722588698898, -122.423601653893) | |||
28724 | 28724 | 199407 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016184.136419999 | 2096191.07332 | 37.736650012889 | -122.386496812495 | (37.736650012889, -122.386496812495) | ||||
28806 | 28806 | 217820 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1x Junipero Serra Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5991627.31768 | 2095659.9754599999 | 37.733801760145504 | -122.471360849935 | (37.7338017601455, -122.471360849935) | ||||
28854 | 28854 | 246564 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | |||
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) | |||
29064 | 29064 | 194335 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403588999 | (37.7809992081901, -122.38849403589) | |||
29290 | 29290 | 204967 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5995373.3226 | 2092827.47447 | 37.7262403835647 | -122.45820493933 | (37.7262403835647, -122.45820493933) | ||||
29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
29486 | 29486 | 212111 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 5992507.56631 | 2095396.9538900002 | 37.7331304494932 | -122.46829846591801 | (37.7331304494932, -122.468298465918) | |||
29492 | 29492 | 194379 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | |||
29552 | 29552 | 211129 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 5994111.36343 | 2101512.4621099997 | 37.7500146058056 | -122.463197343983 | (37.7500146058056, -122.463197343983) | |||
29553 | 29553 | 211075 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 650x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | ||||
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) | |||
29681 | 29681 | 211122 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 5994167.1459 | 2101393.52573 | 37.749691250071 | -122.462995818511 | (37.749691250071, -122.462995818511) | |||
29712 | 29712 | 244826 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 500x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6004940.864159999 | 2105188.02891 | 37.760724766043 | -122.42600994929501 | (37.760724766043, -122.426009949295) | ||||
29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
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) | ||||
29957 | 29957 | 187712 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013733.01886 | 2087017.8562099999 | 37.7113262093072 | -122.39432937061301 | (37.7113262093072, -122.394329370613) | |||
30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) |
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");