Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 160690 | 160690 | 118626 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 499 46th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 10ft | 5981578.2503 | 2112431.17888 | 37.7792642811872 | -122.507346739716 | (37.7792642811872, -122.507346739716) | |||
| 131480 | 131480 | 118634 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 5981640.48035 | 2112637.4972099997 | 37.779834435634896 | -122.507146773829 | (37.7798344356349, -122.507146773829) | ||||
| 131223 | 131223 | 118635 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | 5981642.90919 | 2112624.80307 | 37.779799724333294 | -122.50713742957399 | (37.7797997243333, -122.507137429574) | ||||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 137797 | 137797 | 118610 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5981717.62769 | 2112632.61479 | 37.77982557339521 | -122.506879529548 | (37.7798255733952, -122.506879529548) | ||||
| 39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
| 48507 | 48507 | 118600 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 5981958.17368 | 2112601.6345 | 37.779754673268705 | -122.506045091658 | (37.7797546732687, -122.506045091658) | ||||
| 39519 | 39519 | 118599 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5981986.20635 | 2112598.8818200002 | 37.7797487653148 | -122.50594791191901 | (37.7797487653148, -122.505947911919) | ||||
| 53743 | 53743 | 118598 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5982022.838269999 | 2112594.06181 | 37.7797376871414 | -122.50582083083799 | (37.7797376871414, -122.505820830838) | ||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 98898 | 98898 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 2 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 112260 | 112260 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 1 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 160229 | 160229 | 120264 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 100 24th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5988352.12015 | 2115168.07199 | 37.787175686198 | -122.48411416398301 | (37.787175686198, -122.484114163983) | ||||
| 166247 | 166247 | 120262 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 100 24th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | ||||
| 34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
| 163684 | 163684 | 120263 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 24th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | ||||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 43664 | 43664 | 120267 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 100 24th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988369.5187800005 | 2115107.91648 | 37.7870115292654 | -122.48404955627501 | (37.7870115292654, -122.484049556275) | ||||
| 78279 | 78279 | 117277 | Permitted Site 1 | Tree(s) :: 17 | 1745 Pacheco St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 06/01/2016 12:00:00 AM | 3 | Permit Number 778164 | 5989481.8 | 2101691.1 | 37.75023731196929 | -122.479219506966 | (37.7502373119693, -122.479219506966) | ||
| 103109 | 103109 | 117003 | Permitted Site 1 | Tree(s) :: 17 | 1701x PACHECO ST | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778399 | 5989693.0 | 2101699.0 | 37.750271267074 | -122.47848974966101 | (37.750271267074, -122.478489749661) | |
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 162601 | 162601 | 178307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 623 Brotherhood Way | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 5990951.00825 | 2088079.7183700001 | 37.712949111472604 | -122.473146401692 | (37.7129491114726, -122.473146401692) | |||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 156685 | 156685 | 206432 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1501 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 6ft | 5991165.77974 | 2105142.87216 | 37.759812628661706 | -122.473648022834 | (37.7598126286617, -122.473648022834) | |||
| 33553 | 33553 | 211325 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 6ft | 5991167.02607 | 2105120.24929 | 37.7597505844426 | -122.47364206215 | (37.7597505844426, -122.47364206215) | |||
| 50991 | 50991 | 203317 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1515 16th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 8ft | 5991175.14948 | 2105039.99944 | 37.759530710094296 | -122.47360811363899 | (37.7595307100943, -122.473608113639) | |||
| 171180 | 171180 | 211324 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991176.95636 | 2105105.05253 | 37.7597094332699 | -122.473606609976 | (37.7597094332699, -122.473606609976) | ||||
| 137129 | 137129 | 203318 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1515 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 8ft | 5991179.11324 | 2105030.95188 | 37.7595060974465 | -122.473593745149 | (37.7595060974465, -122.473593745149) | |||
| 46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
| 40913 | 40913 | 211323 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5991179.3605 | 2105090.2513200003 | 37.759668932303796 | -122.47359721564399 | (37.7596689323038, -122.473597215644) | ||||
| 2768 | 2768 | 219151 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 5991179.47447 | 2105124.8493 | 37.759763935780704 | -122.47359934526101 | (37.7597639357807, -122.473599345261) | |||
| 2776 | 2776 | 219152 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 6ft | 5991180.06905 | 2105137.8500200002 | 37.759799666743 | -122.473598237272 | (37.759799666743, -122.473598237272) | |||
| 2774 | 2774 | 219153 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 6ft | 5991180.54312 | 2105148.28148 | 37.759828336219705 | -122.473597358645 | (37.7598283362197, -122.473597358645) | |||
| 131514 | 131514 | 213997 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1500 16th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 5991180.77064 | 2105068.88436 | 37.7596103459632 | -122.47359078009501 | (37.7596103459632, -122.473590780095) | ||||
| 175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
| 157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
| 173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
| 157067 | 157067 | 218988 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1510 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5991201.1182 | 2105012.79044 | 37.759457505289504 | -122.47351631712 | (37.7594575052895, -122.47351631712) | ||||
| 3399 | 3399 | 251598 | Undocumented 2 | Tree(s) :: 17 | 900x Moraga St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780206 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | |
| 173872 | 173872 | 211287 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1549 15th Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991543.24459 | 2104910.37541 | 37.759196107445796 | -122.472325621056 | (37.7591961074458, -122.472325621056) | ||||
| 120316 | 120316 | 121151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1X Payson St | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 25 | 3x3 | 5992041.0 | 2087761.0 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | |||
| 80765 | 80765 | 121082 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 24X KEMPTON AVE | 6 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 112585 | 112585 | 117548 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 2 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 121639 | 121639 | 117546 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 126638 | 126638 | 117550 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 4 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
| 3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
| 64944 | 64944 | 218223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 399 Claremont Blvd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5993474.17256 | 2097846.02445 | 37.73991076848 | -122.465134496264 | (37.73991076848, -122.465134496264) | ||||
| 181473 | 181473 | 218224 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 5993477.431469999 | 2097858.26435 | 37.7399445640996 | -122.465124117182 | (37.7399445640996, -122.465124117182) | ||||
| 74085 | 74085 | 218197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5993480.75094 | 2097837.1493599997 | 37.7398867790468 | -122.465111106706 | (37.7398867790468, -122.465111106706) | ||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 136128 | 136128 | 218153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Ashton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5994153.71185 | 2090014.1877400002 | 37.7184456203604 | -122.46221709555 | (37.7184456203604, -122.46221709555) | ||||
| 39341 | 39341 | 218152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 22 Ashton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5994167.21256 | 2090073.13732 | 37.71860825915 | -122.46217470241601 | (37.71860825915, -122.462174702416) | ||||
| 159471 | 159471 | 130532 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997120.56574 | 2115634.70295 | 37.7889635367836 | -122.45381111889799 | (37.7889635367836, -122.453811118898) | |||
| 58449 | 58449 | 130533 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997122.58531 | 2115614.86787 | 37.7889091907409 | -122.453802698553 | (37.7889091907409, -122.453802698553) | |||
| 47947 | 47947 | 130534 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 4ft | 5997125.56519 | 2115595.68583 | 37.7888566928265 | -122.453791002876 | (37.7888566928265, -122.453791002876) | |||
| 166855 | 166855 | 129091 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 200 Spruce St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 5997131.25122 | 2115563.65608 | 37.78876907367739 | -122.45376901623399 | (37.7887690736774, -122.453769016234) | |||
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
| 182180 | 182180 | 210572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998021.954 | 2095543.6754599998 | 37.7338502677764 | -122.449244404708 | (37.7338502677764, -122.449244404708) | ||||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 182461 | 182461 | 205446 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Melrose Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 5998064.66474 | 2095546.64669 | 37.73386086896821 | -122.449096955455 | (37.7338608689682, -122.449096955455) | ||||
| 147311 | 147311 | 205445 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Melrose Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998069.65907 | 2095547.09422 | 37.7338623834248 | -122.449079720856 | (37.7338623834248, -122.449079720856) | ||||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
| 70865 | 70865 | 204586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998760.41171 | 2095319.0068400002 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | ||||
| 37058 | 37058 | 204587 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998761.6398599995 | 2095307.9959099998 | 37.733245428730996 | -122.446670146634 | (37.733245428731, -122.446670146634) | ||||
| 133793 | 133793 | 206299 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 231 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 5998763.35609 | 2095379.2875599999 | 37.733441276780205 | -122.446669340837 | (37.7334412767802, -122.446669340837) | ||||
| 174262 | 174262 | 205433 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 231 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5998775.87477 | 2095301.89625 | 37.733229493638 | -122.44662049415001 | (37.733229493638, -122.44662049415) | ||||
| 134530 | 134530 | 218787 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998781.19291 | 2095377.439 | 37.733437219949 | -122.44660754120702 | (37.733437219949, -122.446607541207) | ||||
| 152132 | 152132 | 218786 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998782.33461 | 2095362.2846400002 | 37.733395674875005 | -122.44660250410101 | (37.733395674875, -122.446602504101) | ||||
| 165042 | 165042 | 218785 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5998782.76063 | 2095352.74135 | 37.733369495591795 | -122.446600344857 | (37.7333694955918, -122.446600344857) | ||||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 133301 | 133301 | 218784 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998790.64503 | 2095351.5410200001 | 37.733366650131295 | -122.446573000066 | (37.7333666501313, -122.446573000066) | ||||
| 54571 | 54571 | 211276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 49 | 5998791.497719999 | 2095472.56851 | 37.7336990117025 | -122.446578756609 | (37.7336990117025, -122.446578756609) | ||||
| 29239 | 29239 | 211277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 5998792.56249 | 2095483.7387400002 | 37.7337297433315 | -122.44657587878599 | (37.7337297433315, -122.446575878786) | ||||
| 47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
| 69463 | 69463 | 205919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 230 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 5998797.1475 | 2095343.94395 | 37.7333461617934 | -122.44654997291599 | (37.7333461617934, -122.446549972916) | ||||
| 180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
| 152037 | 152037 | 211278 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 5998798.56109 | 2095521.95863 | 37.733835028746796 | -122.44655788876301 | (37.7338350287468, -122.446557888763) | ||||
| 179249 | 179249 | 206474 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 230 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5998806.12443 | 2095305.20487 | 37.73324030618979 | -122.446516151203 | (37.7332403061898, -122.446516151203) | ||||
| 48369 | 48369 | 179631 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 184 Mount Vernon Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998932.987869999 | 2089405.3609099998 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | ||||
| 59717 | 59717 | 178076 | Undocumented 2 | Persea americana :: Avocado 113 | 184 Mount Vernon Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998937.21643 | 2089402.34913 | 37.7170399224441 | -122.44563859365401 | (37.7170399224441, -122.445638593654) | ||||
| 174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
| 35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
| 184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
| 65775 | 65775 | 176097 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998962.663240001 | 2089377.08137 | 37.716971995749795 | -122.445548820645 | (37.7169719957498, -122.445548820645) |
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");