Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, SiteOrder, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2211 | 2211 | 188595 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/05/2017 12:00:00 AM | 3 | Width 7ft | 6011997.611930001 | 2102271.8897 | 37.7531139870419 | -122.401398733477 | (37.7531139870419, -122.401398733477) | ||
4184 | 4184 | 180651 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:53:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
4196 | 4196 | 251778 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:02:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
4249 | 4249 | 180650 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:41:00 AM | 3 | Width 7ft | 6001253.45718 | 2087396.1433599999 | 37.7116632967974 | -122.437488893205 | (37.7116632967974, -122.437488893205) | ||
4272 | 4272 | 251777 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:57:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
27144 | 27144 | 120835 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 39 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 5989870.35579 | 2114909.24265 | 37.786553290140205 | -122.47884251842501 | (37.7865532901402, -122.478842518425) | |||
28201 | 28201 | 234514 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009944.54234 | 2103430.26244 | 37.7561798559202 | -122.408580392894 | (37.7561798559202, -122.408580392894) | |||
29855 | 29855 | 198531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.736898746479895 | -122.392556198035 | (37.7368987464799, -122.392556198035) | |||
32041 | 32041 | 223379 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2730 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 7ft | 6009758.65341 | 2103393.8455 | 37.756069450652795 | -122.4092206931 | (37.7560694506528, -122.4092206931) | |||
32101 | 32101 | 122195 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 7ft | 5991459.5618199995 | 2114871.1888599996 | 37.786540956413205 | -122.47334153385799 | (37.7865409564132, -122.473341533858) | |||
34104 | 34104 | 120838 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 55 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 5989873.67504 | 2114823.8325 | 37.7863189706432 | -122.47882478569299 | (37.7863189706432, -122.478824785693) | |||
38647 | 38647 | 122188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 7ft | 5991455.25466 | 2115068.89976 | 37.7870835661247 | -122.473370861161 | (37.7870835661247, -122.473370861161) | |||
39645 | 39645 | 120839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 55 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 5989874.45589 | 2114802.5830900003 | 37.7862606710831 | -122.47882052946899 | (37.7862606710831, -122.478820529469) | |||
42467 | 42467 | 122191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 7ft | 5991455.42177 | 2114972.80191 | 37.7868197178511 | -122.47336327131501 | (37.7868197178511, -122.473363271315) | |||
43471 | 43471 | 232438 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 Florida St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009220.36399 | 2105639.7439 | 37.762206006125396 | -122.41124093103399 | (37.7622060061254, -122.411240931034) | |||
47708 | 47708 | 201384 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018192.32323 | 2095410.89535 | 37.73461876184721 | -122.379499389078 | (37.7346187618472, -122.379499389078) | |||
47889 | 47889 | 135126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6009794.33207 | 2122480.55113 | 37.808479012257706 | -122.410444987853 | (37.8084790122577, -122.410444987853) | |||
50223 | 50223 | 191523 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 7ft | 6015501.46651 | 2104207.8933 | 37.7586247150714 | -122.389416796942 | (37.7586247150714, -122.389416796942) | |||
50861 | 50861 | 242785 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009778.64704 | 2103394.74604 | 37.7560730434384 | -122.409151611674 | (37.7560730434384, -122.409151611674) | |||
51140 | 51140 | 232437 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 Florida St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009218.18097 | 2105675.07688 | 37.762302899984796 | -122.41125097736901 | (37.7623028999848, -122.411250977369) | |||
53945 | 53945 | 198518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014349.89775 | 2096310.6445799998 | 37.7368766213595 | -122.392846979413 | (37.7368766213595, -122.392846979413) | |||
58465 | 58465 | 225227 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2700 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009911.03097 | 2103403.5616 | 37.756104664524 | -122.408694403538 | (37.756104664524, -122.408694403538) | |||
59133 | 59133 | 227950 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009943.9384 | 2103453.89323 | 37.756244706952295 | -122.408584148445 | (37.7562447069523, -122.408584148445) | |||
59944 | 59944 | 198525 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977203995 | -122.391751642923 | (37.736441977204, -122.391751642923) | |||
61085 | 61085 | 198534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014341.63524 | 2096385.88519 | 37.7370827576597 | -122.392880809218 | (37.7370827576597, -122.392880809218) | |||
64672 | 64672 | 201451 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.15931 | 2095830.10025 | 37.735770303244294 | -122.379497951066 | (37.7357703032443, -122.379497951066) | |||
65552 | 65552 | 232439 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 Florida St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009231.6785699995 | 2105511.08607 | 37.761853375653 | -122.41119270939801 | (37.761853375653, -122.411192709398) | |||
65978 | 65978 | 197181 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1301 Rhode Island St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6011998.69489 | 2102279.56036 | 37.7531351094233 | -122.40139552739201 | (37.7531351094233, -122.401395527392) | |||
67195 | 67195 | 201447 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.6528199995 | 2095922.70915 | 37.7360246162273 | -122.379502676117 | (37.7360246162273, -122.379502676117) | |||
67533 | 67533 | 234513 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009942.57021 | 2103461.5506 | 37.7562656557487 | -122.408589420289 | (37.7562656557487, -122.408589420289) | |||
68023 | 68023 | 201453 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018197.87092 | 2095750.8837 | 37.7355526088591 | -122.37950381915199 | (37.7355526088591, -122.379503819152) | |||
70501 | 70501 | 201446 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018203.56195 | 2095942.2457299998 | 37.7360783651123 | -122.37949743215599 | (37.7360783651123, -122.379497432156) | |||
71342 | 71342 | 201450 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 6018200.75737 | 2095847.6313 | 37.735818417881106 | -122.379500558206 | (37.7358184178811, -122.379500558206) | |||
72620 | 72620 | 201382 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018191.80275 | 2095463.53858 | 37.7347632810917 | -122.379504844387 | (37.7347632810917, -122.379504844387) | |||
73547 | 73547 | 191524 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 7ft | 6015503.99036 | 2104179.13483 | 37.7585458903883 | -122.38940605994499 | (37.7585458903883, -122.389406059945) | |||
74870 | 74870 | 228377 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 1102 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 7ft | 6009982.45484 | 2102743.6436400004 | 37.7542966773511 | -122.408400848645 | (37.7542966773511, -122.408400848645) | |||
74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
75067 | 75067 | 122189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 5991458.245630001 | 2115020.83895 | 37.786951777712495 | -122.47335700646799 | (37.7869517777125, -122.473357006468) | |||
75964 | 75964 | 229301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 7ft | 6004947.77286 | 2104335.41432 | 37.75838407807579 | -122.42592536178002 | (37.7583840780758, -122.42592536178) | |||
76234 | 76234 | 198526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014646.0524 | 2096160.0564599999 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | |||
76492 | 76492 | 201448 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.246669999 | 2095899.23828 | 37.735960147450704 | -122.379502450391 | (37.7359601474507, -122.379502450391) | |||
109198 | 109198 | 193851 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014478.009330001 | 2096283.4252799999 | 37.7368089977332 | -122.392402134273 | (37.7368089977332, -122.392402134273) | |||
122539 | 122539 | 190926 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1303 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6012003.88758 | 2102215.75937 | 37.7529602155494 | -122.40137308660401 | (37.7529602155494, -122.401373086604) | |||
126756 | 126756 | 202160 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1901 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6013174.41964 | 2093345.4419200001 | 37.7286694254389 | -122.396703346088 | (37.7286694254389, -122.396703346088) | |||
129816 | 129816 | 198516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014335.026380001 | 2096322.17337 | 37.736907451020606 | -122.392899203062 | (37.7369074510206, -122.392899203062) | |||
131093 | 131093 | 198520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6014468.3432 | 2096223.93289 | 37.7366451070745 | -122.392431394602 | (37.7366451070745, -122.392431394602) | |||
133528 | 133528 | 122190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 27 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 7ft | 5991456.07949 | 2114996.8975 | 37.786885915721996 | -122.473362753885 | (37.786885915722, -122.473362753885) | |||
135251 | 135251 | 198533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014374.32844 | 2096361.3025900002 | 37.737017074781896 | -122.392766053934 | (37.7370170747819, -122.392766053934) | |||
135349 | 135349 | 233915 | Undocumented 2 | Persea americana :: Avocado 113 | 998 York St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.01185 | 2103432.65253 | 37.756186332856295 | -122.408585854469 | (37.7561863328563, -122.408585854469) | |||
136710 | 136710 | 191525 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6015505.26646 | 2104138.41993 | 37.758434166722395 | -122.38939880333099 | (37.7584341667224, -122.389398803331) | |||
137036 | 137036 | 198519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 6014430.37923 | 2096250.7581099998 | 37.7367166553422 | -122.39256452932699 | (37.7367166553422, -122.392564529327) | |||
137330 | 137330 | 228378 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 1102 York St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 7ft | 6009982.64105 | 2102733.41799 | 37.754268610424106 | -122.40839948345301 | (37.7542686104241, -122.408399483453) | |||
146409 | 146409 | 248641 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 69 Fair Oaks St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 7ft | 6005403.80316 | 2103339.90036 | 37.7556763911732 | -122.424277402685 | (37.7556763911732, -122.424277402685) | |||
146815 | 146815 | 246518 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 155 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 7ft | 6005162.55314 | 2109484.17323 | 37.7725334778669 | -122.42554898739701 | (37.7725334778669, -122.425548987397) | |||
147808 | 147808 | 227948 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.19062 | 2103487.1600900004 | 37.756335896405396 | -122.40859599791 | (37.7563358964054, -122.40859599791) | |||
149823 | 149823 | 201454 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018196.93035 | 2095729.08903 | 37.73549271311771 | -122.379505557543 | (37.7354927131177, -122.379505557543) | |||
149918 | 149918 | 198528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014599.09575 | 2096195.7007900001 | 37.736574847558295 | -122.39197734938601 | (37.7365748475583, -122.391977349386) | |||
150324 | 150324 | 198535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014325.04496 | 2096399.73326 | 37.73711986009079 | -122.392939138341 | (37.7371198600908, -122.392939138341) | |||
150944 | 150944 | 135124 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009811.99757 | 2122478.3969 | 37.8084740875856 | -122.41038369905701 | (37.8084740875856, -122.410383699057) | |||
154449 | 154449 | 198530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.39248265324899 | (37.7368601394856, -122.392482653249) | |||
155539 | 155539 | 190952 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 50 Southern Heights Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6012228.79731 | 2104083.07063 | 37.7580999894276 | -122.400726473151 | (37.7580999894276, -122.400726473151) | |||
157882 | 157882 | 201381 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018192.01331 | 2095500.19369 | 37.7348639404214 | -122.379506661926 | (37.7348639404214, -122.379506661926) | |||
158886 | 158886 | 198521 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014485.10287 | 2096211.0948599998 | 37.7366107871579 | -122.39237255107099 | (37.7366107871579, -122.392372551071) | |||
158960 | 158960 | 224727 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1102 York St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6009981.53531 | 2102756.63648 | 37.7543323012985 | -122.40840494503 | (37.7543323012985, -122.40840494503) | |||
160514 | 160514 | 227949 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.58696 | 2103473.27819 | 37.756297802015794 | -122.408593647988 | (37.7562978020158, -122.408593647988) | |||
161011 | 161011 | 122193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 45 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 5991455.48516 | 2114922.34945 | 37.786681193103206 | -122.473359370807 | (37.7866811931032, -122.473359370807) | |||
161118 | 161118 | 247229 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 760 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6002065.37798 | 2108297.71243 | 37.7691002638038 | -122.43617749189501 | (37.7691002638038, -122.436177491895) | |||
161132 | 161132 | 202144 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1999 Armstrong Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6012917.46969 | 2093534.23595 | 37.7291735107263 | -122.39760487958598 | (37.7291735107263, -122.397604879586) | |||
161771 | 161771 | 198523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014565.5806599995 | 2096150.99697 | 37.7364502392755 | -122.392090100993 | (37.7364502392755, -122.392090100993) | |||
162036 | 162036 | 228380 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 1102 York St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 7ft | 6009984.616119999 | 2102714.1131 | 37.7542157141043 | -122.40839129154301 | (37.7542157141043, -122.408391291543) | |||
163339 | 163339 | 135128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 7ft | 6009778.15443 | 2122482.07693 | 37.808482294798104 | -122.410501083081 | (37.8084822947981, -122.410501083081) | |||
168657 | 168657 | 198524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014591.36063 | 2096131.8328599997 | 37.7363990498707 | -122.391999628307 | (37.7363990498707, -122.391999628307) | |||
169396 | 169396 | 120837 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 45 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 7ft | 5989872.80375 | 2114860.19185 | 37.786418752593995 | -122.47883046034599 | (37.786418752594, -122.478830460346) | |||
170404 | 170404 | 120840 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 55 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 5989874.85476 | 2114772.97102 | 37.7861793878304 | -122.47881698293399 | (37.7861793878304, -122.478816982934) | |||
171084 | 171084 | 228379 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 1102 York St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 7ft | 6009985.1643 | 2102722.04384 | 37.754237520846 | -122.40838995515301 | (37.754237520846, -122.408389955153) | |||
174247 | 174247 | 190951 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 50 Southern Heights Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 6012249.68745 | 2104070.76225 | 37.758067358448294 | -122.40065336098301 | (37.7580673584483, -122.400653360983) | |||
176124 | 176124 | 227951 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.616780001 | 2103443.6327299997 | 37.7562165159053 | -122.408584536948 | (37.7562165159053, -122.408584536948) | |||
176290 | 176290 | 201449 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018200.77353 | 2095868.3398 | 37.7358752802274 | -122.37950194045901 | (37.7358752802274, -122.379501940459) | |||
176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
176654 | 176654 | 248640 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 69 Fair Oaks St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 7ft | 6005405.03328 | 2103323.5928700003 | 37.7556316840678 | -122.424271988762 | (37.7556316840678, -122.424271988762) | |||
179136 | 179136 | 124657 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 30 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 7ft | 5995444.46973 | 2115398.79213 | 37.7882195529326 | -122.459593054716 | (37.7882195529326, -122.459593054716) | |||
179491 | 179491 | 201452 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6018199.95572 | 2095808.82115 | 37.7357118086525 | -122.37950063464199 | (37.7357118086525, -122.379500634642) | |||
180768 | 180768 | 247230 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 760 Duboce Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 7ft | 6002048.90983 | 2108298.85433 | 37.7691024635297 | -122.436234535902 | (37.7691024635297, -122.436234535902) | |||
180999 | 180999 | 201383 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 120 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018192.817430001 | 2095435.4996599997 | 37.7346863476974 | -122.379499389088 | (37.7346863476974, -122.379499389088) | |||
182996 | 182996 | 124440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Edward St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 7ft | 5996107.05641 | 2111748.15597 | 37.7782339565121 | -122.457036464694 | (37.7782339565121, -122.457036464694) | |||
183295 | 183295 | 194277 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | Width 7ft | 6012002.23785 | 2102241.02504 | 37.7530294975215 | -122.401380567153 | (37.7530294975215, -122.401380567153) | |||
185076 | 185076 | 244824 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 773 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6005057.02214 | 2103838.7107 | 37.757026420139 | -122.42551217995701 | (37.757026420139, -122.425512179957) | |||
185625 | 185625 | 188596 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Rhode Island St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 7ft | 6011998.11194 | 2102296.49626 | 37.7531815791825 | -122.401398733471 | (37.7531815791825, -122.401398733471) | |||
185828 | 185828 | 120836 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 39 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 5989871.68647 | 2114884.91927 | 37.786486582253396 | -122.47883613501001 | (37.7864865822534, -122.47883613501) | |||
185851 | 185851 | 242784 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009801.01572 | 2103396.12186 | 37.756078074246 | -122.409074350022 | (37.756078074246, -122.409074350022) | |||
185967 | 185967 | 198527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014634.66691 | 2096168.3212099997 | 37.736501643630795 | -122.39185244975599 | (37.7365016436308, -122.391852449756) | |||
186460 | 186460 | 198536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1782 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014278.07437 | 2096434.6477400002 | 37.7372131188949 | -122.393103980488 | (37.7372131188949, -122.393103980488) | |||
187394 | 187394 | 227947 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009924.719330001 | 2103404.59086 | 37.7561082572986 | -122.40864713697901 | (37.7561082572986, -122.408647136979) | |||
188815 | 188815 | 228381 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 1102 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 7ft | 6009986.01041 | 2102705.0422400003 | 37.754190885624794 | -122.408385829946 | (37.7541908856248, -122.408385829946) |
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");