Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 186533 | 186533 | 103207 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.756234279341896 | -122.487292457342 | (37.7562342793419, -122.487292457342) | |||
| 183697 | 183697 | 103183 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987454.6857 | 2104156.4641 | 37.756888596653496 | -122.486410289114 | (37.7568885966535, -122.486410289114) | |||
| 182999 | 182999 | 103192 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 182904 | 182904 | 111801 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010771.68914 | 2110936.4486 | 37.7768364262956 | -122.40624866125401 | (37.7768364262956, -122.406248661254) | |||
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 182049 | 182049 | 102370 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.18727 | 2110032.649 | 37.7728299448261 | -122.49826190746201 | (37.7728299448261, -122.498261907462) | |||
| 181298 | 181298 | 97892 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401x Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/2010 12:00:00 AM | 8 | 3x3 | Permit Number 55034 | 6002514.74306 | 2090342.41745 | 37.7198247442045 | -122.433339952791 | (37.7198247442045, -122.433339952791) | |
| 166717 | 166717 | 102372 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984152.563490001 | 2110057.09296 | 37.7728970243511 | -122.49826587084299 | (37.7728970243511, -122.498265870843) | |||
| 165859 | 165859 | 111800 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010798.82321 | 2110910.53582 | 37.77676679357771 | -122.40615296978599 | (37.7767667935777, -122.406152969786) | |||
| 165655 | 165655 | 103189 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987449.3548 | 2104293.8827 | 37.7572656000244 | -122.48643881405899 | (37.7572656000244, -122.486438814059) | |||
| 156733 | 156733 | 102371 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.49826336723801 | (37.7729475975471, -122.498263367238) | |||
| 152223 | 152223 | 115560 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 3x3 | 6007697.45646 | 2117180.95447 | 37.793809878961895 | -122.417326013802 | (37.7938098789619, -122.417326013802) | |||
| 150039 | 150039 | 102376 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 5984157.512069999 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | ||||
| 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) | |||
| 146308 | 146308 | 115547 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 146286 | 146286 | 103200 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 146269 | 146269 | 24686 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.77976647962429 | -122.49010635929599 | (37.7797664796243, -122.490106359296) | ||
| 146211 | 146211 | 116150 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 146163 | 146163 | 29073 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 146124 | 146124 | 26307 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/06/1998 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 146051 | 146051 | 20469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 145985 | 145985 | 8503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 145973 | 145973 | 114481 | Undocumented 2 | Washingtonia filifera :: California Fan Palm 189 | 45 HOFF ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6006591.0 | 2106401.0 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | ||||
| 145655 | 145655 | 8486 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | ||
| 145495 | 145495 | 112130 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 145449 | 145449 | 20228 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.784908839203204 | -122.43481026677 | (37.7849088392032, -122.43481026677) | |||
| 144830 | 144830 | 9474 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 144600 | 144600 | 20499 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 144403 | 144403 | 112127 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 144094 | 144094 | 100036 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 143937 | 143937 | 17725 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 60 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 143186 | 143186 | 112154 | Undocumented 2 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 299x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | ||||
| 143176 | 143176 | 9471 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 143168 | 143168 | 9547 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 143087 | 143087 | 24922 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2199X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | ||
| 142733 | 142733 | 103174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142678 | 142678 | 5488 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 700X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 142495 | 142495 | 103187 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142388 | 142388 | 112153 | Undocumented 2 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 299x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | ||||
| 142159 | 142159 | 113981 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 142153 | 142153 | 113800 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 142111 | 142111 | 103178 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142017 | 142017 | 9797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 141984 | 141984 | 112129 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 141644 | 141644 | 20495 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 141627 | 141627 | 26301 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 141545 | 141545 | 98431 | DPW Maintained 3 | Tree(s) :: 17 | 1401X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
| 141366 | 141366 | 24933 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 141324 | 141324 | 24926 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 141306 | 141306 | 5462 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 141246 | 141246 | 108956 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 141239 | 141239 | 116275 | Undocumented 2 | :: 54 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 141166 | 141166 | 115544 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 141081 | 141081 | 116127 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 141074 | 141074 | 8523 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 140981 | 140981 | 112651 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
| 140734 | 140734 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 1820X Palou Ave | : Cutout 24 | Tree 1 | Rec/Park 3 | FUF 1 | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | ||||
| 140654 | 140654 | 27152 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | ||
| 140572 | 140572 | 116137 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 140434 | 140434 | 103232 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 140247 | 140247 | 103204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 140221 | 140221 | 9790 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 139901 | 139901 | 9540 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 139799 | 139799 | 111804 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 139564 | 139564 | 8480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 139473 | 139473 | 8483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 139472 | 139472 | 26647 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2199X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | ||
| 139446 | 139446 | 116292 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 139442 | 139442 | 98425 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 139264 | 139264 | 12049 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 139137 | 139137 | 20489 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 139043 | 139043 | 2809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 138721 | 138721 | 25414 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 133698 | 133698 | 103182 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987451.7241 | 2104232.2812 | 37.757096597166296 | -122.48642609757201 | (37.7570965971663, -122.486426097572) | |||
| 129343 | 129343 | 9783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 129202 | 129202 | 26138 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1500 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/05/2005 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 129090 | 129090 | 8524 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 128979 | 128979 | 113978 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 128867 | 128867 | 101513 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 128863 | 128863 | 111797 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 128824 | 128824 | 26153 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 128747 | 128747 | 20512 | Permitted Site 1 | Pinus pinea :: Italian Stone Pine 143 | 1211X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 128333 | 128333 | 29068 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1091X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.781077615403596 | -122.426966984587 | (37.7810776154036, -122.426966984587) | ||
| 128318 | 128318 | 116151 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 128189 | 128189 | 8478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 128126 | 128126 | 9796 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 127866 | 127866 | 29071 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 127585 | 127585 | 111795 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 126954 | 126954 | 2807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 126681 | 126681 | 10586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.40532126913901 | (37.7763811461579, -122.405321269139) |
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");