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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107894 | 107894 | 111381 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) | ||
| 121695 | 121695 | 111379 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) | ||
| 86120 | 86120 | 114712 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 92714 | 92714 | 114713 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 97865 | 97865 | 114715 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 105879 | 105879 | 114717 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 110071 | 110071 | 114718 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 118222 | 118222 | 114719 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 125441 | 125441 | 114716 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 143907 | 143907 | 114714 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 12084 | 12084 | 43317 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 Athens St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51344 | 6004450.31399 | 2091734.8767 | 37.7237577510972 | -122.42674847077299 | (37.7237577510972, -122.426748470773) | |
| 100393 | 100393 | 106237 | Undocumented 2 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010922.6 | 2091903.6 | 37.724584840413996 | -122.404386617586 | (37.724584840414, -122.404386617586) | ||||||
| 1720 | 1720 | 251666 | Undocumented 2 | Shrub :: Shrub 98 | 76 Denslowe Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990680.0 | 2091936.0 | 37.723521814492294 | -122.474364317808 | (37.7235218144923, -122.474364317808) | ||||
| 94753 | 94753 | 110144 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 129 DE SOTO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 10x10 | 5993256.9 | 2092045.6 | 37.723971707155705 | -122.465464466989 | (37.7239717071557, -122.465464466989) | |||
| 11634 | 11634 | 101011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Santa Ynez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x10 | 6000610.71791 | 2092062.1351 | 37.724438494726 | -122.44004473049101 | (37.724438494726, -122.440044730491) | |||
| 111568 | 111568 | 94421 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 119473 | 119473 | 94422 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 119718 | 119718 | 94425 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 128487 | 128487 | 94424 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 96017 | 96017 | 115668 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 193 VALMAR TER | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004786.0 | 2092223.0 | 37.72511700396829 | -122.425622784245 | (37.7251170039683, -122.425622784245) | ||||
| 117455 | 117455 | 115667 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 193 VALMAR TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 3x3 | 6004786.0 | 2092223.0 | 37.72511700396829 | -122.425622784245 | (37.7251170039683, -122.425622784245) | |||
| 2587 | 2587 | 253128 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 129 Lisbon St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003441.615680001 | 2092643.9430799999 | 37.726196762848794 | -122.430300196616 | (37.7261967628488, -122.430300196616) | ||||
| 2589 | 2589 | 113754 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 129 Lisbon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | 6003441.615680001 | 2092643.9430799999 | 37.726196762848794 | -122.430300196616 | (37.7261967628488, -122.430300196616) | |||
| 87899 | 87899 | 94618 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 90012 | 90012 | 94626 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 104154 | 104154 | 94623 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1728 Bancroft Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 8 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 111591 | 111591 | 94625 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 121493 | 121493 | 94621 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 2 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 138528 | 138528 | 94624 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1728 Bancroft Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 144156 | 144156 | 94620 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 1799X Armstrong Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 144675 | 144675 | 94622 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 1769 Armstrong Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 3 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 97126 | 97126 | 36330 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 40@San Ramon Eastwood Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/14/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | |||
| 107750 | 107750 | 36332 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 40 Eastwood Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/14/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | |||
| 81069 | 81069 | 113145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990980.0 | 2092843.0 | 37.726029586770395 | -122.473393404688 | (37.7260295867704, -122.473393404688) | ||||
| 131875 | 131875 | 95679 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Holyoke St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767431 | 6009609.49645 | 2092896.87368 | 37.727238694008705 | -122.408995916549 | (37.7272386940087, -122.408995916549) |
| 89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
| 79506 | 79506 | 117197 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 70 CERRITOS AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10x6 | 5992485.0 | 2092977.0 | 37.7264845532002 | -122.4682005031 | (37.7264845532002, -122.4682005031) | ||||
| 109255 | 109255 | 92815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.72657814349439 | -122.46787650278 | (37.7265781434944, -122.46787650278) | ||
| 82391 | 82391 | 105357 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 107922 | 107922 | 105358 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 106512 | 106512 | 117420 | Permitted Site 1 | Tree(s) :: 17 | 77 Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777175 | 5994584.4 | 2093084.8 | 37.7269015728644 | -122.46095082579399 | (37.7269015728644, -122.460950825794) | |
| 15294 | 15294 | 94619 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1799X Armstrong Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 2 | Permit Number 53777 | 6013459.79784 | 2093130.5142700002 | 37.7280951570487 | -122.39570171627199 | (37.7280951570487, -122.395701716272) | ||
| 79054 | 79054 | 100424 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 88841 | 88841 | 100425 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 53739 | 53739 | 107420 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 62 Naples St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 23 | 6004646.42863 | 2093164.0318599998 | 37.727692982045205 | -122.426172231973 | (37.7276929820452, -122.426172231973) | ||||
| 90228 | 90228 | 111728 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 MANOR DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993477.0 | 2093271.0 | 37.7273490481485 | -122.464792568508 | (37.7273490481485, -122.464792568508) | ||||
| 141580 | 141580 | 109627 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 500 CIRCULAR AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999334.0 | 2093430.0 | 37.728121569817 | -122.444556419888 | (37.728121569817, -122.444556419888) | ||||
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 78805 | 78805 | 97021 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 82893 | 82893 | 97042 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 88802 | 88802 | 97029 | Property Tree 7 | Rhamnus californica :: Coffeeberry Tree 232 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 90248 | 90248 | 97040 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 99914 | 99914 | 97028 | Property Tree 7 | Morus alba :: White Mulberry 112 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 104476 | 104476 | 97043 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 107550 | 107550 | 97032 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125485 | 125485 | 97041 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125835 | 125835 | 97004 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 127473 | 127473 | 97045 | Property Tree 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 128784 | 128784 | 97039 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140389 | 140389 | 97037 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140586 | 140586 | 97044 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140629 | 140629 | 97038 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 142369 | 142369 | 97035 | Property Tree 7 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145213 | 145213 | 97026 | Property Tree 7 | Tilia cordata :: Littleleaf Linden 208 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145522 | 145522 | 97036 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 78574 | 78574 | 109626 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 117 JUDSON AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999286.5 | 2093444.4 | 37.728158398345705 | -122.44472166307101 | (37.7281583983457, -122.444721663071) | |||||
| 11005 | 11005 | 108841 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Pioche St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773762 | 6006499.8637 | 2093472.98879 | 37.7286458955893 | -122.419786780156 | (37.7286458955893, -122.419786780156) | |
| 140792 | 140792 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6007547.0 | 2093670.0 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | |||||
| 97089 | 97089 | 102584 | Undocumented 2 | Tree(s) :: 17 | 22 Gennessee St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | |||||
| 105312 | 105312 | 122403 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 400X Circular Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999746.0 | 2093731.0 | 37.7289715465039 | -122.443153734972 | (37.7289715465039, -122.443153734972) | ||||
| 105446 | 105446 | 38572 | Permitted Site 1 | Dracaena draco :: Dragon Tree 361 | 1222 Palou Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/25/2016 12:00:00 AM | 3 | Permit Number 777465 | 6016907.86791438 | 2093772.63366009 | 37.730049495784 | -122.38382619652398 | (37.730049495784, -122.383826196524) | ||
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 77166 | 77166 | 77218 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 82646 | 82646 | 42355 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 88765 | 88765 | 42344 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 99139 | 99139 | 74759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 123438 | 123438 | 42348 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 93623 | 93623 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 103824 | 103824 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 114698 | 114698 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 103209 | 103209 | 122566 | Permitted Site 1 | Betula spp :: Birch 95 | 378 Sweeny St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779091 | 6008597.7357 | 2094518.65936 | 37.731635041845706 | -122.412608176508 | (37.7316350418457, -122.412608176508) | |
| 92510 | 92510 | 88654 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 120372 | 120372 | 88656 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 88044 | 88044 | 10731 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 103686 | 103686 | 10735 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 78294 | 78294 | 24522 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 45 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 92247 | 92247 | 10776 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 95381 | 95381 | 10763 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 22 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) |
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");