View In:   ArcGIS Online Map Viewer

Name: Coal Powerplants

Display Field: entity_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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.

Service Item Id: 22aaf2e337974faf8369d53ce09ae988

Copyright Text: 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.

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.76003350711E7
YMin: 2254743.8621999994
XMax: -7879661.100199999
YMax: 9570063.925099999
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [104, 104, 104, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• plant_id ( modelName: plant_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Plant_ID, type: esriFieldTypeString )
• entity_id ( modelName: entity_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Entity_ID, type: esriFieldTypeString )
• entity_name ( modelName: entity_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Entity_Name, type: esriFieldTypeString )
• plant_name ( modelName: plant_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Plant_Name, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: State, type: esriFieldTypeString )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: County, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• operating_nameplate_capacity_mw ( modelName: operating_nameplate_capacity_mw, nullable: true, editable: true, defaultValue: null, alias: Operating_Nameplate_Capacity_MW, type: esriFieldTypeDouble )
• operating_generator_id ( modelName: operating_generator_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Operating_Generator_ID, type: esriFieldTypeString )
• energy_source_code ( modelName: energy_source_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Energy_Source_Code, type: esriFieldTypeString )
• operating_year ( modelName: operating_year, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Operating_Year, type: esriFieldTypeString )
• planned_retirement_year ( modelName: planned_retirement_year, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Planned_Retirement_Year, type: esriFieldTypeString )
• retired_nameplate_capacity_mw ( modelName: retired_nameplate_capacity_mw, nullable: true, editable: true, defaultValue: null, alias: Retired_Nameplate_Capacity_MW, type: esriFieldTypeDouble )
• retired_generator_id ( modelName: retired_generator_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Retired_Generator_ID, type: esriFieldTypeString )
• retired_energy_source_code ( modelName: retired_energy_source_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Retired_Energy_Source_Code, type: esriFieldTypeString )
• retired_operating_year ( modelName: retired_operating_year, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Retired_Operating_Year, type: esriFieldTypeString )
• retired_year ( modelName: retired_year, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Retired_Year, type: esriFieldTypeString )

Templates:

• Name: Coal Powerplants
  Description:
  Prototype:
  plant_id: null
  planned_retirement_year: null
  entity_name: null
  retired_nameplate_capacity_mw: null
  latitude: null
  county: null
  energy_source_code: null
  entity_id: null
  retired_operating_year: null
  retired_year: null
  operating_nameplate_capacity_mw: null
  operating_generator_id: null
  retired_energy_source_code: null
  state: null
  operating_year: null
  retired_generator_id: null
  plant_name: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata