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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49965 | 49965 | 114038 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2x Moffitt St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6002767.774130001 | 2096661.3136900002 | 37.737189358209704 | -122.43291650912201 | (37.7371893582097, -122.432916509122) | ||||
| 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) | |||
| 88155 | 88155 | 114671 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
| 83587 | 83587 | 114672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
| 112258 | 112258 | 114673 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
| 114561 | 114561 | 114882 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 801x Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6004188.833980001 | 2094500.26728 | 37.731336111506295 | -122.42784931643499 | (37.7313361115063, -122.427849316435) | |||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 100045 | 100045 | 120550 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298x Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 10 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 100141 | 100141 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 145551 | 145551 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100583 | 100583 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 108310 | 108310 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 86677 | 86677 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92655 | 92655 | 121162 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92297 | 92297 | 121163 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 119339 | 119339 | 121341 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 401X Cargo Way | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 3x3 | 6017217.0 | 2098844.0 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | |||
| 86485 | 86485 | 122824 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 407x Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6010366.0 | 2120356.0 | 37.8026775529699 | -122.40831661418899 | (37.8026775529699, -122.408316614189) | |||||
| 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) | ||||
| 181546 | 181546 | 125276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | ||||
| 176347 | 176347 | 125277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6006721.71386 | 2119753.35883 | 37.800818109519206 | -122.420884898228 | (37.8008181095192, -122.420884898228) | ||||
| 172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) | ||||
| 73129 | 73129 | 125336 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6008636.03175 | 2118982.55728 | 37.7988093963818 | -122.41420596974702 | (37.7988093963818, -122.414205969747) | ||||
| 132907 | 132907 | 125337 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6008660.27555 | 2118990.50152 | 37.79883257103621 | -122.414122640373 | (37.7988325710362, -122.414122640373) | ||||
| 68308 | 68308 | 125338 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008681.05502 | 2118993.3413 | 37.7988415354762 | -122.414050937395 | (37.7988415354762, -122.414050937395) | ||||
| 183929 | 183929 | 125339 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6008681.4461 | 2118995.9175299997 | 37.7988486311296 | -122.414049766478 | (37.7988486311296, -122.414049766478) | ||||
| 57891 | 57891 | 125340 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6008683.32426 | 2118993.96894 | 37.798843386272395 | -122.41404312948299 | (37.7988433862724, -122.414043129483) | ||||
| 35403 | 35403 | 125386 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 943 Vallejo St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008816.3361599995 | 2118653.07682 | 37.797914850658 | -122.413558740271 | (37.797914850658, -122.413558740271) | ||||
| 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) | ||||
| 162918 | 162918 | 126034 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 2390 Bay St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 4ft | 5999370.04259 | 2120163.81894 | 37.801527995669204 | -122.446354207574 | (37.8015279956692, -122.446354207574) | |||
| 52971 | 52971 | 126040 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2390 Bay St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.801529357251205 | -122.446341287942 | (37.8015293572512, -122.446341287942) | |||
| 122555 | 122555 | 126122 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2833 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.42182910722799 | (37.804070054442, -122.421829107228) | ||||
| 31946 | 31946 | 126123 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2836 Larkin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341001 | (37.8041539827815, -122.42172367341) | ||||
| 179457 | 179457 | 126275 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2836 Larkin St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | ||||
| 35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
| 59780 | 59780 | 126415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 48 | 6006502.51226 | 2121001.4648 | 37.804232732814704 | -122.421732129727 | (37.8042327328147, -122.421732129727) | ||||
| 184674 | 184674 | 126416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6006501.512069999 | 2121012.26216 | 37.804262323204895 | -122.421736358356 | (37.8042623232049, -122.421736358356) | ||||
| 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) | |||
| 32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
| 147117 | 147117 | 129641 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 943 Green St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.41406679246201 | (37.7987948111981, -122.414066792462) | ||||
| 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) | |||
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 165040 | 165040 | 131051 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1285 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006739.62065 | 2119756.87873 | 37.8008287835889 | -122.42082318315701 | (37.8008287835889, -122.420823183157) | ||||
| 130652 | 130652 | 132198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6006512.519719999 | 2121038.28328 | 37.804334391275894 | -122.42170011478301 | (37.8043343912759, -122.421700114783) | ||||
| 187806 | 187806 | 132199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085543998 | (37.8043563455331, -122.42175085544) | ||||
| 173443 | 173443 | 132298 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.42171884046199 | (37.8042069600397, -122.421718840462) | ||||
| 147259 | 147259 | 132299 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006506.76363 | 2120995.98891 | 37.8042179371566 | -122.421717028328 | (37.8042179371566, -122.421717028328) | ||||
| 38844 | 38844 | 132391 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6006489.423769999 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | ||||
| 155855 | 155855 | 132392 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006479.362930001 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | ||||
| 72084 | 72084 | 132393 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006475.56322 | 2120927.38496 | 37.8040278087899 | -122.42182012391001 | (37.8040278087899, -122.42182012391) | ||||
| 130704 | 130704 | 132394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006476.08021 | 2120921.35396 | 37.804011278359205 | -122.42181790617599 | (37.8040112783592, -122.421817906176) | ||||
| 31588 | 31588 | 132395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6006513.4872 | 2120932.40539 | 37.8040437321931 | -122.42168924196999 | (37.8040437321931, -122.42168924197) | ||||
| 30048 | 30048 | 132396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 6006504.32212 | 2120945.10898 | 37.804078096188704 | -122.421721861273 | (37.8040780961887, -122.421721861273) | ||||
| 57817 | 57817 | 132397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006502.73263 | 2120950.76111 | 37.804093525861795 | -122.42172776352899 | (37.8040935258618, -122.421727763529) | ||||
| 58870 | 58870 | 132398 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006507.37075 | 2120957.5617299997 | 37.8041124601724 | -122.421712196283 | (37.8041124601724, -122.421712196283) | ||||
| 177265 | 177265 | 132399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | ||||
| 153202 | 153202 | 132422 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6008806.4990300005 | 2118647.23011 | 37.7978982446696 | -122.413592365905 | (37.7978982446696, -122.413592365905) | ||||
| 44694 | 44694 | 132423 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.41355547121401 | (37.7979513838133, -122.413555471214) | ||||
| 179610 | 179610 | 132424 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008826.962619999 | 2118671.13776 | 37.7979650382118 | -122.41352324761101 | (37.7979650382118, -122.413523247611) | ||||
| 175972 | 175972 | 132431 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008617.41774 | 2118989.2974400003 | 37.7988268576225 | -122.41427085762501 | (37.7988268576225, -122.414270857625) | ||||
| 55110 | 55110 | 132432 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008616.66785 | 2118981.63248 | 37.7988057694225 | -122.41427290988999 | (37.7988057694225, -122.41427290989) | ||||
| 76994 | 76994 | 132433 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008619.19252 | 2118974.8638 | 37.79878732612271 | -122.41426369452499 | (37.7987873261227, -122.414263694525) | ||||
| 63952 | 63952 | 132434 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6008620.992269999 | 2118990.5013599996 | 37.7988303640752 | -122.41425857377199 | (37.7988303640752, -122.414258573772) | ||||
| 63232 | 63232 | 132435 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6008622.60306 | 2118990.33445 | 37.7988299962621 | -122.414252988079 | (37.7988299962621, -122.414252988079) | ||||
| 64602 | 64602 | 132436 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008624.64494 | 2118991.4983200002 | 37.798833306655105 | -122.414246004875 | (37.7988333066551, -122.414246004875) | ||||
| 62899 | 62899 | 132437 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6008631.997880001 | 2118976.07541 | 37.7987913721926 | -122.414219469452 | (37.7987913721926, -122.414219469452) | ||||
| 133323 | 133323 | 132438 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008636.9513 | 2118981.46679 | 37.798806453817896 | -122.414202710601 | (37.7988064538179, -122.414202710601) | ||||
| 154158 | 154158 | 132459 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.42185659591699 | (37.8025801584021, -122.421856595917) | ||||
| 62403 | 62403 | 132460 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006458.07728 | 2120400.55617 | 37.8025802852249 | -122.421843190623 | (37.8025802852249, -122.421843190623) |
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");