Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
2702 | 2702 | 175365 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5993296.25394 | 2087788.76232 | 37.712285726578 | -122.465019407322 | (37.712285726578, -122.465019407322) | |||
2703 | 2703 | 175367 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993394.31846 | 2087754.15211 | 37.7121963492565 | -122.464677958129 | (37.7121963492565, -122.464677958129) | |||
2705 | 2705 | 175366 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5993316.47827 | 2087783.2739799998 | 37.7122718230516 | -122.464949108223 | (37.7122718230516, -122.464949108223) | |||
2708 | 2708 | 175370 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993448.13741 | 2087722.6413599998 | 37.712112930839 | -122.464489658971 | (37.712112930839, -122.464489658971) | |||
2709 | 2709 | 175364 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993263.021319999 | 2087797.41727 | 37.7123075747038 | -122.465134896479 | (37.7123075747038, -122.465134896479) | |||
2716 | 2716 | 175362 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5993185.52762 | 2087808.44828 | 37.7123333942447 | -122.46540353654 | (37.7123333942447, -122.46540353654) | |||
2720 | 2720 | 175369 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993431.63462 | 2087732.39125 | 37.7121387503812 | -122.46454740445101 | (37.7121387503812, -122.464547404451) | |||
2721 | 2721 | 175371 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993471.88559 | 2087712.01586 | 37.712085124705204 | -122.464406808033 | (37.7120851247052, -122.464406808033) | |||
2722 | 2722 | 175368 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993415.10175 | 2087740.6954 | 37.7121605985029 | -122.464605149022 | (37.7121605985029, -122.464605149022) | |||
3382 | 3382 | 122965 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993050.799269999 | 2114904.9128799997 | 37.786725565514004 | -122.467838745487 | (37.786725565514, -122.467838745487) | |||
4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
23444 | 23444 | 201445 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018205.83588 | 2096062.22823 | 37.7364079387746 | -122.379497902505 | (37.7364079387746, -122.379497902505) | |||
23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
23539 | 23539 | 122063 | Undocumented 2 | Ilex spp :: Holly Species 163 | 5 17th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5990505.08019 | 2115005.32961 | 37.786853953760705 | -122.476653573827 | (37.7868539537607, -122.476653573827) | |||
23738 | 23738 | 215457 | Undocumented 2 | Ulmus americana :: American Elm 119 | 170 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992608.79004 | 2095578.76173 | 37.7336354943765 | -122.467961730965 | (37.7336354943765, -122.467961730965) | |||
24030 | 24030 | 136773 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5997087.63405 | 2115382.9814299997 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | |||
24903 | 24903 | 201466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Catalina St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6017699.909990001 | 2096021.8364 | 37.7362691149141 | -122.38124431128 | (37.7362691149141, -122.38124431128) | |||
24990 | 24990 | 130764 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2672 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6000780.4951599995 | 2117576.2259299997 | 37.794503603424 | -122.441287648428 | (37.794503603424, -122.441287648428) | |||
25026 | 25026 | 124921 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Maple St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5996572.93556 | 2115696.21149 | 37.789101010747 | -122.455710282907 | (37.789101010747, -122.455710282907) | |||
25593 | 25593 | 215447 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992597.98393 | 2095879.53795 | 37.7344607266837 | -122.468020961215 | (37.7344607266837, -122.468020961215) | |||
25618 | 25618 | 241059 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6005916.7260300005 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | |||
25802 | 25802 | 187983 | Undocumented 2 | Alnus cordata :: Italian Alder 294 | 1740 Bancroft Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 6013541.30669 | 2092786.45742 | 37.7271549806017 | -122.395395842461 | (37.7271549806017, -122.395395842461) | |||
26150 | 26150 | 130766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2672 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6000749.67266 | 2117573.07322 | 37.79449319107189 | -122.441394071498 | (37.7944931910719, -122.441394071498) | |||
26155 | 26155 | 190587 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1245 03rd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6015583.31199 | 2109308.81865 | 37.7726352865222 | -122.38948996669701 | (37.7726352865222, -122.389489966697) | |||
26364 | 26364 | 126688 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000574.048880001 | 2117936.56798 | 37.79548124560729 | -122.44202785340201 | (37.7954812456073, -122.442027853402) | |||
26566 | 26566 | 250534 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 70 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5988031.60804 | 2115549.24332 | 37.7882036078474 | -122.485251031835 | (37.7882036078474, -122.485251031835) | |||
26694 | 26694 | 124453 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 61 Edward St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5995857.77274 | 2111686.71555 | 37.7780509386546 | -122.457894375539 | (37.7780509386546, -122.457894375539) | |||
27032 | 27032 | 203761 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Portola Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5991748.48888 | 2096138.80576 | 37.73512351624029 | -122.470976798948 | (37.7351235162403, -122.470976798948) | |||
27131 | 27131 | 215446 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992597.86385 | 2095891.15575 | 37.7344926193226 | -122.468022221156 | (37.7344926193226, -122.468022221156) | |||
27154 | 27154 | 192389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 450 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6018217.012999999 | 2099612.2395900004 | 37.746156176965606 | -122.37970582128901 | (37.7461561769656, -122.379705821289) | |||
27238 | 27238 | 124451 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 61 Edward St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5995921.71899 | 2111694.81562 | 37.7780768529354 | -122.457673750202 | (37.7780768529354, -122.457673750202) | |||
28365 | 28365 | 223874 | Undocumented 2 | Cycas revoluta :: Sago palm 359 | 2712 Bryant St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6009766.52355 | 2101514.6779099996 | 37.750910116518 | -122.409060886278 | (37.750910116518, -122.409060886278) | |||
28433 | 28433 | 175352 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Brotherhood Way | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5993139.4707 | 2087896.7194400001 | 37.7125731094281 | -122.46556913053301 | (37.7125731094281, -122.465569130533) | |||
28460 | 28460 | 211766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992106.77002 | 2095921.0899200002 | 37.73454643836789 | -122.469722258175 | (37.7345464383679, -122.469722258175) | |||
28469 | 28469 | 133683 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003639.65716 | 2120421.26895 | 37.8024778119699 | -122.431597810397 | (37.8024778119699, -122.431597810397) | |||
28498 | 28498 | 218176 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1450 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992814.7731 | 2097288.8664 | 37.7383429066102 | -122.467373901707 | (37.7383429066102, -122.467373901707) | |||
28938 | 28938 | 201582 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020666.22255 | 2092954.7050599998 | 37.7280106612574 | -122.370776399631 | (37.7280106612574, -122.370776399631) | |||
29385 | 29385 | 241060 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.735075558995206 | -122.421928139697 | (37.7350755589952, -122.421928139697) | |||
29496 | 29496 | 215453 | Undocumented 2 | Ulmus americana :: American Elm 119 | 130 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992604.15491 | 2095739.66057 | 37.734077014732705 | -122.46798945526501 | (37.7340770147327, -122.467989455265) | |||
29517 | 29517 | 135087 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010278.59779 | 2122338.55223 | 37.8081162545339 | -122.408759020708 | (37.8081162545339, -122.408759020708) | |||
29917 | 29917 | 211768 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 120 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 5ft | 5992110.677069999 | 2095846.95978 | 37.7343431214426 | -122.469703355335 | (37.7343431214426, -122.469703355335) | |||
30168 | 30168 | 122242 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1628 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5990370.4799 | 2114772.2223799997 | 37.7862060986385 | -122.477102214032 | (37.7862060986385, -122.477102214032) | |||
30613 | 30613 | 175346 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Brotherhood Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993589.7174 | 2087738.26685 | 37.712163995237105 | -122.464001454798 | (37.7121639952371, -122.464001454798) | |||
31296 | 31296 | 221186 | Undocumented 2 | Azara microphylla :: Little-Leaf Azara 295 | 2 Bird St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 5ft | 6005971.92074 | 2105741.10447 | 37.7623015995533 | -122.422483282201 | (37.7623015995533, -122.422483282201) | |||
31358 | 31358 | 191605 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2400 Mendell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6013387.2032 | 2093129.03799 | 37.7280870649434 | -122.39595257676399 | (37.7280870649434, -122.395952576764) | |||
31470 | 31470 | 236880 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5999599.46075 | 2106928.4775400003 | 37.7652002791041 | -122.44460850030701 | (37.7652002791041, -122.444608500307) | |||
31655 | 31655 | 124443 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 5996014.365230001 | 2111743.99955 | 37.778217220689 | -122.457356814692 | (37.778217220689, -122.457356814692) | |||
31717 | 31717 | 135070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010442.39712 | 2122245.83866 | 37.8078708592274 | -122.4081856049 | (37.8078708592274, -122.4081856049) | |||
31719 | 31719 | 218144 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 74 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5997132.65616 | 2090034.31598 | 37.7186719635242 | -122.451921626186 | (37.7186719635242, -122.451921626186) | |||
31752 | 31752 | 250543 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5988034.75992 | 2115431.27896 | 37.78787989509 | -122.485231467955 | (37.78787989509, -122.485231467955) | |||
32044 | 32044 | 218190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5993083.56044 | 2097460.2146099997 | 37.738828899343204 | -122.466457024875 | (37.7388288993432, -122.466457024875) | |||
32205 | 32205 | 201465 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 221 Catalina St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 6017857.702409999 | 2096046.34832 | 37.736345129211294 | -122.380700455256 | (37.7363451292113, -122.380700455256) | |||
32864 | 32864 | 218189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1421 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 5993057.32079 | 2097427.16876 | 37.7387366495817 | -122.46654534729299 | (37.7387366495817, -122.466545347293) | |||
32907 | 32907 | 126694 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000564.04952 | 2118006.17276 | 37.7956717921666 | -122.44206745147 | (37.7956717921666, -122.44206745147) | |||
33022 | 33022 | 187984 | Undocumented 2 | Alnus cordata :: Italian Alder 294 | 1740 Bancroft Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 6013523.184119999 | 2092800.1784400002 | 37.7271916477681 | -122.395459453304 | (37.7271916477681, -122.395459453304) | |||
33352 | 33352 | 203352 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5991879.77556 | 2095665.97475 | 37.733832833509396 | -122.470488472467 | (37.7338328335094, -122.470488472467) | |||
33512 | 33512 | 228422 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 840 27th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001124.36874 | 2099998.4940400003 | 37.746259119672 | -122.438837573191 | (37.746259119672, -122.438837573191) | |||
33548 | 33548 | 215452 | Undocumented 2 | Ulmus americana :: American Elm 119 | 130 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992604.2406 | 2095761.0748 | 37.7341358178054 | -122.467990716115 | (37.7341358178054, -122.467990716115) | |||
33678 | 33678 | 135076 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010384.52328 | 2122278.10501 | 37.807956213866 | -122.408388169972 | (37.807956213866, -122.408388169972) | |||
33718 | 33718 | 205774 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 367 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5994104.037819999 | 2099097.57437 | 37.743383512235496 | -122.46304748455401 | (37.7433835122355, -122.463047484554) | |||
33854 | 33854 | 124441 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 5996092.3035699995 | 2111750.82416 | 37.7782404354383 | -122.45708769291402 | (37.7782404354383, -122.457087692914) | |||
34056 | 34056 | 124444 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5995959.12368 | 2111736.70034 | 37.778194005969 | -122.45754738597401 | (37.778194005969, -122.457547385974) | |||
34335 | 34335 | 201443 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6018205.670580001 | 2096108.31022 | 37.736534461697104 | -122.379501674263 | (37.7365344616971, -122.379501674263) | |||
34960 | 34960 | 135084 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010314.2182599995 | 2122318.99449 | 37.8080645489009 | -122.40863436569201 | (37.8080645489009, -122.408634365692) | |||
35188 | 35188 | 191596 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 450 Amador St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018234.420580001 | 2099614.56318 | 37.74616351723 | -122.379645788832 | (37.74616351723, -122.379645788832) | |||
35570 | 35570 | 240617 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6003712.72581 | 2104261.51662 | 37.7581112975082 | -122.43019142809099 | (37.7581112975082, -122.430191428091) | |||
35635 | 35635 | 218057 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5991870.78261 | 2095844.7512599998 | 37.73432318885929 | -122.47053257972401 | (37.7343231888593, -122.470532579724) | |||
35642 | 35642 | 175347 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Brotherhood Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993550.997219999 | 2087766.5420799998 | 37.712239400706395 | -122.464137333384 | (37.7122394007064, -122.464137333384) | |||
35773 | 35773 | 121884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5990230.5783400005 | 2114834.8193200002 | 37.78636985483121 | -122.477590808601 | (37.7863698548312, -122.477590808601) | |||
35979 | 35979 | 215448 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992599.75801 | 2095859.8997900002 | 37.7344069076591 | -122.46801339970501 | (37.7344069076591, -122.468013399705) | |||
36013 | 36013 | 201469 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Catalina St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6017698.8541 | 2095974.10398 | 37.7361379928748 | -122.381244644042 | (37.7361379928748, -122.381244644042) | |||
37132 | 37132 | 211777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 180 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 5ft | 5992120.545080001 | 2095553.8250099998 | 37.7335388172519 | -122.46964790585 | (37.7335388172519, -122.46964790585) | |||
37319 | 37319 | 124448 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 5995755.70235 | 2111706.15448 | 37.778098448140895 | -122.458248878605 | (37.7780984481409, -122.458248878605) | |||
37410 | 37410 | 211776 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 170 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 5ft | 5992119.752169999 | 2095585.4214 | 37.73362552719011 | -122.46965294655001 | (37.7336255271901, -122.46965294655) | |||
37621 | 37621 | 250510 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 75 27th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5987308.66603 | 2115522.71145 | 37.788088617839705 | -122.487750306256 | (37.7880886178397, -122.487750306256) | |||
37918 | 37918 | 126693 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000564.95745 | 2118000.54097 | 37.7956563804956 | -122.44206390543002 | (37.7956563804956, -122.44206390543) | |||
38144 | 38144 | 201442 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6018207.71631 | 2096124.7676 | 37.736579763236705 | -122.37949574413601 | (37.7365797632367, -122.379495744136) | |||
38268 | 38268 | 222737 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 840 27th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001059.80246 | 2099994.7201799997 | 37.7462450839594 | -122.439060564612 | (37.7462450839594, -122.439060564612) | |||
38616 | 38616 | 215454 | Undocumented 2 | Ulmus americana :: American Elm 119 | 160 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992606.05096 | 2095656.4975700001 | 37.733848779404795 | -122.46797685305401 | (37.7338487794048, -122.467976853054) | |||
38633 | 38633 | 250514 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5987350.46748 | 2115543.99511 | 37.788149494743706 | -122.487607246587 | (37.7881494947437, -122.487607246587) | |||
38754 | 38754 | 219028 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1490 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5991185.310269999 | 2105281.9213400004 | 37.76019555188989 | -122.473590620024 | (37.7601955518899, -122.473590620024) | |||
38804 | 38804 | 218054 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991875.535130001 | 2095741.56423 | 37.7340401380298 | -122.470508636163 | (37.7340401380298, -122.470508636163) | |||
38879 | 38879 | 133686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 6003672.54238 | 2120178.33709 | 37.801812648208 | -122.43146665866301 | (37.801812648208, -122.431466658663) | |||
39010 | 39010 | 188236 | Undocumented 2 | Archontophoenix cunninghamiana :: King Palm 210 | 1108 Rhode Island St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6011896.7371 | 2103246.34422 | 37.755783996849 | -122.401816071954 | (37.755783996849, -122.401816071954) | |||
39016 | 39016 | 215462 | Undocumented 2 | Ulmus americana :: American Elm 119 | 196 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992612.6930599995 | 2095452.3609 | 37.733288654633704 | -122.467939046451 | (37.7332886546337, -122.467939046451) | |||
39232 | 39232 | 132164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011515.19186 | 2120799.8495099996 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | |||
39667 | 39667 | 121886 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 18th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5990230.2479 | 2114806.89873 | 37.786293173551 | -122.47758991028499 | (37.786293173551, -122.477589910285) | |||
39845 | 39845 | 236879 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5999597.94254 | 2106903.1548099997 | 37.7651306625862 | -122.44461193121599 | (37.7651306625862, -122.444611931216) | |||
40492 | 40492 | 215456 | Undocumented 2 | Ulmus americana :: American Elm 119 | 170 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992607.47204 | 2095602.74615 | 37.73370127349371 | -122.46796803159599 | (37.7337012734937, -122.467968031596) | |||
40630 | 40630 | 124449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 5995696.13098 | 2111699.5362400003 | 37.7780768529151 | -122.45845447691299 | (37.7780768529151, -122.458454476913) | |||
40874 | 40874 | 118059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 478 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5984726.55462 | 2112637.2362 | 37.780014996055 | -122.496470823095 | (37.780014996055, -122.496470823095) | |||
41197 | 41197 | 227088 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | |||
41465 | 41465 | 228421 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 840 27th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001133.99652 | 2099998.61422 | 37.746259997407705 | -122.438804290182 | (37.7462599974077, -122.438804290182) | |||
42323 | 42323 | 126124 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | |||
42480 | 42480 | 250519 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 5987405.1087 | 2115487.58099 | 37.787997784516 | -122.487414054232 | (37.787997784516, -122.487414054232) | |||
42557 | 42557 | 205256 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1490 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5991184.504790001 | 2105292.04801 | 37.7602233103899 | -122.473594144473 | (37.7602233103899, -122.473594144473) | |||
43023 | 43023 | 133488 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Spruce St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 5997064.99147 | 2115637.7546099997 | 37.7889687294832 | -122.454003617874 | (37.7889687294832, -122.454003617874) | |||
43130 | 43130 | 188825 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1888 Illinois St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6016272.37699 | 2100354.77616 | 37.7480875745024 | -122.38648195390199 | (37.7480875745024, -122.386481953902) |
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");