Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19350 | 19350 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2721 Pacific Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||||
| 19781 | 19781 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 185 Chilton Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251004 | -122.436889661497 | (37.732941575251, -122.436889661497) | ||||
| 50166 | 50166 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177.0 | 2107098.0 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | |||
| 54776 | 54776 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 77818 | 77818 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 862 Kansas St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774734 | 6011570.0 | 2104296.0 | 37.758647879927395 | -122.403019866682 | (37.7586478799274, -122.403019866682) | |||||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 80420 | 80420 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||
| 81688 | 81688 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 82109 | 82109 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||||
| 87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
| 90772 | 90772 | 106612 | Significant Tree 6 | Schinus molle :: California Pepper 138 | 1189 TENNESSEE ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6015654.1 | 2103577.3 | 37.7569017014681 | -122.388844893024 | (37.7569017014681, -122.388844893024) | |||||
| 92048 | 92048 | 111996 | Significant Tree 6 | Tree(s) :: 17 | 501 Point Lobos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775626 | 5981249.6 | 2112592.5 | 37.779687857228296 | -122.508495636007 | (37.7796878572283, -122.508495636007) | ||
| 93582 | 93582 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 415 Belvedere St | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998488.0 | 2106798.0 | 37.7647785355325 | -122.44844336243601 | (37.7647785355325, -122.448443362436) | ||||||
| 96055 | 96055 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991993.7 | 2093259.3 | 37.727231291852604 | -122.469919436342 | (37.7272312918526, -122.469919436342) | ||||||
| 98130 | 98130 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849.0 | 2112535.0 | 37.780379598944705 | -122.457986127959 | (37.7803795989447, -122.457986127959) | ||||
| 99064 | 99064 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 99731 | 99731 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 86 Stanton St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | ||||||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 103866 | 103866 | 87188 | Significant Tree 6 | Tree(s) :: 17 | 2119 Bush St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50204 | 6002998.0 | 2114831.0 | 37.787091984974104 | -122.433418544226 | (37.7870919849741, -122.433418544226) | ||||
| 105112 | 105112 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2620 Larkin St | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | Permit Number 56959 | 6006630.0 | 2120172.0 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | ||||
| 106619 | 106619 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | ||||
| 108424 | 108424 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 230 Lakeview Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | |||||
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 109838 | 109838 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 766 Anderson St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723.0 | 2095324.0 | 37.7337971999422 | -122.41568932106199 | (37.7337971999422, -122.415689321062) | |||
| 110495 | 110495 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2203 Divisadero St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | ||||||
| 112470 | 112470 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 342 HILL ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 778799 | 6004048.0 | 2103384.0 | 37.755720828524204 | -122.42896934322901 | (37.7557208285242, -122.428969343229) | |||
| 113676 | 113676 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 115263 | 115263 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395.0 | 2101384.0 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | |||
| 116721 | 116721 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||||
| 121702 | 121702 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 30 Onondaga Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.721861535681704 | -122.437972107548 | (37.7218615356817, -122.437972107548) | ||||
| 122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
| 123402 | 123402 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2324 Sacramento St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.43117371849199 | (37.7902385582714, -122.431173718492) | |||
| 125171 | 125171 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004592.7 | 2107127.1 | 37.766029309282295 | -122.42735222853202 | (37.7660293092823, -122.427352228532) | ||||||
| 126422 | 126422 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 36 ARBOR ST | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | |||||
| 127034 | 127034 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99 Divisadero St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | ||||||
| 139354 | 139354 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 4849X 19th St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.759295701171105 | -122.44429784106501 | (37.7592957011711, -122.444297841065) | |||||
| 141435 | 141435 | 104808 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 08th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) | |||||
| 142961 | 142961 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 144810 | 144810 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
| 1310 | 1310 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010641.0 | 2100362.0 | 37.747794064611604 | -122.40595565659201 | (37.7477940646116, -122.405955656592) | ||||
| 1719 | 1719 | 251394 | Significant Tree 6 | Araucaria araucana :: Monkey puzzle 154 | 203 Corbett Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779803 | 6000094.0 | 2105620.0 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | |
| 1820 | 1820 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003450.0 | 2104734.0 | 37.75939373993371 | -122.431133769968 | (37.7593937399337, -122.431133769968) | |||||
| 1939 | 1939 | 252822 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3852 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2734 | 2734 | 253182 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5157 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000788.0 | 2100195.0 | 37.7467795353698 | -122.44001478039101 | (37.7467795353698, -122.440014780391) | |||||
| 2736 | 2736 | 253183 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5159 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000808.0 | 2099903.0 | 37.745978911495 | -122.439924689335 | (37.745978911495, -122.439924689335) | |||||
| 2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3138 | 3138 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 270 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 3283 | 3283 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 55 Cerritos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5992588.0 | 2092941.0 | 37.7263916542788 | -122.46784182223999 | (37.7263916542788, -122.46784182224) | ||||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3662 | 3662 | 253513 | Significant Tree 6 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1545 05th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/14/2012 12:00:00 AM | 3x3 | Permit Number 768941 | 5994803.920580001 | 2105050.88998 | 37.7597700982665 | -122.461058902115 | (37.7597700982665, -122.461058902115) | ||
| 4923 | 4923 | 253718 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 227 Madison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005690.0 | 2092595.0 | 37.726189474375204 | -122.422524168298 | (37.7261894743752, -122.422524168298) | ||||
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | |||
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 7809 | 7809 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 13267 | 13267 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 4283 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001353.0 | 2102279.0 | 37.7525338497288 | -122.43821033719401 | (37.7525338497288, -122.438210337194) | ||||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 19018 | 19018 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.41342088796499 | (37.7565461982029, -122.413420887965) | |||
| 19405 | 19405 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174.0 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | |||
| 20477 | 20477 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 20865 | 20865 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 4187 26th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x3 | 6002700.0 | 2100625.0 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | |||
| 22304 | 22304 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 Oakdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.39108575959101 | (37.7349525388235, -122.391085759591) | |||||
| 26650 | 26650 | 109414 | Significant Tree 6 | Persea americana :: Avocado 113 | 4 GUY PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6014378.1 | 2114502.6 | 37.786829336844605 | -122.394022608955 | (37.7868293368446, -122.394022608955) | ||||
| 46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 47419 | 47419 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | ||
| 50498 | 50498 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | ||
| 53186 | 53186 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 188 The Embarcadero | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | |||
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 63120 | 63120 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 109 | 1808 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.796275437823894 | -122.427440299436 | (37.7962754378239, -122.427440299436) | |||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 67558 | 67558 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Allston Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418.0 | 37.741524734078205 | -122.46256819082701 | (37.7415247340782, -122.462568190827) | ||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 74055 | 74055 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 3020 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.44326025018299 | (37.790530933705, -122.443260250183) | |||
| 74816 | 74816 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 701 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | |||
| 75150 | 75150 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 203 Surrey St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768282 | 6002070.0 | 2096079.6 | 37.73555250464221 | -122.435287431957 | (37.7355525046422, -122.435287431957) | ||||
| 77206 | 77206 | 107056 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 601X Davis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 12 | Permit Number 771755 | 6013142.97136 | 2118525.3196099997 | 37.797806054267895 | -122.39857828598 | (37.7978060542679, -122.39857828598) | ||
| 77671 | 77671 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 231 | 276 Yerba Buena Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5995080.66446 | 2095640.15746 | 37.733946507354396 | -122.459420244296 | (37.7339465073544, -122.459420244296) | ||||
| 78125 | 78125 | 106567 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 79360 | 79360 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5982877.4 | 2101339.2 | 37.748885310102104 | -122.502031530859 | (37.7488853101021, -122.502031530859) | |||||
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 80137 | 80137 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6006502.0 | 2099737.0 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | ||||
| 80154 | 80154 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.39755199325701 | (37.7614986071193, -122.397551993257) | |||
| 80497 | 80497 | 104013 | Significant Tree 6 | Fremontodendron spp :: Flannel Bush Tree 331 | 3978 Sacramento St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | Permit Number 770312 | 5995753.1 | 2114886.6 | 37.7868309532778 | -122.45848816233601 | (37.7868309532778, -122.458488162336) | |||
| 80662 | 80662 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6000094.0 | 2105620.0 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | |||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 81071 | 81071 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 970 GUERRERO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005649.9 | 2103318.5 | 37.755631523761394 | -122.42342479955799 | (37.7556315237614, -122.423424799558) |
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");