Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109200 | 109200 | 101625 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 64 Levant St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.76398959970761 | -122.442236202383 | (37.7639895997076, -122.442236202383) | ||||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 111585 | 111585 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 111891 | 111891 | 105167 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 1 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 8 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 113343 | 113343 | 116624 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 114285 | 114285 | 96183 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||||
| 114585 | 114585 | 115388 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 169x BOCANA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 25 | 40x50 | 6007278.0 | 2097999.0 | 37.7411171346524 | -122.417417333034 | (37.7411171346524, -122.417417333034) | |||
| 115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
| 117224 | 117224 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 731 CLAYTON ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5998515.0 | 2108057.0 | 37.768236974715705 | -122.44844065135099 | (37.7682369747157, -122.448440651351) | |||||
| 117877 | 117877 | 112570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 117969 | 117969 | 105170 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 4 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 2 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 117993 | 117993 | 108442 | Permitted Site 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 750 12th Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773771 | 5992283.6285 | 2110333.09253 | 37.7741282667999 | -122.470159914203 | (37.7741282667999, -122.470159914203) | |||
| 118309 | 118309 | 114264 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 32 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 118617 | 118617 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1526 MASONIC AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x6 | 5999767.0 | 2107205.0 | 37.7659690994291 | -122.44404889486401 | (37.7659690994291, -122.444048894864) | ||||
| 119101 | 119101 | 116621 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
| 122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
| 123053 | 123053 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 408 | 55 BRONTE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6009403.0 | 2097128.0 | 37.738844891472894 | -122.410008345842 | (37.7388448914729, -122.410008345842) | ||||
| 123166 | 123166 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 101 LUNDYS LN | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 6006875.0 | 2098969.0 | 37.7437578546964 | -122.41887954343599 | (37.7437578546964, -122.418879543436) | ||||
| 123257 | 123257 | 116622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 123578 | 123578 | 114260 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 124228 | 124228 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 243 | 707 Douglass St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775627 | 6001281.0 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | ||||
| 124339 | 124339 | 116630 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 11 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 124370 | 124370 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 124433 | 124433 | 114265 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 26 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 125158 | 125158 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 6006172.0 | 2100967.0 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | |||
| 125790 | 125790 | 116627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 8 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 129310 | 129310 | 99268 | Property Tree 7 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004280.0 | 2096681.0 | 37.7373290690714 | -122.42768945491501 | (37.7373290690714, -122.427689454915) | ||||||
| 129412 | 129412 | 104753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | ||||
| 129431 | 129431 | 110789 | Section 143 8 | Pinus radiata :: Monterey Pine 3 | 850x SANCHEZ ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | ||||
| 139135 | 139135 | 112417 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98X BROADMOOR DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 5990934.0 | 2093194.0 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | |||
| 139185 | 139185 | 114938 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 14 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 139221 | 139221 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 139674 | 139674 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 25 MIDCREST WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5997992.0 | 2100464.0 | 37.747358577228496 | -122.44970241305 | (37.7473585772285, -122.44970241305) | ||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 140796 | 140796 | 114929 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 141088 | 141088 | 115806 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 362 MISSOURI ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6013446.0 | 2105415.0 | 37.7618249904211 | -122.39661020099 | (37.7618249904211, -122.39661020099) | |||
| 141835 | 141835 | 114936 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 12 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 141973 | 141973 | 114935 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 142217 | 142217 | 108441 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | |||
| 142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
| 142683 | 142683 | 116623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 144227 | 144227 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 455X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 144669 | 144669 | 114930 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 144956 | 144956 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
| 9848 | 9848 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | |
| 97249 | 97249 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060.0 | 2120781.0 | 37.8036588138585 | -122.41978724303999 | (37.8036588138585, -122.41978724304) | ||
| 98858 | 98858 | 114924 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 37X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 103011 | 103011 | 114923 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 85532 | 85532 | 108239 | Permitted Site 1 | Tree(s) :: 17 | 15 ASHBURY TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 5x50 | Permit Number 774721 | 5999554.7 | 2106911.6 | 37.7651513833487 | -122.444762103204 | (37.7651513833487, -122.444762103204) | |
| 140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
| 106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
| 129263 | 129263 | 63301 | Permitted Site 1 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.745892263304896 | -122.411424351246 | (37.7458922633049, -122.411424351246) | |
| 10183 | 10183 | 173712 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 10195 | 10195 | 173713 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 128304 | 128304 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727.0 | 2102215.0 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | |
| 56651 | 56651 | 31242 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2523 17th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50225 | 5991071.12499 | 2098214.14208 | 37.7407826611875 | -122.473469993967 | (37.7407826611875, -122.473469993967) | |
| 102290 | 102290 | 31648 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 113764 | 113764 | 31646 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 127767 | 127767 | 31647 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 142954 | 142954 | 110788 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 80053 | 80053 | 109497 | Permitted Site 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 785 Mangels Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438.0 | 2095245.0 | 37.732939449865896 | -122.45469900823 | (37.7329394498659, -122.45469900823) |
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 89776 | 89776 | 98528 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 118464 | 118464 | 98529 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 22873 | 22873 | 251137 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828.0 | 2094364.0 | 37.7312793503434 | -122.40834398535401 | (37.7312793503434, -122.408343985354) | |
| 86072 | 86072 | 54809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Carmel St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.760876867329294 | -122.449709427273 | (37.7608768673293, -122.449709427273) | |
| 129398 | 129398 | 109973 | Undocumented 2 | Tree(s) :: 17 | 1458 43rd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/16/2015 12:00:00 AM | 3 | 3x3 | 5982831.2 | 2105195.6 | 37.7594711884194 | -122.502476670215 | (37.7594711884194, -122.502476670215) | ||
| 2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
| 8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
| 85775 | 85775 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.79010430227179 | -122.42974344149499 | (37.7901043022718, -122.429743441495) | |
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 85808 | 85808 | 98327 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 143 Alhambra St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49254 | 6001613.1 | 2120268.4 | 37.8019430002039 | -122.43859972925199 | (37.8019430002039, -122.438599729252) | ||
| 138475 | 138475 | 96182 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||
| 85057 | 85057 | 115566 | Permitted Site 1 | Tree(s) :: 17 | 2026 36TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777529 | 5985134.0 | 2101392.0 | 37.7491625951009 | -122.49423221215099 | (37.7491625951009, -122.494232212151) | |
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 119427 | 119427 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 125647 | 125647 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070 California St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 103533 | 103533 | 12529 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.78679797610221 | -122.460619935074 | (37.7867979761022, -122.460619935074) |
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 80984 | 80984 | 88447 | Permitted Site 1 | Tree(s) :: 17 | 93 Prentiss St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51413 | 6008891.7 | 2098141.7 | 37.7415996198956 | -122.411847801096 | (37.7415996198956, -122.411847801096) | ||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 105928 | 105928 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.745700269008296 | -122.457505029341 | (37.7457002690083, -122.457505029341) | ||
| 81053 | 81053 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) |
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");