{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "MPCA Remediation Sites", "type": "Feature Layer", "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.\n\nThe 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.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 102, 27, 132, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 84540.02859999985, "ymin": 4816319.4164, "xmax": 754434.9933000002, "ymax": 5467304.9694, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ai_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "length": 75, "domain": null }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "length": 4, "domain": null }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null }, { "name": "project_id", "type": "esriFieldTypeString", "alias": "project_id", "length": 100, "domain": null }, { "name": "ai_name", "type": "esriFieldTypeString", "alias": "ai_name", "length": 100, "domain": null }, { "name": "project_type", "type": "esriFieldTypeString", "alias": "project_type", "length": 50, "domain": null }, { "name": "project_name", "type": "esriFieldTypeString", "alias": "project_name", "length": 500, "domain": null }, { "name": "si_type", "type": "esriFieldTypeString", "alias": "si_type", "length": 4, "domain": null }, { "name": "site_type", "type": "esriFieldTypeString", "alias": "site_type", "length": 3, "domain": null }, { "name": "acreage", "type": "esriFieldTypeDouble", "alias": "acreage", "domain": null }, { "name": "address1", "type": "esriFieldTypeString", "alias": "address1", "length": 100, "domain": null }, { "name": "address2", "type": "esriFieldTypeString", "alias": "address2", "length": 100, "domain": null }, { "name": "city", "type": "esriFieldTypeString", "alias": "city", "length": 100, "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "state", "length": 2, "domain": null }, { "name": "zip", "type": "esriFieldTypeString", "alias": "zip", "length": 15, "domain": null }, { "name": "loc_desc", "type": "esriFieldTypeString", "alias": "loc_desc", "length": 2000, "domain": null }, { "name": "county", "type": "esriFieldTypeString", "alias": "county", "length": 4000, "domain": null }, { "name": "cong_dist", "type": "esriFieldTypeString", "alias": "cong_dist", "length": 2, "domain": null }, { "name": "house_dist", "type": "esriFieldTypeString", "alias": "house_dist", "length": 4, "domain": null }, { "name": "senate_dist", "type": "esriFieldTypeString", "alias": "senate_dist", "length": 3, "domain": null }, { "name": "huc8", "type": "esriFieldTypeString", "alias": "huc8", "length": 8, "domain": null }, { "name": "huc8_name", "type": "esriFieldTypeString", "alias": "huc8_name", "length": 40, "domain": null }, { "name": "huc10", "type": "esriFieldTypeString", "alias": "huc10", "length": 12, "domain": null }, { "name": "huc12", "type": "esriFieldTypeString", "alias": "huc12", "length": 12, "domain": null }, { "name": "huc12_name", "type": "esriFieldTypeString", "alias": "huc12_name", "length": 40, "domain": null }, { "name": "dwsma_code", "type": "esriFieldTypeString", "alias": "dwsma_code", "length": 2, "domain": null }, { "name": "dwsma_name", "type": "esriFieldTypeString", "alias": "dwsma_name", "length": 40, "domain": null }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null }, { "name": "method_desc", "type": "esriFieldTypeString", "alias": "method_desc", "length": 50, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 50, "domain": null }, { "name": "project_managers", "type": "esriFieldTypeString", "alias": "project_managers", "length": 4000, "domain": null }, { "name": "hydrologists", "type": "esriFieldTypeString", "alias": "hydrologists", "length": 4000, "domain": null }, { "name": "npl", "type": "esriFieldTypeString", "alias": "npl", "length": 1, "domain": null }, { "name": "plp", "type": "esriFieldTypeString", "alias": "plp", "length": 1, "domain": null }, { "name": "bpet", "type": "esriFieldTypeString", "alias": "bpet", "length": 1, "domain": null }, { "name": "bvic", "type": "esriFieldTypeString", "alias": "bvic", "length": 1, "domain": null }, { "name": "sems", "type": "esriFieldTypeString", "alias": "sems", "length": 1, "domain": null }, { "name": "unp_dump", "type": "esriFieldTypeString", "alias": "unp_dump", "length": 1, "domain": null }, { "name": "federal_reg", "type": "esriFieldTypeString", "alias": "federal_reg", "length": 1, "domain": null }, { "name": "fed_state_reg", "type": "esriFieldTypeString", "alias": "fed_state_reg", "length": 1, "domain": null }, { "name": "state_reg", "type": "esriFieldTypeString", "alias": "state_reg", "length": 1, "domain": null }, { "name": "non_reg", "type": "esriFieldTypeString", "alias": "non_reg", "length": 1, "domain": null }, { "name": "mntba", "type": "esriFieldTypeString", "alias": "mntba", "length": 1, "domain": null }, { "name": "sf_voluntary", "type": "esriFieldTypeString", "alias": "sf_voluntary", "length": 1, "domain": null }, { "name": "ic", "type": "esriFieldTypeString", "alias": "ic", "length": 1, "domain": null }, { "name": "hrs_score", "type": "esriFieldTypeDouble", "alias": "hrs_score", "domain": null }, { "name": "score_year", "type": "esriFieldTypeString", "alias": "score_year", "length": 4, "domain": null }, { "name": "wimn_url", "type": "esriFieldTypeString", "alias": "wimn_url", "length": 92, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape" }, "indexes": [ { "name": "r9306_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a4945_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Data,Query", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "14bad7b6d24342d797ea06ddf9aaa1bb" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Remediation Activity", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "item_id", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "length": 75, "domain": null }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null }, { "name": "site_id", "type": "esriFieldTypeString", "alias": "site_id", "length": 100, "domain": null }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "length": 4, "domain": null }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null }, { "name": "activity_id", "type": "esriFieldTypeString", "alias": "activity_id", "length": 27, "domain": null }, { "name": "activity_type_desc", "type": "esriFieldTypeString", "alias": "activity_type_desc", "length": 100, "domain": null }, { "name": "activity_class_code", "type": "esriFieldTypeString", "alias": "activity_class_code", "length": 3, "domain": null }, { "name": "activity_year", "type": "esriFieldTypeSmallInteger", "alias": "activity_year", "domain": null }, { "name": "activity_num", "type": "esriFieldTypeInteger", "alias": "activity_num", "domain": null }, { "name": "site_start", "type": "esriFieldTypeDate", "alias": "site_start", "length": 8, "domain": null }, { "name": "leak_discovered", "type": "esriFieldTypeDate", "alias": "leak_discovered", "length": 8, "domain": null }, { "name": "leak_reported", "type": "esriFieldTypeDate", "alias": "leak_reported", "length": 8, "domain": null }, { "name": "leak_reopened", "type": "esriFieldTypeDate", "alias": "leak_reopened", "length": 8, "domain": null }, { "name": "received", "type": "esriFieldTypeDate", "alias": "received", "length": 8, "domain": null }, { "name": "discovered", "type": "esriFieldTypeDate", "alias": "discovered", "length": 8, "domain": null }, { "name": "staff_assigned", "type": "esriFieldTypeDate", "alias": "staff_assigned", "length": 8, "domain": null }, { "name": "app_completed", "type": "esriFieldTypeDate", "alias": "app_completed", "length": 8, "domain": null }, { "name": "site_closed", "type": "esriFieldTypeDate", "alias": "site_closed", "length": 8, "domain": null }, { "name": "npl_list", "type": "esriFieldTypeDate", "alias": "npl_list", "length": 8, "domain": null }, { "name": "npl_delete", "type": "esriFieldTypeDate", "alias": "npl_delete", "length": 8, "domain": null }, { "name": "plp_list", "type": "esriFieldTypeDate", "alias": "plp_list", "length": 8, "domain": null }, { "name": "plp_delist", "type": "esriFieldTypeDate", "alias": "plp_delist", "length": 8, "domain": null }, { "name": "ff_aproved", "type": "esriFieldTypeDate", "alias": "ff_aproved", "length": 8, "domain": null }, { "name": "ff_closed", "type": "esriFieldTypeDate", "alias": "ff_closed", "length": 8, "domain": null }, { "name": "inv_completed", "type": "esriFieldTypeDate", "alias": "inv_completed", "length": 8, "domain": null }, { "name": "er_site_eval", "type": "esriFieldTypeDate", "alias": "er_site_eval", "length": 8, "domain": null }, { "name": "remedy_implemented", "type": "esriFieldTypeDate", "alias": "remedy_implemented", "length": 8, "domain": null }, { "name": "remedy_selected", "type": "esriFieldTypeDate", "alias": "remedy_selected", "length": 8, "domain": null }, { "name": "asmt_completed", "type": "esriFieldTypeDate", "alias": "asmt_completed", "length": 8, "domain": null }, { "name": "nfa_decision", "type": "esriFieldTypeDate", "alias": "nfa_decision", "length": 8, "domain": null } ], "indexes": [ { "name": "r9304_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Data,Query", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "14bad7b6d24342d797ea06ddf9aaa1bb" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "MPCA Remediation Sites", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "item_id", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "length": 75, "domain": null }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null }, { "name": "site_id", "type": "esriFieldTypeString", "alias": "site_id", "length": 100, "domain": null }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "length": 4, "domain": null }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null }, { "name": "activity_id", "type": "esriFieldTypeString", "alias": "activity_id", "length": 27, "domain": null }, { "name": "activity_type_desc", "type": "esriFieldTypeString", "alias": "activity_type_desc", "length": 100, "domain": null }, { "name": "activity_class_code", "type": "esriFieldTypeString", "alias": "activity_class_code", "length": 3, "domain": null }, { "name": "activity_year", "type": "esriFieldTypeSmallInteger", "alias": "activity_year", "domain": null }, { "name": "activity_num", "type": "esriFieldTypeInteger", "alias": "activity_num", "domain": null }, { "name": "site_start", "type": "esriFieldTypeDate", "alias": "site_start", "length": 8, "domain": null }, { "name": "leak_discovered", "type": "esriFieldTypeDate", "alias": "leak_discovered", "length": 8, "domain": null }, { "name": "leak_reported", "type": "esriFieldTypeDate", "alias": "leak_reported", "length": 8, "domain": null }, { "name": "leak_reopened", "type": "esriFieldTypeDate", "alias": "leak_reopened", "length": 8, "domain": null }, { "name": "received", "type": "esriFieldTypeDate", "alias": "received", "length": 8, "domain": null }, { "name": "discovered", "type": "esriFieldTypeDate", "alias": "discovered", "length": 8, "domain": null }, { "name": "staff_assigned", "type": "esriFieldTypeDate", "alias": "staff_assigned", "length": 8, "domain": null }, { "name": "app_completed", "type": "esriFieldTypeDate", "alias": "app_completed", "length": 8, "domain": null }, { "name": "site_closed", "type": "esriFieldTypeDate", "alias": "site_closed", "length": 8, "domain": null }, { "name": "npl_list", "type": "esriFieldTypeDate", "alias": "npl_list", "length": 8, "domain": null }, { "name": "npl_delete", "type": "esriFieldTypeDate", "alias": "npl_delete", "length": 8, "domain": null }, { "name": "plp_list", "type": "esriFieldTypeDate", "alias": "plp_list", "length": 8, "domain": null }, { "name": "plp_delist", "type": "esriFieldTypeDate", "alias": "plp_delist", "length": 8, "domain": null }, { "name": "ff_aproved", "type": "esriFieldTypeDate", "alias": "ff_aproved", "length": 8, "domain": null }, { "name": "ff_closed", "type": "esriFieldTypeDate", "alias": "ff_closed", "length": 8, "domain": null }, { "name": "inv_completed", "type": "esriFieldTypeDate", "alias": "inv_completed", "length": 8, "domain": null }, { "name": "er_site_eval", "type": "esriFieldTypeDate", "alias": "er_site_eval", "length": 8, "domain": null }, { "name": "remedy_implemented", "type": "esriFieldTypeDate", "alias": "remedy_implemented", "length": 8, "domain": null }, { "name": "remedy_selected", "type": "esriFieldTypeDate", "alias": "remedy_selected", "length": 8, "domain": null }, { "name": "asmt_completed", "type": "esriFieldTypeDate", "alias": "asmt_completed", "length": 8, "domain": null }, { "name": "nfa_decision", "type": "esriFieldTypeDate", "alias": "nfa_decision", "length": 8, "domain": null } ], "indexes": [ { "name": "r9305_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Data,Query", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "14bad7b6d24342d797ea06ddf9aaa1bb" } ] }