View In:   ArcGIS Online Map Viewer

Name: Coal Mines by County

Display Field: state_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: CoalMine_All_County is aggregated at the County-level for all input mine points according to the county and state designated in the input data. The script starts by installing essential Python packages to handle spatial and non-spatial data. It then imports coal mine data and integrates it with spatial data from the U.S. Census Bureau. A significant feature of the script is the spatial join process, aligning coal mine data with geographical areas of census tracts and counties. The script filters the data based on mine status, identifying active, abandoned, and problematic mines (due to missing or invalid geographic coordinates). It then aggregates the data, compiling counts of mines and associated employment figures. The script distinguishes between valid and problematic data, ensuring accurate spatial analysis. The output is organized into detailed spatial layers, formatted as CSV and GeoPackage files, encompassing aggregated information on active and abandoned coal mines at the county and census tract levels.Calculations:The script computes several key metrics related to coal mines. It calculates the total count of active and abandoned coal mines, as well as the sum of employed individuals in these mines, both at the county and census tract levels. For abandoned mines, the script aggregates counts by the year of abandonment, providing a temporal dimension to the analysis. These aggregations include spatial attributes like State, County, and Census Tract names, alongside geographical identifiers such as GEOID. In processing problematic data entries, the script filters out mines with missing or invalid geographical coordinates, ensuring the accuracy of spatial joins and subsequent analyses. These calculations are pivotal in generating a comprehensive and detailed understanding of the spatial distribution and status of coal mines across different geographical areas.

Service Item Id: 22aaf2e337974faf8369d53ce09ae988

Copyright Text: Original Data: Mines Data Set, Mines Safety and Health Administration Original Data Source Weblink: [https://www.msha.gov/data-and-reports/mine-data-retrieval-system] Retrieval Date: October 2023 Original Data Source Description: The Mine dataset lists all Coal and Metal/Non-Metal mines under MSHA's jurisdiction since 1/1/1970. It includes such information as the current status of each mine (Active, Abandoned, NonProducing, etc.), the current owner and operating company, commodity codes and physical attributes of the mine. Mine ID is the unique key for this data. (Includes Abandoned or Abandoned and Sealed Mines) Spatial Data: U.S. Census Bureau's TIGER/Line Shapefiles Spatial Data Source Weblink: https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.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:

XMin: -1.99519149256E7
YMin: -1643352.0163999982
XMax: 2.00218864032E7
YMax: 1.15543482474E7
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: activecoalmine_count
Min. Value: 1.0
ClassBreakInfos:
• Class Maximum Value: 10
  Label: 0 - 10
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [247, 252, 253, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 20
  Label: 10 - 20
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [214, 239, 237, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 30
  Label: 20 - 30
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [142, 211, 193, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 40
  Label: 30 - 40
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [72, 178, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 50
  Label: 40 - 50
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [21, 127, 59, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 52
  Label: 50 - 52
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 68, 27, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 25
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 )
• state_abbr ( modelName: state_abbr, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: State_Abbr, type: esriFieldTypeString )
• state_name ( modelName: state_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: State_Name, type: esriFieldTypeString )
• geoid ( modelName: geoid, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: GEOID, type: esriFieldTypeString )
• county_name ( modelName: county_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: County_Name, type: esriFieldTypeString )
• activecoalmine_count ( modelName: activecoalmine_count, nullable: true, editable: true, defaultValue: null, alias: ActiveCoalMine_Count, type: esriFieldTypeDouble )
• activecoalmine_employed ( modelName: activecoalmine_employed, nullable: true, editable: true, defaultValue: null, alias: ActiveCoalMine_Employed, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1970 ( modelName: abandonedcoalmine_count_1970, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1970, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1971 ( modelName: abandonedcoalmine_count_1971, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1971, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1972 ( modelName: abandonedcoalmine_count_1972, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1972, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1973 ( modelName: abandonedcoalmine_count_1973, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1973, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1974 ( modelName: abandonedcoalmine_count_1974, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1974, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1975 ( modelName: abandonedcoalmine_count_1975, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1975, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1976 ( modelName: abandonedcoalmine_count_1976, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1976, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1977 ( modelName: abandonedcoalmine_count_1977, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1977, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1978 ( modelName: abandonedcoalmine_count_1978, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1978, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1979 ( modelName: abandonedcoalmine_count_1979, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1979, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1980 ( modelName: abandonedcoalmine_count_1980, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1980, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1981 ( modelName: abandonedcoalmine_count_1981, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1981, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1982 ( modelName: abandonedcoalmine_count_1982, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1982, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1983 ( modelName: abandonedcoalmine_count_1983, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1983, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1984 ( modelName: abandonedcoalmine_count_1984, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1984, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1985 ( modelName: abandonedcoalmine_count_1985, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1985, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1986 ( modelName: abandonedcoalmine_count_1986, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1986, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1987 ( modelName: abandonedcoalmine_count_1987, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1987, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1988 ( modelName: abandonedcoalmine_count_1988, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1988, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1989 ( modelName: abandonedcoalmine_count_1989, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1989, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1990 ( modelName: abandonedcoalmine_count_1990, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1990, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1991 ( modelName: abandonedcoalmine_count_1991, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1991, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1992 ( modelName: abandonedcoalmine_count_1992, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1992, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1993 ( modelName: abandonedcoalmine_count_1993, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1993, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1994 ( modelName: abandonedcoalmine_count_1994, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1994, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1995 ( modelName: abandonedcoalmine_count_1995, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1995, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1996 ( modelName: abandonedcoalmine_count_1996, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1996, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1997 ( modelName: abandonedcoalmine_count_1997, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1997, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1998 ( modelName: abandonedcoalmine_count_1998, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1998, type: esriFieldTypeDouble )
• abandonedcoalmine_count_1999 ( modelName: abandonedcoalmine_count_1999, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_1999, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2000 ( modelName: abandonedcoalmine_count_2000, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2000, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2001 ( modelName: abandonedcoalmine_count_2001, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2001, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2002 ( modelName: abandonedcoalmine_count_2002, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2002, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2003 ( modelName: abandonedcoalmine_count_2003, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2003, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2004 ( modelName: abandonedcoalmine_count_2004, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2004, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2005 ( modelName: abandonedcoalmine_count_2005, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2005, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2006 ( modelName: abandonedcoalmine_count_2006, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2006, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2007 ( modelName: abandonedcoalmine_count_2007, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2007, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2008 ( modelName: abandonedcoalmine_count_2008, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2008, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2009 ( modelName: abandonedcoalmine_count_2009, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2009, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2010 ( modelName: abandonedcoalmine_count_2010, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2010, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2011 ( modelName: abandonedcoalmine_count_2011, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2011, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2012 ( modelName: abandonedcoalmine_count_2012, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2012, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2013 ( modelName: abandonedcoalmine_count_2013, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2013, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2014 ( modelName: abandonedcoalmine_count_2014, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2014, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2015 ( modelName: abandonedcoalmine_count_2015, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2015, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2016 ( modelName: abandonedcoalmine_count_2016, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2016, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2017 ( modelName: abandonedcoalmine_count_2017, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2017, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2018 ( modelName: abandonedcoalmine_count_2018, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2018, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2019 ( modelName: abandonedcoalmine_count_2019, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2019, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2020 ( modelName: abandonedcoalmine_count_2020, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2020, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2021 ( modelName: abandonedcoalmine_count_2021, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2021, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2022 ( modelName: abandonedcoalmine_count_2022, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2022, type: esriFieldTypeDouble )
• abandonedcoalmine_count_2023 ( modelName: abandonedcoalmine_count_2023, nullable: true, editable: true, defaultValue: null, alias: AbandonedCoalMine_Count_2023, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Coal Mines by County
  Description:
  Prototype:
  abandonedcoalmine_count_1976: null
  abandonedcoalmine_count_1977: null
  abandonedcoalmine_count_1978: null
  abandonedcoalmine_count_1979: null
  abandonedcoalmine_count_2023: null
  abandonedcoalmine_count_1970: null
  abandonedcoalmine_count_1971: null
  abandonedcoalmine_count_1972: null
  abandonedcoalmine_count_1973: null
  abandonedcoalmine_count_1974: null
  abandonedcoalmine_count_1975: null
  state_name: null
  abandonedcoalmine_count_2020: null
  abandonedcoalmine_count_2021: null
  abandonedcoalmine_count_2022: null
  abandonedcoalmine_count_1987: null
  abandonedcoalmine_count_1988: null
  abandonedcoalmine_count_1989: null
  abandonedcoalmine_count_1980: null
  abandonedcoalmine_count_1981: null
  abandonedcoalmine_count_1982: null
  abandonedcoalmine_count_1983: null
  abandonedcoalmine_count_1984: null
  abandonedcoalmine_count_1985: null
  abandonedcoalmine_count_1986: null
  abandonedcoalmine_count_1998: null
  abandonedcoalmine_count_2009: null
  abandonedcoalmine_count_1999: null
  activecoalmine_employed: null
  abandonedcoalmine_count_1990: null
  abandonedcoalmine_count_2001: null
  abandonedcoalmine_count_1991: null
  abandonedcoalmine_count_2002: null
  abandonedcoalmine_count_1992: null
  abandonedcoalmine_count_2003: null
  abandonedcoalmine_count_1993: null
  abandonedcoalmine_count_2004: null
  abandonedcoalmine_count_1994: null
  abandonedcoalmine_count_2005: null
  abandonedcoalmine_count_1995: null
  abandonedcoalmine_count_2006: null
  abandonedcoalmine_count_1996: null
  abandonedcoalmine_count_2007: null
  abandonedcoalmine_count_1997: null
  abandonedcoalmine_count_2008: null
  abandonedcoalmine_count_2000: null
  activecoalmine_count: null
  abandonedcoalmine_count_2012: null
  abandonedcoalmine_count_2013: null
  abandonedcoalmine_count_2014: null
  abandonedcoalmine_count_2015: null
  county_name: null
  abandonedcoalmine_count_2016: null
  abandonedcoalmine_count_2017: null
  abandonedcoalmine_count_2018: null
  abandonedcoalmine_count_2019: null
  abandonedcoalmine_count_2010: null
  geoid: null
  abandonedcoalmine_count_2011: null
  state_abbr: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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