Coal Power Plants


FGDC Metadata:

Identification Information:
Citation:
Citation Information:
Title: Coal Power Plants
Geospatial Data Presentation Form: vector digital data
Description:
Abstract: The dataset began as an Excel file containing multiple sheets related to coal and natural gas power plants. Each sheet was read and processed using Pandas, a data manipulation library in Python. The data was categorized based on the energy source code into coal and natural gas datasets. From these datasets, subsets focusing on operating and retired power plants were created. Key attributes, such as 'Entity ID', 'Plant Name', and 'Capacity', were selected, and their data types were adjusted for consistency. Notably, 'Planned Retirement Year' in the operating subset and equivalent fields in the retired subset were filled with 'NA' for missing values, and all column names were standardized. These subsets were then aggregated by 'Plant ID', applying specific rules like 'first' for categorical fields and 'sum' for numerical fields. The aggregated datasets were merged based on shared attributes like 'Entity ID' and 'Plant ID', forming a comprehensive dataset. This merged data was then converted into a GeoDataFrame using GeoPandas, assigning geographic point locations based on 'Latitude' and 'Longitude'. The geospatial data was exported as a GeoPackage file, suitable for importing into ArcGIS Pro as feature classes. The resulting spatial layers offer insights into the distribution, capacity, and operational status of power plants across different energy types.
Purpose: This geospatial dataset provides a detailed overview of coal power plants grouped by Plant ID, derived from the EIA-860M form data, and processed for spatial analysis.
Keywords:
Theme:
Theme Keyword Thesaurus: None
Theme Keyword: coal
Theme Keyword: power plant
Theme Keyword: generator
Theme Keyword: eia
Access Constraints: None
Use Constraints: USE LIMITATION: This project was funded by the United States Department of Energy, National Energy Technology Laboratory, in part, through a site support contract. Neither the United States Government nor any agency thereof, nor any of their employees, nor the support contractor, nor any of their employees, makes any warranty, express or implied, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any information, apparatus, product, or process disclosed, or represents that its use would not infringe privately owned rights. Reference herein to any specific commercial product, process, or service by trade name, trademark, manufacturer, or otherwise does not necessarily constitute or imply its endorsement, recommendation, or favoring by the United States Government or any agency thereof. The views and opinions of authors expressed herein do not necessarily state or reflect those of the United States Government or any agency thereof.
Data Set Credit: Original Data: U.S. Energy Information Administration's EIA-860M data Original Data Source Weblink: https://www.eia.gov/electricity/data/eia860m/ Original Data Release Date: September 2023 Source Use Restrictions: This dataset is publicly available and can be freely used, with proper citation to the U.S. Energy Information Administration's EIA-860M as the original data source.
Native Data Set Environment: Esri ArcGIS 13.2.0.49743
Spatial Data Organization Information:
Direct Spatial Reference Method: Vector
Point and Vector Object Information:
SDTS Terms Description:
SDTS Point and Vector Object Type: Entity point
Point and Vector Object Count: 0
Entity and Attribute Information:
Detailed Description:
Entity Type:
Entity Type Label: Coal_Powerplants_EIA
Attribute:
Attribute Label: OBJECTID
Attribute Definition: Internal feature number.
Attribute Definition Source: Esri
Attribute Domain Values:
Unrepresentable Domain: Sequential unique whole numbers that are automatically generated.
Attribute:
Attribute Label: Shape
Attribute Definition: Feature geometry.
Attribute Definition Source: Esri
Attribute Domain Values:
Unrepresentable Domain: Coordinates defining the features.
Attribute:
Attribute Label: Plant_ID
Attribute:
Attribute Label: Entity_ID
Attribute:
Attribute Label: Entity_Name
Attribute:
Attribute Label: Plant_Name
Attribute:
Attribute Label: State
Attribute:
Attribute Label: County
Attribute:
Attribute Label: Latitude
Attribute:
Attribute Label: Longitude
Attribute:
Attribute Label: Operating_Nameplate_Capacity_MW
Attribute:
Attribute Label: Operating_Generator_ID
Attribute:
Attribute Label: Energy_Source_Code
Attribute:
Attribute Label: Operating_Year
Attribute:
Attribute Label: Planned_Retirement_Year
Attribute:
Attribute Label: Retired_Nameplate_Capacity_MW
Attribute:
Attribute Label: Retired_Generator_ID
Attribute:
Attribute Label: Retired_Energy_Source_Code
Attribute:
Attribute Label: Retired_Operating_Year
Attribute:
Attribute Label: Retired_Year
Metadata Reference Information:
Metadata Date: 20231218
Metadata Standard name: FGDC Content Standard for Digital Geospatial Metadata
Metadata Standard Version: FGDC-STD-001-1998
Metadata Time Convention: local time