Modeling climate-smart forest management and wood use for climate mitigation potential in Maryland and Pennsylvania
Data files
Oct 20, 2023 version files 267.47 GB
-
CBMoutputs.pdf
1.88 MB
-
Column_list.xlsx
15.32 KB
-
leakage.MD.844.tCO2e.csv
21.90 KB
-
leakage.PA.844.tCO2e.csv
20.23 KB
-
MD_afforGGRA_2030.mdb
9.31 MB
-
MD_afforGGRA_2050.mdb
9.31 MB
-
MD_afforGGRA_age_2030.csv
908.81 MB
-
MD_afforGGRA_age_2050.csv
1 GB
-
MD_afforGGRA_dist_2030.csv
447.43 MB
-
MD_afforGGRA_dist_2050.csv
495.61 MB
-
MD_afforGGRA_flux_2030.csv
6.15 GB
-
MD_afforGGRA_flux_2050.csv
6.82 GB
-
MD_afforscaleup_2030.mdb
9.31 MB
-
MD_afforscaleup_2050.mdb
9.31 MB
-
MD_afforscaleup_age_2030.csv
1.01 GB
-
MD_afforscaleup_age_2050.csv
987.95 MB
-
MD_afforscaleup_dist_2030.csv
497.24 MB
-
MD_afforscaleup_dist_2050.csv
485.82 MB
-
MD_afforscaleup_flux_2030.csv
6.85 GB
-
MD_afforscaleup_flux_2050.csv
6.69 GB
-
MD_baseline_age.csv
894.46 MB
-
MD_baseline_dist.csv
440.37 MB
-
MD_baseline_flux.csv
6.05 GB
-
MD_baseline.mdb
9.24 MB
-
MD_ccdist10_age.csv
915.89 MB
-
MD_ccdist10_dist.csv
451.89 MB
-
MD_ccdist10_flux.csv
5.91 GB
-
MD_ccdist10.mdb
9.33 MB
-
MD_ccgrowth_age.csv
1.02 GB
-
MD_ccgrowth_dist.csv
987.81 MB
-
MD_ccgrowth_flux.csv
6.57 GB
-
MD_ccgrowth.mdb
13.14 MB
-
MD_DeerBrowse_age.csv
907.63 MB
-
MD_DeerBrowse_dist.csv
492.13 MB
-
MD_DeerBrowse_flux.csv
6.15 GB
-
MD_DeerBrowse.mdb
9.31 MB
-
MD_ExtRot_age.csv
948.83 MB
-
MD_ExtRot_dist.csv
469.13 MB
-
MD_ExtRot_flux.csv
6.45 GB
-
MD_ExtRot_PineAlt_age.csv
995.06 MB
-
MD_ExtRot_PineAlt_dist.csv
492.96 MB
-
MD_ExtRot_PineAlt_flux.csv
6.78 GB
-
MD_ExtRot_PineAlt.mdb
9.35 MB
-
MD_ExtRot.mdb
9.35 MB
-
MD_NoHarv_age.csv
872.22 MB
-
MD_NoHarv_dist.csv
482.85 MB
-
MD_NoHarv_flux.csv
5.76 GB
-
MD_NoHarv.mdb
8.72 MB
-
MD_Portfolio_age.csv
771.46 MB
-
MD_Portfolio_dist.csv
386.56 MB
-
MD_Portfolio_flux.csv
5.27 GB
-
MD_Portfolio.mdb
9.70 MB
-
MD_Reduce_defor_age.csv
928.68 MB
-
MD_Reduce_defor_dist.csv
498.32 MB
-
MD_Reduce_defor_flux.csv
6.29 GB
-
MD_Reduce_defor.mdb
9.35 MB
-
MD_Reducedhighgrading_age.csv
906.67 MB
-
MD_Reducedhighgrading_dist.csv
456.21 MB
-
MD_Reducedhighgrading_flux.csv
6.21 GB
-
MD_reducehighgrading.mdb
9.25 MB
-
MD_Restock_age.csv
868.71 MB
-
MD_Restock_dist.csv
427.93 MB
-
MD_Restock_flux.csv
5.87 GB
-
MD_Restock.mdb
9.31 MB
-
MD_RestockAlt_age.csv
941.93 MB
-
MD_RestockAlt_dist.csv
464.32 MB
-
MD_RestockAlt_flux.csv
6.39 GB
-
MD_RestockAlt.mdb
9.34 MB
-
MD_silvo_age.csv
698.10 MB
-
MD_silvo_dist.csv
344.79 MB
-
MD_silvo_flux.csv
4.49 GB
-
MD_silvopasture.mdb
9.36 MB
-
MD_TSI_age.csv
917.97 MB
-
MD_TSI_dist.csv
457.19 MB
-
MD_TSI_flux.csv
6.26 GB
-
MD_TSI.mdb
9.74 MB
-
MD.DE.bio.tC_HW.csv
11.30 KB
-
MD.DE.bio.tC_SW.csv
11.34 KB
-
MD.DE.wood.tC_HW.leak.64.csv
20.68 KB
-
MD.DE.wood.tC_SW.leak.64.csv
23.04 KB
-
MD.emissions_cum.disagg.tC_07.csv
12.67 KB
-
MD.emissions_cum.disagg.tC_20.csv
7.75 KB
-
MD.Emissions_HW_07.19.csv
24.43 KB
-
MD.Emissions_HW_2020.csv
21.09 KB
-
MD.Emissions_HW_p2007.csv
24.39 KB
-
MD.Emissions_SW_07.19.csv
24.42 KB
-
MD.Emissions_SW_2020.csv
21.07 KB
-
MD.Emissions_SW_p2007.csv
24.45 KB
-
MD.Stocks_HW.csv
34.74 KB
-
MD.Stocks_SW.csv
34.72 KB
-
MD.stocks.disagg.tC_07.csv
10.77 KB
-
mdb_tablenames.xlsx
10.97 KB
-
PA_afforGGRA2050.mdb
16.09 MB
-
PA_afforscaleup2030.mdb
15.96 MB
-
PA_afforscaleup2050.mdb
16.09 MB
-
PA_baseline_age.csv
742.71 MB
-
PA_baseline_dist.csv
364.54 MB
-
PA_baseline_flux.csv
4.76 GB
-
PA_ccdist10_age.csv
699.27 MB
-
PA_ccdist10_dist.csv
342.91 MB
-
PA_ccdist10_flux.csv
4.47 GB
-
PA_ccdist10.mdb
16.12 MB
-
PA_ccgrowth_age.csv
875.70 MB
-
PA_ccgrowth_dist.csv
436.85 MB
-
PA_ccgrowth_flux.csv
5.52 GB
-
PA_ccgrowth.mdb
20.23 MB
-
PA_DeerBrowse_age.csv
737.11 MB
-
PA_DeerBrowse_dist.csv
362.16 MB
-
PA_DeerBrowse_flux.csv
4.73 GB
-
PA_ExtRot_age.csv
700.61 MB
-
PA_ExtRot_dist.csv
361.33 MB
-
PA_ExtRot_flux.csv
4.65 GB
-
PA_ExtRot.mdb
15.80 MB
-
PA_ggra2030_age.csv
783.08 MB
-
PA_ggra2030_dist.csv
383.82 MB
-
PA_ggra2030_flux.csv
5.02 GB
-
PA_ggra2050_age.csv
796.71 MB
-
PA_ggra2050_flux.csv
5.10 GB
-
PA_NoHarv_age.csv
634.91 MB
-
PA_NoHarv_dist.csv
319.04 MB
-
PA_NoHarv_flux.csv
4.18 GB
-
PA_Portfolio_age.csv
1.04 GB
-
PA_Portfolio_dist.csv
514.95 MB
-
PA_Portfolio.mdb
15.93 MB
-
PA_Reduce_defor_age.csv
732.62 MB
-
PA_Reduce_defor_dist.csv
358.74 MB
-
PA_Reduce_defor_flux.csv
4.69 GB
-
PA_reducedhighgrade_age.csv
721.42 MB
-
PA_reducedhighgrade_dist.csv
355.10 MB
-
PA_reducedhighgrade_flux.csv
4.63 GB
-
PA_reducehighgrading.mdb
15.73 MB
-
PA_restock_agev2.csv
717.94 MB
-
PA_restock_distv2.csv
352.38 MB
-
PA_restock_fluxv2.csv
4.59 GB
-
PA_restockv2.mdb
16.03 MB
-
PA_scaleup2030_age.csv
966.39 MB
-
PA_scaleup2030_dist.csv
472.24 MB
-
PA_scaleup2030_flux.csv
6.19 GB
-
PA_scaleup2050_age.csv
1.27 GB
-
PA_scaleup2050_dist.csv
618.27 MB
-
PA_scaleup2050_flux.csv
8.14 GB
-
PA_silvo_age.csv
938.47 MB
-
PA_silvo_dist.csv
462.71 MB
-
PA_silvo_flux.csv
6.03 GB
-
PA_TSI_age.csv
723.64 MB
-
PA_TSI_dist.csv
359.29 MB
-
PA_TSI_flux.csv
4.67 GB
-
PA_TSI.mdb
13.67 MB
-
PA.DE.bio.tC_HW.csv
9.64 KB
-
PA.DE.bio.tC_SW.csv
9.66 KB
-
PA.DE.wood.tC_HW.leak.64.csv
20.69 KB
-
PA.DE.wood.tC_SW.leak.64.csv
20.95 KB
-
PA.emissions_cum.disagg.tC_07.csv
10.25 KB
-
PA.emissions_cum.disagg.tC_20.csv
10.25 KB
-
PA.Emissions_HW_07.19.csv
21.01 KB
-
PA.Emissions_HW_2020.csv
18.12 KB
-
PA.Emissions_HW_p2007.csv
21.03 KB
-
PA.Emissions_SW_07.19.csv
21 KB
-
PA.Emissions_SW_2020.csv
18.13 KB
-
PA.Emissions_SW_p2007.csv
20.98 KB
-
PA.Stocks_HW.csv
29.90 KB
-
PA.Stocks_SW.csv
29.93 KB
-
PA.stocks.disagg.tC_07.csv
9.21 KB
-
README.md
5.76 KB
-
Scenario_list.xlsx
12.10 KB
Abstract
State and local governments are increasingly interested in understanding the role forests and harvested wood products play in regional carbon sinks and storage, their potential contributions to state-level greenhouse gas (GHG) reductions, and the interactions between GHG reduction goals and potential economic opportunities. We used empirically driven process-based forest carbon dynamics and harvested wood product models in a systems-based approach to project the carbon impacts of various forest management and wood utilization activities in Maryland and Pennsylvania from 2007–2100. To quantify state-wide forest carbon dynamics, we integrated forest inventory data, harvest and management activity data, and remotely-sensed metrics of landuse change and natural forest disturbances within a participatory modeling approach. We accounted for net GHG emissions across (1) forest ecosystems (2) harvested wood products, (3) substitution benefits from wood product utilization, and (4) leakage associated with reduced instate harvesting activities. Based on state agency partner input, a total of 15 management scenarios were modeled for Maryland and 13 for Pennsylvania, along with two climate change scenarios and two bioenergy scenarios for each state. Our findings show that both strategic forest management and wood utilization can provide substantial climate mitigation potential relative to business-as-usual practices, increasing the forest C sink by 29% in Maryland and 38% in Pennsylvania by 2030 without disrupting timber supplies. Key climate-smart forest management activities include maintaining and increasing forest extent, fostering forest resiliency and natural regeneration, encouraging sustainable harvest practices, balancing timber supply and wood utilization with tree growth, and preparing for future climate impacts. This study adds to a growing body of work that quantifies the relationships between forest growth, forest disturbance, and harvested wood products.
https://doi.org/10.5061/dryad.8w9ghx3sg
This dataset provides formatted input databases and post-processed results databases for the CBM-CFS3 ecosystem model portion of this analysis. Additionally, the post processed data from both the CBM-HWP-MD and CBM-HWP-PA harvest wood product models are provided. Please see the methods section and appendices for more detailed descriptions of data sources and data processing.
To be compatible with the CBM-CFS3 software, ecosystem model inputs were processed and reformatted into a MS access database format. The input databases are then run through the simulation software using a Python API where results are exported in CSV format. Ecosystem model results are post-processed to be inputted into the associated harvested wood product models which then provide additional CSV files.
Ecosystem results provide a variety of information disaggregated by a list of forest characteristics such as forest type, ownership, site indices, etc., on annual timesteps starting in 2007 until 2150. HWP results are from 2007-2100. Result databases include information such as carbon fluxes split by pool, carbon pools, forest area, area disturbed, carbon transferred to harvested wood products, age demographics, and biomass. All area units are in hectares while carbon units can be in metric tons of carbon or tons of CO2e.
Description of the data and file structure
Users should be very aware of the sign (negative or positive) of each column for both ecosystem and HWP model results in flux and emission files to correctly sum on annual timesteps. For ecosystem files, Timestep 1 is equivalent to the year 2007. A comprehensive list of scenarios and descriptions is located in ‘Scenario_list.xlxs’ file.
Input Databases
All input databases are in ‘.mdb’ formats. Input databases can be run through the CBM-CFS3 simulation software using python API and python code provided in the American Forest GitHub page to generate the same the results databases provided in the Ecosystem model outputs section.
The ‘mdb_tablenames.xlxs’ file contains all of the table names included in the input databases. Users can open the raw ‘.mdb’ formats utilizing the ‘R coding environment’ and the following code chunk; however, mdb files are included primarily as the simulation input to be able to run through the software providing users the same output tables provided if using the python API and code provided below.
## read in the data
install.packages('RODBC')
library(RODBC)
db = odbcDriverConnect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};
DBQ= Your Directory and File Name Here .mdb")
## Get data
data = as_tibble(sqlFetch (db , "Table Name", rownames=TRUE)) ## Insert Table Name to call it
Ecosystem model outputs
Ecosystem model outputs have four associated CSV files per scenario with the following format STATENAME_SCENARIO_FILE.csv (for example: MD_baseline_flux.csv). The three ecosystem files have the following names:
- XX_XXXX_age.csv
- XX_XXXX_dist.csv
- XX_XXXX_flux.csv
Detailed descriptions of columns and units contained in the age, dist, and flux CSVs can be found in the ‘CBMoutputs.pdf’ file as well as the ‘Column_list.xlxs’ file.
Further detailed descriptions of each results database file and for each column including further detailed definitions and descriptions of fluxes and pools contained with the model can be found in Kull, S.J., Rampley, G.J., Morken, S., Metsaranta, J., Neilson, E.T., Kurz, W.A. (2020). Operational-Scale Carbon Budget Model of the Canadian Forest Sector (CBM-CFS3) Version 1.2: User’s Guide. Natural Resources Canada, Canadian Forest Service, Alberta, Canada.
DistProduct Data
DistProduct Data from the “XX_XXXX_dist.csv” files were aggregated into softwood (SW) and hardwood (HW) categories to be inputted into the HWP models. Harvest wood product files are split between softwood (SW) and hardwood (HW) as species specific wood characteristics and growth forms often dictate the product stream the timber supply enters. For each state, there are XX files where the XX’s represent the state or the wood type (SW versus HW).
- XX.DE.bio.tC_XX - Displaced emissions from bioenergy HW/SW in tons of carbon, in CO2e
- XX.DE.wood.tC_XX - Displaced emissions from wood products HW/SW in tons of carbon, in CO2e
- XX.Emissions_XX_XX_07.19 - HWP emissions from 2007-2019, in tons of carbon
- XX.Emissions_XX_XX_2020 - HWP emissions from 2020-2100., in tons of carbon
- XX.Emissions_XX_p2007 - HWP emissions inherited from wood in use pre-2007 (starts in 1950), in tons of carbon.
- XX_Stocks_XX - HWP carbon pool split by product stream for 2020-2100, in tons of carbon
- XX.stocks.disagg.tc_07 - HWP carbon pool from 2007-2019, in tons of carbon
- Leakage.XX - Assumed additional annual emissions of carbon leaving the HWP from the other states (includes emissions associated with 1) harvest disturbance and 2) HWP emissions) stemming from a 63.9% leakage rate
- XX.emissions_cum.disagg.tC_07 - Cumulative emissions by scenario and product stream for years 2030, 2050, 2100 starting in year 2007
- XX.emissions_cum.disagg.tC_20 - Cumulative emissions by scenario and product stream for years 2030, 2050, 2100 starting in year 2020
Code/Software
All code, scripts, and notebooks used in this analysis can be found at https://github.com/American-Forests
Additionally, the CBM-CFS3 software is freely available here: https://natural-resources.canada.ca/climate-change/climate-change-impacts-forests/carbon-accounting/carbon-budget-model/13107
Primary data inputs to CBM-CFS3 included a detailed forest inventory, growth-yield relations to estimate forest productivity, and estimates of harvest yields and intensity, land-use change, and natural disturbances. Inventory data are categorized by a series of forest classifiers defining relevant characteristics such as spatially referenced boundaries, ownership, forest type, site productivity, or reserve status. Allometric equations are used to predict tree volume-to-biomass relationships (Boudewyn et al., 2007). For this study, forest inventory, growth-yield curves, and harvest data were estimated from the USDA Forest Service Forest Inventory and Analysis (FIA) program, which we accessed through the FIA DataMart (USDA Forest Service, 2019) using the rFIA package (Stanke et al., 2020) in the R programming environment (R Core Team, 2020), which enables data exploration and user-defined spatio-temporal queries and estimation of the FIA database (FIADB). Methodologies derived from Bechtold & Patterson, 2005 and Pugh et al., 2018 were used to estimate each state’s forest inventory by a predetermined list of classifiers. Natural disturbance history was estimated from both the FIADB and LANDFIRE (USGS, 2016) datasets to better constrain initial belowground and soil carbon parameters during what the modeling framework refers to as the model spin-up period (Kurz et al., 2009). Estimates of merchantable volume and corresponding biomass from FIADB were used to calibrate the model’s allometric volume-to-biomass assumptions to match forest type groups and growth conditions in Maryland and Pennsylvania.
Harvest removals were estimated as average annual removal of merchantable timber in cubic feet between 2007 and 2019, converted to metric tons of carbon using methodologies and specific gravities reported by Smith et al., 2006. To assign a harvest type and intensity to each record of volumetric removal, stand age at the time of removal was calculated by taking the mid-point average between time t1 and t2 (Bechtold & Patterson, 2005) where t1 is the year the unharvested stand was measured and t2 is the repeat interval year measurement post-harvest. In collaboration with state partners, harvest type and intensity were determined heuristically for each forest type based upon state-level management documentation, peer-reviewed literature, and expert input. A complete list of harvest types and intensities prescribed to each forest type group as a product of stand age can be found in Table S3 of the manuscript.
Longer-term averages from 2007-2019 were used to estimate annual area targets for all land-use change (LUC) and natural disturbance events including wind, fire, disease, and insects. Annual LUC average rates by ownership and forest type group were derived by overlaying a geospatial forestland ownership dataset (Sass et al., 2020), the Protected Areas Database of the U.S. (PAD-US), a national geodatabase of protected areas (USGS, 2018), and the National Land Cover Database (NLCD), a remotely-sensed data product used to characterize land cover and land cover change (Wickham et al., 2021). Wind disturbance events were calculated using the LANDFIRE Historic Disturbance dataset (USGS, 2016), a remotely-sensed data product provided by the USGS that estimates annual disturbance events. Annual averages for wildfire disturbances were derived from the LANDFIRE Historic Disturbance dataset (USGS, 2016) and validated through annual reports from the National Interagency Fire Center (NIFC). Annual prescribed fire acres were estimated from reports provided by the Maryland DNR Forest Service and Pennsylvania DCNR Bureau of Forestry and scaled to represent treatments on forestlands only. Annual acreages of insect and disease disturbance were derived from the National Insect & Disease Detection Survey (USDA Forest Service, 2020), a spatial data product produced by USDA that collects and reports data on forest insects, diseases, and other disturbances. For more information on all input and activity data see Supplementary Materials 1.2. A complete list of BAU parameters can be found in Table S2.
State-specific trade and commodity data from Resource Planning Act (RPA) assessments (USDA Forest Service, 2021), US Commodity Flow Surveys (US Department of Transportation et al., 2020), US International Trade Commission export data (US International Trade Commission, 2021), and published peer-reviewed data (Howard & Liang, 2019) when available, or US averages from the same sources, were used to adapt and parameterize both HWP models. FAOSTAT data (FAO, 2021) were utilized to determine the commodity distributions of exported roundwood. Softwood products were parameterized and modeled separately from hardwood products, as the two wood types differ in exports and commodities produced as well as their associated product half-lives and displacement (Dymond, 2012; Howard et al., 2017). Published data were used to calculate softwood- and hardwood-specific half-lives for Maryland and Pennsylvania sawn wood and veneer products, while we relied on literature estimates for other products (Skog, 2008; J. E. Smith et al., 2006b). To calculate substitution benefits, we coupled region-specific data (USDA Forest Service, 2021), US consumption rates (Howard et al., 2017), product weights (C. Smyth et al., 2017), and LCA data (Bala et al., 2010; Dylewski & Adamczyk, 2013; Hubbard et al., 2020; Meil & Bushi, 2013; Puettmann, 2020a, 2020b; Puettmann et al., 2016; Puettmann & Salazar, 2018, 2019), following methods developed by Smyth et al. (2017). Landfill CO2 and CH4 emissions rely on PICC defaults for methane generation (k) and landfill half-lives for wet, temperate climates (Pingoud et al., 2006). See Supplementary Materials 1.3 for more details on substitution and leakage calculation methods.