Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134629 | 134629 | 45072 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 580 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Permit Number 770844 | 6012040.04022 | 2105787.48822 | 37.7627694124935 | -122.401499066356 | (37.7627694124935, -122.401499066356) | |||
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 104446 | 104446 | 53220 | Permitted Site 1 | Citrus x hystrix :: Kaffir lime 515 | 311 San Benito Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | 3x7 | Permit Number 769253 | 5992906.41199583 | 2094772.69381636 | 37.7314394147179 | -122.466874195473 | (37.7314394147179, -122.466874195473) | ||
| 125592 | 125592 | 54922 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 367 San Benito Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992758.47184875 | 2094166.59026038 | 37.729766665017294 | -122.467341592307 | (37.7297666650173, -122.467341592307) | |||
| 125286 | 125286 | 66057 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/03/1990 12:00:00 AM | Permit Number 29097 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||
| 121226 | 121226 | 66980 | Permitted Site 1 | Tree(s) :: 17 | 320 Santa Ana Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | Permit Number 769440 | 5992591.07178475 | 2094730.63231779 | 37.7313057191225 | -122.467961318401 | (37.7313057191225, -122.467961318401) | |||
| 117301 | 117301 | 72691 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
| 94230 | 94230 | 72891 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
| 117346 | 117346 | 85502 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 87896 | 87896 | 85505 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 83308 | 83308 | 85506 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 77508 | 77508 | 85510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 87738 | 87738 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330.0 | 2096776.0 | 37.737422605415205 | -122.43789575270901 | (37.7374226054152, -122.437895752709) | |||
| 122346 | 122346 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.779498769084604 | -122.46395756623998 | (37.7794987690846, -122.46395756624) | ||||
| 18682 | 18682 | 87286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1272 42nd Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | ||||
| 112080 | 112080 | 91153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 89039 | 89039 | 91154 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 90242 | 90242 | 91155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 106739 | 106739 | 91156 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 127660 | 127660 | 91157 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 143680 | 143680 | 91158 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 97616 | 97616 | 91159 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 110148 | 110148 | 92047 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 119294 | 119294 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1001 Potrero Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 123605 | 123605 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1001 Potrero Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 13319 | 13319 | 93075 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1230 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 109090 | 109090 | 93076 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 108406 | 108406 | 93077 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 104976 | 104976 | 93078 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 126285 | 126285 | 93079 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 96674 | 96674 | 93080 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 139099 | 139099 | 93081 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 102109 | 102109 | 93082 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 111279 | 111279 | 93083 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 124821 | 124821 | 93084 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 127530 | 127530 | 93085 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 80355 | 80355 | 93086 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 88184 | 88184 | 93087 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 128728 | 128728 | 93088 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 101164 | 101164 | 93089 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 94930 | 94930 | 93090 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 123792 | 123792 | 93091 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 101678 | 101678 | 93092 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 124365 | 124365 | 93093 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 83063 | 83063 | 93094 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 93093 | 93093 | 93196 | Permitted Site 1 | Tree(s) :: 17 | 1223 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/19/2010 12:00:00 AM | Permit Number 53200 | 5988582.3 | 2106975.8 | 37.764695390778606 | -122.482717226164 | (37.7646953907786, -122.482717226164) | |||
| 107755 | 107755 | 94230 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Everglade Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 84102 | 84102 | 94231 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 116587 | 116587 | 94232 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 88999 | 88999 | 94233 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 141881 | 141881 | 94235 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 27 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 116621 | 116621 | 94328 | Permitted Site 1 | Acacia cognata :: River Wattle 249 | 599X Wisconsin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | 6 | 8x6 | Permit Number 53628 | 6012719.6074 | 2104814.62781 | 37.7601360473633 | -122.39908037835899 | (37.7601360473633, -122.399080378359) | |
| 120993 | 120993 | 94368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 81316 | 81316 | 94369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 110217 | 110217 | 94377 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 125326 | 125326 | 94378 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87626 | 87626 | 94379 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 83515 | 83515 | 94380 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 100408 | 100408 | 94381 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 143608 | 143608 | 94382 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 84196 | 84196 | 94383 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87589 | 87589 | 94384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 95304 | 95304 | 94385 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 116794 | 116794 | 94386 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 127453 | 127453 | 94387 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 78735 | 78735 | 94388 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 108858 | 108858 | 94503 | Permitted Site 1 | Tree(s) :: 17 | 60 Fernwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/24/2010 12:00:00 AM | Permit Number 53693 | 5994613.0 | 2095460.0 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | |||
| 127983 | 127983 | 94565 | Permitted Site 1 | Tree(s) :: 17 | 66 Saint Elmo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/17/2010 12:00:00 AM | 55 | Permit Number 53747 | 5995072.9 | 2094997.2 | 37.732180656709396 | -122.45940054063801 | (37.7321806567094, -122.459400540638) | ||
| 140594 | 140594 | 94706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 86950 | 86950 | 94707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 84685 | 84685 | 95096 | Permitted Site 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | 10 | Permit Number 54030 | 5999362.0 | 2116697.3 | 37.7920093994348 | -122.44613254842899 | (37.7920093994348, -122.446132548429) | ||
| 91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 138461 | 138461 | 95531 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2569 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/30/2010 12:00:00 AM | 25x100x60 | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | ||
| 93391 | 93391 | 95532 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2569 San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/30/2010 12:00:00 AM | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | |||
| 109467 | 109467 | 95533 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2569 San Jose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/30/2010 12:00:00 AM | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | |||
| 79736 | 79736 | 95880 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 114374 | 114374 | 95881 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 144564 | 144564 | 95882 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 42964 | 42964 | 95883 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 122040 | 122040 | 95884 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 40007 | 40007 | 95885 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 84812 | 84812 | 96294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | ||
| 18031 | 18031 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 122848 | 122848 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 114437 | 114437 | 96866 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 107496 | 107496 | 96868 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 114131 | 114131 | 96875 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 61149 | 61149 | 96876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 101381 | 101381 | 96988 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) |
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");