Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 24617 | 24617 | 181947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | |||
| 24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
| 25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
| 26149 | 26149 | 142789 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 625 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007523.6751 | 2113458.738 | 37.783579806807296 | -122.417663367701 | (37.7835798068073, -122.417663367701) | |||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 28014 | 28014 | 138798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.44209701285101 | (37.7873021338531, -122.442097012851) | |||
| 29296 | 29296 | 244956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | |||
| 30952 | 30952 | 182628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1890 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988800.9853 | 2102469.1319999998 | 37.7523340169161 | -122.48163075760901 | (37.7523340169161, -122.481630757609) | |||
| 32754 | 32754 | 138797 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 35621 | 35621 | 181328 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1749 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987757.6067 | 2098927.9954 | 37.742550273655 | -122.484979108902 | (37.742550273655, -122.484979108902) | |||
| 35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) | |||
| 37946 | 37946 | 244981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | |||
| 38525 | 38525 | 182391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1555 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988367.831 | 2104720.8488 | 37.7584914283371 | -122.48329370054199 | (37.7584914283371, -122.483293700542) | |||
| 38600 | 38600 | 237996 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001915.60449 | 2101837.36295 | 37.7513532016953 | -122.436233155455 | (37.7513532016953, -122.436233155455) | |||
| 38634 | 38634 | 138786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1844 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001549.1292 | 2114811.3044 | 37.7869555995023 | -122.43842989547701 | (37.7869555995023, -122.438429895477) | |||
| 38667 | 38667 | 140316 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2118 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997686.3851 | 2109923.9689 | 37.7733157811634 | -122.451441408617 | (37.7733157811634, -122.451441408617) | |||
| 39971 | 39971 | 218354 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993503.7358800005 | 2100017.05504 | 37.745873575808794 | -122.46518993049801 | (37.7458735758088, -122.465189930498) | |||
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 44345 | 44345 | 181814 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2169 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986311.3611 | 2099566.4282 | 37.7442188936716 | -122.49002668010799 | (37.7442188936716, -122.490026680108) | |||
| 45248 | 45248 | 184305 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984382.3056 | 2104532.0637 | 37.757740324240295 | -122.497063286444 | (37.7577403242403, -122.497063286444) | |||
| 47858 | 47858 | 142823 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | |||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 48508 | 48508 | 183557 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1606 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987960.4417 | 2097637.0195 | 37.7390174057998 | -122.48418311934999 | (37.7390174057998, -122.48418311935) | |||
| 48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
| 49057 | 49057 | 142822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | |||
| 49341 | 49341 | 138118 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1700 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004348.6538 | 2114674.3634 | 37.7867384352501 | -122.42873440937201 | (37.7867384352501, -122.428734409372) | |||
| 50845 | 50845 | 214391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 181 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994381.282869999 | 2098640.67197 | 37.742144938946204 | -122.462055722089 | (37.7421449389462, -122.462055722089) | |||
| 51252 | 51252 | 214403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2140 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993695.41418 | 2101124.7709 | 37.7489261338491 | -122.464607559198 | (37.7489261338491, -122.464607559198) | |||
| 51415 | 51415 | 182275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376001 | (37.7591168373077, -122.49474304376) | |||
| 52291 | 52291 | 214402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 75 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993211.39069 | 2093578.01882 | 37.728176729173796 | -122.465733068822 | (37.7281767291738, -122.465733068822) | |||
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
| 54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 55665 | 55665 | 178881 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 56991 | 56991 | 214441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991205.26954 | 2101153.09908 | 37.748860046264205 | -122.473220466273 | (37.7488600462642, -122.473220466273) | |||
| 57720 | 57720 | 196392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013963.537140001 | 2112927.48749 | 37.7824813907387 | -122.39534652723499 | (37.7824813907387, -122.395346527235) | |||
| 59178 | 59178 | 182739 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1755 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985933.2204 | 2103292.5347 | 37.7544276818477 | -122.491608417213 | (37.7544276818477, -122.491608417213) | |||
| 59581 | 59581 | 138813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1605 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000066.1969 | 2114526.3397 | 37.7860886985052 | -122.44354001020399 | (37.7860886985052, -122.443540010204) | |||
| 60297 | 60297 | 182224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1599 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985275.2811 | 2104383.8376 | 37.7573856255252 | -122.493964129886 | (37.7573856255252, -122.493964129886) | |||
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 62754 | 62754 | 214473 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997009.81636 | 2095018.0676900002 | 37.732349130199296 | -122.452705728912 | (37.7323491301993, -122.452705728912) | |||
| 63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
| 63435 | 63435 | 214440 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992520.380580001 | 2103558.15623 | 37.7555397706536 | -122.468847844656 | (37.7555397706536, -122.468847844656) | |||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 64105 | 64105 | 142765 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 730 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007516.0375 | 2113852.9835 | 37.784661879382604 | -122.417717744325 | (37.7846618793826, -122.417717744325) | |||
| 64291 | 64291 | 140313 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2104 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997741.5862 | 2109932.7571 | 37.77334307210079 | -122.45125109527001 | (37.7733430721008, -122.45125109527) | |||
| 64861 | 64861 | 238007 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997631.46598 | 2104146.92887 | 37.757450353356795 | -122.45121467184099 | (37.7574503533568, -122.451214671841) | |||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 67840 | 67840 | 183942 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1805 Quintara St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987837.1544 | 2100978.5872 | 37.748185287488496 | -122.484854460213 | (37.7481852874885, -122.484854460213) | |||
| 68429 | 68429 | 185590 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2086 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986989.5241 | 2101082.1958 | 37.748420363683294 | -122.487793111063 | (37.7484203636833, -122.487793111063) | |||
| 68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
| 68995 | 68995 | 214386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2658 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991781.74675 | 2097342.53415 | 37.7384305734182 | -122.470949475734 | (37.7384305734182, -122.470949475734) | |||
| 69519 | 69519 | 142769 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 684 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007544.7694 | 2113646.7684 | 37.7840972796264 | -122.41760372057101 | (37.7840972796264, -122.417603720571) | |||
| 72225 | 72225 | 103482 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.719579750897104 | -122.431167899382 | (37.7195797508971, -122.431167899382) | |||
| 72387 | 72387 | 178871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998313.518130001 | 2088706.56781 | 37.7150938380738 | -122.44774434904801 | (37.7150938380738, -122.447744349048) | |||
| 73533 | 73533 | 196401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 403 06th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.40395017576701 | (37.7770436561708, -122.403950175767) | |||
| 74598 | 74598 | 135903 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | ||||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 132439 | 132439 | 138008 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1803 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003906.6028 | 2114561.528 | 37.7864035892695 | -122.430255747535 | (37.7864035892695, -122.430255747535) | |||
| 133506 | 133506 | 196386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | |||
| 133839 | 133839 | 196397 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011301.22079 | 2111291.73097 | 37.7778415553936 | -122.404441855801 | (37.7778415553936, -122.404441855801) | |||
| 134668 | 134668 | 214384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1616 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992797.81985 | 2104455.58928 | 37.758019912916204 | -122.46795365505899 | (37.7580199129162, -122.467953655059) | |||
| 134870 | 134870 | 140684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1922 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998591.1033 | 2110400.7567 | 37.7746766831785 | -122.44834621816999 | (37.7746766831785, -122.44834621817) | |||
| 135125 | 135125 | 178874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998666.63351 | 2088343.6345099998 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | |||
| 136547 | 136547 | 214401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 San Benito Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992866.37257 | 2094814.0590599999 | 37.731550682422 | -122.467015624375 | (37.731550682422, -122.467015624375) | |||
| 138003 | 138003 | 70633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 3x3 | 6003062.45597 | 2090620.0521099998 | 37.720618125211 | -122.43146651207898 | (37.720618125211, -122.431466512079) | |
| 149261 | 149261 | 142760 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | |||
| 149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
| 150701 | 150701 | 138799 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000493.7553 | 2114952.745 | 37.78728387171021 | -122.44209139561 | (37.7872838717102, -122.44209139561) | |||
| 151352 | 151352 | 138056 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1881 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003626.3632 | 2114522.6258 | 37.7862808966144 | -122.431222527433 | (37.7862808966144, -122.431222527433) | |||
| 152192 | 152192 | 137955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1615 SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004810.4247 | 2114689.3847 | 37.786805803696204 | -122.42713786122299 | (37.7868058036962, -122.427137861223) | |||
| 152248 | 152248 | 178929 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 236 Niagara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999086.8403199995 | 2089914.7209 | 37.7184553195406 | -122.445158233389 | (37.7184553195406, -122.445158233389) | ||||
| 152339 | 152339 | 214383 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1328 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993657.40703 | 2106457.98969 | 37.7635675841926 | -122.465126297154 | (37.7635675841926, -122.465126297154) | |||
| 152743 | 152743 | 182409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1521 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985259.3217 | 2104833.2809 | 37.7586187384667 | -122.494052446724 | (37.7586187384667, -122.494052446724) | |||
| 152855 | 152855 | 214399 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 280 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5993979.945780001 | 2098920.29255 | 37.7428895919817 | -122.46346369708799 | (37.7428895919817, -122.463463697088) | |||
| 153877 | 153877 | 214465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 538 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998516.53897 | 2094996.08822 | 37.732375000089505 | -122.44749508032801 | (37.7323750000895, -122.447495080328) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 154435 | 154435 | 196388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.782348452967206 | -122.395514731015 | (37.7823484529672, -122.395514731015) | |||
| 154672 | 154672 | 182570 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2202 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989157.6649 | 2098357.6812 | 37.7410657893771 | -122.480096445466 | (37.7410657893771, -122.480096445466) | |||
| 154934 | 154934 | 80023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.43968765086201 | (37.7762172841329, -122.439687650862) | ||
| 155472 | 155472 | 182206 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1659 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989323.8869 | 2104045.9173 | 37.75669384099071 | -122.479937878141 | (37.7566938409907, -122.479937878141) | |||
| 156919 | 156919 | 196387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013895.88765 | 2112864.3036700003 | 37.782304139751794 | -122.39557613855301 | (37.7823041397518, -122.395576138553) | |||
| 157893 | 157893 | 214416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 539 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994748.7087900005 | 2092127.64393 | 37.724282906628794 | -122.46031349786399 | (37.7242829066288, -122.460313497864) | |||
| 158937 | 158937 | 214443 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991170.54389 | 2101147.50148 | 37.7488426659675 | -122.473340138153 | (37.7488426659675, -122.473340138153) | |||
| 159311 | 159311 | 183377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2651 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989551.7412 | 2097288.806 | 37.738153824368204 | -122.478655737727 | (37.7381538243682, -122.478655737727) | |||
| 160226 | 160226 | 178928 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 86 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6000750.4572 | 2093270.2717099998 | 37.7277637154981 | -122.439648243684 | (37.7277637154981, -122.439648243684) |
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");