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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 93980 | 93980 | 110202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1039 PAGE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.43795762529301 | (37.771984919077, -122.437957625293) | |||||
| 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) | |
| 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) | ||||
| 103820 | 103820 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
| 79308 | 79308 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
| 88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
| 78259 | 78259 | 111280 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X BOSWORTH ST | 18 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 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) | ||||
| 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) | |||
| 89532 | 89532 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2224 Baker St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | |||
| 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) | |||
| 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) | ||||
| 89540 | 89540 | 112569 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | |||
| 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) | ||||
| 102533 | 102533 | 112571 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 87119 | 87119 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 98650 | 98650 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 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) | ||||
| 102339 | 102339 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 909 ASHBURY ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5999156.0 | 2107025.0 | 37.7654399906909 | -122.44614926226002 | (37.7654399906909, -122.44614926226) | ||||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 86718 | 86718 | 114261 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 101205 | 101205 | 114262 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 80776 | 80776 | 114263 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 29 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 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) | ||||
| 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) | ||||
| 96445 | 96445 | 114266 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 800x BROTHERHOOD WAY | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 9 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 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) | |
| 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) | ||
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 134828 | 134828 | 114679 | Permitted Site 1 | Malus :: Crab Apple 235 | 836 Brussels St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | ||
| 124233 | 124233 | 114680 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 54 Colby St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861.0 | 37.729793151999395 | -122.414784067206 | (37.7297931519994, -122.414784067206) | |||
| 110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
| 95797 | 95797 | 114729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1930 35TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/03/2015 12:00:00 AM | 4x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 82154 | 82154 | 114926 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 77706 | 77706 | 114927 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 103256 | 103256 | 114928 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | ||||
| 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) | ||||
| 100601 | 100601 | 114931 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 78663 | 78663 | 114932 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 8 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 91895 | 91895 | 114933 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 9 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 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) | |
| 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) | ||||
| 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) | ||||
| 106106 | 106106 | 114937 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 13 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | ||||
| 82056 | 82056 | 114939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 15 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |||
| 100636 | 100636 | 114940 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 16 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | |
| 85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
| 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) | |
| 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) | |||
| 99011 | 99011 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 3524 Jackson St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||||
| 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) | |
| 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) | |||
| 81797 | 81797 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 811 TREAT AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 3x3 | 6008597.0 | 2103712.0 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | |||
| 100355 | 100355 | 116620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 12 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 58682 | 58682 | 116625 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 6 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 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) | |||
| 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) | |||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 98906 | 98906 | 116629 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 10 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 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) | |||
| 84743 | 84743 | 116631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 12 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 85684 | 85684 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6 | 3x3 | 6001245.0 | 2101454.0 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | |||
| 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) | |||
| 100592 | 100592 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 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) | |||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 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) | |||||
| 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) | |
| 78331 | 78331 | 117161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | |||||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 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) | ||||
| 88886 | 88886 | 117247 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1096 EDDY ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6x6 | 6005188.0 | 2113045.0 | 37.7823120756394 | -122.425714454198 | (37.7823120756394, -122.425714454198) | ||||
| 142230 | 142230 | 120534 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2043 32nd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5986293.0 | 2101328.0 | 37.7490546230695 | -122.49021972232599 | (37.7490546230695, -122.490219722326) | ||
| 74401 | 74401 | 121592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002342.0 | 2100313.0 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | ||||
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) |
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");