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: 14bad7b6d24342d797ea06ddf9aaa1bb
Copyright Text: null
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Feature Draw Order:
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: false
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: true
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: null
Fields:
-
objectid
(
type: esriFieldTypeOID, alias: objectid
)
-
item_id
(
type: esriFieldTypeString, alias: item_id, length: 75
)
-
ai_id
(
type: esriFieldTypeDouble, alias: ai_id
)
-
site_id
(
type: esriFieldTypeString, alias: site_id, length: 100
)
-
si_cat
(
type: esriFieldTypeString, alias: si_cat, length: 4
)
-
si_id
(
type: esriFieldTypeDouble, alias: si_id
)
-
activity_id
(
type: esriFieldTypeString, alias: activity_id, length: 27
)
-
activity_type_desc
(
type: esriFieldTypeString, alias: activity_type_desc, length: 100
)
-
activity_class_code
(
type: esriFieldTypeString, alias: activity_class_code, length: 3
)
-
activity_year
(
type: esriFieldTypeSmallInteger, alias: activity_year
)
-
activity_num
(
type: esriFieldTypeInteger, alias: activity_num
)
-
site_start
(
type: esriFieldTypeDate, alias: site_start, length: 8
)
-
leak_discovered
(
type: esriFieldTypeDate, alias: leak_discovered, length: 8
)
-
leak_reported
(
type: esriFieldTypeDate, alias: leak_reported, length: 8
)
-
leak_reopened
(
type: esriFieldTypeDate, alias: leak_reopened, length: 8
)
-
received
(
type: esriFieldTypeDate, alias: received, length: 8
)
-
discovered
(
type: esriFieldTypeDate, alias: discovered, length: 8
)
-
staff_assigned
(
type: esriFieldTypeDate, alias: staff_assigned, length: 8
)
-
app_completed
(
type: esriFieldTypeDate, alias: app_completed, length: 8
)
-
site_closed
(
type: esriFieldTypeDate, alias: site_closed, length: 8
)
-
npl_list
(
type: esriFieldTypeDate, alias: npl_list, length: 8
)
-
npl_delete
(
type: esriFieldTypeDate, alias: npl_delete, length: 8
)
-
plp_list
(
type: esriFieldTypeDate, alias: plp_list, length: 8
)
-
plp_delist
(
type: esriFieldTypeDate, alias: plp_delist, length: 8
)
-
ff_aproved
(
type: esriFieldTypeDate, alias: ff_aproved, length: 8
)
-
ff_closed
(
type: esriFieldTypeDate, alias: ff_closed, length: 8
)
-
inv_completed
(
type: esriFieldTypeDate, alias: inv_completed, length: 8
)
-
er_site_eval
(
type: esriFieldTypeDate, alias: er_site_eval, length: 8
)
-
remedy_implemented
(
type: esriFieldTypeDate, alias: remedy_implemented, length: 8
)
-
remedy_selected
(
type: esriFieldTypeDate, alias: remedy_selected, length: 8
)
-
asmt_completed
(
type: esriFieldTypeDate, alias: asmt_completed, length: 8
)
-
nfa_decision
(
type: esriFieldTypeDate, alias: nfa_decision, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata