{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 46, "name": "Indicator Gap", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 52, "name": "SignificantPressureSubstanceFailing", "relatedTableId": 88, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SPSFID", "composite": false } ], "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "indicatorGap", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "indicatorGap", "type": "esriFieldTypeString", "alias": "Indicator Gap", "domain": { "type": "codedValue", "name": "IndicatorPressure_Enum", "description": "Indicator Pressure", "codedValues": [ { "name": "NA \u2013 Data on gaps to good status not available in the format required", "code": "NA" }, { "name": "PA01 \u2013 Area (km2) of agricultural land at risk of soil erosion", "code": "PA01" }, { "name": "PA02 \u2013 Area (km2) of forest land at risk of soil erosion", "code": "PA02" }, { "name": "PA03 \u2013 Area (km2) of forest land affected by pressures preventing the achievement of objectives", "code": "PA03" }, { "name": "PA04 \u2013 Area (km2) of groundwater bodies not achieving objectives because of alteration of water levels/volumes", "code": "PA04" }, { "name": "PA05 \u2013 Area (km2) of groundwater bodies not achieving objectives because of groundwater recharges", "code": "PA05" }, { "name": "PA06 \u2013 Area (km2) of water bodies where diffuse urban run off is preventing the achievement of objectives", "code": "PA06" }, { "name": "PA07 \u2013 Area (km2) of water bodies where hydromorphological alterations for agricultural purposes are preventing the achievement of objectives", "code": "PA07" }, { "name": "PA08 \u2013 Area (km2) of water bodies where hydromorphological alterations for aquaculture purposes are preventing the achievement of objectives", "code": "PA08" }, { "name": "PA09 \u2013 Area (km2) of water bodies where hydromorphological alterations for hydropower production are preventing the achievement of objectives", "code": "PA09" }, { "name": "PA10 \u2013 Area (km2) of water bodies where hydromorphological alterations for other purposes are preventing the achievement of objectives", "code": "PA10" }, { "name": "PA11 \u2013 Area (km2) of water bodies where hydromorphological alterations for public water supply purposes are preventing the achievement of objectives", "code": "PA11" }, { "name": "PA12 \u2013 Area (km2) of water bodies where hydromorphological alterations for transport purposes are preventing the achievement of objectives", "code": "PA12" }, { "name": "PA13 \u2013 Area (km2) of water bodies where other anthropogenic pressures are preventing the achievement of objectives", "code": "PA13" }, { "name": "PA14 \u2013 Area (km2) of water bodies where physical loss of habitats is preventing the achievement of objectives", "code": "PA14" }, { "name": "PA15 \u2013 Area (km2) of water bodies where the exploitation/removal of animals/plants is preventing the achievement of objectives", "code": "PA15" }, { "name": "PA16 \u2013 Area (km2) of water bodies where unknown pressures are preventing the achievement of objectives", "code": "PA16" }, { "name": "PE01 \u2013 Load (tonne per year) of BOD to be reduced to achieve objectives", "code": "PE01" }, { "name": "PE02 \u2013 Load (tonne per year) of nitrogen to be reduced to achieve objectives", "code": "PE02" }, { "name": "PE03 \u2013 Load (tonne per year) of phosphorus to be reduced to achieve objectives", "code": "PE03" }, { "name": "PE04 \u2013 Load (tonne per year) of sediment to be reduced to achieve objectives", "code": "PE04" }, { "name": "PE05 \u2013 Load (tonne per year) of priority substances to be reduced to achieve objectives", "code": "PE05" }, { "name": "PL01 \u2013 Length (km) of water bodies where diffuse urban run off is preventing the achievement of objectives", "code": "PL01" }, { "name": "PL02 \u2013 Length (km) of water bodies where hydromorphological alterations for agricultural purposes are preventing the achievement of objectives", "code": "PL02" }, { "name": "PL03 \u2013 Length (km) of water bodies where hydromorphological alterations for aquaculture purposes are preventing the achievement of objectives", "code": "PL03" }, { "name": "PL04 \u2013 Length (km) of water bodies where hydromorphological alterations for flood protection are preventing the achievement of objectives", "code": "PL04" }, { "name": "PL05 \u2013 Length (km) of water bodies where hydromorphological alterations for hydropower production are preventing the achievement of objectives", "code": "PL05" }, { "name": "PL06 \u2013 Length (km) of water bodies where hydromorphological alterations for other purposes are preventing the achievement of objectives", "code": "PL06" }, { "name": "PL07 \u2013 Length (km) of water bodies where hydromorphological alterations for public water supply purposes are preventing the achievement of objectives", "code": "PL07" }, { "name": "PL08 \u2013 Length (km) of water bodies where hydromorphological alterations for transport purposes are preventing the achievement of objectives", "code": "PL08" }, { "name": "PL09 \u2013 Length (km) of water bodies where hydromorphological alterations for unknown purposes are preventing the achievement of objectives", "code": "PL09" }, { "name": "PL10 \u2013 Length (km) of water bodies where litter or fly tipping are preventing the achievement of objectives", "code": "PL10" }, { "name": "PL11 \u2013 Length (km) of water bodies where other anthropogenic pressures are preventing the achievement of objectives", "code": "PL11" }, { "name": "PL12 \u2013 Length (km) of water bodies where physical loss of habitats is preventing the achievement of objectives", "code": "PL12" }, { "name": "PL13 \u2013 Length (km) of water bodies where the exploitation/removal of animals/plants is preventing the achievement of objectives", "code": "PL13" }, { "name": "PL14 \u2013 Length (km) of water bodies where unknown pressures are preventing the achievement of objectives", "code": "PL14" }, { "name": "PN01 \u2013 Number of contaminated sites preventing the achievement of objectives", "code": "PN01" }, { "name": "PN02 \u2013 Number of dams/ weirs/ barriers and locks associated with drinking water that have conditions not compatible with the achievement of objectives", "code": "PN02" }, { "name": "PN03 \u2013 Number of dams/ weirs/ barriers and locks associated with flood protection that have conditions not compatible with the achievement of objectives", "code": "PN03" }, { "name": "PN04 \u2013 Number of dams/ weirs/ barriers and locks associated with hydropower that have conditions not compatible with the achievement of objectives", "code": "PN04" }, { "name": "PN05 \u2013 Number of dams/ weirs/ barriers and locks associated with industry that have conditions not compatible with the achievement of objectives", "code": "PN05" }, { "name": "PN06 \u2013 Number of dams/ weirs/ barriers and locks associated with irrigation that have conditions not compatible with the achievement of objectives", "code": "PN06" }, { "name": "PN07 \u2013 Number of dams/ weirs/ barriers and locks associated with navigation that have conditions not compatible with the achievement of objectives", "code": "PN07" }, { "name": "PN08 \u2013 Number of dams/ weirs/ barriers and locks associated with other uses that have conditions not compatible with the achievement of objectives", "code": "PN08" }, { "name": "PN09 \u2013 Number of dams/ weirs/ barriers and locks associated with recreation that have conditions not compatible with the achievement of objectives", "code": "PN09" }, { "name": "PN10 \u2013 Number of discharges not connected to sewerage network that are preventing the achievement of objectives", "code": "PN10" }, { "name": "PN11 \u2013 Number of farms not covered by advisory services", "code": "PN11" }, { "name": "PN12 \u2013 Number of introduced diseases preventing the achievement of objectives", "code": "PN12" }, { "name": "PN13 \u2013 Number of introduced species preventing the achievement of objectives", "code": "PN13" }, { "name": "PN14 \u2013 Number of mine water discharges preventing the achievement of objectives", "code": "PN14" }, { "name": "PN15 \u2013 Number of permits not compatible with the achievement of objectives", "code": "PN15" }, { "name": "PN16 \u2013 Number of point sources preventing the achievement of objectives", "code": "PN16" }, { "name": "PN17 \u2013 Number of urban areas with excessive overflows that are causing or contributing to failure of objectives", "code": "PN17" }, { "name": "PN18 \u2013 Number of waste disposal sites preventing the achievement of objectives", "code": "PN18" }, { "name": "PN19 \u2013 Number of water bodies affected by emissions/ discharges or losses of priority and priority hazardous substances", "code": "PN19" }, { "name": "PN20 \u2013 Number of water bodies failing EQS for pesticides originating from diffuse agricultural sources", "code": "PN20" }, { "name": "PN21 \u2013 Number of water bodies failing EQS ", "code": "PN21" }, { "name": "PO99 \u2013 Other indicator", "code": "PO99" }, { "name": "PV01 \u2013 Volume (million m3 per year) of storm water that is causing or contributing to failure of objectives", "code": "PV01" }, { "name": "PV02 \u2013 Volume (million m3 per year) of water abstracted/diverted for agriculture to be reduced to achieve objectives", "code": "PV02" }, { "name": "PV03 \u2013 Volume (million m3 per year) of water abstracted/diverted for aquaculture to be reduced to achieve objectives", "code": "PV03" }, { "name": "PV04 \u2013 Volume (million m3 per year) of water abstracted/diverted for cooling water to be reduced to achieve objectives", "code": "PV04" }, { "name": "PV05 \u2013 Volume (million m3 per year) of water abstracted/diverted for industry to be reduced to achieve objectives", "code": "PV05" }, { "name": "PV06 \u2013 Volume (million m3 per year) of water abstracted/diverted for other purposes (such as recreation) to be reduced to achieve objectives", "code": "PV06" }, { "name": "PV07 \u2013 Volume (million m3 per year) of water abstracted/diverted for public water supply to be reduced to achieve objectives", "code": "PV07" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "indicatorGap" }, { "name": "indicatorGapOther", "type": "esriFieldTypeString", "alias": "Indicator Gap Other", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "indicatorGapOther" }, { "name": "indicatorGapValue2021", "type": "esriFieldTypeDouble", "alias": "Indicator Gap Value 2021", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "indicatorGapValue2021" }, { "name": "IndicatorGapID", "type": "esriFieldTypeDouble", "alias": "Indicator Gap ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IndicatorGapID" }, { "name": "SPSFID", "type": "esriFieldTypeDouble", "alias": "Significant Pressure Substance Failing ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignificantPressureSubstanceFailingID" } ], "indexes": [ { "name": "R197_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G412SPSFID", "fields": "SPSFID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Indicator Gap", "description": "", "prototype": { "attributes": { "IndicatorGapID": null, "indicatorGap": null, "indicatorGapOther": null, "indicatorGapValue2021": null, "SPSFID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "55a58faaa8e84ee68d4992e277268bf2" }