Name: MPCA Remediation Sites

Display Field: item_id

Type: Table

Geometry Type: N/A

Description: This dataset represents the locations, classifications, and physical characteristics of remediation activities carried out by the Minnesota Pollution Control Agency. The locations represent leak clean up, emergency response, petroleum brownfields, non-petroleum brownfields (Voluntary Investigation and Cleanup), Superfund, RCRA, integrated remediation and site assessment sites. The geodatabase, env_remediation_sites.gdb, contains two related datasets: (1) the remediation_sites point feature class, which has one record for each remediation site, and (2) the spatial_rem_activity table, which contains one record for each MPCA effort to investigate contamination at a site. The two datasets can be related using the ITEM_ID. In most cases, there will be one record in spatial_rem_activity for each record in remediation_sites. However, reopened leak sites may have multiple records in spatial_rem_activity for a single site, and CERCLIS/SEMS sites where the EPA was the lead agency may have zero records in spatial_rem_activity. The spatial_rem_activity table only exists in the file geodatabase format of this dataset.

Service Item Id: 53bfdc20c89a4aff863706b8cc0a8d0a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

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: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• item_id ( type: esriFieldTypeString, alias: item_id, editable: true, nullable: true, length: 75, defaultValue: null, modelName: item_id )
• ai_id ( type: esriFieldTypeDouble, alias: ai_id, editable: true, nullable: true, defaultValue: null, modelName: ai_id )
• site_id ( type: esriFieldTypeString, alias: site_id, editable: true, nullable: true, length: 100, defaultValue: null, modelName: site_id )
• si_cat ( type: esriFieldTypeString, alias: si_cat, editable: true, nullable: true, length: 4, defaultValue: null, modelName: si_cat )
• si_id ( type: esriFieldTypeDouble, alias: si_id, editable: true, nullable: true, defaultValue: null, modelName: si_id )
• activity_id ( type: esriFieldTypeString, alias: activity_id, editable: true, nullable: true, length: 27, defaultValue: null, modelName: activity_id )
• activity_type_desc ( type: esriFieldTypeString, alias: activity_type_desc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: activity_type_desc )
• activity_class_code ( type: esriFieldTypeString, alias: activity_class_code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: activity_class_code )
• activity_year ( type: esriFieldTypeSmallInteger, alias: activity_year, editable: true, nullable: true, defaultValue: null, modelName: activity_year )
• activity_num ( type: esriFieldTypeInteger, alias: activity_num, editable: true, nullable: true, defaultValue: null, modelName: activity_num )
• site_start ( type: esriFieldTypeDate, alias: site_start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: site_start )
• leak_discovered ( type: esriFieldTypeDate, alias: leak_discovered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_discovered )
• leak_reported ( type: esriFieldTypeDate, alias: leak_reported, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_reported )
• leak_reopened ( type: esriFieldTypeDate, alias: leak_reopened, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_reopened )
• received ( type: esriFieldTypeDate, alias: received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: received )
• discovered ( type: esriFieldTypeDate, alias: discovered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: discovered )
• staff_assigned ( type: esriFieldTypeDate, alias: staff_assigned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: staff_assigned )
• app_completed ( type: esriFieldTypeDate, alias: app_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: app_completed )
• site_closed ( type: esriFieldTypeDate, alias: site_closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: site_closed )
• npl_list ( type: esriFieldTypeDate, alias: npl_list, editable: true, nullable: true, length: 8, defaultValue: null, modelName: npl_list )
• npl_delete ( type: esriFieldTypeDate, alias: npl_delete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: npl_delete )
• plp_list ( type: esriFieldTypeDate, alias: plp_list, editable: true, nullable: true, length: 8, defaultValue: null, modelName: plp_list )
• plp_delist ( type: esriFieldTypeDate, alias: plp_delist, editable: true, nullable: true, length: 8, defaultValue: null, modelName: plp_delist )
• ff_aproved ( type: esriFieldTypeDate, alias: ff_aproved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ff_aproved )
• ff_closed ( type: esriFieldTypeDate, alias: ff_closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ff_closed )
• inv_completed ( type: esriFieldTypeDate, alias: inv_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inv_completed )
• er_site_eval ( type: esriFieldTypeDate, alias: er_site_eval, editable: true, nullable: true, length: 8, defaultValue: null, modelName: er_site_eval )
• remedy_implemented ( type: esriFieldTypeDate, alias: remedy_implemented, editable: true, nullable: true, length: 8, defaultValue: null, modelName: remedy_implemented )
• remedy_selected ( type: esriFieldTypeDate, alias: remedy_selected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: remedy_selected )
• asmt_completed ( type: esriFieldTypeDate, alias: asmt_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: asmt_completed )
• nfa_decision ( type: esriFieldTypeDate, alias: nfa_decision, editable: true, nullable: true, length: 8, defaultValue: null, modelName: nfa_decision )

Templates:

• Name: MPCA Remediation Sites
  Description:
  Prototype:
  asmt_completed: null
  nfa_decision: null
  item_id: null
  ai_id: null
  site_id: null
  si_cat: null
  si_id: null
  activity_id: null
  activity_type_desc: null
  activity_class_code: null
  activity_year: null
  activity_num: null
  site_start: null
  leak_discovered: null
  leak_reported: null
  leak_reopened: null
  received: null
  discovered: null
  staff_assigned: null
  app_completed: null
  site_closed: null
  npl_list: null
  npl_delete: null
  plp_list: null
  plp_delist: null
  ff_aproved: null
  ff_closed: null
  inv_completed: null
  er_site_eval: null
  remedy_implemented: null
  remedy_selected: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata