Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14496 | 14496 | 843 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010316.34076 | 2107575.5688099996 | 37.7675827459718 | -122.407586838062 | (37.7675827459718, -122.407586838062) | |
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 16748 | 16748 | 18307 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 18 | 3x3 | Permit Number 777000 | 6010317.92211 | 2107539.48864 | 37.7674837665976 | -122.407578824211 | (37.7674837665976, -122.407578824211) | |
| 50077 | 50077 | 849 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 36 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 50165 | 50165 | 115003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691.0 | 37.737359123084005 | -122.42753146953999 | (37.737359123084, -122.42753146954) | |||
| 85779 | 85779 | 110615 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 91663 | 91663 | 87201 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637.0 | 2097914.0 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | ||
| 92141 | 92141 | 846 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 100042 | 100042 | 115001 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.742688023212295 | -122.46631133896999 | (37.7426880232123, -122.46631133897) | |||
| 100340 | 100340 | 88026 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175.0 | 2112425.0 | 37.78077804050471 | -122.415336822355 | (37.7807780405047, -122.415336822355) | ||
| 100887 | 100887 | 847 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 24 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 110515 | 110515 | 92271 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 112902 | 112902 | 55412 | Permitted Site 1 | Tree(s) :: 17 | 3738 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 9x6 | Permit Number 777221 | 6003499.49370932 | 2103052.56810363 | 37.7547797324185 | -122.430842600357 | (37.7547797324185, -122.430842600357) | |
| 114874 | 114874 | 88025 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175.0 | 2112425.0 | 37.78077804050471 | -122.415336822355 | (37.7807780405047, -122.415336822355) | ||
| 115269 | 115269 | 845 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 117539 | 117539 | 92270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1650 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 119190 | 119190 | 67634 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.740091384847496 | -122.468021337222 | (37.7400913848475, -122.468021337222) | ||
| 122896 | 122896 | 18309 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109 POTRERO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 123218 | 123218 | 60670 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.42751133803101 | (37.737354818402, -122.427511338031) | ||
| 139730 | 139730 | 18308 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 111 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010285.004085599 | 2107800.6845896 | 37.768199108188796 | -122.407711102885 | (37.7681991081888, -122.407711102885) | |
| 143017 | 143017 | 92269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1650 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 143386 | 143386 | 110614 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 144425 | 144425 | 844 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | |
| 145274 | 145274 | 88024 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175.0 | 2112425.0 | 37.78077804050471 | -122.415336822355 | (37.7807780405047, -122.415336822355) | ||
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 85940 | 85940 | 37918 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1350X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773093 | 6013279.95089898 | 2106637.32404771 | 37.765171979803 | -122.39727022087799 | (37.765171979803, -122.397270220878) | ||
| 110782 | 110782 | 64873 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.43540751638399 | (37.77059279087, -122.435407516384) | ||
| 115278 | 115278 | 100571 | Permitted Site 1 | Prunus laurocerasus :: English laurel 227 | 20 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2014 12:00:00 AM | 3x3 | Permit Number 770316 | 6004449.0 | 2107658.0 | 37.76747890479621 | -122.42788709132601 | (37.7674789047962, -122.427887091326) | ||
| 146076 | 146076 | 106925 | Permitted Site 1 | Tree(s) :: 17 | 4530 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2014 12:00:00 AM | Permit Number 773337 | 6000944.17505 | 2105238.64712 | 37.7606370613449 | -122.43983630086201 | (37.7606370613449, -122.439836300862) | ||||
| 83699 | 83699 | 102167 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) |
| 86638 | 86638 | 59742 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 678 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769762 | 6002373.84394228 | 2104261.94389375 | 37.7580365463466 | -122.43482188178301 | (37.7580365463466, -122.434821881783) |
| 89281 | 89281 | 102176 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) |
| 92794 | 92794 | 102177 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465363996 | -122.436794111878 | (37.758153465364, -122.436794111878) |
| 93426 | 93426 | 102165 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) |
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 99121 | 99121 | 102169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 111579 | 111579 | 102175 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 484 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769767 | 5999426.4 | 2104189.2 | 37.7576690270565 | -122.445010134311 | (37.7576690270565, -122.445010134311) |
| 111655 | 111655 | 102180 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) |
| 117367 | 117367 | 102168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 117592 | 117592 | 102174 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.44109912879699 | (37.7615509231117, -122.441099128797) | |
| 119070 | 119070 | 58905 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018003996 | 37.7584164881822 | -122.43467847442601 | (37.7584164881822, -122.434678474426) | ||
| 142248 | 142248 | 102166 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 627 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769759 | 6002435.1 | 2104542.4 | 37.7588100889329 | -122.434630086253 | (37.7588100889329, -122.434630086253) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143949 | 143949 | 102170 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 270 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | 6001983.1 | 2104294.8 | 37.758104568963105 | -122.436175590041 | (37.7581045689631, -122.436175590041) | |
| 144941 | 144941 | 102173 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.44109912879699 | (37.7615509231117, -122.441099128797) | |
| 74210 | 74210 | 92968 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 633 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 53126 | 6011005.62443 | 2105237.5214299997 | 37.7612015551355 | -122.40503803797199 | (37.7612015551355, -122.405038037972) | |
| 85018 | 85018 | 92970 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2009 12:00:00 AM | 3x3 | Permit Number 53127 | 6003465.3 | 2106607.7 | 37.764539336845004 | -122.43121459836901 | (37.764539336845, -122.431214598369) | ||
| 112141 | 112141 | 57610 | Permitted Site 1 | Tree(s) :: 17 | 350 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2009 12:00:00 AM | Permit Number 53125 | 6013182.80165221 | 2105434.53689469 | 37.7618639828655 | -122.39752187603202 | (37.7618639828655, -122.397521876032) | ||
| 20472 | 20472 | 89331 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4658 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201.0 | 2105201.0 | 37.760491360371596 | -122.4424038966 | (37.7604913603716, -122.4424038966) | |||
| 66740 | 66740 | 91087 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207.0 | 2088764.0 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | |||
| 128266 | 128266 | 91088 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207.0 | 2088751.0 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | ||
| 41700 | 41700 | 87109 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1358 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50058 | 5985264.3746 | 2105978.0640000002 | 37.761762290042704 | -122.49411934585301 | (37.7617622900427, -122.494119345853) | |
| 45697 | 45697 | 38488 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2003 12:00:00 AM | 12 | Permit Number 47240 | 6008353.25415 | 2118952.7565200003 | 37.7987116832495 | -122.415182364581 | (37.7987116832495, -122.415182364581) | |
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 90654 | 90654 | 49014 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.974491901 | 2105793.6078214003 | 37.762116974703495 | -122.442539913685 | (37.7621169747035, -122.442539913685) | |||
| 105940 | 105940 | 49015 | Permitted Site 1 | Tree(s) :: 17 | 4378 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.974491901 | 2105793.6078214003 | 37.762116974703495 | -122.442539913685 | (37.7621169747035, -122.442539913685) | |||
| 146129 | 146129 | 49012 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | |||
| 3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 5809 | 5809 | 46193 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 10516 | 10516 | 46191 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11887 | 11887 | 46194 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11991 | 11991 | 46192 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13775 | 13775 | 46199 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 14367 | 14367 | 46202 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 17145 | 17145 | 26089 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 69 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996119.0708099995 | 2088037.05628 | 37.7131298482426 | -122.455280899808 | (37.7131298482426, -122.455280899808) | ||
| 17541 | 17541 | 26090 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 10 | 3X3 | 5996152.8898599995 | 2088036.7197200002 | 37.7131308644675 | -122.455163986131 | (37.7131308644675, -122.455163986131) | ||
| 18286 | 18286 | 26079 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 233 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 9 | 3X3 | 5994695.0262 | 2088049.5542 | 37.7130823559233 | -122.46020374932199 | (37.7130823559233, -122.460203749322) | ||
| 18445 | 18445 | 26085 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 137 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5995511.0035 | 2088041.696 | 37.7131076806722 | -122.457382907838 | (37.7131076806722, -122.457382907838) | ||
| 18756 | 18756 | 26074 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 281 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994215.6413 | 2088057.2008 | 37.713075765644604 | -122.46186120626801 | (37.7130757656446, -122.461861206268) | ||
| 19513 | 19513 | 26034 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Broad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 10 | 3X3 | 5996410.41215 | 2088086.4928700002 | 37.7132823013076 | -122.454277500129 | (37.7132823013076, -122.454277500129) | ||
| 20090 | 20090 | 26095 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 15 | 3X3 | 5996463.561430001 | 2088032.82115 | 37.7131379789998 | -122.454089924914 | (37.7131379789998, -122.454089924914) | ||
| 21491 | 21491 | 26033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 4 | 3X3 | 5996445.70952 | 2088085.7556900003 | 37.7132823012984 | -122.45415544772699 | (37.7132823012984, -122.454155447727) | ||
| 21833 | 21833 | 26080 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 225 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5994777.2272 | 2088048.9194 | 37.7130853407984 | -122.459919591104 | (37.7130853407984, -122.459919591104) | ||
| 21968 | 21968 | 26072 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 287 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994124.0216 | 2088057.6707 | 37.713071781001894 | -122.46217790636001 | (37.7130717810019, -122.46217790636) | ||
| 22069 | 22069 | 26082 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 205 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 8 | 3X3 | 5994939.7251 | 2088047.0152 | 37.71308945655289 | -122.459357809835 | (37.7130894565529, -122.459357809835) | ||
| 22239 | 22239 | 26081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 219 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994828.0078 | 2088047.6499 | 37.7130847754132 | -122.45974398562099 | (37.7130847754132, -122.459743985621) | ||
| 79471 | 79471 | 26094 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996391.73364 | 2088029.79177 | 37.71312554209 | -122.454337965939 | (37.71312554209, -122.454337965939) | ||
| 113738 | 113738 | 26400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 272 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994293.52025 | 2088114.03225 | 37.7132362944599 | -122.46159615030899 | (37.7132362944599, -122.461596150309) | ||
| 111946 | 111946 | 66365 | Permitted Site 1 | Tree(s) :: 17 | 5522 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1990 12:00:00 AM | Permit Number 29487 | 5990472.1348999 | 2114087.04095849 | 37.7843306790394 | -122.476700440548 | (37.7843306790394, -122.476700440548) | |||
| 119295 | 119295 | 20163 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1175 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | ||
| 9829 | 9829 | 57473 | Permitted Site 1 | Tree(s) :: 17 | 51 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778400 | 5998920.48261 | 2116370.17499 | 37.7910859772748 | -122.447636637234 | (37.7910859772748, -122.447636637234) | |
| 9831 | 9831 | 36377 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) |
| 9832 | 9832 | 36376 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | |
| 21548 | 21548 | 31364 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391001 | (37.745296448467, -122.47378484391) | |
| 91286 | 91286 | 94498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 99058 | 99058 | 114988 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1020 Ulloa St | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.741536411656604 | -122.467057099516 | (37.7415364116566, -122.467057099516) | |||
| 100920 | 100920 | 94496 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 101924 | 101924 | 106975 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1020 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.77277 | 2098449.45466 | 37.7415362855926 | -122.467057190372 | (37.7415362855926, -122.467057190372) | |||
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 58949 | 58949 | 108642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 167 Judson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | |
| 80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");