search

chihacknight / decarbonize-my-state

What does it take to decarbonize your state?
https://decarbmystate.com/
MIT License
13 stars 1 forks source link

Create Designs for State Power Plants Page & Individual Power Plant Page #184

Closed vkoves closed 1 year ago

vkoves commented 1 year ago

We want to have a page we can link to from each state details page that shows a map of power plants with some filters, plus a list of the power plants in a table with some data about the type of power plant, the power output, emissions, and whatever else.

Derek said we have the emissions broken down by type (e.g. CO2, NOX, Methane) so we need to make a formula to create emissions.

vkoves commented 1 year ago

@derekeder - do you want to weigh in on what you want to see here?

vkoves commented 1 year ago

Also @derekeder if for my designs you could output the current data we have for one power plant that would be very helpful.

vkoves commented 1 year ago

Here's a JSON export of our data for the biggest Illinois coal plant "Baldwin Energy Complex":

JSON Data ```ts [ { "Plant sequence number": 166, "eGRID Plant file sequence number": 3606, "Data Year": 2019, "state": "IL", "plant_name": "Baldwin Energy Complex", "DOE/EIA ORIS plant or facility code": 889, "Plant transmission or distribution system owner name": "Ameren Illinois Company", "Plant transmission or distribution system owner ID": 56697, "utility_name": "Dynegy Midwest Generation Inc", "Utility ID": 5517, "Plant-level sector": "IPP Non-CHP", "Balancing Authority Name": "Midcontinent Independent Transmission System Operator, Inc..", "Balancing Authority Code": "MISO", "NERC region acronym": "SERC", "eGRID subregion acronym": "SRMW", "eGRID subregion name": "SERC Midwest", "Plant associated ISO/RTO Territory": "MISO", "Plant FIPS state code": 17, "Plant FIPS county code": 157, "county": "Randolph", "Latitude": 38.205, "Longitude": -89.8544, "Number of units": 3, "Number of generators": 3, "Plant primary fuel": "RC", "fossil_fuel_category": "COAL", "Flag indicating if the plant burned or generated any amount of coal": "Yes", "Plant capacity factor": 0.3792, "capacity_mw": 1894.1, "Nonbaseload Factor": 0.7013, "Biogas/ biomass plant adjustment flag": "", "Combined heat and power (CHP) plant adjustment flag": "", "CHP plant useful thermal output (MMBtu)": "", "CHP plant power to heat ratio": "", "CHP plant electric allocation factor": "", "Plant pumped storage flag": "", "Plant annual heat input from combustion (MMBtu)": 64178406, "Plant ozone season heat input from combustion (MMBtu)": 26849671, "Plant total annual heat input (MMBtu)": 64178406, "Plant total ozone season heat input (MMBtu)": 26849671, "Plant annual net generation (MWh)": 6291993, "Plant ozone season net generation (MWh)": 2589577, "Plant annual NOx emissions (tons)": 2810.336, "Plant ozone season NOx emissions (tons)": 1159.899, "Plant annual SO2 emissions (tons)": 2276.793, "Plant annual CO2 emissions (tons)": 6731034.75, "Plant annual CH4 emissions (lbs)": 1591417.454, "Plant annual N2O emissions (lbs)": 231488.399, "Plant annual CO2 equivalent emissions (tons)": 6785419.24, "Plant annual Hg emissions (lbs)": "", "Plant annual NOx total output emission rate (lb/MWh)": 0.893, "Plant ozone season NOx total output emission rate (lb/MWh)": 0.896, "Plant annual SO2 total output emission rate (lb/MWh)": 0.724, "Plant annual CO2 total output emission rate (lb/MWh)": 2139.556, "Plant annual CH4 total output emission rate (lb/MWh)": 0.253, "Plant annual N2O total output emission rate (lb/MWh)": 0.037, "Plant annual CO2 equivalent total output emission rate (lb/MWh)": 2156.843, "Plant annual Hg total output emission rate (lb/MWh)": "", "Plant annual NOx input emission rate (lb/MMBtu)": 0.088, "Plant ozone season NOx input emission rate (lb/MMBtu)": 0.086, "Plant annual SO2 input emission rate (lb/MMBtu)": 0.071, "Plant annual CO2 input emission rate (lb/MMBtu)": 209.76, "Plant annual CH4 input emission rate (lb/MMBtu)": 0.025, "Plant annual N2O input emission rate (lb/MMBtu)": 0.004, "Plant annual CO2 equivalent input emission rate (lb/MMBtu)": 211.455, "Plant annual Hg input emission rate (lb/MMBtu)": "", "Plant annual NOx combustion output emission rate (lb/MWh)": 0.893, "Plant ozone season NOx combustion output emission rate (lb/MWh)": 0.896, "Plant annual SO2 combustion output emission rate (lb/MWh)": 0.724, "Plant annual CO2 combustion output emission rate (lb/MWh)": 2139.556, "Plant annual CH4 combustion output emission rate (lb/MWh)": 0.253, "Plant annual N2O combustion output emission rate (lb/MWh)": 0.037, "Plant annual CO2 equivalent combustion output emission rate (lb/MWh)": 2156.843, "Plant annual Hg combustion output emission rate (lb/MWh)": "", "Plant unadjusted annual NOx emissions (tons)": 2810.34, "Plant unadjusted ozone season NOx emissions (tons)": 1159.9, "Plant unadjusted annual SO2 emissions (tons)": 2276.79, "Plant unadjusted annual CO2 emissions (tons)": 6731034.75, "Plant unadjusted annual CH4 emissions (lbs)": 1591417.45, "Plant unadjusted annual N2O emissions (lbs)": 231488.4, "Plant unadjusted annual Hg emissions (lbs)": "", "Plant unadjusted annual heat input from combustion (MMBtu)": 64178406, "Plant unadjusted ozone season heat input from combustion (MMBtu)": 26849671, "Plant unadjusted total annual heat input (MMBtu)": 64178406, "Plant unadjusted total ozone season heat input (MMBtu)": 26849671, "Plant unadjusted annual NOx emissions source": "EPA/CAMD", "Plant unadjusted ozone season NOx emissions source": "EPA/CAMD", "Plant unadjusted annual SO2 emissions source": "EPA/CAMD", "Plant unadjusted annual CO2 emissions source": "EPA/CAMD", "Plant unadjusted annual CH4 emissions source": "EIA", "Plant unadjusted annual N2O emissions source": "EIA", "Plant unadjusted annual Hg emissions source": "--", "Plant unadjusted annual heat input source": "EPA/CAMD", "Plant unadjusted ozone season heat input source": "EPA/CAMD", "Plant annual NOx biomass emissions (tons)": "", "Plant ozone season NOx biomass emissions (tons)": "", "Plant annual SO2 biomass emissions (tons)": "", "Plant annual CO2 biomass emissions (tons)": "", "Plant annual CH4 biomass emissions (lbs)": "", "Plant annual N2O biomass emissions (lbs)": "", "Plant combustion heat input CHP adjustment value (MMBtu)": "", "Plant combustion annual ozone season heat input CHP adjustment value (MMBtu)": "", "Plant annual NOx emissions CHP adjustment value (tons)": "", "Plant ozone season NOx emissions CHP adjustment value (tons)": "", "Plant annual SO2 emissions CHP adjustment value (tons)": "", "Plant annual CO2 emissions CHP adjustment value (tons)": "", "Plant annual CH4 emissions CHP adjustment value (lbs)": "", "Plant annual N2O emissions CHP adjustment value (lbs)": "", "Plant nominal heat rate (Btu/kWh)": 10200.012, "Plant annual coal net generation (MWh)": 6282239.4, "Plant annual oil net generation (MWh)": 9753.63, "Plant annual gas net generation (MWh)": 0, "Plant annual nuclear net generation (MWh)": 0, "Plant annual hydro net generation (MWh)": 0, "Plant annual biomass net generation (MWh)": 0, "Plant annual wind net generation (MWh)": 0, "Plant annual solar net generation (MWh)": 0, "Plant annual geothermal net generation (MWh)": 0, "Plant annual other fossil net generation (MWh)": 0, "Plant annual other unknown/ purchased fuel net generation (MWh)": 0, "Plant annual total nonrenewables net generation (MWh)": 6291993.03, "Plant annual total renewables net generation (MWh)": 0, "Plant annual total nonhydro renewables net generation (MWh)": 0, "Plant annual total combustion net generation (MWh)": 6291993.03, "Plant annual total noncombustion net generation (MWh)": 0, "Plant coal generation percent (resource mix)": 1, "Plant oil generation percent (resource mix)": 0, "Plant gas generation percent (resource mix)": 0, "Plant nuclear generation percent (resource mix)": 0, "Plant hydro generation percent (resource mix)": 0, "Plant biomass generation percent (resource mix)": 0, "Plant wind generation percent (resource mix)": 0, "Plant solar generation percent (resource mix)": 0, "Plant geothermal generation percent (resource mix)": 0, "Plant other fossil generation percent (resource mix)": 0, "Plant other unknown / purchased fuel generation percent (resource mix)": 0, "Plant total nonrenewables generation percent (resource mix)": 1, "Plant total renewables generation percent (resource mix)": 0, "Plant total nonhydro renewables generation percent (resource mix)": 0, "Plant total combustion generation percent (resource mix)": 1, "Plant total noncombustion generation percent (resource mix)": 0, "CAMD Flag": "Yes", "CAMD Units": "1,2,3", "2020 Plant total Heat Input (mmBtu) from CAMD": 42583477.5, "2020 Plant total CO2 mass (tons) from CAMD": 4466151.6, "2020 Plant total NOx mass (tons) from CAMD": 1784.8, "2020 Plant total SO2 mass (tons) from CAMD": 1474.9, "2020 Plant total Mercury mass (tons) from CAMD": 0, "Google Maps": "https://www.google.com/maps/@?api=1&map_action=map¢er=38.205%2C-89.8544&zoom=17&basemap=satellite", "total population (ACS2018)": 555, "Total Population for whom Poverty Status is Determined": 553, "Total Households": 234, "Total Population Age 25 up": 401, "Houses Built Pre 1960": 103, "Buffer distance": "3 miles", "State Abbreviation": "IL", "State Name": "Illinois", "EPA region number": 5, "State percentile for EJ Index for Particulate Matter (PM 2.5)": 46, "Regional percentile for EJ Index for Particulate Matter (PM 2.5)": 54, "National percentile for EJ Index for Particulate Matter (PM 2.5)": 41, "State percentile for EJ Index for Ozone": 46, "Regional percentile for EJ Index for Ozone": 55, "National percentile for EJ Index for Ozone": 41, "State percentile for EJ Index for NATA Diesel PM": 52, "Regional percentile for EJ Index for NATA Diesel PM": 57, "National percentile for EJ Index for NATA Diesel PM": 43, "State percentile for EJ Index for NATA Air Toxics Cancer Risk": 46, "Regional percentile for EJ Index for NATA Air Toxics Cancer Risk": 52, "National percentile for EJ Index for NATA Air Toxics Cancer Risk": 42, "State percentile for EJ Index for NATA Respiratory Hazard Index": 47, "Regional percentile for EJ Index for NATA Respiratory Hazard Index": 53, "National percentile for EJ Index for NATA Respiratory Hazard Index": 43, "State percentile for EJ Index for Traffic Proximity and Volume": 55, "Regional percentile for EJ Index for Traffic Proximity and Volume": 61, "National percentile for EJ Index for Traffic Proximity and Volume": 49, "State percentile for EJ Index for Lead Paint Indicator": 35, "Regional percentile for EJ Index for Lead Paint Indicator": 45, "National percentile for EJ Index for Lead Paint Indicator": 25, "State percentile for EJ Index for Superfund Proximity": 54, "Regional percentile for EJ Index for Superfund Proximity": 66, "National percentile for EJ Index for Superfund Proximity": 49, "State percentile for EJ Index for RMP Proximity": 33, "Regional percentile for EJ Index for RMP Proximity": 34, "National percentile for EJ Index for RMP Proximity": 23, "State percentile for EJ Index for Hazardous Waste Proximity": 55, "Regional percentile for EJ Index for Hazardous Waste Proximity": 63, "National percentile for EJ Index for Hazardous Waste Proximity": 48, "State percentile for EJ Index for Wastewater Discharge Indicator": 30, "Regional percentile for EJ Index for Wastewater Discharge Indicator": 20, "National percentile for EJ Index for Wastewater Discharge Indicator": 11, "Raw data for Particulate Matter (PM 2.5 in ug/m3)": 9.19, "State percentile for Particulate Matter (PM 2.5 in ug/m3)": 46, "Regional percentile for Particulate Matter (PM 2.5 in ug/m3)": 73, "National percentile for Particulate Matter (PM 2.5 in ug/m3)": 70, "State average for Particulate Matter (PM 2.5 in ug/m3)": 9.13, "Regional average for Particulate Matter (PM 2.5 in ug/m3)": 8.4, "National average for Particulate Matter (PM 2.5 in ug/m3)": 8.55, "Raw data for Ozone (ppb)": 47.7, "State percentile for Ozone (ppb)": 89, "Regional percentile for Ozone (ppb)": 97, "National percentile for Ozone (ppb)": 84, "State average for Ozone (ppb)": 46.5, "Regional average for Ozone (ppb)": 43.8, "National average for Ozone (ppb)": 42.9, "Raw data for NATA Diesel PM (ug/m3)": 0.248, "State percentile for NATA Diesel PM (ug/m3)": 12, "Regional percentile for NATA Diesel PM (ug/m3)": "<50th", "National percentile for NATA Diesel PM (ug/m3)": "<50th", "State average for NATA Diesel PM (ug/m3)": 0.67, "Regional average for NATA Diesel PM (ug/m3)": 0.446, "National average for NATA Diesel PM (ug/m3)": 0.478, "Raw data for NATA Air Toxics Cancer Risk (risk per MM)": 28, "State percentile for NATA Air Toxics Cancer Risk (risk per MM)": 36, "Regional percentile for NATA Air Toxics Cancer Risk (risk per MM)": "70-80th", "National percentile for NATA Air Toxics Cancer Risk (risk per MM)": "<50th", "State average for NATA Air Toxics Cancer Risk (risk per MM)": 33, "Regional average for NATA Air Toxics Cancer Risk (risk per MM)": 26, "National average for NATA Air Toxics Cancer Risk (risk per MM)": 32, "Raw data for NATA Respiratory Hazard Index": 0.35, "State percentile for NATA Respiratory Hazard Index": 33, "Regional percentile for NATA Respiratory Hazard Index": "60-70th", "National percentile for NATA Respiratory Hazard Index": "<50th", "State average for NATA Respiratory Hazard Index": 0.42, "Regional average for NATA Respiratory Hazard Index": 0.34, "National average for NATA Respiratory Hazard Index": 0.44, "Raw data for Traffic Proximity and Volume (daily traffic count/distance to road)": 7, "State percentile for Traffic Proximity and Volume (daily traffic count/distance to road)": 5, "Regional percentile for Traffic Proximity and Volume (daily traffic count/distance to road)": 11, "National percentile for Traffic Proximity and Volume (daily traffic count/distance to road)": 10, "State average for Traffic Proximity and Volume (daily traffic count/distance to road)": 630, "Regional average for Traffic Proximity and Volume (daily traffic count/distance to road)": 530, "National average for Traffic Proximity and Volume (daily traffic count/distance to road)": 750, "Raw data for Lead Paint Indicator (% pre-1960s housing)": 0.31, "State percentile for Lead Paint Indicator (% pre-1960s housing)": 43, "Regional percentile for Lead Paint Indicator (% pre-1960s housing)": 49, "National percentile for Lead Paint Indicator (% pre-1960s housing)": 63, "State average for Lead Paint Indicator (% pre-1960s housing)": 0.41, "Regional average for Lead Paint Indicator (% pre-1960s housing)": 0.38, "National average for Lead Paint Indicator (% pre-1960s housing)": 0.28, "Raw data for Superfund Proximity (site count/km distance)": 0.019, "State percentile for Superfund Proximity (site count/km distance)": 7, "Regional percentile for Superfund Proximity (site count/km distance)": 9, "National percentile for Superfund Proximity (site count/km distance)": 16, "State average for Superfund Proximity (site count/km distance)": 0.096, "Regional average for Superfund Proximity (site count/km distance)": 0.13, "National average for Superfund Proximity (site count/km distance)": 0.13, "Raw data for RMP Proximity (facility count/km distance)": 0.61, "State percentile for RMP Proximity (facility count/km distance)": 47, "Regional percentile for RMP Proximity (facility count/km distance)": 60, "National percentile for RMP Proximity (facility count/km distance)": 64, "State average for RMP Proximity (facility count/km distance)": 1.2, "Regional average for RMP Proximity (facility count/km distance)": 0.83, "National average for RMP Proximity (facility count/km distance)": 0.74, "Raw data for Hazardous Waste Proximity (facility count/km distance)": 0.1, "State percentile for Hazardous Waste Proximity (facility count/km distance)": 7, "Regional percentile for Hazardous Waste Proximity (facility count/km distance)": 13, "National percentile for Hazardous Waste Proximity (facility count/km distance)": 14, "State average for Hazardous Waste Proximity (facility count/km distance)": 4.1, "Regional average for Hazardous Waste Proximity (facility count/km distance)": 2.4, "National average for Hazardous Waste Proximity (facility count/km distance)": 5, "Raw data for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 0.016, "State percentile for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 53, "Regional percentile for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 74, "National percentile for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 82, "State average for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 6.3, "Regional average for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 2.4, "National average for Wastewater Discharge Indicators (toxicity-weighted concentration/m distance)": 9.4, "Raw data for Demographic Index": 0.16, "State percentile for Demographic Index": 26, "Regional percentile for Demographic Index": 35, "National percentile for Demographic Index": 21, "State average for Demographic Index": 0.34, "Regional average for Demographic Index": 0.28, "National average for Demographic Index": 0.36, "Raw data for People of Color Population": 0.03, "State percentile for People of Color Population": 7, "Regional percentile for People of Color Population": 12, "National percentile for People of Color Population": 6, "State average for People of Color Population": 0.38, "Regional average for People of Color Population": 0.25, "National average for People of Color Population": 0.39, "Raw data for Low Income Population": 0.29, "State percentile for Low Income Population": 57, "Regional percentile for Low Income Population": 55, "National percentile for Low Income Population": 51, "State average for Low Income Population": 0.29, "Regional average for Low Income Population": 0.3, "National average for Low Income Population": 0.33, "Raw data for Linguistically Isolated Population": 0, "State percentile for Linguistically Isolated Population": 44, "Regional percentile for Linguistically Isolated Population": 59, "National percentile for Linguistically Isolated Population": 45, "State average for Linguistically Isolated Population": 0.05, "Regional average for Linguistically Isolated Population": 0.02, "National average for Linguistically Isolated Population": 0.04, "Raw data for Population with Less Than High School Education": 0.09, "State percentile for Population with Less Than High School Education": 55, "Regional percentile for Population with Less Than High School Education": 58, "National percentile for Population with Less Than High School Education": 49, "State average for Population with Less Than High School Education": 0.11, "Regional average for Population with Less Than High School Education": 0.1, "National average for Population with Less Than High School Education": 0.13, "Raw data for Population under Age 5": 0.03, "State percentile for Population under Age 5": 25, "Regional percentile for Population under Age 5": 25, "National percentile for Population under Age 5": 25, "State average for Population under Age 5": 0.06, "Regional average for Population under Age 5": 0.06, "National average for Population under Age 5": 0.06, "Raw data for Population over Age 64": 0.16, "State percentile for Population over Age 64": 62, "Regional percentile for Population over Age 64": 57, "National percentile for Population over Age 64": 61, "State average for Population over Age 64": 0.15, "Regional average for Population over Age 64": 0.16, "National average for Population over Age 64": 0.15, "PM 2.5 Emssions (tons)": 44.465, "PM 2.5 Emission Rate (lb/MWh)": 0.014, "Mapped Fuel Type": "Coal", "Additional Number Data First": 110011697075, "Additional Number Data Second": "", "Additional Number Data Third": "", "Additional Text Data First": "", "Additional Text Data Second": "", "Additional Text Data Third": "" } ] ```
vkoves commented 1 year ago

@derekeder and @SuragNuthulapaty - I've got some initial concept mocks I'd love your thoughts on. In particular:

State Page Individual Power Plant
State Power Plant Home Individual Power Plant Page

I know we also talked about planned shutdown dates, but how would we source that data for the whole country?

derekeder commented 1 year ago

@vkoves these are great! Some thoughts on each:

State page:

Individual power plant:

vkoves commented 1 year ago

We made this page! There's more stuff we can do but I don't think it'll need more designs