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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184767 | 184767 | 234869 | Undocumented 2 | Populus deltoides :: Eastern cottonwood 559 | 483 Valley St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 6002812.524730001 | 2099166.42238 | 37.7440703451703 | -122.432940705074 | (37.7440703451703, -122.432940705074) | ||||
133988 | 133988 | 221178 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1101 San Jose Ave | 68 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005051.84205 | 2096632.8627099998 | 37.7372405248233 | -122.425017413417 | (37.7372405248233, -122.425017413417) | |||
163433 | 163433 | 205609 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1484 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5991184.61852 | 2105324.79706 | 37.760313237173 | -122.47359614005899 | (37.760313237173, -122.473596140059) | |||
101496 | 101496 | 117093 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
102296 | 102296 | 117095 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
68539 | 68539 | 205975 | Undocumented 2 | Cedrus libani :: Lebanon cedar 443 | 5 Sequoia Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5998211.61791 | 2097832.09967 | 37.7401445796092 | -122.448753454923 | (37.7401445796092, -122.448753454923) | |||
67491 | 67491 | 190750 | Undocumented 2 | Juglans hindsii :: Walnut: Black (n.calif) 442 | 1717 Revere Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 6014482.8243 | 2094823.0948599998 | 37.732799496305596 | -122.392283381472 | (37.7327994963056, -122.392283381472) | ||||
76582 | 76582 | 246774 | Undocumented 2 | Juglans hindsii :: Walnut: Black (n.calif) 442 | 1850 Alabama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6009457.96402 | 2098740.81971 | 37.743276423664796 | -122.40993212697398 | (37.7432764236648, -122.409932126974) | ||||
59139 | 59139 | 194431 | Undocumented 2 | Pinus coulteri :: Coulter pine 435 | 889 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011332.59627 | 2104195.66484 | 37.7583591218854 | -122.403833861042 | (37.7583591218854, -122.403833861042) | ||||
62995 | 62995 | 194429 | Undocumented 2 | Pinus coulteri :: Coulter pine 435 | 800 Vermont St | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6011307.95664 | 2104238.22353 | 37.7584746020401 | -122.40392207106599 | (37.7584746020401, -122.403922071066) | ||||
188670 | 188670 | 194430 | Undocumented 2 | Pinus coulteri :: Coulter pine 435 | 800 Vermont St | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 5ft | 6011313.02989 | 2104102.06211 | 37.7581010164682 | -122.403894943896 | (37.7581010164682, -122.403894943896) | |||
97483 | 97483 | 98313 | Undocumented 2 | Acacia dealbata :: Silver Wattle 434 | 160 Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | |||||
183064 | 183064 | 239034 | Undocumented 2 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 415 | 246 Bemis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6003036.33312 | 2096321.01175 | 37.7362701959111 | -122.43196368609699 | (37.7362701959111, -122.431963686097) | ||||
160613 | 160613 | 234868 | Undocumented 2 | Populus alba :: White Poplar 408 | 310 Liberty St | 58 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6003726.802759999 | 2103918.02855 | 37.7571689581965 | -122.430118240383 | (37.7571689581965, -122.430118240383) | |||
129843 | 129843 | 233280 | Undocumented 2 | Metasequoia glyplostroboides :: Dawn Redwood 404 | 310 Liberty St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 6003983.2907 | 2103931.1784900003 | 37.757219588241895 | -122.42923214376002 | (37.7572195882419, -122.42923214376) | |||
83177 | 83177 | 206788 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 1695 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993693.37369 | 2103986.07893 | 37.7567824340901 | -122.46482237757401 | (37.7567824340901, -122.464822377574) | |||
130890 | 130890 | 184718 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 1635 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5984663.6565 | 2104045.9774 | 37.7564221499071 | -122.496054413144 | (37.7564221499071, -122.496054413144) | |||
133577 | 133577 | 122062 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 5 17th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5990511.82638 | 2115005.39059 | 37.7868545124865 | -122.476630238278 | (37.7868545124865, -122.476630238278) | |||
177373 | 177373 | 223268 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 3910 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6002358.80853 | 2102981.78525 | 37.7545206841088 | -122.43478233672899 | (37.7545206841088, -122.434782336729) | |||
38362 | 38362 | 187789 | Undocumented 2 | Acacia vestita :: Hairy wattle 398 | 1300 19th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 6013726.39859 | 2105263.44398 | 37.7614244520865 | -122.395629787589 | (37.7614244520865, -122.395629787589) | |||
172698 | 172698 | 221571 | Undocumented 2 | Acacia vestita :: Hairy wattle 398 | 749 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 8ft | 6005046.80982 | 2104035.1729099997 | 37.757565282231795 | -122.42556147989401 | (37.7575652822318, -122.425561479894) | |||
48846 | 48846 | 126459 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 1077 Front St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012590.315719999 | 2120009.18075 | 37.801849575267795 | -122.40059493200899 | (37.8018495752678, -122.400594932009) | ||||
73806 | 73806 | 126460 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 1077 Front St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012603.517530001 | 2119981.99214 | 37.8017756581763 | -122.400547336316 | (37.8017756581763, -122.400547336316) | ||||
74200 | 74200 | 126458 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 1077 Front St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6012574.01246 | 2120093.81487 | 37.80208105084861 | -122.400657298194 | (37.8020810508486, -122.400657298194) | ||||
159276 | 159276 | 126456 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 407 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011480.28729 | 2119030.06568 | 37.7990991939222 | -122.40436721300101 | (37.7990991939222, -122.404367213001) | ||||
184649 | 184649 | 126457 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 1077 Front St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6012574.12076 | 2120110.8151599998 | 37.8021277355747 | -122.400658118379 | (37.8021277355747, -122.400658118379) | ||||
37626 | 37626 | 197049 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013764.800419999 | 2092903.72469 | 37.7274894006957 | -122.394631429511 | (37.7274894006957, -122.394631429511) | |||
37646 | 37646 | 197041 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6013605.15041 | 2093023.0960900001 | 37.727808293095705 | -122.395191702628 | (37.7278082930957, -122.395191702628) | |||
39186 | 39186 | 197051 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013800.11346 | 2092877.36895 | 37.7274189963798 | -122.394507506523 | (37.7274189963798, -122.394507506523) | |||
56050 | 56050 | 197048 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013748.7232 | 2092915.9489400003 | 37.7275220721631 | -122.39468786464899 | (37.7275220721631, -122.394687864649) | |||
58699 | 58699 | 197052 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013818.36042 | 2092864.2626599998 | 37.727384023540004 | -122.39444350896002 | (37.72738402354, -122.39444350896) | |||
61484 | 61484 | 197054 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013854.322790001 | 2092836.7206400002 | 37.7273103978347 | -122.39431725855499 | (37.7273103978347, -122.394317258555) | |||
66267 | 66267 | 197056 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013889.03643 | 2092811.44718 | 37.727242931591704 | -122.394195484039 | (37.7272429315917, -122.394195484039) | |||
68624 | 68624 | 197044 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013656.53687 | 2092984.3482 | 37.7277047568578 | -122.39501134449101 | (37.7277047568578, -122.395011344491) | |||
69690 | 69690 | 197047 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013710.59449 | 2092944.54081 | 37.7275984596917 | -122.39482167838999 | (37.7275984596917, -122.39482167839) | |||
71670 | 71670 | 197055 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013870.2556 | 2092825.67225 | 37.7272809468354 | -122.39426140526001 | (37.7272809468354, -122.39426140526) | |||
74271 | 74271 | 197053 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013835.9279 | 2092850.8350799999 | 37.7273481306962 | -122.39438183795099 | (37.7273481306962, -122.394381837951) | |||
135573 | 135573 | 197042 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013621.73197 | 2093010.8615400002 | 37.7277756216363 | -122.39513352280399 | (37.7277756216363, -122.395133522804) | |||
150594 | 150594 | 197040 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013586.08958 | 2093037.5592599998 | 37.7278469459806 | -122.395258609504 | (37.7278469459806, -122.395258609504) | |||
151345 | 151345 | 197046 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013693.17841 | 2092957.12727 | 37.7276320511772 | -122.39488276754 | (37.7276320511772, -122.39488276754) | |||
157524 | 157524 | 197050 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6013784.53754 | 2092889.41533 | 37.7274512073814 | -122.394562196094 | (37.7274512073814, -122.394562196094) | |||
169611 | 169611 | 197045 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013673.46175 | 2092972.44179 | 37.7276730054053 | -122.39495200093 | (37.7276730054053, -122.39495200093) | |||
175475 | 175475 | 197043 | Undocumented 2 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 393 | 1751 Armstrong Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013640.62798 | 2092996.5691099998 | 37.72773742833179 | -122.395067197801 | (37.7277374283318, -122.395067197801) | |||
31184 | 31184 | 201362 | Undocumented 2 | Cornus florida :: Eastern Dogwood 374 | 225 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 2ft | 6013043.2726 | 2092711.57463 | 37.72692165510811 | -122.397112304693 | (37.7269216551081, -122.397112304693) | |||
186127 | 186127 | 131690 | Undocumented 2 | Musa spp :: Banana 371 | 407 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 105 | 6011485.14109 | 2119034.37122 | 37.7991112871264 | -122.40435072033199 | (37.7991112871264, -122.404350720332) | ||||
74335 | 74335 | 219146 | Undocumented 2 | Grevillea spp :: Silkoak species 369 | 16 Belmont Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5996651.84787 | 2106248.4947099998 | 37.763164581797206 | -122.454754395304 | (37.7631645817972, -122.454754395304) | ||||
131024 | 131024 | 188537 | Undocumented 2 | Acacia cyclops :: Cyclops wattle 366 | 861 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6011328.80753 | 2104353.51433 | 37.7587923298333 | -122.403858071687 | (37.7587923298333, -122.403858071687) | ||||
182609 | 182609 | 210891 | Undocumented 2 | Paulownia fortunei :: Dragon tree 365 | 32 Malta Dr | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999662.89438 | 2095983.26213 | 37.7351509923308 | -122.443602765959 | (37.7351509923308, -122.443602765959) | |||
28431 | 28431 | 246705 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Bonview St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6007711.520280001 | 2099134.96568 | 37.7442606264379 | -122.41599879791201 | (37.7442606264379, -122.415998797912) | ||||
31850 | 31850 | 213746 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1500 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5991556.54065 | 2105092.12844 | 37.759695922737706 | -122.47229288660601 | (37.7596959227377, -122.472292886606) | ||||
59417 | 59417 | 246703 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Bonview St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007703.57405 | 2099117.4326400002 | 37.7442120378532 | -122.416025032948 | (37.7442120378532, -122.416025032948) | ||||
129523 | 129523 | 239035 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 459 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6002938.47397 | 2099171.49854 | 37.74409142617971 | -122.43250556359301 | (37.7440914261797, -122.432505563593) | ||||
68139 | 68139 | 218288 | Undocumented 2 | Albizia distachya :: Plume Albizia Tree 360 | 1 Woodacre Dr | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5991312.53474 | 2095563.2830599998 | 37.733518052796896 | -122.472442091346 | (37.7335180527969, -122.472442091346) | ||||
85791 | 85791 | 218281 | Undocumented 2 | Albizia distachya :: Plume Albizia Tree 360 | 1 Woodacre Dr | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991365.3672 | 2095642.13358 | 37.733737614189 | -122.47226518211399 | (37.733737614189, -122.472265182114) | ||||
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) | |||
28197 | 28197 | 210995 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991353.53003 | 2101776.30529 | 37.750579791933 | -122.472753220802 | (37.750579791933, -122.472753220802) | |||
31291 | 31291 | 210988 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 2000 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5991307.5277 | 2101754.98227 | 37.7505185813763 | -122.472910744261 | (37.7505185813763, -122.472910744261) | |||
44933 | 44933 | 234469 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 300 Virginia Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6006922.403419999 | 2098338.34388 | 37.7420288832343 | -122.41867091933001 | (37.7420288832343, -122.41867091933) | |||
53422 | 53422 | 210987 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 2000 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5991305.02511 | 2101744.43769 | 37.750489483824 | -122.472918629501 | (37.750489483824, -122.472918629501) | |||
56097 | 56097 | 210994 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991361.38114 | 2101775.42738 | 37.750577835904004 | -122.472726007301 | (37.750577835904, -122.472726007301) | |||
62977 | 62977 | 210992 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991431.17714 | 2101777.51792 | 37.750587616043 | -122.47248480193001 | (37.750587616043, -122.47248480193) | |||
137155 | 137155 | 210996 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991338.45312 | 2101773.77329 | 37.750571966934 | -122.472805172843 | (37.750571966934, -122.472805172843) | |||
159028 | 159028 | 211000 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991404.67403 | 2101775.93946 | 37.7505817479591 | -122.47257633583901 | (37.7505817479591, -122.472576335839) | |||
161548 | 161548 | 210993 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1151 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991379.26573 | 2101775.40636 | 37.7505788134643 | -122.47266416004 | (37.7505788134643, -122.47266416004) | |||
172390 | 172390 | 210998 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1400 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995887.63896 | 2093343.72809 | 37.7276874323278 | -122.45646430059601 | (37.7276874323278, -122.456464300596) | |||
172448 | 172448 | 210999 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 445 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994973.63206 | 2100193.03469 | 37.7464414257323 | -122.460120016828 | (37.7464414257323, -122.460120016828) | |||
175763 | 175763 | 210989 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 2000 16th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5991306.24732 | 2101766.36355 | 37.750549757281604 | -122.472916001697 | (37.7505497572816, -122.472916001697) | |||
75131 | 75131 | 199412 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 450 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6017962.7763 | 2099598.9904099996 | 37.7461057708787 | -122.380584028138 | (37.7461057708787, -122.380584028138) | ||||
61271 | 61271 | 118195 | Undocumented 2 | Nerium oleander :: Oleander 351 | 858 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5985129.694569999 | 2110010.45788 | 37.7728262247758 | -122.494882469642 | (37.7728262247758, -122.494882469642) | |||
76872 | 76872 | 118194 | Undocumented 2 | Nerium oleander :: Oleander 351 | 858 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5985130.26203 | 2110017.353 | 37.772845190029294 | -122.494881015244 | (37.7728451900293, -122.494881015244) | |||
159562 | 159562 | 194104 | Undocumented 2 | Nerium oleander :: Oleander 351 | 801 19th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015143.45963 | 2105289.88586 | 37.761575778325295 | -122.390730569759 | (37.7615757783253, -122.390730569759) | ||||
165430 | 165430 | 177852 | Undocumented 2 | Nerium oleander :: Oleander 351 | 521 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 6ft | 6002035.79624 | 2090425.6768200002 | 37.720026172549794 | -122.43500145298 | (37.7200261725498, -122.43500145298) | |||
75614 | 75614 | 204755 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994506.1495 | 2100077.57714 | 37.7460975088062 | -122.46172813683799 | (37.7460975088062, -122.461728136838) | |||
129722 | 129722 | 204752 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994511.5278 | 2100117.0182 | 37.7462061136348 | -122.46171239872 | (37.7462061136348, -122.46171239872) | |||
136592 | 136592 | 204754 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994505.572930001 | 2100089.53761 | 37.7461303160582 | -122.461730997591 | (37.7461303160582, -122.461730997591) | |||
161300 | 161300 | 204751 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994525.40112 | 2100147.21703 | 37.746289830623205 | -122.461666616016 | (37.7462898306232, -122.461666616016) | |||
163913 | 163913 | 204750 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994534.31056 | 2100157.7428599996 | 37.746319244754 | -122.46163657149201 | (37.746319244754, -122.461636571492) | |||
177172 | 177172 | 204753 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 140 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994508.79603 | 2100105.12708 | 37.746173306357996 | -122.461720982741 | (37.746173306358, -122.461720982741) | |||
33535 | 33535 | 226834 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 246 Bemis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6003051.73266 | 2096339.9722099998 | 37.7363231300074 | -122.431911797003 | (37.7363231300074, -122.431911797003) | ||||
38122 | 38122 | 190754 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 373 Arkansas St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6012960.2346 | 2105313.22845 | 37.7615185013946 | -122.398283141072 | (37.7615185013946, -122.398283141072) | |||
76436 | 76436 | 221196 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 150 Coso Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6007431.47639 | 2099616.35507 | 37.745566665075295 | -122.41700123351801 | (37.7455666650753, -122.417001233518) | ||||
114226 | 114226 | 110115 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 185x SANSOME ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9x90 | 6012318.0 | 2116367.0 | 37.7918338284962 | -122.40128118389099 | (37.7918338284962, -122.401281183891) | ||||
67280 | 67280 | 249976 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.19943 | 2120231.20207 | 37.8024062690918 | -122.403891507608 | (37.8024062690918, -122.403891507608) | |||
168803 | 168803 | 249975 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.325669999 | 2120237.40655 | 37.8024233121334 | -122.403891507612 | (37.8024233121334, -122.403891507612) | |||
177213 | 177213 | 249977 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6011643.6544699995 | 2120226.12946 | 37.8023924222307 | -122.403886115262 | (37.8023924222307, -122.403886115262) | |||
27168 | 27168 | 197313 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016056.29901 | 2108502.85342 | 37.7704484959236 | -122.387797593705 | (37.7704484959236, -122.387797593705) | |||
27425 | 27425 | 197327 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016081.45818 | 2108068.9584 | 37.769258508494 | -122.387680289716 | (37.769258508494, -122.387680289716) | |||
29684 | 29684 | 197303 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016090.0437900005 | 2108435.7275799997 | 37.770266052269605 | -122.387676185234 | (37.7702660522696, -122.387676185234) | |||
29752 | 29752 | 197306 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016086.21724 | 2108504.38173 | 37.7704543496162 | -122.387694212136 | (37.7704543496162, -122.387694212136) | |||
31840 | 31840 | 197328 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016081.1788 | 2108055.10958 | 37.7692204671748 | -122.38768028972 | (37.7692204671748, -122.38768028972) | |||
49137 | 49137 | 197279 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6016112.1574800005 | 2108055.69454 | 37.769223789269205 | -122.387573175954 | (37.7692237892692, -122.387573175954) | |||
52449 | 52449 | 197294 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6016100.76588 | 2108247.57178 | 37.769750011393796 | -122.387625967988 | (37.7697500113938, -122.387625967988) | |||
53199 | 53199 | 197321 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016071.10439 | 2108245.38059 | 37.7697423518581 | -122.38772841426099 | (37.7697423518581, -122.387728414261) | |||
53823 | 53823 | 197330 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016083.25197 | 2108007.00917 | 37.7690885087587 | -122.38766976226002 | (37.7690885087587, -122.38766976226) | |||
62665 | 62665 | 197292 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6016102.8622 | 2108222.32256 | 37.769680798655 | -122.38761695497699 | (37.769680798655, -122.387616954977) | |||
62780 | 62780 | 197312 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016054.19772 | 2108528.00678 | 37.770517445153295 | -122.38780661748001 | (37.7705174451533, -122.38780661748) | |||
64854 | 64854 | 197298 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016094.16751 | 2108363.36014 | 37.7700675754904 | -122.387656871394 | (37.7700675754904, -122.387656871394) | |||
64959 | 64959 | 197310 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016082.19822 | 2108581.9361 | 37.7706670743519 | -122.387713525969 | (37.7706670743519, -122.387713525969) | |||
67294 | 67294 | 197308 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016082.38164 | 2108554.13112 | 37.7705907381114 | -122.38771095122101 | (37.7705907381114, -122.387710951221) | |||
71238 | 71238 | 197314 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6016057.14011 | 2108479.8898 | 37.770385489431604 | -122.38779308179501 | (37.7703854894316, -122.387793081795) |
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");