Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | 76 | 241180 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | |
| 82 | 82 | 241178 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004795.3896699995 | 2108410.1055900003 | 37.769563595403106 | -122.42674254153299 | (37.7695635954031, -122.426742541533) | |
| 90 | 90 | 241179 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004783.47466 | 2108409.88584 | 37.769562318364 | -122.426783739481 | (37.769562318364, -122.426783739481) | |
| 91 | 91 | 241181 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004757.3052900005 | 2108409.26199 | 37.7695591257908 | -122.42687421397 | (37.7695591257908, -122.42687421397) | |
| 604 | 604 | 171523 | Permitted Site 1 | Tree(s) :: 17 | 281 Harvard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779632 | 6006304.03409 | 2092571.58308 | 37.7261597980302 | -122.420399821019 | (37.7261597980302, -122.420399821019) | |
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 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) | |
| 16457 | 16457 | 93053 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | |||||||||
| 17030 | 17030 | 110785 | Permitted Site 1 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | |||
| 18684 | 18684 | 109456 | Permitted Site 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 19797 | 19797 | 97906 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 401 Upper Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428002 | (37.7632905770055, -122.44586250428) | ||
| 40015 | 40015 | 58273 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 211 Brighton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/20/1978 12:00:00 AM | Permit Number 17285 | 5996205.3244984 | 2091294.13562794 | 37.722077972487504 | -122.455218010255 | (37.7220779724875, -122.455218010255) | |||
| 55715 | 55715 | 102680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 65540 | 65540 | 100177 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 252 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768965 | 6000636.0 | 2106677.4 | 37.764569975148895 | -122.44100535545 | (37.7645699751489, -122.44100535545) | ||||
| 73842 | 73842 | 105230 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 69 KEYSTONE WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/17/2014 12:00:00 AM | 30 | Permit Number 773353 | 5994093.4 | 2093229.9 | 37.7272717167315 | -122.462658710338 | (37.7272717167315, -122.462658710338) | ||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 77775 | 77775 | 102678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78873 | 78873 | 94419 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 79033 | 79033 | 93597 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 79477 | 79477 | 96905 | Permitted Site 1 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Greenwich Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Park | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 80809 | 80809 | 93587 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81004 | 81004 | 70844 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/19/2015 12:00:00 AM | 3 | Permit Number 774723 | 6001345.45815513 | 2095262.03450684 | 37.733266486381396 | -122.437733908358 | (37.7332664863814, -122.437733908358) | ||
| 81098 | 81098 | 93610 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81268 | 81268 | 92013 | Permitted Site 1 | Tree(s) :: 17 | 360 04th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527.0 | 2112512.0 | 37.781260557947704 | -122.40028716013201 | (37.7812605579477, -122.400287160132) | |||
| 81311 | 81311 | 94411 | Permitted Site 1 | Tree(s) :: 17 | 905 California St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/27/2010 12:00:00 AM | 9 | Permit Number 53651 | 6010018.0 | 2116471.0 | 37.791990800007504 | -122.409246561226 | (37.7919908000075, -122.409246561226) | ||
| 81657 | 81657 | 93601 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81728 | 81728 | 93606 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81934 | 81934 | 104236 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1265 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.73558706538579 | -122.44118499343901 | (37.7355870653858, -122.441184993439) | ||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83450 | 83450 | 68449 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4054 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.757934492021604 | -122.431783761852 | (37.7579344920216, -122.431783761852) | ||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 84545 | 84545 | 104639 | Permitted Site 1 | Tree(s) :: 17 | 217 Montcalm St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 84695 | 84695 | 113360 | Permitted Site 1 | Tree(s) :: 17 | 821 HEAD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776477 | 5993783.0 | 2091497.0 | 37.7224957130636 | -122.463606040268 | (37.7224957130636, -122.463606040268) | |
| 86081 | 86081 | 97440 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1900 Pacific Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/11/2011 12:00:00 AM | Permit Number 768364 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||
| 86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 86232 | 86232 | 92014 | Permitted Site 1 | Tree(s) :: 17 | 360 04th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527.0 | 2112512.0 | 37.781260557947704 | -122.40028716013201 | (37.7812605579477, -122.400287160132) | |||
| 87602 | 87602 | 106822 | Permitted Site 1 | Tree(s) :: 17 | 75 Cerritos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/09/2014 12:00:00 AM | 5992422.3 | 2092894.9 | 37.7262555054251 | -122.468411282045 | (37.7262555054251, -122.468411282045) | ||||
| 89087 | 89087 | 93593 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 89104 | 89104 | 106823 | Permitted Site 1 | Tree(s) :: 17 | 75 Cerritos Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/09/2014 12:00:00 AM | 5992422.3 | 2092894.9 | 37.7262555054251 | -122.468411282045 | (37.7262555054251, -122.468411282045) | ||||
| 89383 | 89383 | 93603 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 91873 | 91873 | 93591 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 92434 | 92434 | 93037 | Permitted Site 1 | Tree(s) :: 17 | 1220 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/14/2010 12:00:00 AM | Permit Number 53146 | 5982155.6 | 2106783.3 | 37.7637908375908 | -122.504930842514 | (37.7637908375908, -122.504930842514) | |||
| 92814 | 92814 | 113055 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista West Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999858.0 | 2108239.0 | 37.76881339508 | -122.44380843942301 | (37.76881339508, -122.443808439423) | |||||
| 93992 | 93992 | 116877 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 401x Franconia St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/05/2016 12:00:00 AM | 3 | Permit Number 777241 | 6009999.3 | 2098658.1 | 37.743079617702996 | -122.40805448716499 | (37.743079617703, -122.408054487165) | ||
| 94269 | 94269 | 98150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 94297 | 94297 | 93581 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 94387 | 94387 | 87294 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2087 28th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2008 12:00:00 AM | Permit Number 50307 | 5987541.6 | 2101099.3 | 37.7484995140672 | -122.48588532379298 | (37.7484995140672, -122.485885323793) | ||||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 95611 | 95611 | 93602 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 95770 | 95770 | 94417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 96949 | 96949 | 109968 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
| 98020 | 98020 | 93590 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99163 | 99163 | 93596 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99567 | 99567 | 93609 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99578 | 99578 | 93612 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 100016 | 100016 | 93582 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 100907 | 100907 | 94418 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 102514 | 102514 | 107902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 Elsie St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.6513900002 | 37.742523860763995 | -122.417846568545 | (37.742523860764, -122.417846568545) | |||
| 103097 | 103097 | 93605 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 105671 | 105671 | 105223 | Permitted Site 1 | Tree(s) :: 17 | 1239 Turk St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | Permit Number 771274 | 6004111.8 | 2112513.0 | 37.780790463537 | -122.429399679053 | (37.780790463537, -122.429399679053) | |||
| 106366 | 106366 | 108368 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 36 KNOLLVIEW WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 774549 | 5997629.0 | 2101321.0 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | |||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 107377 | 107377 | 102675 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107438 | 107438 | 102679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107776 | 107776 | 93585 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 108434 | 108434 | 93588 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 108983 | 108983 | 98164 | Permitted Site 1 | Magnolia x alba :: White Champaca 342 | 90 Balceta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | Permit Number 768312 | 5995830.5 | 2099880.5 | 37.7456325309111 | -122.457134479076 | (37.7456325309111, -122.457134479076) | |||
| 109824 | 109824 | 112486 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||
| 110482 | 110482 | 93611 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 110791 | 110791 | 93604 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 112295 | 112295 | 88288 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 74 Lobos St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | Permit Number 51290 | 5996341.0 | 2088696.0 | 37.7149518852461 | -122.454561415793 | (37.7149518852461, -122.454561415793) | |||
| 112435 | 112435 | 108367 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 36 KNOLLVIEW WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 774549 | 5997629.0 | 2101321.0 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | |||
| 112533 | 112533 | 93599 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 112567 | 112567 | 104077 | Permitted Site 1 | Tree(s) :: 17 | 39 Miraloma Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | Permit Number 770105 | 5994966.0 | 2097586.0 | 37.7392827186602 | -122.459957583013 | (37.7392827186602, -122.459957583013) | |||
| 113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
| 113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 114786 | 114786 | 102677 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 115185 | 115185 | 97924 | Permitted Site 1 | Tree(s) :: 17 | 2939 Divisadero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768415 | 6000521.0 | 2118346.0 | 37.7966024147448 | -122.442240817081 | (37.7966024147448, -122.442240817081) | |
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 116097 | 116097 | 104831 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3210 Jackson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 3x3 | 5998893.9 | 2116279.9 | 37.7908365867802 | -122.447722110161 | (37.7908365867802, -122.447722110161) | |||
| 116154 | 116154 | 93584 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 116804 | 116804 | 93592 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116818 | 116818 | 113391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2151 15TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602.0 | 2100781.0 | 37.7478613219593 | -122.47182147099899 | (37.7478613219593, -122.471821470999) | |
| 117214 | 117214 | 93598 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 117698 | 117698 | 94688 | Permitted Site 1 | Tree(s) :: 17 | 230 Upland Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/27/2010 12:00:00 AM | 23 | 2x3 | Permit Number 53827 | 5993701.0 | 2094087.0 | 37.729602496423 | -122.464077417771 | (37.729602496423, -122.464077417771) | |
| 117976 | 117976 | 93229 | Permitted Site 1 | Tree(s) :: 17 | 804 Steiner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/02/2010 12:00:00 AM | Permit Number 53218 | 6003047.9 | 2111017.2 | 37.7766230788836 | -122.432973325779 | (37.7766230788836, -122.432973325779) |
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");