------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset: Supporting data for The hidden value of trees: Quantifying the ecosystem services of tree lineages and their major threats across the contiguous US 2. Author Information: Jeannine Cavender-Bares1,2*, Erik Nelson3, Jose Eduardo Meireles1,4, Jesse R Lasky5, Daniela A. Miteva6, David Nowak7, William D. Pearse8, Matthew Helmus9, Amy E. Zanne10, William Fagan11,12, Christopher Mihiar13, Nicholas Z. Muller14, Nathan Kraft15, Stephen Polasky1,2,16 1Department of Ecology, Evolution and Behavior, University of Minnesota, Saint Paul MN 55108 2Institute on Environment, University of Minnesota, Saint Paul, MN 55108 3 Department of Economics, Bowdoin College, Brunswick, ME, 04011-8497, enelson2@bowdoin.edu 4 School of Biology & Ecology, University of Maine, Orono, ME 04469, jose.meireles@maine.edu 5Department of Biology, Pennsylvania State University, University Park, PA, 16802, jrl35@psu.edu 6Department of Agricultural, Environmental and Development Economics, The Ohio State University, Columbus, OH 43210, miteva.2@osu.edu 7USDA Forest Service, Northern Research Station, 5 Moon Library, SUNY-ESF, Syracuse, NY 13210, david.nowak@usda.gov 8Department of Biology & Ecology Center, Utah State University, Logan, UT, will.pearse@gmail.com 9Center for Biodiversity, Department of Biology, Temple University, 1925 N. 12th Street, Philadelphia, PA 19122, mrhelmus@gmail.com 10Departmental of Biological Sciences, George Washington University, Washington, DC, aezanne@gmail.com 11Department of Biology, University of Maryland, College Park, Maryland, bfagan@umd.edu 12SESYNC, University of Maryland, Annapolis, MD, 13US Forest Service, Southern Research Station, Research Triangle Park, NC 27709, Christopher.Mihiar@usda.gov 14Department of Engineering and Public Policy, Carnegie Mellon University, Pittsburgh, PA, 15213, nzm@andrew.cmu.edu 15Department of Ecology and Evolutionary Biology, University of California, Los Angeles, CA 90095, nkraft@ucla.edu 16Department of Applied Economics, University of Minnesota, Saint Paul, MN 55108, polasky@umn.edu 3. Date of data collection: 2010/01/01 to 2020/01/01 4. Geographic location of data collection: United States 5. Information about funding sources that supported the collection of the data: Sponsorship: DBI-1052875 6. Licenses/restrictions placed on the data: Attribution-NonCommercial-NoDerivs 3.0 United States 7. Links to publications that cite or use the data: Cavender-Bares, J., Nelson, E., Meireles, J. E., Lasky, J., Miteva, D. A., Nowak, D., … Polasky, S. (2019, November 18). The hidden value of trees: quantifying the ecosystem services of tree lineages and their major threats across the contiguous US. https://doi.org/10.32942/osf.io/gp7mt 8. Recommended citation for the data: Cavender-Bares, Jeannine; Nelson, Erik; Meireles, Jose Eduardo; Lasky, Jesse R; Miteva, Daniela A; Nowak, David; Pearse, William D; Helmus, Matthew; Zanne, Amy E; Fagan, William; Mihiar, Christopher; Muller, Nicholas Z; Kraft, Nathan; Polasky, Stephen. (2021). Supporting data for The hidden value of trees: Quantifying the ecosystem services of tree lineages and their major threats across the contiguous US. Retrieved from the Data Repository for the University of Minnesota, https://doi.org/10.13020/126g-6t56. --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. carbon.annual.value.species.csv Short description: Annual value of carbon stored in US trees by species based on the social cost of carbon $119.58 per ton in 2010 $ per metric ton (Interagency Working Group August 2016) using three discount rates Number of variables: 11 Number of cases/rows: 390 rows Variable List: Name: GenSp Description: Genus species latin binomial name based on the US Forest Service FIA database Name: carbon.annual.value Description: medium annual value of carbon storage (2010 USD) using a discount rate of 3%. Name: carbon.annual.value_high Description: high estimate of the annual value of carbon storage (2010 USD) using a discount rate of 2.5% Name: carbon.annual.value_low Description: low estimate of the annual value of carbon storage (2010 USD) using a discount rate of 5% Values: 0 to 7,938,230,714 B. carbon.annual.value.county.csv Short description: annual value of carbon stored in US trees by county based on the social cost of carbon $119.58 per ton in 2010 $ per metric ton (Interagency Working Group August 2016) using three discount rates Number of variables: 4 Number of cases/rows: 3222 rows Variable List: Name: FIPS Description: FIPS code for a state, county combination Name: carbon.annual.value Description: medium annual value of carbon storage (2010 USD) using a discount rate of 3%. Name: carbon.annual.value_high Description: high estimate of the annual value of carbon storage (2010 USD) using a discount rate of 2.5% Name: carbon.annual.value_low Description: low estimate of the annual value of carbon storage (2010 USD) using a discount rate of 5% Values: 0 to 869,211,752 C. air.pollution.removal.annual.value.species.csv Short description: Annual air pollution removal benefits at species and county level Number of variables: 11 Number of cases/rows: 79596 rows Missing data codes: NA Data not available Variable List: Name: stfips Description: FIPS code for a state Name: countyfips Description: FIPS code for a county Name: fips Description: FIPS code for a state, county combination Name: fiaspeciescode Description: USFIA tree species code Name: commonname Description: tree species name Name: Deaths Prevented Low Description: Annual deaths prevented by species and county, low estimate. Values: 0 to 28.26 Name: Deaths Prevented Mean Description: Annual deaths prevented by species and county, mean estimate Values: 0 to 40.28 Name: Deaths Prevented High Description: Annual deaths prevented by species and county, high estimate Values: 0 and 51.95 Name: Damage Avoided Low (2010 USD) Description: monetary value of annual deaths prevented (2010 USD) by species and county, low estimate. Values: 0 to 81350380 Name: Damage Avoided Mean (2010$) Description: monetary value of annual deaths prevented (2010 USD) by species and county, mean estimate Values: 0 to 287118987 Name: Damage Avoided High (2010$) Description: monetary value of annual deaths prevented (2010 USD) by species and county, high estimate Values: 0 to 520863291 D. air.pollution.removal.annual.value.county.csv Short description: Annual air pollution removal benefits at county level Number of variables: 9 Number of cases/rows: 2929 rows Variable List: Name: stfips Description: FIPS code for a state Name: county fips Description: FIPS code for a county Name: fips Description: FIPS code for a state, county combination Name: Deaths Prevented Low Description: Annual deaths prevented by county, low estimate. Values: 0 to 62.19 Name: Deaths Prevented Mean Description: Annual deaths prevented by county, mean estimate Values: 0 to 88.64 Name: Deaths Prevented High Description: Annual deaths prevented by county, high estimate Values: 0 and 114.34 Name: Damage Avoided Low (2010$) Description: monetary value of annual deaths prevented (2010 USD) by county, low estimate. Values: 0 to 179009153.2 Name: Damage Avoided Mean (2010$) Description: monetary value of annual deaths prevented (2010 USD) by county, mean estimate Values: 0 to 631798006.8 Name: Damage Avoided High (2010 USD) Description: monetary value of annual deaths prevented (2010 USD) by county, high estimate Values: 0 to 1145729326 E. TotalRoundwoodNetReturnsSpeciesByCounty.csv Short description: net timber returns for each species in each county. Number of variables: 5 Number of cases/rows: 38264 rows Variable List: mean fifth ninetyfifth FIPS SPCD Mean net return (2010 USD) Fifth percentile of net return (2010 USD) Ninety-Fifth percentile of net return (2010 USD) County FIPS code Species Code (USFS FIA) F. tree.crops.annual.net.ret.species.csv Short description: Annualized net returns to tree crops at species and county level. Number of variables: 7 Number of cases/rows: 45383 rows Variable List: Name: Fips Description: FIPS code for a state, county combination Name: Species Description: Taxonomic identity at the species level Name: Min NR Description: Minimum annualized net return (2010 USD) to producing a given species in a given county. Values: -398,898,982 to 363,817,270 Name: Low NR Description: Low annualized net return (2010 USD) to producing a given species in a given county. Values: -263,651,583 to 363,817,270 Name: Average NR Description: Average annualized net return (2010 USD) to producing a given species in a given county. Values: -201,925,125 and 479,981,450 Name: High NR Description: High annualized net return (2010 USD) to producing a given species in a given county. Values: -140,198,666 to 596,145,631 Name: Max NR Description: Maximum annualized net return (2010 USD) to producing a given species in a given county. Values: -133,327,146 to 757,234,254 G. tree.crops.annual.net.ret.county.csv Short description: Annualized net returns to tree crops at the county level Number of variables: 9 Number of cases/rows: 2161 rows Variable List: Name: State Description: State abbreviation Name: State FIPs Description: FIPS code for a state Name: County FIPs Description: FIPS code for a county Name: FIPs Description: FIPS code for a state, county combination Name: Species Description: Taxonomic identity at the species level Name: Min NR Description: Minimum annualized net return (2010 USD) in a given county. Values: -405,925,870 to 335,452,917 Name: Low NR Description: Low annualized net return (2010 USD) in a given county. Values: -332,428,426 to 335,492,184 Name: Average NR Description: Average annualized net return (2010 USD) in a given county. Values: -252,446,882 and 508,968,259 Name: High NR Description: High annualized net return (2010 USD) in a given county. Values: -172,465,338 to 682,444,335 Name: Max NR Description: Maximum annualized net return (2010 USD) in a given county. Values: -162,255,963 to 861,159,990 H. Christmas.trees.annual.value.species.csv Short description: Annualized net returns to Christmas tree crops at the species and state level Number of variables: 8 Number of cases/rows: 945 rows Variable List: Name: State Description: State abbreviation Name: State FIPs Description: FIPS code for a state Name: Species Description: Taxonomic identity at the species level Name: Min NR Description: Minimum state-level annualized net return (2010 USD) to producing a given species in a given state. Values: -26814732.13 to 14011245.54 Name: Low NR Description: Low state-level annualized net return (2010 USD) to producing a given species in a given state. Values: -2861228.292 to 16998204.05 Name: Average NR Description: Average state-level annualized net return (2010 USD) to producing a given species in a given state. Values: -315217.9494 and 18105525.48 Name: High NR Description: High state-level annualized net return (2010 USD) to producing a given species in a given state. Values: -76705.49575 to 19212846.91 Name: Max NR Description: Maximum state-level annualized net return (2010 USD) to producing a given species in a given state. Values: -48323.09847 to 19212846.91 I. Christmas.trees.annual.value.state.csv Short description: Annualized net returns to Christmas tree crops at the county level Number of variables: 9 Number of cases/rows: 3143 rows Missing data codes: NA Data not available Variable List: Name: State Description: State abbreviation Name: State FIPs Description: FIPS code for a state Name: County FIPs Description: FIPS code for a county Name: FIPs Description: FIPS code for a state, county combination Name: Species Description: Taxonomic identity at the species level Name: Min NR Description: Minimum annualized net return (2010 USD) in a given county. Values: -5083992.139 to 1388418.931 Name: Low NR Description: Low annualized net return (2010 USD) in a given county. Values: 0 to 1684024.808 Name: Average NR Description: Average annualized net return (2010 USD) in a given county. Values: 0 and 2637718.515 Name: High NR Description: High annualized net return (2010 USD) in a given county. Values: 0 to 3595694.874 Name: Max NR Description: Maximum annualized net return (2010 USD) in a given county. Values: 0 to 4678796.093 J. climate.species.csv Short description: Climate change threat by species Number of variables: 6 Number of cases/rows: 389 rows Missing data codes: NA Data not available Variable List: Name: Species Description: Taxonomic identity at the species level Name: TOTAL_LIVE_C_MG Description: Total carbon mass (MG) of a species across the US Name: MAT Description: Fraction of a species’ biomass projected to be outside of its mean annual temperature climatic envelope by 2050. Values: between 0 and 1 Name: MAP Description: Fraction of a species’ biomass projected to be outside of its mean annual precipitation climatic envelope by 2050. Values: between 0 and 1 Name: AHM Description: Fraction of a species biomass projected to be outside of its annual heat moisture climatic envelope by 2050. Values: between 0 and 1 Name: MULTI Description: Fraction of a species’ biomass projected to be outside of its multivariate climatic envelope (either MAT or MAP or AHM). Values: between 0 and 1 K.climate.county.csv Short description: Climate change threat by county Number of variables: 6 Number of cases/rows: 2983 rows Missing data codes: NA Data not available Variable List: Name: FIPS Description: FIPS code for a county Name: TOTAL_LIVE_C_MG Description: Total carbon mass (MG) in a county Name: MAT Description: Fraction of a county’s biomass belonging to species projected to be outside of their mean annual temperature climatic envelope by 2050 in that county. Values: between 0 and 1 Name: MAP Description: Fraction of a county’s biomass belonging to species projected to be outside of their mean annual precipitation climatic envelope by 2050 in that county Values: between 0 and 1 Name: AHM Description: Fraction of a county’s biomass belonging to species projected to be outside of their annual heat moisture climatic envelope by 2050 in that county. Values: between 0 and 1 Name: MULTI Description: Fraction of a county’s biomass belonging to species projected to be outside of their multivariate climatic envelope (either MAT or MAP or AHM) by 2050 in that county. Values: between 0 and 1 L. pest.pathogens.crops.species.csv Short description: Fraction of tree crop biomass across the contiguous US threatened by pests and pathogens Number of variables: 2 Number of cases/rows: 21 rows Missing data codes: NA Data not available Variable List: Name: Species Description: Taxonomic identity at the species level Name: crop.pest.risk Description: Fraction of tree crop biomass across the contiguous US threatened by pests and pathogens. Values: 0 to 1 M. pest.threat.species.csv Short description: Pest and pathogen threats for forest trees by species Number of variables: 2 Number of cases/rows: 382 rows Missing data codes: NA Data not available Variable List: Name: spcd Description: FIA species code Name: expected_biomass_reduction Description: Projected fraction of biomass loss biomass due to pests and pathogens. Values: between 0 and 1 N. pest.threat.county.csv Short description: Pest and pathogen threats for forest trees by county Number of variables: 2 Number of cases/rows: 2941 rows Missing data codes: NA Data not available Variable List: Name: spcd Description: FIPS county code Name: expected_biomass_reduction Description: Projected fraction of biomass loss biomass due to pests and pathogens. Values: between 0 and 1 O. fire.frequency.species.csv Short description: Frequency of Major Fires by Species Number of variables: 4 Number of cases/rows: 382 rows Missing data codes: NA Data not available Variable List: Name: spcd Description: FIA species code Name: fire_hist_mean Description: Mean historical frequency of major fires (count/week) by species Name: fire_fut_mean Description: Mean future frequency of major fires (count/week) by species Name: fire_fut_minus_hist_mean Description: Future minus historical frequency of major fires (count/week) by species P. fire.frequency.county Short description: Frequency of Major Fires by County Number of variables: 4 Number of cases/rows: 3109 rows Missing data codes: NA Data not available Variable List: Name: FIPS Description: FIPS county code Name: fire_hist_mean Description: Mean historical frequency of major fires (count/week) by county Name: fire_fut_mean Description: Mean future frequency of major fires (count/week) by county Name: fire_fut_minus_hist_mean Description: Future minus historical frequency of major fires (count/week) by county Q. tank.fia.crop.tree.tre Short description: Phylogeny of all US tree species analyzed based on Zanne et al. 2014 phylogeny Newick format phylogenetic relationships among species using latin binomials of genus_species R. FIA.SPCD.csv Short description: USDA Species codes Number of variables: 4 Number of cases/rows: 388 rows Missing data codes: #N/A Data not available Variable List: Name: Phylo Name Description: name used in the phylogeny Name: FIA Species Code Description: number code from USFS Name: Common Name Description: one common name the species Name: Scientific Name Description: latin binomial with the genus and species names