ArcGIS REST Services Directory Login
JSON

Layer: Coal Powerplants by Census Tract (EIA) (ID: 30)

View In:   ArcGIS Online Map Viewer

Name: Coal Powerplants by Census Tract (EIA)

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: The EIA-860M Excel dataset was imported and processed using Python. The script involved data fetching, cleansing, and formatting procedures to prepare the dataset for analysis. Geospatial data from the U.S. Census Bureau was utilized to enrich the EIA-860M data with spatial information. The script performed spatial joins, aggregations, and pivot operations to align the data at the census tract level. Detailed and summary outputs were generated in various formats (CSV, Excel, GeoPackage) for ease of use and analysis.For details on the methodology and potential limitations of the original EIA-860M data, refer to the U.S. Energy Information Administration's documentation.Calculations:The fields "Number of Operable Coal Generators" (COAL_OPER_CT) and "Number of Operable Natural Gas Generators" (NGAS_OPER_CT) represent the total count of operable generators within each Census Tract as of the report's date. These are calculated by aggregating the number of generators classified as 'Coal' or 'Natural Gas' respectively. The "Capacity (MW) of Operable Coal Generators" (COAL_OPER_CPCTY) and "Capacity (MW) of Operable Natural Gas Generators" (NGAS_OPER_CPCTY) fields reflect the total capacity in Megawatts of operable generators for coal and natural gas technologies within each Census Tract as of the report's date. These values are the summation of the nameplate capacity of all operable generators within each category.For fields like "Number of Coal Generators with Planned Retirement YYYY" (COAL_PR_CT_YYYY) and "Number of Natural Gas Generators with Planned Retirement YYYY" (NGAS_PR_CT_YYYY), the totals are calculated by counting the number of generators within each technology type that have a planned retirement in the specified year. Similarly, "Capacity (MW) of Coal Generators with Planned Retirement YYYY" (COAL_PR_CPCTY_YYYY) and "Capacity (MW) of Natural Gas Generators with Planned Retirement YYYY" (NGAS_PR_CPCTY_YYYY) are calculated by summing up the capacity of all generators in each technology type that are planned to retire in the specified year. The retired generator fields, such as "Number of Coal Generators Retired YYYY" (COAL_R_CT_YYYY) and "Number of Natural Gas Generators Retired YYYY" (NGAS_R_CT_YYYY), are totals of the generators that have been retired in the specified year, categorized by technology type. The corresponding capacity fields for retired generators are computed in the same manner, summing the capacity of all retired generators for each technology type in the specified year.

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. Spatial Data: U.S. Census Bureau's 2022 Substate Geographic Boundary Files Spatial Data Source Weblink: [https://www.census.gov/geographies/mapping-files/time-series/geo/cartographic-boundary.html]

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:
Drawing Info: Advanced Query Capabilities:
HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields: Templates:
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