trees
39,840 rows where qLegalStatus_id = 7 sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
9254 | 87113 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 4 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
37694 | 86761 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
49179 | 86765 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
58275 | 86763 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
60303 | 86768 | Permitted Site 7 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
65616 | 86757 | Permitted Site 7 | Prunus spp :: Cherry 68 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
68762 | 87112 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 3 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
73349 | 86764 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
127770 | 86766 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
135310 | 87111 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 2 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
140356 | 86759 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
153743 | 86758 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
156279 | 86760 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
161613 | 86767 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
176590 | 87115 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 6 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
183512 | 87114 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 5 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
4489 | 97354 | Permitted Site 7 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
7552 | 97352 | Permitted Site 7 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
10185 | 97351 | Permitted Site 7 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
12859 | 97357 | Permitted Site 7 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
13861 | 97353 | Permitted Site 7 | Tree(s) :: 17 | 3 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
16991 | 112614 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1799x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792 | 2103743 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | 10 | 3 | 8 | 28856 | 29 | ||
17452 | 97358 | Permitted Site 7 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
19547 | 97356 | Permitted Site 7 | Tree(s) :: 17 | 6 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
27649 | 64475 | Permitted Site 7 | Tree(s) :: 17 | 201 Quintara St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 03/27/2012 12:00:00 AM | Permit Number 768647 | 5992886.81207962 | 2101152.3784099 | 37.7489552885612 | -122.467405690566 | (37.7489552885612, -122.467405690566) | 1 | 8 | 4 | 29491 | 40 | |||
38815 | 96537 | Permitted Site 7 | Tree(s) :: 17 | 950X Kansas St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011564.8 | 2103917.5 | 37.7576083124183 | -122.403011228478 | (37.7576083124183, -122.403011228478) | 10 | 3 | 8 | 28856 | 29 | |||
59358 | 103517 | Permitted Site 7 | Prunus spp :: Cherry 68 | 55X MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 770452 | 6008432 | 2119159 | 37.7992824016355 | -122.414924482909 | (37.7992824016355, -122.414924482909) | 5 | 1 | 10 | 308 | 32 | ||||
60665 | 122555 | Permitted Site 7 | Tree(s) :: 17 | 1910X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6002640 | 2099906 | 37.7460912652213 | -122.433590100931 | (37.7460912652213, -122.433590100931) | 2 | 7 | 5 | 63 | 22 | |||||
68373 | 115524 | Permitted Site 7 | Tree(s) :: 17 | 25 FRANCONIA ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777451 | 6010006 | 2099954 | 37.7466382512014 | -122.408122694659 | (37.7466382512014, -122.408122694659) | 2 | 7 | 7 | 28859 | 2 | |
72174 | 105759 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 15 | Permit Number 771977 | 6002617 | 2100030 | 37.7464304351188 | -122.433678492599 | (37.7464304351188, -122.433678492599) | 2 | 7 | 5 | 63 | 22 | ||
85873 | 97535 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 300 Winfield St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.419591868256 | (37.7411896837785, -122.419591868256) | 2 | 7 | 7 | 28859 | 2 | |||||
114511 | 96539 | Permitted Site 7 | Tree(s) :: 17 | 952X Kansas St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011608.51303 | 2103942.83298 | 37.7576803120977 | -122.402861831849 | (37.7576803120977, -122.402861831849) | 10 | 3 | 8 | 28856 | 29 | |||
115258 | 97537 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 300 Winfield St | 3 | Unaccepted Street : Yard | Tree | Private 2 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.419591868256 | (37.7411896837785, -122.419591868256) | 2 | 7 | 7 | 28859 | 2 | |||||
131094 | 105760 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 5 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 15 | Permit Number 771977 | 6002617 | 2100030 | 37.7464304351188 | -122.433678492599 | (37.7464304351188, -122.433678492599) | 2 | 7 | 5 | 63 | 22 | ||
144693 | 105756 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | Permit Number 771977 | 6002640 | 2099906 | 37.7460912652213 | -122.433590100931 | (37.7460912652213, -122.433590100931) | 2 | 7 | 5 | 63 | 22 | ||
148055 | 96538 | Permitted Site 7 | Tree(s) :: 17 | 950X Kansas St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011564.8 | 2103917.5 | 37.7576083124183 | -122.403011228478 | (37.7576083124183, -122.403011228478) | 10 | 3 | 8 | 28856 | 29 | |||
161675 | 98378 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 199X Cragmont Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 768647 | 5992899 | 2101153 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | 1 | 8 | 4 | 29491 | 40 | ||||
164808 | 114584 | Permitted Site 7 | Tree(s) :: 17 | 3300x HARRISON ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | Permit Number 777406 | 6009042 | 2099449 | 37.745197609352 | -122.411420448228 | (37.745197609352, -122.411420448228) | 2 | 7 | 7 | 28859 | 2 | ||
171603 | 33896 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 150 Bronte St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 03/03/1997 12:00:00 AM | 25 | Permit Number 37869 | 6009276.59000035 | 2096641.35700735 | 37.7375015895327 | -122.410411061845 | (37.7375015895327, -122.410411061845) | 10 | 7 | 7 | 28859 | 2 | ||
177278 | 115526 | Permitted Site 7 | Tree(s) :: 17 | 25 FRANCONIA ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777451 | 6010006 | 2099954 | 37.7466382512014 | -122.408122694659 | (37.7466382512014, -122.408122694659) | 2 | 7 | 7 | 28859 | 2 | |
186015 | 97536 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 300 Winfield St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 768224 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.419591868256 | (37.7411896837785, -122.419591868256) | 2 | 7 | 7 | 28859 | 2 | ||||
980 | 96180 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767812 | ||||||||||||||
4537 | 96174 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767807 | ||||||||||||||
5227 | 96177 | Permitted Site 7 | Diospyros kaki :: Persimmon 288 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
6343 | 96176 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767809 | ||||||||||||||
6730 | 96175 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767808 | ||||||||||||||
8362 | 96178 | Permitted Site 7 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
11572 | 96179 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | Permit Number 767811 | |||||||||||||||
19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
1125 | 101207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
5032 | 85509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
11388 | 101208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
11701 | 87286 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1272 42nd Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | 1 | 8 | 3 | 56 | 35 | ||||
11838 | 94234 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
15788 | 93091 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
16748 | 96876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | 9 | 7 | 6 | 28861 | 25 | |||||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
17820 | 101211 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
20624 | 97964 | Permitted Site 7 | Tree(s) :: 17 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/10/2012 12:00:00 AM | 12 | 4x4 | Permit Number 768496 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.449589586059 | (37.7598420097441, -122.449589586059) | 15 | 5 | 11 | 29492 | 12 | |
21758 | 103918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
23452 | 85510 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
23885 | 100248 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | 1 | 8 | 4 | 29491 | 40 | |||
24093 | 94378 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
25047 | 93079 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
25386 | 93084 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
25544 | 94565 | Permitted Site 7 | Tree(s) :: 17 | 66 Saint Elmo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/17/2010 12:00:00 AM | 55 | Permit Number 53747 | 5995072.9 | 2094997.2 | 37.7321806567094 | -122.459400540638 | (37.7321806567094, -122.459400540638) | 9 | 8 | 4 | 59 | 40 | ||
27622 | 103900 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
29509 | 93088 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
29994 | 93085 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
30958 | 104965 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3660 21ST ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 3x4 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.7565180033839 | -122.429186559891 | (37.7565180033839, -122.429186559891) | 2 | 4 | 5 | 28862 | 3 | ||
32077 | 66057 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601 20th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/03/1990 12:00:00 AM | Permit Number 29097 | 5989923.85389835 | 2104457.9188665 | 37.7578599265617 | -122.477893114522 | (37.7578599265617, -122.477893114522) | 1 | 8 | 3 | 56 | 35 | |||
33863 | 91157 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | ||
34019 | 99712 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
35769 | 97545 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 2001 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
36409 | 54922 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 367 San Benito Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992758.47184875 | 2094166.59026038 | 37.7297666650173 | -122.467341592307 | (37.7297666650173, -122.467341592307) | 9 | 8 | 4 | 59 | 40 | |||
36976 | 94387 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
37153 | 97544 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 2001 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
38504 | 93093 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
38709 | 94383 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
41003 | 116084 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.460454581583 | (37.7430561859317, -122.460454581583) | 1 | 8 | 4 | 59 | 40 | |||
42522 | 93094 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
44422 | 94231 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
44745 | 93086 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
48424 | 94380 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
49060 | 94369 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.7726215084612 | -122.486483556825 | (37.7726215084612, -122.486483556825) | 11 | 6 | 2 | 55 | 26 | |||
49613 | 94388 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
50854 | 95880 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
51132 | 85506 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
51345 | 122814 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1648x York St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/29/2016 12:00:00 AM | 3 | 3x3 | 6010545 | 2100072 | 37.7469924183851 | -122.406267191996 | (37.7469924183851, -122.406267191996) | 2 | 7 | 7 | 28859 | 2 | ||
56445 | 101209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
57928 | 100247 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | 1 | 8 | 4 | 29491 | 40 | |||
59080 | 91155 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );