search

TNC-NMFO / NWLAND

carbon accounting model
0 stars 0 forks source link

Soil Conservation Activity Fluxes #85

Open sbassett opened 2 years ago

sbassett commented 2 years ago

Take county-averages for suite of practices, weighted by practice implementation rate (e.g. 33%, 33%, 33% for three practices with no overlap).

sbassett commented 2 years ago

Comet planner data: C:\Users\sbassett.TNC\Box\USCA Project (CO and NM)\Model Development\Data\US_COMET-Planner_Download_2021_09_29.xlsx

Attribute Description
total_ghg_co2 Mean of total greenhouse gas emission reductions in metric tonnes CO2 equivalent per acre per year (MT CO2e/ac/yr)
total_ghg_co2_sterr Standard error of the mean for total greenhouse gas emission reductions in metric tonnes CO2 equivalent per acre per year (MT CO2e/ac/yr)
total_ghg_co2_min Minimum of total greenhouse gas emission reductions in metric tonnes CO2 equivalent per acre per year (MT CO2e/ac/yr)
total_ghg_co2_max Maximum of total greenhouse gas emission reductions in metric tonnes CO2 equivalent per acre per year (MT CO2e/ac/yr)
n sample size for COMET-Farm modeled practices

to convert the Standard Error to Standard Deviation as required by the lc_params file, I will use of SD = SE * sqrt(N) [per https://handbook-5-1.cochrane.org/chapter_7/7_7_3_2_obtaining_standard_deviations_from_standard_errors_and.htm ]

sbassett commented 2 years ago

Will weight by irrigated/non-irrigated based on 2018 irrigation census.

Around 25% of "Land in farms (acres)" are "Acres irrigated". State Land in Farms (acres) Acres irrigated Proportion irrigated
CO 11,056,259* 2,458,742 0.222385
NM 1,825,827* 675,330 0.369876

*total farm acres are from the 2017 census of agriculture

sbassett commented 2 years ago

C:\Users\sbassett.TNC\Documents\GitHub\NWLAND\raw_data\CultivatedLands_ActivityFlux_Workspace.xlsx

copy A28:G124 to lc_params sheet to close this issue