{ "isCoGoEnabled": false, "extent": { "ymin": 2929343.8517999984, "xmin": -1.74525139193E7, "ymax": 1.1502860587300003E7, "xmax": -7640473.3631, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 29, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Natural Gas Powerplants", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "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 } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Natural Gas Powerplants", "allowTrueCurvesUpdates": false, "displayField": "entity_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "plant_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plant_id", "length": 2147483647, "alias": "Plant_ID", "type": "esriFieldTypeString" }, { "modelName": "entity_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "entity_id", "length": 2147483647, "alias": "Entity_ID", "type": "esriFieldTypeString" }, { "modelName": "entity_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "entity_name", "length": 2147483647, "alias": "Entity_Name", "type": "esriFieldTypeString" }, { "modelName": "plant_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plant_name", "length": 2147483647, "alias": "Plant_Name", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2147483647, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "county", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county", "length": 2147483647, "alias": "County", "type": "esriFieldTypeString" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "operating_nameplate_capacity_mw", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operating_nameplate_capacity_mw", "alias": "Operating_Nameplate_Capacity_MW", "type": "esriFieldTypeDouble" }, { "modelName": "operating_generator_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operating_generator_id", "length": 2147483647, "alias": "Operating_Generator_ID", "type": "esriFieldTypeString" }, { "modelName": "energy_source_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_source_code", "length": 2147483647, "alias": "Energy_Source_Code", "type": "esriFieldTypeString" }, { "modelName": "operating_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operating_year", "length": 2147483647, "alias": "Operating_Year", "type": "esriFieldTypeString" }, { "modelName": "planned_retirement_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planned_retirement_year", "length": 2147483647, "alias": "Planned_Retirement_Year", "type": "esriFieldTypeString" }, { "modelName": "retired_nameplate_capacity_mw", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retired_nameplate_capacity_mw", "alias": "Retired_Nameplate_Capacity_MW", "type": "esriFieldTypeDouble" }, { "modelName": "retired_generator_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retired_generator_id", "length": 2147483647, "alias": "Retired_Generator_ID", "type": "esriFieldTypeString" }, { "modelName": "retired_energy_source_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retired_energy_source_code", "length": 2147483647, "alias": "Retired_Energy_Source_Code", "type": "esriFieldTypeString" }, { "modelName": "retired_operating_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retired_operating_year", "length": 2147483647, "alias": "Retired_Operating_Year", "type": "esriFieldTypeString" }, { "modelName": "retired_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retired_year", "length": 2147483647, "alias": "Retired_Year", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "This geospatial dataset provides a detailed overview of coal and natural gas power plants, derived from the EIA-860M form data, and processed for spatial analysis in ArcGIS Pro.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.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r4698_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4502_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "22aaf2e337974faf8369d53ce09ae988", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 }, "color": [ 151, 44, 165, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "Original Data: U.S. Energy Information Administration's EIA-860M data\nOriginal Data Source Weblink: https://www.eia.gov/electricity/data/eia860m/\nOriginal Data Release Date: September 2023\nSource 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.", "zDefault": 0, "geometryType": "esriGeometryPoint" }