{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 106,
 "name": "Targeted Q",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "basicMeasuresArt113c",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "basicMeasuresArt113c",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113c",
   "length": 111,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresChanges_Enum",
    "description": "Basic measures changes",
    "codedValues": [
     {
      "name": "Measures of this type implemented in previous cycle, no new measures nor significant changes planned.",
      "code": "Measures of this type implemented in previous cycle, no new measures nor significant changes planned."
     },
     {
      "name": "Measures of this type implemented in previous cycle but new measures and/or significant changes planned.",
      "code": "Measures of this type implemented in previous cycle but new measures and/or significant changes planned."
     },
     {
      "name": "No measures of this type implemented in previous cycle but new measures and/or significant changes planned.",
      "code": "No measures of this type implemented in previous cycle but new measures and/or significant changes planned."
     },
     {
      "name": "No measures of this type implemented in previous cycle and no measures planned.",
      "code": "No measures of this type implemented in previous cycle and no measures planned."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113d",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 d",
   "length": 109,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113d_Enum",
    "description": "Basic measures art 113d",
    "codedValues": [
     {
      "name": "There are safeguard zones and there are no plans to change the regulations as a result of this RBMP.",
      "code": "There are safeguard zones and there are no plans to change the regulations as a result of this RBMP."
     },
     {
      "name": "There are safeguard zones but there will be significant changes to them implemented as a result of this RBMP.",
      "code": "There are safeguard zones but there will be significant changes to them implemented as a result of this RBMP."
     },
     {
      "name": "There are no safeguard zones but there are plans to implement them as a result of this RBMP.",
      "code": "There are no safeguard zones but there are plans to implement them as a result of this RBMP."
     },
     {
      "name": "There are no safeguard zones and no plans to establish them.",
      "code": "There are no safeguard zones and no plans to establish them."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113eRegister",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 e Register",
   "length": 33,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasure_Enum",
    "description": "Basic measures",
    "codedValues": [
     {
      "name": "Yes, for surface and groundwater.",
      "code": "Yes, for surface and groundwater."
     },
     {
      "name": "Yes, for surface water only.",
      "code": "Yes, for surface water only."
     },
     {
      "name": "Yes, for groundwater only.",
      "code": "Yes, for groundwater only."
     },
     {
      "name": "No",
      "code": "No."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113eThreshold",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 e Threshold",
   "length": 65,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113eThreshold_Enum",
    "description": "Basic measures art113 threshold",
    "codedValues": [
     {
      "name": "Yes, small abstractions are exempted from controls.",
      "code": "Yes, small abstractions are exempted from controls."
     },
     {
      "name": "Small abstractions do not require permits but are all registered.",
      "code": "Small abstractions do not require permits but are all registered."
     },
     {
      "name": "No, there are no thresholds.",
      "code": "No, there are no thresholds."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113Permit",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 e Permit",
   "length": 33,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasure_Enum",
    "description": "Basic measures",
    "codedValues": [
     {
      "name": "Yes, for surface and groundwater.",
      "code": "Yes, for surface and groundwater."
     },
     {
      "name": "Yes, for surface water only.",
      "code": "Yes, for surface water only."
     },
     {
      "name": "Yes, for groundwater only.",
      "code": "Yes, for groundwater only."
     },
     {
      "name": "No",
      "code": "No."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113eImpoundment",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 e Impoundment",
   "length": 130,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113eImpoundment_Enum",
    "description": "Basic measures art113e impoundment",
    "codedValues": [
     {
      "name": "Yes, there is a concession, authorisation and/or permitting regime to control water impoundment and a register of impoundments.",
      "code": "Yes, there is a concession, authorisation and/or permitting regime to control water impoundment and a register of impoundments."
     },
     {
      "name": "There is a concession, authorisation and/or permitting regime to control water impoundment but no register of impoundments.",
      "code": "There is a concession, authorisation and/or permitting regime to control water impoundment but no register of impoundments."
     },
     {
      "name": "There is no concession, authorisation nor permitting regime to control water impoundment but there is a register of impoundments.",
      "code": "There is no concession, authorisation nor permitting regime to control water impoundment but there is a register of impoundments."
     },
     {
      "name": "No, there is no concession, authorisation nor permitting regime to control water impoundment and no register of impoundments.",
      "code": "No, there is no concession, authorisation nor permitting regime to control water impoundment and no register of impoundments."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113f",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 f",
   "length": 33,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresChanges_Enum",
    "description": "Basic measures changes",
    "codedValues": [
     {
      "name": "Measures of this type implemented in previous cycle, no new measures nor significant changes planned.",
      "code": "Measures of this type implemented in previous cycle, no new measures nor significant changes planned."
     },
     {
      "name": "Measures of this type implemented in previous cycle but new measures and/or significant changes planned.",
      "code": "Measures of this type implemented in previous cycle but new measures and/or significant changes planned."
     },
     {
      "name": "No measures of this type implemented in previous cycle but new measures and/or significant changes planned.",
      "code": "No measures of this type implemented in previous cycle but new measures and/or significant changes planned."
     },
     {
      "name": "No measures of this type implemented in previous cycle and no measures planned.",
      "code": "No measures of this type implemented in previous cycle and no measures planned."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113gPermit",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 g Permit",
   "length": 33,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasure_Enum",
    "description": "Basic measures",
    "codedValues": [
     {
      "name": "Yes, for surface and groundwater.",
      "code": "Yes, for surface and groundwater."
     },
     {
      "name": "Yes, for surface water only.",
      "code": "Yes, for surface water only."
     },
     {
      "name": "Yes, for groundwater only.",
      "code": "Yes, for groundwater only."
     },
     {
      "name": "No",
      "code": "No."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113gRegister",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 g Register",
   "length": 33,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasure_Enum",
    "description": "Basic measures",
    "codedValues": [
     {
      "name": "Yes, for surface and groundwater.",
      "code": "Yes, for surface and groundwater."
     },
     {
      "name": "Yes, for surface water only.",
      "code": "Yes, for surface water only."
     },
     {
      "name": "Yes, for groundwater only.",
      "code": "Yes, for groundwater only."
     },
     {
      "name": "No",
      "code": "No."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113gThreshold",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 g Threshold",
   "length": 63,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113gThreshold_Unum",
    "description": "Basic measures art113g threshold",
    "codedValues": [
     {
      "name": "Yes, small discharges are exempted from controls.",
      "code": "Yes, small discharges are exempted from controls."
     },
     {
      "name": "Small discharges do not require permits but are all registered.",
      "code": "Small discharges do not require permits but are all registered."
     },
     {
      "name": "No, there are no thresholds.",
      "code": "No, there are no thresholds."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113hRules",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 h Rules",
   "length": 71,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113hRules_Enum",
    "description": "Basic measures Art113h rules",
    "codedValues": [
     {
      "name": "Yes, same rules apply across the whole RBD.",
      "code": "Yes, same rules apply across the whole RBD."
     },
     {
      "name": "Yes, but rules apply only in Nitrate Vulnerable Zones.",
      "code": "Yes, but rules apply only in Nitrate Vulnerable Zones."
     },
     {
      "name": "Yes, but there are differentiated rules for different parts of the RBD.",
      "code": "Yes, but there are differentiated rules for different parts of the RBD."
     },
     {
      "name": "No general binding rules.",
      "code": "No general binding rules."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113iPermit",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 i Permit",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113iRiparian",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 i Riparian",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113iRegister",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 i Register",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113j",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 j",
   "length": 74,
   "domain": {
    "type": "codedValue",
    "name": "BasicMeasuresArt113j_Enum",
    "description": "Basic measures art113 j",
    "codedValues": [
     {
      "name": "Yes, there is a prohibition of all direct discharges.",
      "code": "Yes, there is a prohibition of all direct discharges."
     },
     {
      "name": "Some direct discharges are authorised in accordance with Article 11(3)(j).",
      "code": "Some direct discharges are authorised in accordance with Article 11(3)(j)."
     },
     {
      "name": "No, there is no prohibition of direct discharges.",
      "code": "No, there is no prohibition of direct discharges."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "basicMeasuresArt113k",
   "type": "esriFieldTypeString",
   "alias": "Basic Measures Art 113 k",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "waterReUseMeasure",
   "type": "esriFieldTypeString",
   "alias": "Water ReUse Measure",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ecologicalFlow",
   "type": "esriFieldTypeString",
   "alias": "Ecological Flow",
   "length": 127,
   "domain": {
    "type": "codedValue",
    "name": "EcologicalFlow_Enum",
    "description": "Ecological flow",
    "codedValues": [
     {
      "name": "Yes, ecological flows have been derived for all relevant water bodies.",
      "code": "Yes, ecological flows have been derived for all relevant water bodies."
     },
     {
      "name": "Partly, ecological flows have been derived for some relevant water bodies but the work is still on-going.",
      "code": "Partly, ecological flows have been derived for some relevant water bodies but the work is still on-going."
     },
     {
      "name": "No, ecological flows have not been derived for the relevant water bodies but there are plans to do it during the next cycle.",
      "code": "No, ecological flows have not been derived for the relevant water bodies but there are plans to do it during the next cycle."
     },
     {
      "name": "No, ecological flows have not been derived for the relevant water bodies and there are no plans to do it during the next cycle.",
      "code": "No, ecological flows have not been derived for the relevant water bodies and there are no plans to do it during the next cycle."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ecologicalFlowImplementation",
   "type": "esriFieldTypeString",
   "alias": "Ecological Flow Implementation",
   "length": 108,
   "domain": {
    "type": "codedValue",
    "name": "EcologicalFlowImplementation_Enum",
    "description": "Ecological flow implementation",
    "codedValues": [
     {
      "name": "Yes, ecological flows have been implemented in all relevant water bodies.",
      "code": "Yes, ecological flows have been implemented in all relevant water bodies."
     },
     {
      "name": "Partly, ecological flows have been implemented in some relevant water bodies but the work is still on-going.",
      "code": "Partly, ecological flows have been implemented in some relevant water bodies but the work is still on-going."
     },
     {
      "name": "No, ecological flows have not been implemented but there are plans to do it during the next cycle.",
      "code": "No, ecological flows have not been implemented but there are plans to do it during the next cycle."
     },
     {
      "name": "No, ecological flows have not been implemented and there are no plans to do it during the next cycle.",
      "code": "No, ecological flows have not been implemented and there are no plans to do it during the next cycle."
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "climateChange",
   "type": "esriFieldTypeString",
   "alias": "Climate Change",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "floodsDirective",
   "type": "esriFieldTypeString",
   "alias": "Floods Directive",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "winWinNWRMDroughtsFloods",
   "type": "esriFieldTypeString",
   "alias": "Win Win NWRM Droughts Floods",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "structuralMeasures",
   "type": "esriFieldTypeString",
   "alias": "Structural Measures",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "msfdCoOrdination",
   "type": "esriFieldTypeString",
   "alias": "Msfd CoOrdination",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "YesNoNotrelevant_Union_Enum",
    "description": "Yes, No, Not relevant",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Not relevant",
      "code": "Not relevant"
     },
     {
      "name": "Unclear",
      "code": "Unclear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "msfdAssessment",
   "type": "esriFieldTypeString",
   "alias": "msfdAssessment",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "YesNoNotrelevant_Union_Enum",
    "description": "Yes, No, Not relevant",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Not relevant",
      "code": "Not relevant"
     },
     {
      "name": "Unclear",
      "code": "Unclear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TargetedQID",
   "type": "esriFieldTypeDouble",
   "alias": "Targeted Q ID",
   "domain": null
  },
  {
   "name": "RBMPPoMID",
   "type": "esriFieldTypeDouble",
   "alias": "RBMP PoM ID",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R203_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G418TargetedQID",
   "fields": "TargetedQID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G418RBMPPoMID",
   "fields": "RBMPPoMID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 15,
   "name": "basicMeasuresArt113bReference",
   "relatedTableId": 12,
   "role": "esriRelRoleOrigin",
   "keyField": "TargetedQID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 70,
   "name": "otherAspectsReference",
   "relatedTableId": 67,
   "role": "esriRelRoleOrigin",
   "keyField": "TargetedQID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 16,
   "name": "basicMeasuresArt113hIssues",
   "relatedTableId": 13,
   "role": "esriRelRoleOrigin",
   "keyField": "TargetedQID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 68,
   "name": "msfdMeasuresNeeded",
   "relatedTableId": 65,
   "role": "esriRelRoleOrigin",
   "keyField": "TargetedQID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 19,
   "name": "climateChangeAspectsConsidered",
   "relatedTableId": 16,
   "role": "esriRelRoleOrigin",
   "keyField": "TargetedQID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 90,
   "name": "RBMPPoM",
   "relatedTableId": 84,
   "role": "esriRelRoleDestination",
   "keyField": "RBMPPoMID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": false,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": true,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "730675cccb964c548dbb4f181faa4a6c"
}