trees
39,840 rows where qLegalStatus_id = 7 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
35267 | 256901 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
46403 | 256899 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
64938 | 256897 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
78259 | 256898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
137019 | 256903 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
158583 | 256900 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
2065 | 849 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 36 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
12115 | 115003 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691 | 37.737359123084 | -122.42753146954 | (37.737359123084, -122.42753146954) | 2 | 7 | 5 | 63 | 7 | |||
76330 | 846 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
92208 | 87201 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637 | 2097914 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | 1 | 8 | 4 | 59 | 40 | ||
99901 | 88026 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
103072 | 847 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 24 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
111189 | 115001 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.7426880232123 | -122.46631133897 | (37.7426880232123, -122.46631133897) | 1 | 8 | 4 | 59 | 40 | |||
134667 | 55412 | Permitted Site 7 | Tree(s) :: 17 | 3738 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3 | 9x6 | Permit Number 777221 | 6003499.49370932 | 2103052.56810363 | 37.7547797324185 | -122.430842600357 | (37.7547797324185, -122.430842600357) | 2 | 4 | 5 | 28862 | 22 | |
141241 | 92271 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
141779 | 88025 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
147458 | 845 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
162493 | 60670 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.427511338031 | (37.737354818402, -122.427511338031) | 2 | 7 | 5 | 63 | 7 | ||
166075 | 67634 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.7400913848475 | -122.468021337222 | (37.7400913848475, -122.468021337222) | 1 | 8 | 4 | 59 | 40 | ||
167256 | 18309 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109 POTRERO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
169383 | 92270 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
177008 | 18308 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 111 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010285.0040856 | 2107800.6845896 | 37.7681991081888 | -122.407711102885 | (37.7681991081888, -122.407711102885) | 8 | 4 | 8 | 28853 | 19 | |
179348 | 844 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
189212 | 92269 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
193111 | 88024 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
68314 | 37918 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1350X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773093 | 6013279.95089898 | 2106637.32404771 | 37.765171979803 | -122.397270220878 | (37.765171979803, -122.397270220878) | 14 | 3 | 8 | 28856 | 20 | ||
133606 | 100571 | Permitted Site 7 | Prunus laurocerasus :: English laurel 371 | 20 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | 3x3 | Permit Number 770316 | 6004449 | 2107658 | 37.7674789047962 | -122.427887091326 | (37.7674789047962, -122.427887091326) | 8 | 4 | 5 | 28862 | 3 | ||
148693 | 64873 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.435407516384 | (37.77059279087, -122.435407516384) | 15 | 5 | 11 | 29492 | 9 | ||
190382 | 106925 | Permitted Site 7 | Tree(s) :: 17 | 4530 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | Permit Number 773337 | 6000944.17505 | 2105238.64712 | 37.7606370613449 | -122.439836300862 | (37.7606370613449, -122.439836300862) | 15 | 4 | 5 | 28862 | 3 | ||||
3571 | 102167 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) | 2 | 4 | 5 | 28862 | 3 |
57583 | 102176 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) | 2 | 5 | 5 | 28862 | 3 |
70350 | 59742 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 678 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769762 | 6002373.84394228 | 2104261.94389375 | 37.7580365463466 | -122.434821881783 | (37.7580365463466, -122.434821881783) | 2 | 4 | 5 | 28862 | 3 |
78795 | 102165 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) | 2 | 4 | 5 | 28862 | 3 |
79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
93994 | 102177 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465364 | -122.436794111878 | (37.758153465364, -122.436794111878) | 2 | 4 | 5 | 28862 | 3 |
95737 | 102169 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 235 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.75866298043 | -122.435726513037 | (37.75866298043, -122.435726513037) | 2 | 4 | 5 | 28862 | 3 |
140365 | 102175 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 484 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769767 | 5999426.4 | 2104189.2 | 37.7576690270565 | -122.445010134311 | (37.7576690270565, -122.445010134311) | 2 | 5 | 5 | 28862 | 3 |
145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
159714 | 102174 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
162075 | 102168 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.75866298043 | -122.435726513037 | (37.75866298043, -122.435726513037) | 2 | 4 | 5 | 28862 | 3 |
162120 | 58905 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018004 | 37.7584164881822 | -122.434678474426 | (37.7584164881822, -122.434678474426) | 2 | 4 | 5 | 28862 | 3 | ||
176623 | 102166 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 627 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769759 | 6002435.1 | 2104542.4 | 37.7588100889329 | -122.434630086253 | (37.7588100889329, -122.434630086253) | 2 | 4 | 5 | 28862 | 3 |
176681 | 102170 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 270 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | 6001983.1 | 2104294.8 | 37.7581045689631 | -122.436175590041 | (37.7581045689631, -122.436175590041) | 2 | 4 | 5 | 28862 | 3 | |
187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
194212 | 102173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
61718 | 92970 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2009 12:00:00 AM | 3x3 | Permit Number 53127 | 6003465.3 | 2106607.7 | 37.764539336845 | -122.431214598369 | (37.764539336845, -122.431214598369) | 15 | 4 | 5 | 28862 | 3 | ||
134049 | 57610 | Permitted Site 7 | Tree(s) :: 17 | 350 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2009 12:00:00 AM | Permit Number 53125 | 6013182.80165221 | 2105434.53689469 | 37.7618639828655 | -122.397521876032 | (37.7618639828655, -122.397521876032) | 10 | 3 | 8 | 28856 | 29 | ||
8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
73005 | 49014 | Permitted Site 7 | Syzygium paniculatum :: Brush Cherry 243 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
130924 | 49015 | Permitted Site 7 | Tree(s) :: 17 | 4378 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
192707 | 49012 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | 2 | 7 | 5 | 63 | 22 | |||
1227 | 46197 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
5488 | 46196 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
7997 | 46198 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
43091 | 26094 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 21 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996391.73364 | 2088029.79177 | 37.71312554209 | -122.454337965939 | (37.71312554209, -122.454337965939) | 9 | 8 | 6 | 28861 | 24 | ||
134857 | 26400 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 272 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994293.52025 | 2088114.03225 | 37.7132362944599 | -122.461596150309 | (37.7132362944599, -122.461596150309) | 9 | 8 | 6 | 28861 | 24 | ||
134634 | 66365 | Permitted Site 7 | Tree(s) :: 17 | 5522 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1990 12:00:00 AM | Permit Number 29487 | 5990472.1348999 | 2114087.04095849 | 37.7843306790394 | -122.476700440548 | (37.7843306790394, -122.476700440548) | 11 | 6 | 2 | 55 | 26 | |||
156715 | 20163 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1175 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | ||
15650 | 261311 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3368 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2019 12:00:00 AM | 3 | 3x3 | 5998140.71226 | 2116180.16914 | 37.7905196763565 | -122.450320900484 | (37.7905196763565, -122.450320900484) | 13 | 6 | 1 | 54 | 31 | ||
24608 | 36377 | Permitted Site 7 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | 9 | 7 | 4 | 28861 | 40 |
160120 | 36376 | Permitted Site 7 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | 9 | 7 | 4 | 28861 | 40 | |
93982 | 94498 | Permitted Site 7 | Myoporum laetum :: Myoporum 62 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | |||
105180 | 114988 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 2 | Side Yard : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.7415364116566 | -122.467057099516 | (37.7415364116566, -122.467057099516) | 1 | 8 | 4 | 59 | 40 | |||
107555 | 106975 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.77277 | 2098449.45466 | 37.7415362855926 | -122.467057190372 | (37.7415362855926, -122.467057190372) | 1 | 8 | 4 | 59 | 40 | |||
111216 | 94496 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | |||
18452 | 108642 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Judson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | 9 | 7 | 4 | 28861 | 40 | |
49227 | 108638 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 414 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.21639 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | 9 | 7 | 4 | 59 | 40 | |
49730 | 49426 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 430-438 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 770910 | 5993243.20305227 | 2105992.08375012 | 37.7622644352537 | -122.466525019945 | (37.7622644352537, -122.466525019945) | 1 | 8 | 11 | 56 | 12 | |
60569 | 66609 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.423125096713 | (37.7640893550041, -122.423125096713) | 8 | 4 | 5 | 28859 | 19 | |
69335 | 105728 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82-98X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862 | 2108710 | 37.7702775320686 | -122.433451492357 | (37.7702775320686, -122.433451492357) | 15 | 5 | 5 | 29492 | 9 |
77790 | 103262 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511 | 2108178 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | 8 | 4 | 7 | 28853 | 19 | |
83609 | 70696 | Permitted Site 7 | Elaeocarpus decipiens :: Japanese Blueberry Tree 321 | 40 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772487 | 6009871.61507193 | 2111016.36108742 | 37.7770054589734 | -122.409367943314 | (37.7770054589734, -122.409367943314) | 8 | 2 | 9 | 28853 | 34 |
117947 | 108633 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2610 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
129728 | 37482 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1440 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773208 | 5991178.05147208 | 2105601.75289786 | 37.7610733039937 | -122.473639055541 | (37.7610733039937, -122.473639055541) | 1 | 8 | 4 | 56 | 12 | |
142807 | 108678 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.83802 | 37.7270287484854 | -122.438834512765 | (37.7270287484854, -122.438834512765) | 9 | 7 | 6 | 28861 | 25 |
143336 | 105729 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82-98X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862 | 2108710 | 37.7702775320686 | -122.433451492357 | (37.7702775320686, -122.433451492357) | 15 | 5 | 5 | 29492 | 9 |
143429 | 108627 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 223 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772318 | 6001122.48631 | 2104986.51759 | 37.7599549235553 | -122.439201532761 | (37.7599549235553, -122.439201532761) | 2 | 4 | 5 | 28862 | 3 | |
160733 | 108628 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 741 Ellis St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | 7 | 9 | 9 | 28858 | 36 | |
168214 | 108636 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 68 Mangels Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774603 | 6000942.00546 | 2095224.20835 | 37.7331396755893 | -122.439126041581 | (37.7331396755893, -122.439126041581) | 9 | 7 | 5 | 63 | 40 | |
174379 | 108635 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
182870 | 108661 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 263 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773001 | 5990542.4091 | 2113638.39962 | 37.783102910833 | -122.476424534684 | (37.783102910833, -122.476424534684) | 11 | 6 | 2 | 55 | 26 | |
187282 | 108632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898 | 2105859 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) | 15 | 5 | 5 | 28862 | 3 |
193634 | 108648 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 196 Lippard Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | 9 | 7 | 5 | 63 | 40 | |
5664 | 50654 | Permitted Site 7 | Tree(s) :: 17 | 2824 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47236 | 6004394.14845271 | 2118840.16150037 | 37.7981792344265 | -122.428874109151 | (37.7981792344265, -122.428874109151) | 13 | 9 | 1 | 57 | 17 | |||
47587 | 50309 | Permitted Site 7 | Tree(s) :: 17 | 701 (REVISED) Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.7199495485694 | -122.460248307265 | (37.7199495485694, -122.460248307265) | 9 | 8 | 6 | 28861 | 24 | |||
70503 | 50653 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953359 | -122.452612074363 | (37.710694953359, -122.452612074363) | 9 | 7 | 6 | 28861 | 25 |
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) );