STATE ENVIRONMENTAL HEALTH INDICATORS …



STATE ENVIRONMENTAL HEALTH INDICATORS COLLABORATIVE (SEHIC) CLIMATE AND HEALTH INDICATORSCategory: MitigationIndicator: Total Energy Measure(s): Total Energy Consumption, by SectorTotal Energy Consumption per Capita, by SectorTotal Energy Production Total Energy Production, per CapitaMEASURE DESCRIPTIONLast updated:May 12, 2018Measurement units:Billion Btu and million Btu per capitaGeographic scale:StateTime scale:Annual, 1960 - 2015Background:Energy consumption patterns over time, when adjusted for state population changes and employment changes, could be an indicator of the impact of climate change mitigation or policy measures on energy efficiency.Rationale:Energy efficiency measures reduce the demand for energy generated from fossil fuel sources.Limitations:This measure does not consider state differences in factors that impact energy use, such as weather and temperature. A more accurate calculation of commercial energy efficiency would compare total floor space rather than number of employees. A more accurate calculation of industrial energy efficiency would compare total value of shipments. However, this information is not available at the state level.Data resources:Energy Information Administration, U.S. Department of Energy Data limitations:Statewide data does not differentiate between urban, suburban/extra-urban, and rural populations.Related data: Recommendations:Visualization options: Create a stacked bar graph of total or per capita energy consumption, by sector. Create a line graph of total energy consumed and total energy produced. HOW-TO GUIDE: Total Energy ConsumptionGo to the Energy Information Administration, State Energy Data System (SEDS) website: Scroll down and click “1960-2015 estimates.”Click on “Change State” and select your state.Open “Data files” tab.Select CSV under “Consumption” and then “All consumption estimates.”You will get a file that is titled “use_[state abbreviation].csv”. Pro Tip: You will use this file for the Total Energy and Renewable Energy Indicators.Documentation for category (MSN – column 3) and units is found here: Consumption TableMSN DescriptionTEACBTotal energy consumed by the transportation sector (billion Btu)TEAPB The transportation sector’s energy consumption per capita (million Btu)TECCB Total energy consumed by the commercial sector (billion Btu)TECPB The commercial sector’s energy consumption per capita (million Btu)TEICB Total energy consumed by the industrial sector (billion Btu)TEIPB The industrial sector’s energy consumption per capita (million Btu)TERCB Total energy consumed by the residential sector (billion Btu)TERPBThe residential sector’s energy consumption per capita (million Btu)TETCB Total energy consumed (billion Btu)TETPB Total energy consumption per capita (million Btu)In “use_[state abbreviation].csv” copy rows with MSNs matching the table above into a new spreadsheet. Highlighting may help. Copy/paste MSN and Description from table above into columns D-E into new spreadsheet.Copy/paste rows for years of interest into the Climate and Health Indicator Template. Calculate per capita consumption in Million Btu. Use population estimates you have previously gathered or reference residence population estimates in Appendix C of the technical documentation that are in the unit of thousand people: using population estimates(Renewable energy consumed in billion Btu / Annual population estimate)*1,000If using population estimates in unit of thousand peopleRenewable energy consumed in billion Btu / Annual population estimate in thousand peopleProductionGo to the Energy Information Administration, State Energy Data System (SEDS) website: Scroll down and click “1960-2015 estimates.”Click on “Change State” and select your state.Open “Production” tab.Select XLSX under “Summary” and then “Production in Btu”You will get a file that is titled “PT2_[state abbreviation].xlsx”. Pro Tip: You will use this file for the Total Energy and Renewable Energy Indicators.Copy/paste “Total” column for years of interest into a new spreadsheet.Unit of energy production estimates are currently Trillion Btu. Convert to billion Btu by multiplying each annual total by 1,000. Transpose rows to columns (i.e., longwise).Copy/paste rows for years of interest into the Climate and Health Indicator Template. Calculate per capita production in Million Btu. Use population estimates you have previously gathered or reference residence population estimates in Appendix C of the technical documentation that are in the unit of thousand people: using population estimates(Renewable energy consumed in billion Btu / Annual population estimate)*1,000If using population estimates in unit of thousand peopleRenewable energy consumed in billion Btu / Annual population estimate in thousand people ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download