View In:   ArcGIS Online Map Viewer

Name: Coal Mines

Display Field: current_mine_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The original data was spatially joined to census tract administrative boundaries using the provided Latitude and Longitude columns. The data was filtered based on the results of the spatial join and is available within GEO_VALIDITY as VALID, INVALID, or MISSING. If the data was determined to have valid geometry, the census tract it was joined to is available in CENSUS_TRACT_NAME with the accompanying tract geographic identifier in CENSUS_TRACT_GEOID. For GEO_VALIDITY values:VALID = Latitude/Longitude intersected a Census Tract boundary and was checked for matching STATE valuesINVALID = Latitude/Longitude did not intersect a Census Tract boundary OR it was joined to a Census Tract boundary but STATE values were mismatched for original data and Census TractMISSING = Latitude/Longitude values missing from data

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.90024656797E7
YMin: -1605857.0969999991
XMax: -28.68690000101924
YMax: 2.88176975219E7
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 38, 0, 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 )
• mine_id ( modelName: mine_id, nullable: true, editable: true, defaultValue: null, alias: MINE_ID, type: esriFieldTypeInteger )
• current_mine_name ( modelName: current_mine_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_MINE_NAME, type: esriFieldTypeString )
• coal_metal_ind ( modelName: coal_metal_ind, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: COAL_METAL_IND, type: esriFieldTypeString )
• current_mine_type ( modelName: current_mine_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_MINE_TYPE, type: esriFieldTypeString )
• current_mine_status ( modelName: current_mine_status, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_MINE_STATUS, type: esriFieldTypeString )
• current_status_dt ( modelName: current_status_dt, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_STATUS_DT, type: esriFieldTypeString )
• current_controller_id ( modelName: current_controller_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_CONTROLLER_ID, type: esriFieldTypeString )
• current_controller_name ( modelName: current_controller_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_CONTROLLER_NAME, type: esriFieldTypeString )
• current_operator_id ( modelName: current_operator_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_OPERATOR_ID, type: esriFieldTypeString )
• current_operator_name ( modelName: current_operator_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_OPERATOR_NAME, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: STATE, type: esriFieldTypeString )
• bom_state_cd ( modelName: bom_state_cd, nullable: true, editable: true, defaultValue: null, alias: BOM_STATE_CD, type: esriFieldTypeInteger )
• fips_cnty_cd ( modelName: fips_cnty_cd, nullable: true, editable: true, defaultValue: null, alias: FIPS_CNTY_CD, type: esriFieldTypeInteger )
• fips_cnty_nm ( modelName: fips_cnty_nm, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: FIPS_CNTY_NM, type: esriFieldTypeString )
• cong_dist_cd ( modelName: cong_dist_cd, nullable: true, editable: true, defaultValue: null, alias: CONG_DIST_CD, type: esriFieldTypeDouble )
• company_type ( modelName: company_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: COMPANY_TYPE, type: esriFieldTypeString )
• current_controller_begin_dt ( modelName: current_controller_begin_dt, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_CONTROLLER_BEGIN_DT, type: esriFieldTypeString )
• district ( modelName: district, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: DISTRICT, type: esriFieldTypeString )
• office_cd ( modelName: office_cd, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: OFFICE_CD, type: esriFieldTypeString )
• office_name ( modelName: office_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: OFFICE_NAME, type: esriFieldTypeString )
• assess_ctrl_no ( modelName: assess_ctrl_no, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ASSESS_CTRL_NO, type: esriFieldTypeString )
• primary_sic_cd ( modelName: primary_sic_cd, nullable: true, editable: true, defaultValue: null, alias: PRIMARY_SIC_CD, type: esriFieldTypeDouble )
• primary_sic ( modelName: primary_sic, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_SIC, type: esriFieldTypeString )
• primary_sic_cd_1 ( modelName: primary_sic_cd_1, nullable: true, editable: true, defaultValue: null, alias: PRIMARY_SIC_CD_1, type: esriFieldTypeDouble )
• primary_sic_cd_sfx ( modelName: primary_sic_cd_sfx, nullable: true, editable: true, defaultValue: null, alias: PRIMARY_SIC_CD_SFX, type: esriFieldTypeDouble )
• secondary_sic_cd ( modelName: secondary_sic_cd, nullable: true, editable: true, defaultValue: null, alias: SECONDARY_SIC_CD, type: esriFieldTypeDouble )
• secondary_sic ( modelName: secondary_sic, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SECONDARY_SIC, type: esriFieldTypeString )
• secondary_sic_cd_1 ( modelName: secondary_sic_cd_1, nullable: true, editable: true, defaultValue: null, alias: SECONDARY_SIC_CD_1, type: esriFieldTypeDouble )
• secondary_sic_cd_sfx ( modelName: secondary_sic_cd_sfx, nullable: true, editable: true, defaultValue: null, alias: SECONDARY_SIC_CD_SFX, type: esriFieldTypeDouble )
• primary_canvass_cd ( modelName: primary_canvass_cd, nullable: true, editable: true, defaultValue: null, alias: PRIMARY_CANVASS_CD, type: esriFieldTypeDouble )
• primary_canvass ( modelName: primary_canvass, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_CANVASS, type: esriFieldTypeString )
• secondary_canvass_cd ( modelName: secondary_canvass_cd, nullable: true, editable: true, defaultValue: null, alias: SECONDARY_CANVASS_CD, type: esriFieldTypeDouble )
• secondary_canvass ( modelName: secondary_canvass, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SECONDARY_CANVASS, type: esriFieldTypeString )
• current_103i ( modelName: current_103i, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_103I, type: esriFieldTypeString )
• current_103i_dt ( modelName: current_103i_dt, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CURRENT_103I_DT, type: esriFieldTypeString )
• portable_operation ( modelName: portable_operation, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PORTABLE_OPERATION, type: esriFieldTypeString )
• portable_fips_st_cd ( modelName: portable_fips_st_cd, nullable: true, editable: true, defaultValue: null, alias: PORTABLE_FIPS_ST_CD, type: esriFieldTypeDouble )
• days_per_week ( modelName: days_per_week, nullable: true, editable: true, defaultValue: null, alias: DAYS_PER_WEEK, type: esriFieldTypeInteger )
• hours_per_shift ( modelName: hours_per_shift, nullable: true, editable: true, defaultValue: null, alias: HOURS_PER_SHIFT, type: esriFieldTypeDouble )
• prod_shifts_per_day ( modelName: prod_shifts_per_day, nullable: true, editable: true, defaultValue: null, alias: PROD_SHIFTS_PER_DAY, type: esriFieldTypeDouble )
• maint_shifts_per_day ( modelName: maint_shifts_per_day, nullable: true, editable: true, defaultValue: null, alias: MAINT_SHIFTS_PER_DAY, type: esriFieldTypeDouble )
• no_employees ( modelName: no_employees, nullable: true, editable: true, defaultValue: null, alias: NO_EMPLOYEES, type: esriFieldTypeDouble )
• part48_training ( modelName: part48_training, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PART48_TRAINING, type: esriFieldTypeString )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: LATITUDE, type: esriFieldTypeDouble )
• avg_mine_height ( modelName: avg_mine_height, nullable: true, editable: true, defaultValue: null, alias: AVG_MINE_HEIGHT, type: esriFieldTypeDouble )
• mine_gas_category_cd ( modelName: mine_gas_category_cd, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: MINE_GAS_CATEGORY_CD, type: esriFieldTypeString )
• methane_liberation ( modelName: methane_liberation, nullable: true, editable: true, defaultValue: null, alias: METHANE_LIBERATION, type: esriFieldTypeDouble )
• no_producing_pits ( modelName: no_producing_pits, nullable: true, editable: true, defaultValue: null, alias: NO_PRODUCING_PITS, type: esriFieldTypeDouble )
• no_nonproducing_pits ( modelName: no_nonproducing_pits, nullable: true, editable: true, defaultValue: null, alias: NO_NONPRODUCING_PITS, type: esriFieldTypeDouble )
• no_tailing_ponds ( modelName: no_tailing_ponds, nullable: true, editable: true, defaultValue: null, alias: NO_TAILING_PONDS, type: esriFieldTypeDouble )
• pillar_recovery_used ( modelName: pillar_recovery_used, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PILLAR_RECOVERY_USED, type: esriFieldTypeString )
• highwall_miner_used ( modelName: highwall_miner_used, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: HIGHWALL_MINER_USED, type: esriFieldTypeString )
• multiple_pits ( modelName: multiple_pits, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: MULTIPLE_PITS, type: esriFieldTypeString )
• miners_rep_ind ( modelName: miners_rep_ind, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: MINERS_REP_IND, type: esriFieldTypeString )
• safety_committee_ind ( modelName: safety_committee_ind, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SAFETY_COMMITTEE_IND, type: esriFieldTypeString )
• miles_from_office ( modelName: miles_from_office, nullable: true, editable: true, defaultValue: null, alias: MILES_FROM_OFFICE, type: esriFieldTypeInteger )
• directions_to_mine ( modelName: directions_to_mine, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: DIRECTIONS_TO_MINE, type: esriFieldTypeString )
• nearest_town ( modelName: nearest_town, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NEAREST_TOWN, type: esriFieldTypeString )
• geo_validity ( modelName: geo_validity, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: GEO_VALIDITY, type: esriFieldTypeString )
• census_tract_name ( modelName: census_tract_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CENSUS_TRACT_NAME, type: esriFieldTypeString )
• census_tract_geoid ( modelName: census_tract_geoid, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CENSUS_TRACT_GEOID, type: esriFieldTypeString )

Templates:

• Name: Coal Mines
  Description:
  Prototype:
  company_type: null
  hours_per_shift: null
  secondary_sic_cd: null
  bom_state_cd: null
  primary_sic_cd: null
  mine_gas_category_cd: null
  current_mine_type: null
  maint_shifts_per_day: null
  current_103i: null
  assess_ctrl_no: null
  portable_operation: null
  current_operator_name: null
  primary_sic_cd_sfx: null
  state: null
  highwall_miner_used: null
  longitude: null
  census_tract_name: null
  miners_rep_ind: null
  fips_cnty_nm: null
  cong_dist_cd: null
  office_cd: null
  safety_committee_ind: null
  current_controller_name: null
  secondary_sic: null
  no_producing_pits: null
  census_tract_geoid: null
  current_controller_id: null
  current_operator_id: null
  secondary_sic_cd_1: null
  no_tailing_ponds: null
  district: null
  miles_from_office: null
  part48_training: null
  multiple_pits: null
  current_mine_name: null
  methane_liberation: null
  latitude: null
  fips_cnty_cd: null
  secondary_sic_cd_sfx: null
  avg_mine_height: null
  current_controller_begin_dt: null
  portable_fips_st_cd: null
  nearest_town: null
  current_103i_dt: null
  current_mine_status: null
  primary_canvass_cd: null
  prod_shifts_per_day: null
  geo_validity: null
  primary_sic_cd_1: null
  primary_sic: null
  primary_canvass: null
  pillar_recovery_used: null
  coal_metal_ind: null
  secondary_canvass_cd: null
  current_status_dt: null
  office_name: null
  days_per_week: null
  directions_to_mine: null
  mine_id: null
  secondary_canvass: null
  no_nonproducing_pits: null
  no_employees: 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