{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "MPCA Remediation Sites", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "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.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": 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 } }, "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 }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "", "displayField": "ai_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "item_id" }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ai_id" }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "si_cat" }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "si_id" }, { "name": "project_id", "type": "esriFieldTypeString", "alias": "project_id", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "project_id" }, { "name": "ai_name", "type": "esriFieldTypeString", "alias": "ai_name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ai_name" }, { "name": "project_type", "type": "esriFieldTypeString", "alias": "project_type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "project_type" }, { "name": "project_name", "type": "esriFieldTypeString", "alias": "project_name", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "project_name" }, { "name": "si_type", "type": "esriFieldTypeString", "alias": "si_type", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "si_type" }, { "name": "site_type", "type": "esriFieldTypeString", "alias": "site_type", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "site_type" }, { "name": "acreage", "type": "esriFieldTypeDouble", "alias": "acreage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "acreage" }, { "name": "address1", "type": "esriFieldTypeString", "alias": "address1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "address1" }, { "name": "address2", "type": "esriFieldTypeString", "alias": "address2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "address2" }, { "name": "city", "type": "esriFieldTypeString", "alias": "city", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "city" }, { "name": "state", "type": "esriFieldTypeString", "alias": "state", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "state" }, { "name": "zip", "type": "esriFieldTypeString", "alias": "zip", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "zip" }, { "name": "loc_desc", "type": "esriFieldTypeString", "alias": "loc_desc", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "loc_desc" }, { "name": "county", "type": "esriFieldTypeString", "alias": "county", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "county" }, { "name": "cong_dist", "type": "esriFieldTypeString", "alias": "cong_dist", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "cong_dist" }, { "name": "house_dist", "type": "esriFieldTypeString", "alias": "house_dist", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "house_dist" }, { "name": "senate_dist", "type": "esriFieldTypeString", "alias": "senate_dist", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "senate_dist" }, { "name": "huc8", "type": "esriFieldTypeString", "alias": "huc8", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "huc8" }, { "name": "huc8_name", "type": "esriFieldTypeString", "alias": "huc8_name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "huc8_name" }, { "name": "huc10", "type": "esriFieldTypeString", "alias": "huc10", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "huc10" }, { "name": "huc12", "type": "esriFieldTypeString", "alias": "huc12", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "huc12" }, { "name": "huc12_name", "type": "esriFieldTypeString", "alias": "huc12_name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "huc12_name" }, { "name": "dwsma_code", "type": "esriFieldTypeString", "alias": "dwsma_code", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "dwsma_code" }, { "name": "dwsma_name", "type": "esriFieldTypeString", "alias": "dwsma_name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "dwsma_name" }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "method_desc", "type": "esriFieldTypeString", "alias": "method_desc", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "method_desc" }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "status" }, { "name": "project_managers", "type": "esriFieldTypeString", "alias": "project_managers", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "project_managers" }, { "name": "hydrologists", "type": "esriFieldTypeString", "alias": "hydrologists", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "hydrologists" }, { "name": "npl", "type": "esriFieldTypeString", "alias": "npl", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "npl" }, { "name": "plp", "type": "esriFieldTypeString", "alias": "plp", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "plp" }, { "name": "bpet", "type": "esriFieldTypeString", "alias": "bpet", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "bpet" }, { "name": "bvic", "type": "esriFieldTypeString", "alias": "bvic", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "bvic" }, { "name": "sems", "type": "esriFieldTypeString", "alias": "sems", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "sems" }, { "name": "unp_dump", "type": "esriFieldTypeString", "alias": "unp_dump", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "unp_dump" }, { "name": "federal_reg", "type": "esriFieldTypeString", "alias": "federal_reg", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "federal_reg" }, { "name": "fed_state_reg", "type": "esriFieldTypeString", "alias": "fed_state_reg", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "fed_state_reg" }, { "name": "state_reg", "type": "esriFieldTypeString", "alias": "state_reg", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "state_reg" }, { "name": "non_reg", "type": "esriFieldTypeString", "alias": "non_reg", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "non_reg" }, { "name": "mntba", "type": "esriFieldTypeString", "alias": "mntba", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "mntba" }, { "name": "sf_voluntary", "type": "esriFieldTypeString", "alias": "sf_voluntary", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "sf_voluntary" }, { "name": "ic", "type": "esriFieldTypeString", "alias": "ic", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ic" }, { "name": "hrs_score", "type": "esriFieldTypeDouble", "alias": "hrs_score", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "hrs_score" }, { "name": "score_year", "type": "esriFieldTypeString", "alias": "score_year", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "score_year" }, { "name": "wimn_url", "type": "esriFieldTypeString", "alias": "wimn_url", "domain": null, "editable": true, "nullable": true, "length": 92, "defaultValue": null, "modelName": "wimn_url" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "shape" }, "indexes": [ { "name": "r9306_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "a4945_ix1", "isAscending": true, "isUnique": true, "description": "", "fields": "shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MPCA Remediation Sites", "description": "", "prototype": { "attributes": { "score_year": null, "wimn_url": null, "item_id": null, "ai_id": null, "si_cat": null, "si_id": null, "project_id": null, "ai_name": null, "project_type": null, "project_name": null, "si_type": null, "site_type": null, "acreage": null, "address1": null, "address2": null, "city": null, "state": null, "zip": null, "loc_desc": null, "county": null, "cong_dist": null, "house_dist": null, "senate_dist": null, "huc8": null, "huc8_name": null, "huc10": null, "huc12": null, "huc12_name": null, "dwsma_code": null, "dwsma_name": null, "latitude": null, "longitude": null, "method_desc": null, "status": null, "project_managers": null, "hydrologists": null, "npl": null, "plp": null, "bpet": null, "bvic": null, "sems": null, "unp_dump": null, "federal_reg": null, "fed_state_reg": null, "state_reg": null, "non_reg": null, "mntba": null, "sf_voluntary": null, "ic": null, "hrs_score": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "53bfdc20c89a4aff863706b8cc0a8d0a" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Remediation Activity", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "item_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "item_id" }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ai_id" }, { "name": "site_id", "type": "esriFieldTypeString", "alias": "site_id", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "site_id" }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "si_cat" }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "si_id" }, { "name": "activity_id", "type": "esriFieldTypeString", "alias": "activity_id", "domain": null, "editable": true, "nullable": true, "length": 27, "defaultValue": null, "modelName": "activity_id" }, { "name": "activity_type_desc", "type": "esriFieldTypeString", "alias": "activity_type_desc", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "activity_type_desc" }, { "name": "activity_class_code", "type": "esriFieldTypeString", "alias": "activity_class_code", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "activity_class_code" }, { "name": "activity_year", "type": "esriFieldTypeSmallInteger", "alias": "activity_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "activity_year" }, { "name": "activity_num", "type": "esriFieldTypeInteger", "alias": "activity_num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "activity_num" }, { "name": "site_start", "type": "esriFieldTypeDate", "alias": "site_start", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "site_start" }, { "name": "leak_discovered", "type": "esriFieldTypeDate", "alias": "leak_discovered", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_discovered" }, { "name": "leak_reported", "type": "esriFieldTypeDate", "alias": "leak_reported", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_reported" }, { "name": "leak_reopened", "type": "esriFieldTypeDate", "alias": "leak_reopened", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_reopened" }, { "name": "received", "type": "esriFieldTypeDate", "alias": "received", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "received" }, { "name": "discovered", "type": "esriFieldTypeDate", "alias": "discovered", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "discovered" }, { "name": "staff_assigned", "type": "esriFieldTypeDate", "alias": "staff_assigned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "staff_assigned" }, { "name": "app_completed", "type": "esriFieldTypeDate", "alias": "app_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "app_completed" }, { "name": "site_closed", "type": "esriFieldTypeDate", "alias": "site_closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "site_closed" }, { "name": "npl_list", "type": "esriFieldTypeDate", "alias": "npl_list", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "npl_list" }, { "name": "npl_delete", "type": "esriFieldTypeDate", "alias": "npl_delete", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "npl_delete" }, { "name": "plp_list", "type": "esriFieldTypeDate", "alias": "plp_list", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "plp_list" }, { "name": "plp_delist", "type": "esriFieldTypeDate", "alias": "plp_delist", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "plp_delist" }, { "name": "ff_aproved", "type": "esriFieldTypeDate", "alias": "ff_aproved", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ff_aproved" }, { "name": "ff_closed", "type": "esriFieldTypeDate", "alias": "ff_closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ff_closed" }, { "name": "inv_completed", "type": "esriFieldTypeDate", "alias": "inv_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inv_completed" }, { "name": "er_site_eval", "type": "esriFieldTypeDate", "alias": "er_site_eval", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "er_site_eval" }, { "name": "remedy_implemented", "type": "esriFieldTypeDate", "alias": "remedy_implemented", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "remedy_implemented" }, { "name": "remedy_selected", "type": "esriFieldTypeDate", "alias": "remedy_selected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "remedy_selected" }, { "name": "asmt_completed", "type": "esriFieldTypeDate", "alias": "asmt_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "asmt_completed" }, { "name": "nfa_decision", "type": "esriFieldTypeDate", "alias": "nfa_decision", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "nfa_decision" } ], "indexes": [ { "name": "r9304_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Remediation Activity", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "53bfdc20c89a4aff863706b8cc0a8d0a" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "MPCA Remediation Sites", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "item_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "item_id", "type": "esriFieldTypeString", "alias": "item_id", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "item_id" }, { "name": "ai_id", "type": "esriFieldTypeDouble", "alias": "ai_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ai_id" }, { "name": "site_id", "type": "esriFieldTypeString", "alias": "site_id", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "site_id" }, { "name": "si_cat", "type": "esriFieldTypeString", "alias": "si_cat", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "si_cat" }, { "name": "si_id", "type": "esriFieldTypeDouble", "alias": "si_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "si_id" }, { "name": "activity_id", "type": "esriFieldTypeString", "alias": "activity_id", "domain": null, "editable": true, "nullable": true, "length": 27, "defaultValue": null, "modelName": "activity_id" }, { "name": "activity_type_desc", "type": "esriFieldTypeString", "alias": "activity_type_desc", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "activity_type_desc" }, { "name": "activity_class_code", "type": "esriFieldTypeString", "alias": "activity_class_code", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "activity_class_code" }, { "name": "activity_year", "type": "esriFieldTypeSmallInteger", "alias": "activity_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "activity_year" }, { "name": "activity_num", "type": "esriFieldTypeInteger", "alias": "activity_num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "activity_num" }, { "name": "site_start", "type": "esriFieldTypeDate", "alias": "site_start", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "site_start" }, { "name": "leak_discovered", "type": "esriFieldTypeDate", "alias": "leak_discovered", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_discovered" }, { "name": "leak_reported", "type": "esriFieldTypeDate", "alias": "leak_reported", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_reported" }, { "name": "leak_reopened", "type": "esriFieldTypeDate", "alias": "leak_reopened", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "leak_reopened" }, { "name": "received", "type": "esriFieldTypeDate", "alias": "received", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "received" }, { "name": "discovered", "type": "esriFieldTypeDate", "alias": "discovered", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "discovered" }, { "name": "staff_assigned", "type": "esriFieldTypeDate", "alias": "staff_assigned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "staff_assigned" }, { "name": "app_completed", "type": "esriFieldTypeDate", "alias": "app_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "app_completed" }, { "name": "site_closed", "type": "esriFieldTypeDate", "alias": "site_closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "site_closed" }, { "name": "npl_list", "type": "esriFieldTypeDate", "alias": "npl_list", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "npl_list" }, { "name": "npl_delete", "type": "esriFieldTypeDate", "alias": "npl_delete", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "npl_delete" }, { "name": "plp_list", "type": "esriFieldTypeDate", "alias": "plp_list", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "plp_list" }, { "name": "plp_delist", "type": "esriFieldTypeDate", "alias": "plp_delist", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "plp_delist" }, { "name": "ff_aproved", "type": "esriFieldTypeDate", "alias": "ff_aproved", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ff_aproved" }, { "name": "ff_closed", "type": "esriFieldTypeDate", "alias": "ff_closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ff_closed" }, { "name": "inv_completed", "type": "esriFieldTypeDate", "alias": "inv_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inv_completed" }, { "name": "er_site_eval", "type": "esriFieldTypeDate", "alias": "er_site_eval", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "er_site_eval" }, { "name": "remedy_implemented", "type": "esriFieldTypeDate", "alias": "remedy_implemented", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "remedy_implemented" }, { "name": "remedy_selected", "type": "esriFieldTypeDate", "alias": "remedy_selected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "remedy_selected" }, { "name": "asmt_completed", "type": "esriFieldTypeDate", "alias": "asmt_completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "asmt_completed" }, { "name": "nfa_decision", "type": "esriFieldTypeDate", "alias": "nfa_decision", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "nfa_decision" } ], "indexes": [ { "name": "r9305_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MPCA Remediation Sites", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "53bfdc20c89a4aff863706b8cc0a8d0a" } ] }