{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 55, "name": "Key Type Measure Indicator", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 60, "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": "keyTypeMeasure", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "keyTypeMeasure", "type": "esriFieldTypeString", "alias": "Key Type Measure", "domain": { "type": "codedValue", "name": "KTM_Enum", "description": "KTM", "codedValues": [ { "name": "KTM1 \u2013 Construction or upgrades of wastewater treatment plants", "code": "KTM1" }, { "name": "KTM10 \u2013 Water pricing policy measures for the implementation of the recovery of cost of water services from industry", "code": "KTM10" }, { "name": "KTM11 \u2013 Water pricing policy measures for the implementation of the recovery of cost of water services from agriculture", "code": "KTM11" }, { "name": "KTM12 \u2013 Advisory services for agriculture", "code": "KTM12" }, { "name": "KTM13 \u2013 Drinking water protection measures (e.g. establishment of safeguard zones, buffer zones etc)", "code": "KTM13" }, { "name": "KTM14 \u2013 Research, improvement of knowledge base reducing uncertainty", "code": "KTM14" }, { "name": "KTM15 \u2013 Measures for the phasing-out of emissions, discharges and losses of Priority Hazardous Substances or for the reduction of emissions, discharges and losses of Priority Substances", "code": "KTM15" }, { "name": "KTM16 \u2013 Upgrades or improvements of industrial wastewater treatment plants (including farms).", "code": "KTM16" }, { "name": "KTM17 \u2013 Measures to reduce sediment from soil erosion and surface run-off", "code": "KTM17" }, { "name": "KTM18 \u2013 Measures to prevent or control the adverse impacts of invasive alien species and introduced diseases", "code": "KTM18" }, { "name": "KTM19 \u2013 Measures to prevent or control the adverse impacts of recreation including angling", "code": "KTM19" }, { "name": "KTM2 \u2013 Reduce nutrient pollution from agriculture", "code": "KTM2" }, { "name": "KTM3 \u2013 Reduce pesticides pollution from agriculture.", "code": "KTM3" }, { "name": "KTM4 \u2013 Remediation of contaminated sites (historical pollution including sediments, groundwater, soil)", "code": "KTM4" }, { "name": "KTM5 \u2013 Improving longitudinal continuity (e.g. establishing fish passes, demolishing old dams)", "code": "KTM5" }, { "name": "KTM6 \u2013 Improving hydromorphological conditions of water bodies other than longitudinal continuity", "code": "KTM6" }, { "name": "KTM7 \u2013 Improvements in flow regime and/or establishment of ecological flows", "code": "KTM7" }, { "name": "KTM8 \u2013 Water efficiency, technical measures for irrigation, industry, energy and households", "code": "KTM8" }, { "name": "KTM9 \u2013 Water pricing policy measures for the implementation of the recovery of cost of water services from households", "code": "KTM9" }, { "name": "KTM20 \u2013 Measures to prevent or control the adverse impacts of fishing and other exploitation/removal of animal and plants", "code": "KTM20" }, { "name": "KTM21 \u2013 Measures to prevent or control the input of pollution from urban areas, transport and built infrastructure", "code": "KTM21" }, { "name": "KTM22 \u2013 Measures to prevent or control the input of pollution from forestry", "code": "KTM22" }, { "name": "KTM23 \u2013 Natural water retention measures", "code": "KTM23" }, { "name": "KTM24 \u2013 Adaptation to climate change", "code": "KTM24" }, { "name": "KTM25 \u2013 Measures to counteract acidification", "code": "KTM25" }, { "name": "KTM99 \u2013 Other key type measure reported under PoM", "code": "KTM99" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "keyTypeMeasure" }, { "name": "keyTypeMeasureOther", "type": "esriFieldTypeString", "alias": "Key Type Measure Other", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "keyTypeMeasureOther" }, { "name": "keyTypeMeasureIndicator", "type": "esriFieldTypeString", "alias": "Key Type Measure Indicator", "domain": { "type": "codedValue", "name": "IndicatorKTM_Enum", "description": "Indicator KTM", "codedValues": [ { "name": "KA01 \u2013 Area (km2) of agricultural land required to be covered by advisory services to achieve objectives", "code": "KA01" }, { "name": "KA02 \u2013 Area (km2) of agricultural land required to be covered by measures to achieve objectives", "code": "KA02" }, { "name": "KA03 \u2013 Area (km2) of agricultural land required to be covered by measures to reduce pesticide pollution in agriculture to achieve objectives", "code": "KA03" }, { "name": "KA04 \u2013 Area (km2) of agricultural land where water pricing policy measures are required to achieve the objectives of Article 9", "code": "KA04" }, { "name": "KA05 \u2013 Area (km2) of bank/shore that require rehabilitation and/or restoration measures to achieve objectives", "code": "KA05" }, { "name": "KA06 \u2013 Area (km2) of bank/shore that require removal of hard infrastructure to achieve objectives", "code": "KA06" }, { "name": "KA07 \u2013 Area (km2) of buffer zones required to achieve objectives", "code": "KA07" }, { "name": "KA08 \u2013 Area (km2) of buffer zones required to counteract acidification to achieve objectives", "code": "KA08" }, { "name": "KA09 \u2013 Area (km2) of forest land required to be covered by measures to achieve objectives", "code": "KA09" }, { "name": "KA10 \u2013 Area (km2) of forest land requiring measures to reduce nutrient inputs to levels compatible with the achievement of objectives", "code": "KA10" }, { "name": "KA11 \u2013 Area (km2) of irrigated land required to be covered by measures to achieve objectives", "code": "KA11" }, { "name": "KA12 \u2013 Area (km2) of land for which water pricing policy measures are required to achieve the objectives of Article 9", "code": "KA12" }, { "name": "KA13 \u2013 Area (km2) of land required to be covered by drinking water protection zones to achieve objectives", "code": "KA13" }, { "name": "KA14 \u2013 Area (km2) of land required to be covered by measures to achieve objectives", "code": "KA14" }, { "name": "KA15 \u2013 Area (km2) of land requiring regulation and/or codes of practice for use and disposal of chemicals in urbanised areas, transport and infrastructure to achieve objectives", "code": "KA15" }, { "name": "KA16 \u2013 Area (km2) of water bodies required to be covered by measures to achieve objectives", "code": "KA16" }, { "name": "KA17 \u2013 Area (km2) of water bodies required to be restored or reconnected to floodplains to achieve objectives", "code": "KA17" }, { "name": "KA18 \u2013 Area (km2) of water bodies requiring buffer zones to intercept or reduce sediment loads to water bodies to achieve objectives", "code": "KA18" }, { "name": "KL01 \u2013 Length (km) of bank/shore that require rehabilitation and/or restoration measures to achieve objectives", "code": "KL01" }, { "name": "KL02 \u2013 Length (km) of bank/shore that require removal of hard infrastructure to achieve objectives", "code": "KL02" }, { "name": "KL03 \u2013 Length (km) of remeandering of straightened river channels required to achieve objectives", "code": "KL03" }, { "name": "KL04 \u2013 Length (km) of river network requiring measures to achieve objectives", "code": "KL04" }, { "name": "KL05 \u2013 Length (km) of river requiring bed restoration measures to achieve objectives", "code": "KL05" }, { "name": "KL06 \u2013 Length (km) of river requiring buffer zones to achieve objectives", "code": "KL06" }, { "name": "KL07 \u2013 Length (km) of river requiring buffer zones to counteract acidification to achieve objectives", "code": "KL07" }, { "name": "KL08 \u2013 Length (km) of river requiring buffer zones to intercept or reduce sediment loads to rivers to achieve objectives", "code": "KL08" }, { "name": "KL09 \u2013 Length (km) of transport infrastructure required to be subject to regulation and/or codes of practice for use and disposal of chemicals to achieve objectives", "code": "KL09" }, { "name": "KL10 \u2013 Length (km) of water bodies required to be restored or reconnected to floodplains to achieve objectives", "code": "KL10" }, { "name": "KL11 \u2013 Length (km) of water bodies requiring litter removal to achieve objectives", "code": "KL11" }, { "name": "KN01 \u2013 Number of advisory services required to achieve objectives", "code": "KN01" }, { "name": "KN02 \u2013 Number of aquaculture sites/facilities for which measures are required to achieve objectives", "code": "KN02" }, { "name": "KN03 \u2013 Number of barriers required to be tackled to achieve objectives", "code": "KN03" }, { "name": "KN04 \u2013 Number of Combined Sewer Overflows required to be upgraded to achieve objectives", "code": "KN04" }, { "name": "KN05 \u2013 Number of contaminated sites to be remediated or where preventative actions need to be taken to achieve objectives", "code": "KN05" }, { "name": "KN06 \u2013 Number of discharges required to be connected to sewerage network to achieve objectives", "code": "KN06" }, { "name": "KN07 \u2013 Number of drinking water protection zones required to achieve objectives", "code": "KN07" }, { "name": "KN08 \u2013 Number of Farm Surveys required to achieve objectives", "code": "KN08" }, { "name": "KN09 \u2013 Number of farms that need to be covered by advisory services to achieve objectives", "code": "KN09" }, { "name": "KN10 \u2013 Number of fish/continuity passes required to be installed to achieve objectives", "code": "KN10" }, { "name": "KN11 \u2013 Number of households required to be covered by measures to achieve objectives", "code": "KN11" }, { "name": "KN12 \u2013 Number of Individual Species Action Plans required for species identified as presenting particular risk levels for the achievement of objectives", "code": "KN12" }, { "name": "KN13 \u2013 Number of installations associated with priority substances requiring measures to achieve objectives", "code": "KN13" }, { "name": "KN14 \u2013 Number of installations for which water pricing policy measures are required to achieve the objectives of Article 9", "code": "KN14" }, { "name": "KN15 \u2013 Number of installations where upgrades or improvements are required to achieve objectives", "code": "KN15" }, { "name": "KN16 \u2013 Number of mine discharges requiring measures to achieve objectives", "code": "KN16" }, { "name": "KN17 \u2013 Number of new permits required or permits that need to be updated to achieve objectives", "code": "KN17" }, { "name": "KN18 \u2013 Number of research studies etc that are required to achieve objectives", "code": "KN18" }, { "name": "KN19 \u2013 Number of sites requiring measures to achieve objectives", "code": "KN19" }, { "name": "KN20 \u2013 Number of sources of litter that require control measures to achieve objectives", "code": "KN20" }, { "name": "KN21 \u2013 Number of species for which codes of practice for reducing the spread of invasive alien species are required to be developed and implemented for the achievement of objectives", "code": "KN21" }, { "name": "KN22 \u2013 Number of storm overflows required to be upgraded to achieve objectives", "code": "KN22" }, { "name": "KN23 \u2013 Number of storm overflows where sediment flow to surface water is required to be intercepted or reduced to achieve objectives", "code": "KN23" }, { "name": "KN24 \u2013 Number of substances requiring restrictions or bans on uses to achieve objectives", "code": "KN24" }, { "name": "KN25 \u2013 Number of surface water interceptors and treatment facilities required to achieve objectives", "code": "KN25" }, { "name": "KN26 \u2013 Number of sustainable drainage systems required to achieve objectives", "code": "KN26" }, { "name": "KN27 \u2013 Number of waste disposal sites required to be upgraded or remediated to achieve objectives", "code": "KN27" }, { "name": "KN28 \u2013 Number of wastewater treatment works requiring to be constructed or upgraded to achieve objectives", "code": "KN28" }, { "name": "KN29 \u2013 Number of water bodies required to be affected by drinking water protection measures to achieve objectives", "code": "KN29" }, { "name": "KN30 \u2013 Number of water bodies required to be covered by measures to achieve objectives", "code": "KN30" }, { "name": "KN31 \u2013 Number of water bodies required to have eradication or control measures for the achievement of objectives", "code": "KN31" }, { "name": "KN32 \u2013 Number of water bodies that are expected to achieve objectives as a result of research etc", "code": "KN32" }, { "name": "KN33 \u2013 Number of water bodies that need to be limed to achieve objectives", "code": "KN33" }, { "name": "KN34 \u2013 Number of water bodies where ecological flows need to be established to achieve objectives", "code": "KN34" }, { "name": "KN35 \u2013 Number of water bodies where the operational modification of hydro-peaking is required to achieve objectives", "code": "KN35" }, { "name": "KP01 \u2013 Reduction (%) in water consumption required to achieve objectives", "code": "KP01" }, { "name": "KS01 \u2013 Population equivalent required to be treated by construction or upgrade of wastewater treatment plants to achieve objectives", "code": "KS01" }, { "name": "KS02 \u2013 Population size for which water pricing policy measures are required to achieve the objectives of Article 9", "code": "KS02" }, { "name": "KO99 \u2013 Other indicator", "code": "KO99" }, { "name": "NA \u2013 Data on KTM indicators not available in the format required", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "keyTypeMeasureIndicator" }, { "name": "keyTypeMeasureIndicatorOther", "type": "esriFieldTypeString", "alias": "Key Type Measure Indicator Other", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "keyTypeMeasureIndicatorOther" }, { "name": "keyTypeMeasureIndicatorValue202", "type": "esriFieldTypeDouble", "alias": "Key Type Measure Indicator Value 2021", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "keyTypeMeasureIndicatorValue2021" }, { "name": "KeyTypeMeasureIndicatorID", "type": "esriFieldTypeDouble", "alias": "Key Type Measure Indicator ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "KeyTypeMeasureIndicatorID" }, { "name": "SPSFID", "type": "esriFieldTypeDouble", "alias": "Significant Pressure Substance Failing ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignificantPressureSubstanceFailingID" } ], "indexes": [ { "name": "R198_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G413SPSFID", "fields": "SPSFID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Key Type Measure Indicator", "description": "", "prototype": { "attributes": { "KeyTypeMeasureIndicatorID": null, "keyTypeMeasure": null, "keyTypeMeasureOther": null, "keyTypeMeasureIndicator": null, "keyTypeMeasureIndicatorOther": null, "keyTypeMeasureIndicatorValue202": 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" }