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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106389 | 106389 | 107523 | Permitted Site 1 | Tree(s) :: 17 | 100X Lawton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/19/2014 12:00:00 AM | 3 | Permit Number 773356 | 5993852.82258 | 2104613.64437 | 37.7585147583588 | -122.46431651019199 | (37.7585147583588, -122.464316510192) | ||
| 106397 | 106397 | 103922 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fitzgerald Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 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) | ||
| 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) | |||||
| 107558 | 107558 | 103901 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 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) | ||
| 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) | |||
| 108542 | 108542 | 102129 | Permitted Site 1 | Tree(s) :: 17 | 79 Starview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.751199689085205 | -122.451673814863 | (37.7511996890852, -122.451673814863) | |||
| 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) | |||
| 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) | |||
| 109365 | 109365 | 107697 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 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) | |||
| 109731 | 109731 | 103908 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 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) | ||||
| 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) | |||
| 111919 | 111919 | 101477 | Permitted Site 1 | Tree(s) :: 17 | 1 Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | Permit Number 769453 | 5996419.1 | 2103319.0 | 37.7551075796122 | -122.455347659049 | (37.7551075796122, -122.455347659049) | |||
| 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) | |
| 112388 | 112388 | 97300 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 112608 | 112608 | 97965 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x4 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | ||||
| 112755 | 112755 | 103916 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fitzgerald Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 113655 | 113655 | 101212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 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) | |||||
| 114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 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) | ||
| 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) | |||||
| 114706 | 114706 | 96989 | 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) | ||||
| 114794 | 114794 | 101206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 115703 | 115703 | 103914 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fitzgerald Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 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) | ||
| 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) | |
| 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) | ||||
| 117202 | 117202 | 113146 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||||
| 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) | |||
| 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) | |||||
| 118191 | 118191 | 103906 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 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) | ||||
| 120276 | 120276 | 103903 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 120600 | 120600 | 97302 | Permitted Site 1 | Salix spp :: Willow 218 | 1051 Portola Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 120716 | 120716 | 106300 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 687 28th St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | |||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 121549 | 121549 | 103923 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 121744 | 121744 | 107696 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 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) | ||
| 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) | |||
| 123859 | 123859 | 101211 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 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) | |||
| 124611 | 124611 | 103905 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 124748 | 124748 | 103918 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 126095 | 126095 | 97964 | Permitted Site 1 | Tree(s) :: 17 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 12 | 4x4 | Permit Number 768496 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||
| 128312 | 128312 | 103900 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 128441 | 128441 | 97544 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 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) | |||
| 129197 | 129197 | 104965 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3660 21ST ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 3x4 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.756518003383896 | -122.429186559891 | (37.7565180033839, -122.429186559891) | ||
| 129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 129336 | 129336 | 97545 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 130630 | 130630 | 104345 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6014995.86461 | 2104338.49081 | 37.7589552627061 | -122.391174540789 | (37.7589552627061, -122.391174540789) | ||||
| 134430 | 134430 | 104344 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6014997.70938 | 2104304.04046 | 37.7588607718232 | -122.391165752619 | (37.7588607718232, -122.391165752619) | ||||
| 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) | |||
| 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) | ||
| 138626 | 138626 | 102585 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | |||
| 138857 | 138857 | 103904 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 138871 | 138871 | 97543 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 138913 | 138913 | 113080 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 89 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x2 | Permit Number 776239 | 5994496.1 | 2101295.2 | 37.7494402154084 | -122.461851162221 | (37.7494402154084, -122.461851162221) | |||
| 138966 | 138966 | 103921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 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) | |||
| 139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 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) | ||
| 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) | ||||
| 141000 | 141000 | 103915 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 141297 | 141297 | 107698 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 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) | ||
| 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) | ||||
| 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) | |
| 144474 | 144474 | 102871 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 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) | ||
| 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) | |||
| 144807 | 144807 | 103910 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 150129 | 150129 | 106243 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 580 De Haro St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Permit Number 770844 | 6012044.67282 | 2105739.34228 | 37.7626374729575 | -122.401479659865 | (37.7626374729575, -122.401479659865) | |||
| 155586 | 155586 | 106240 | Permitted Site 1 | Acacia dealbata :: Silver Wattle 434 | 580 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 770844 | 6012038.28061 | 2105776.10992 | 37.7627380720357 | -122.40150435254401 | (37.7627380720357, -122.401504352544) | |||
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 241 | 241 | 251257 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 251 | 251 | 251258 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 545 | 545 | 251322 | Undocumented 2 | Betula spp :: Birch 95 | 828 Foerster St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5998302.82159 | 2096489.58159 | 37.7364635618398 | -122.448341458403 | (37.7364635618398, -122.448341458403) | ||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) |
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");