Published January 25, 2022 | Version v1
Dataset Open

Profitability and investment risk of Texan power system winterization

  • 1. Institute for Sustainable Economic Development, University of Natural Resources and Life Sciences, Vienna
  • 2. Institute of Statistics, University of Natural Resources and Life Sciences, Vienna
  • 3. Institute Statistics, University of Natural Resources and Life Sciences, Vienna

Description

Profitability and investment risk of Texan power system winterization

This data repository contains interim and final results of the paper “Profitability and investment risk of Texan power system winterization” published in Nature Energy. Code used to generate these results can be found at github

Abstract

A lack of winterization of power system infrastructure resulted in significant rolling blackouts in Texas in 2021 though debate about the cost of winterization continues. Here, we assess if incentives for winterization on the energy only market are sufficient. We combine power demand estimates with estimates of power plant outages to derive power deficits and scarcity prices. Expected profits from winterization of a large share of existing capacity are positive. However, investment risk is high due to the low frequency of freeze events, potentially explaining under-investment, as do high discount rates and uncertainty about power generation failure under cold temperatures. As the social cost of power deficits is one to two orders of magnitude higher than winterization cost, regulatory enforcement of winterization is welfare enhancing. Current legislation can be improved by emphasizing winterization of gas power plants and infrastructure.

Date and time format

Please observe that we omit the date column from the description of columns below for all datasets. The ERA5 data in input/ is in UTC, all other input datasets are in local Texas time (GMT-6). In interim, temperatures/temppop/, temperatures/temp_gas_powerplant.csv, temperatures/temp_gas_outages.csv, temperatures/temp_coal_powerplant.csv, temperatures/temp_coal_outages.csv and the wind power simulation output (windpower/) is in UTC. All other datasets are in local Texas time.

Data

cache/

Data cache used by the scripts analyzing the extreme events: extreme temperatures, loss of load, their return periods, durations, maxima/minima (the cached files are not included, but can be generated with scripts/R/events.R)

figures/

Figures shown in the manuscript

  • raw_data: includes raw data for reproducing the figures in the main part of the manuscript
  • outage_model: figures representing the outage function as derived with our model

input/

Input data from external sources (with exception of orcd not included due to licensing issues)

  • ERA5_windspeeds_USA: available from the CDS. Download with scripts/download_era5_USA.py
  • gas_production: available from the Texas Railroad Commission in PDF format here. We extracted the data manually.
  • Load: available from ERCOT here
  • orcd: Scarcity prices as regulated by ERCOT. Manually extracted from J. Zarnikau et al.
  • outages: Outage Events from ERCOT with geo locations provided by Edgar Virguez here resulting from unit outage data provided by Ercot
  • population: population density data provided by arcgis here
  • powerplants: locations of power plants in Texas provided by the Energy Information Administration here
  • shp: shapefile of Texas state boundaries provided by arcgis here
  • temperatures: available from the CDS here. Can be downloaded with script scripts/download_era5_TX_temp.py
  • USWTDB: US wind turbine data base provided by the US Geological Service here. We used version: uswtdb_v3_3_20210114
  • GWA2: Global Wind Atlas Version 2.1 accessible here

interim/

Intermediary files from the analysis

  • bootstrap_year.csv: 30 randomly selected years between 1950 and 2021, 10,000 times used for bootstrapping
    Generated by notebooks/outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
  • bootstrap_year2020.csv: 30 randomly selected years between 1950 and 2020, 10,000 times used for bootstrapping without 2021 event
    Generated by outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
  • turbine_data.csv: turbine data for Texan wind turbines
    Generated by scripts/prepare_TX_turbines.py
    Columns:
    • capacity: turbine capacity (kW)
    • height: turbine height (m)
    • lon: longitude coordinate (°)
    • lat: latitude coordinate (°)
    • sp: specific power (W/m²)
    • ind: running index

interim/load/

Temperature dependent estimates of electricity load for Texas.

  • load_est70_LR24_temptrend_Hook-8.csv
    Generated by notebooks/load_estimation_LR24_temptrend_Hook-8.ipynb
    Columns:
    • load_est: load estimated for the period 1950-2021 assuming an average load level as in 2021 (MWh)
    • temp: population weighted temperature (°C)
  • load_est10_LR24_temptrend_Hook-8.csv
    Generated by notebooks/load_estimation_LR24_temptrend_Hook-8.ipynb
    Columns:
    • load: observed load in period 2012-2021 as published by ERCOT (MWh)
    • load_est: load estimated for period 2012-2021 considering time trend, i.e. this is a replication of the observed load without outages with our model for validation purposes (MWh)
  • load_est9_LR24temptrend2021_Hook-8.csv
    Generated by notebooks/load_estimation_LR24_temptrend_Hook-8.ipynb
    Columns:
    • load: observed load in period 2004-2021/01 and load forecast 2021/02 as published by ERCOT (MWh)
    • load_est: load estimated for the years 2012-2020 for cross validation of load model. For training, the years 2012-2021 (2021/02 forecast) were used, except the predicted year, i.e. this is a replication of the observed load with our model for validation purposes. (MWh)
  • load_est17_crossvalidation_LR24temptrend_Hook-8.csv Generated by notebooks/load_estimation_LR24_temptrend_Hook-8.ipynb
    Columns:
    • load: observed load 2004 - 2021/01 and load forecast 2021/02 as published by ERCOT (MWh)
    • load_est: load estimated for cross validation for years 2004-2021, training years 2012-2020, trained with each year in traning period except modelled year with variable load level, i.e. this is a replication of the observed load with our model for validation purposes(MWh)
  • load_est_LR24temptrend_Hook-8.csv Generated by notebooks/load_estimation_LR24_temptrend_Hook-8.ipynb
    Columns:
    • load: observed load 2004 - 2021 as published by ERCOT (MWh)
    • load_est: years 2004-2021 predicted with a model which was trained for the years 2012-2020 considering time trend, i.e. this is a replication of the observed load without outages with our temperature dependent model with our model for validation purposes (MWh)

interim/outages

  • outages.feather Outage by minute of all generation units in Texas in February 2021. Created by scripts/R/create-ercot-outage-timeseries.R In Texas local time.
    Columns:
    • station: name of power plant
    • unit: name of generation unit
    • fullname: concatenated string of station and name
    • dataset: ercot or edgar. ercot refers to the raw dataset provided by ERCOT, Edgar to the dataset provided by Edgar Virguez (for details see above in section input/)
    • Longitude: Longitude of location of power plant
    • Latitude: Latitude of location of power plant
    • reduction: hourly reduction of capacity due to outage in this minute (MW)
    • cap_available: available capacity in this minute (MW)
    • cap_max: maximum capacity of unit (MW)
  • outages-hourly.feather Hourly outages at all generation units in Texas in February 2021. Created by scripts/R/create-ercot-outage-timeseries.R In Texas local time.
    Columns:
    • station: name of power plant
    • unit: name of generation unit
    • fullname: concatenated string of station and name
    • dataset: ercot or edgar. ercot refers to the raw dataset provided by ERCOT, Edgar to the dataset provided by Edgar Virguez (for details see above in section input/)
    • Longitude: Longitude of location of power plant
    • Latitude: Latitude of location of power plant
    • reduction: hourly reduction of capacity due to outage in this time step (MW)
    • cap_available: hourly available capacity in this minute (MW)
    • cap_max: maximum capacity of unit (MW)
  • outages_reduction.csv Hourly outages per fuel (MW). We use these outages for COAL and GAS only in the analysis.
    Generated by notebooks/prepare_outages_NSsplit.ipynb
    Columns:
    • NG: natural gas power plants
    • WIND: wind power plants
    • SOLAR: solar power plants
    • ESR: energy storage resource
    • HYDRO: hydropower plants
    • NUCLEAR: nuclear power plants
  • outages_reductionNorth.csv Hourly outages for the Northern part of Texas (latitude > 30) (MW). We use these outages for WIND only in the analysis.
    Generated by notebooks/prepare_outages_NSsplit.ipynb
    Columns as above.
  • outages_reductionSouth.csv Hourly outages for the Southern part area of Texas (latitude <= 30) (MW). We use these outages for WIND only in the analysis.
    Generated by notebooks/prepare_outages_NSsplit.ipynb
    Columns as above.

interim/temperatures

  • temppop
    Generated by scripts/calc_temppopC.py
    • contains population weighted temperatures for Texas, one file for each year (°C).
  • temp_coal_outage.csv
    Generated by notebooks/temperatures_NSsplit.ipynb
    Columns:
    • t2m: temperature weighted by coal power plants experiencing outages in February 2021 (°C)
  • temp_coal_powerplant.csv
    Generated by notebooks/temperatures_NSsplit.ipynb
    Columns:
    • t2m: temperature weighted by all coal power plants (°C)
  • temp_gas_outage.csv
    Generated by notebooks/temperatures_NSsplit.ipynb
    Columns:
    • t2m: temperature weighted by gaspower plants experiencing outages in February 2021 (°C)
  • temp_gas_powerplant.csv
    Generated by notebooks/temperatures_NSsplit.ipynb
    Columns:
    • t2m: temperature weighted by all gas power plants (°C)
  • temp_gasfields.csv
    Generated by notebooks/temperatures_NSsplit.ipynb
    Columns:
    • t2m: temperature weighted by all gasfields (°C)
  • tempWP_NSsplit.csv
    Generated by notebooks/wp_temp_NSsplit.ipynb
    Columns:
    • t2mSouth: temperatures weighted by all wind power plants in the South (°C)
    • t2mNorth: temperatures weighted by all wind power plants in the North (°C)

interim/thresholds

  • thresh_total63.5GW.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • total available capacity of gas, coal and wind considering outages, assuming gasfield temperatures for gas outages (GW)
  • thresh_totalPP63.5GW.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • total available capacity of gas, coal and wind, considering outages, assuming gas power plant temperatures for gas outages (GW)
  • threshold_coal.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • outages of coal power plants based on coal power plant temperatures (GW)
  • threshold_gas.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • outages of gas power plants based on gasfield temperatures (GW)
  • threshold_gasPP.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • outages of gas power plants based on gas power plant temperatures (GW)
  • threshold_gas_coal63.5GW.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • available capacity of gas and coal, considering outages, assuming gasfield temperatures for gas outages (GW)
  • threshold_gas_coalPP63.5GW.csv
    Generated by notebooks/outages_thresholds_gasPP_vs_gasfield_LR24temptrend_Hook-8.ipynb
    Columns:
    • available capacity of gas and coal, considering outages, assuming gas power plant temperatures for gas outages (GW)

interim/windpower

  • cfTXh.csv
    Generated by notebooks/windpower_ERA5_GWA2_const_cap.ipynb
    Columns:
    • Capacity factors of simulated Texan wind power (dimensionless)
  • wpTXh.csv
    Generated by notebooks/windpower_ERA5_GWA2_const_cap.ipynb
    Columns:
  • simulated Texan wind power generation (kWh)

output/

  • marginal_revenue_coal_10_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_10_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization for coal (bn$/GW winterized) with discount rate of 10% and deficit events up to 2021
  • marginal_revenue_coal_LR24temptrend_Hook-8.csv
    Generated by notebooks/outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of coal (bn$/GW winterized) with discount rate of 5% and deficit events up to 2021
  • marginal_revenue_coal2020_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_2020_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of coal (bn$/GW winterized) with discount rate of 5% and deficit events up to 2020
  • marginal_revenue_gas_10_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_10_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of gas (bn$/GW winterized) with discount rate of 10% and deficit events up to 2021
  • marginal_revenue_gas_LR24temptrend_Hook-8.csv
    Generated by notebooks/outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of gas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2021
  • marginal_revenue_gas2020_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_2020_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of gas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2020
  • marginal_revenue_wind_north_10_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_10_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Northern Wind in Texas (bn$/GW winterized) with discount rate of 10% and deficit events up to 2021
  • marginal_revenue_wind_north_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Northern Wind in Texas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2021
  • marginal_revenue_wind_north2020_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_2020_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Northern Wind in Texas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2020
  • marginal_revenue_wind_south_10_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_10_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Southern Wind in Texas (bn$/GW winterized) with discount rate of 10% and deficit events up to 2021
  • marginal_revenue_wind_south_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Southern Wind in Texas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2021
  • marginal_revenue_wind_south2020_LR24temptrend_Hook-8.csv Generated by notebooks/outages_reduced_bootstrap_2020_LR24temptrend_Hook-8.ipynb
    Columns:
    • Marginal revenues from winterization of Southern Wind in Texas (bn$/GW winterized) with discount rate of 5% and deficit events up to 2020
  • sensitivity_analysis_temperature_thresholds_all_LR24temptrend_Hook-8.csv Generated by notebooks/outages_thresholds_sensitivity_LR24temptrend_Hook-8.ipynb
    Columns:
    • delta_thresh_temp: change in outage temperature thresholds for all technologies (°C)
    • delta_rec_temp: change in recovery temperature thresholds for all technologies (°C)
    • number_of_events: estimated number of events within 7 decades
    • after2004: years of events after 2004
    • total_loss_TWh: total loss of load (TWh)
    • max_loss_GW: maximum loss of load (GW)
    • mean_loss_GW: average loss og load (GW)
    • mean_revenue_mioUSD: average revenue (M$)
    • rank_2021_event: rank of 2021 event in terms of loss of load
  • sensitivity_analysis_temperature_thresholds_coal_LR24temptrend_Hook-8.csv Generated by notebooks/outages_thresholds_sensitivity_LR24temptrend_Hook-8.ipynb
    Columns:
    • thresh_coal_temp: outage temperature thresholds for coal (°C)
    • rec_coal_temp: recovery temperature thresholds for coal (°C)
    • number_of_events: estimated number of events within 7 decades
    • after2004: years of events after 2004
    • total_loss_TWh: total loss of load (TWh)
    • max_loss_GW: maximum loss of load (GW)
    • mean_loss_GW: average loss og load (GW)
    • mean_revenue_mioUSD: average revenue (M$)
    • rank_2021_event: rank of 2021 event in terms of loss of load
  • sensitivity_analysis_temperature_thresholds_gas_LR24temptrend_Hook-8.csv Generated by notebooks/outages_thresholds_sensitivity_LR24temptrend_Hook-8.ipynb
    Columns:
    • thresh_gas_temp: outage temperature thresholds for gas (°C)
    • rec_gas_temp: recovery temperature thresholds for gas (°C)
    • number_of_events: estimated number of events within 7 decades
    • after2004: years of events after 2004
    • total_loss_TWh: total loss of load (TWh)
    • max_loss_GW: maximum loss of load (GW)
    • mean_loss_GW: average loss og load (GW)
    • mean_revenue_mioUSD: average revenue (M$)
    • rank_2021_event: rank of 2021 event in terms of loss of load
  • sensitivity_analysis_temperature_thresholds_wind_north_LR24temptrend_Hook-8.csv Generated by notebooks/outages_thresholds_sensitivity_LR24temptrend_Hook-8.ipynb
    Columns:
    • thresh_windn_temp: outage temperature thresholds for wind north (°C)
    • rec_windn_temp:recovery temperature thresholds for wind north (°C)
    • number_of_events: estimated number of events within 7 decades
    • after2004: years of events after 2004
    • total_loss_TWh: total loss of load (TWh)
    • max_loss_GW: maximum loss of load (GW)
    • mean_loss_GW: average loss og load (GW)
    • mean_revenue_mioUSD: average revenue (M$)
    • rank_2021_event: rank of 2021 event in terms of loss of load
  • sensitivity_analysis_temperature_thresholds_wind_south_LR24temptrend_Hook-8.csv Generated by notebooks/outages_thresholds_sensitivity_LR24temptrend_Hook-8.ipynb
    Columns:
    • thresh_winds_temp: outage temperature thresholds for wind south (°C)
    • rec_winds_temp:recovery temperature thresholds for wind south (°C)
    • number_of_events: estimated number of events within 7 decades
    • after2004: years of events after 2004
    • total_loss_TWh: total loss of load (TWh)
    • max_loss_GW: maximum loss of load (GW)
    • mean_loss_GW: average loss og load (GW)
    • mean_revenue_mioUSD: average revenue (M$)
    • rank_2021_event: rank of 2021 event in terms of loss of load

 

Files

data.zip

Files (289.5 MB)

Name Size Download all
md5:aa001188329239865bf4aa22b61fcd05
289.5 MB Preview Download

Additional details

Related works

Is supplement to
Software: https://github.com/inwe-boku/texas-power-outages (URL)
Is supplemented by
Working paper: https://arxiv.org/abs/2105.05148 (URL)