39,840 rows where qLegalStatus_id = 7 sorted by PlantDate descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);