Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| 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) | |||
| 53479 | 53479 | 108406 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.41554073723302 | (37.7814172463574, -122.415540737233) | |
| 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) | |
| 88315 | 88315 | 108412 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 90414 | 90414 | 112573 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685.0 | 2098946.0 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | ||
| 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) | |
| 92393 | 92393 | 108411 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 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) | |
| 107281 | 107281 | 108413 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 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) | ||
| 112409 | 112409 | 108414 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 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) | |
| 113248 | 113248 | 112574 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685.0 | 2098946.0 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | ||
| 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) | ||
| 135927 | 135927 | 108405 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581001 | (37.7814823069089, -122.41555124581) | |
| 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) | ||
| 151164 | 151164 | 108408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.41551621722601 | (37.7812898924571, -122.415516217226) | |
| 170033 | 170033 | 108407 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | |
| 182575 | 182575 | 108410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530314995 | -122.41549695101801 | (37.781198530315, -122.415496951018) | |
| 184627 | 184627 | 108409 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.78123313714521 | -122.41550570771601 | (37.7812331371452, -122.415505707716) | |
| 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) | ||||
| 125644 | 125644 | 3784 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.735613192974704 | -122.382544123056 | (37.7356131929747, -122.382544123056) | ||
| 21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
| 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 | |||||||||
| 16933 | 16933 | 26076 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | ||
| 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) | ||
| 17492 | 17492 | 26073 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 285 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 8 | 3x3 | 5994159.2599 | 2088057.6707 | 37.7130738098987 | -122.462056111894 | (37.7130738098987, -122.462056111894) | ||
| 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) | ||
| 18540 | 18540 | 26342 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2630 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5997363.52119 | 2088889.5746799998 | 37.715541990037295 | -122.451041118862 | (37.7155419900373, -122.451041118862) | ||
| 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) | ||
| 19329 | 19329 | 26084 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 145 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 11 | 3X3 | 5995430.1902 | 2088042.6356 | 37.713105618543 | -122.457662291956 | (37.713105618543, -122.457662291956) | ||
| 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) |
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");