Modeling climate-smart forest management and wood use for climate mitigation potential in Maryland and Pennsylvania

# Modeling Climate-Smart Forest Management and Wood Use for Climate Mitigation Potential in Maryland and Pennsylvania [https://doi.org/10.5061/dryad.8w9ghx3sg](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