{
 "layers": [
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 0,
   "name": "WSP_Bridges_Risk_Locations",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 2193,
    "latestWkid": 2193,
    "xyTolerance": 0.001,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -4020900,
    "falseY": 1900,
    "xyUnits": 10000,
    "falseZ": -100000,
    "zUnits": 10000,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriPMS",
      "url": "cc594eb96e63bcce7898c947b4030dae",
      "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAeCAYAAADOziUSAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADTklEQVRIib2WT2jTYBjGny5pa2tF2WjZImQgw4JjEt2rbCB42MSBXWU48CZToScPQzwKc+BgMA8TFbEedPjnMLAF68TiaRjw8oUFFS+Ggr2sUqoEt25tlulhS0z/bJ0gPrfkfd/f97xf3u8jPP6h+P8CY4yJAESuUOhx6brfZRi6EQ5rAGQi0ncEY4yJfCYzsmtm5pI7kwk26bqf1zSYra0w9+8vliQpv5BO3zVbWh5WQ/lqkEdV7+xOJvt9c3N+Z4zL5QBV9fvm5tpL8/NTPy9fjjDGLhBRtgZmgfZNTkZ5TdsACAK8kQg4QcBqKgVDUQAAXlkGr2knf9y8eQfA2RoYn8mM7E4m+y2Qu7sbex88gLu7GwAQGBvD+uIivg8OwlAUcLkc9jx+HF1Ip68dOX36lg1jjIm7ZmYuWa1xglABstTU1obmVArfBMF26Hv16gpjbJaIspYz0Z3JBK0ibyRSA3IC/bEYivH4RgdfvrQDEAFswLhCoadJ1+0N5zZX3krOuFvTwBUKPQBkHgBcuu7ncjk7YTWVQmBsbFugU65NIzwArB04oK0HAnbQUBSsLy6iqa2tptBQFPy8ccN+Xg8E4DIM3YYBkEu9vXmPqtr79n1wEM2pVAXQUBQsjY9XwEu9vXkjHE7aMCLKfpqezgMIOgu/CQL8sZi9R05Hdl44nAdQ4QzGwYPTZUmKe1S1Itn6avVUliSYwWDcOlY2zAyFZpdGRkabR0cPbVntkNnaiuLQ0GerxQoYEemMsYmVgYFnvjdvGsJKx4/nS8eOTdc9m5vA5x8ePYp5VPWkc1TquopG35uh0Kzzfc0VVO7qul4cGkrsuX8/WB2ztNrfny9L0tS2V9CmO1lNJJ743r69ah36isUkCSunTiWISK6O1b1p10Tx9tL58+f2TUy0V8dW+vo+lzs779WrqwsjouxCOn23ND8/5ZX/GChLEspHj8aJ6OOOYQBgtrQ8XB4evuiV5UMA8CsQqBmFHcOISF94/doeZKOjA0ZHR9w5CjuGAYAZCqWLZ8589ahq+0pf37auGsKIKKsmEi9KJ05cNQ4ffredq4YwAFgTxeTy8PBAubPzaaPchjAiktWXL8frzdVfwwBAikZnG2f943+N31pcXlONX2OhAAAAAElFTkSuQmCC",
      "contentType": "image/png",
      "width": 14,
      "height": 22,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 1756297.9340000004,
    "ymin": 5564751,
    "xmax": 2076537,
    "ymax": 5920971.023,
    "spatialReference": {
     "wkid": 2193,
     "latestWkid": 2193,
     "xyTolerance": 0.001,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -4020900,
     "falseY": 1900,
     "xyUnits": 10000,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "bridge_name",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "structure_id",
     "type": "esriFieldTypeInteger",
     "alias": "HSIMS Structure ID",
     "domain": null
    },
    {
     "name": "bridge_name",
     "type": "esriFieldTypeString",
     "alias": "Bridge Name",
     "length": 500,
     "domain": null
    },
    {
     "name": "point_x",
     "type": "esriFieldTypeDouble",
     "alias": "x_coordinate",
     "domain": null
    },
    {
     "name": "point_y",
     "type": "esriFieldTypeDouble",
     "alias": "y_coordinate",
     "domain": null
    },
    {
     "name": "additional_info",
     "type": "esriFieldTypeString",
     "alias": "additional_info",
     "length": 500,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "uniquerowid",
     "type": "esriFieldTypeGUID",
     "alias": "uniquerowid",
     "length": 38,
     "domain": null
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SH",
     "type": "esriFieldTypeString",
     "alias": "SH",
     "length": 255,
     "domain": null
    },
    {
     "name": "RS",
     "type": "esriFieldTypeInteger",
     "alias": "RS",
     "domain": null
    },
    {
     "name": "RP",
     "type": "esriFieldTypeDouble",
     "alias": "RP",
     "domain": null
    },
    {
     "name": "Location",
     "type": "esriFieldTypeString",
     "alias": "Location",
     "length": 255,
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "url_parameter",
     "type": "esriFieldTypeString",
     "alias": "URL Parameter",
     "length": 255,
     "domain": null
    },
    {
     "name": "hsims_structure_number",
     "type": "esriFieldTypeInteger",
     "alias": "HSIMS Structure Number",
     "domain": null
    },
    {
     "name": "region",
     "type": "esriFieldTypeString",
     "alias": "region",
     "length": 255,
     "domain": null
    },
    {
     "name": "sharepoint_link",
     "type": "esriFieldTypeString",
     "alias": "Sharepoint Link",
     "length": 1000,
     "domain": null
    },
    {
     "name": "hsims_link",
     "type": "esriFieldTypeString",
     "alias": "HSIMS Link",
     "length": 255,
     "domain": null
    },
    {
     "name": "obis_link",
     "type": "esriFieldTypeString",
     "alias": "OBIS Link",
     "length": 255,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "UUID_741",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_44981_unique",
     "fields": "uniquerowid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "bridge_id",
     "fields": "structure_id",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "gdb_ct3_741",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S539_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "WSPGIS.GISADMIN.WSP_Bridges_Identified_Risks",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "GlobalID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "hasZ": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsWithReturnUrl": true
   },
   "supportsDatumTransformation": true,
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1699935432000
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "805491ae5fa644e89d111a51f9ad7c7a"
  }
 ],
 "tables": [
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 1,
   "name": "wsp_bridges_identified_risks",
   "type": "Table",
   "description": null,
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "location_name",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "bridge_id",
     "type": "esriFieldTypeInteger",
     "alias": "Bridge ID",
     "domain": null
    },
    {
     "name": "location_name",
     "type": "esriFieldTypeString",
     "alias": "Asset Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "date_raised",
     "type": "esriFieldTypeDate",
     "alias": "Date Raised (dd/mm/yyy)",
     "length": 8,
     "domain": null
    },
    {
     "name": "risk_description",
     "type": "esriFieldTypeString",
     "alias": "Risk Description (include whether this is a threat or an opportunity)",
     "length": 1000,
     "domain": null
    },
    {
     "name": "risk_owning_organisation",
     "type": "esriFieldTypeString",
     "alias": "Risk Owning Organisation",
     "length": 255,
     "domain": null
    },
    {
     "name": "risk_owner",
     "type": "esriFieldTypeString",
     "alias": "Risk Management Owner",
     "length": 255,
     "domain": null
    },
    {
     "name": "current_controls",
     "type": "esriFieldTypeString",
     "alias": "Current Controls",
     "length": 255,
     "domain": null
    },
    {
     "name": "current_likelihood",
     "type": "esriFieldTypeString",
     "alias": "Current Likelihood",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Likelihood",
      "description": "Risk Likelihood",
      "codedValues": [
       {
        "name": "Almost Certain",
        "code": "5"
       },
       {
        "name": "Likely",
        "code": "4"
       },
       {
        "name": "Possible",
        "code": "3"
       },
       {
        "name": "Unlikely",
        "code": "2"
       },
       {
        "name": "Rare",
        "code": "1"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "current_consequence",
     "type": "esriFieldTypeString",
     "alias": "Current Consequence",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Consequence",
      "description": "Risk Consequence",
      "codedValues": [
       {
        "name": "Extreme",
        "code": "5"
       },
       {
        "name": "Severe",
        "code": "4"
       },
       {
        "name": "Moderate",
        "code": "3"
       },
       {
        "name": "Minor",
        "code": "2"
       },
       {
        "name": "Insignificant",
        "code": "1"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "risk_consequence_generic",
     "type": "esriFieldTypeString",
     "alias": "Consequence Category",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Consequence_Categories",
      "description": "Consequence Categories",
      "codedValues": [
       {
        "name": "Stakeholders",
        "code": "Stakeholders"
       },
       {
        "name": "Public/Media",
        "code": "Public/Media"
       },
       {
        "name": "Legal/Compliance",
        "code": "Legal/Compliance"
       },
       {
        "name": "Delivery",
        "code": "Delivery"
       },
       {
        "name": "Cost",
        "code": "Cost"
       },
       {
        "name": "Health & Safety",
        "code": "Health & Safety"
       },
       {
        "name": "Environmental",
        "code": "Environmental"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "current_risk_level",
     "type": "esriFieldTypeString",
     "alias": "Current Controlled Risk Level",
     "length": 255,
     "domain": null
    },
    {
     "name": "acceptable_risk",
     "type": "esriFieldTypeString",
     "alias": "Level of risk acceptable, when compared to Risk Tolerance Threshold",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "treatment_actions",
     "type": "esriFieldTypeString",
     "alias": "Planned Risk Treatment Actions",
     "length": 1000,
     "domain": null
    },
    {
     "name": "treatment_owner",
     "type": "esriFieldTypeString",
     "alias": "Risk Treatment Owner",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Treatment_Owners",
      "description": "",
      "codedValues": [
       {
        "name": "WSP",
        "code": "WSP"
       },
       {
        "name": "Waka Kotahi",
        "code": "Waka Kotahi"
       },
       {
        "name": "TREC",
        "code": "TREC"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "planned_treatment_date",
     "type": "esriFieldTypeString",
     "alias": "Planned Treatment Implementation Date(s) (dd/mm/yyyy)",
     "length": 255,
     "domain": null
    },
    {
     "name": "residual_likelihood",
     "type": "esriFieldTypeString",
     "alias": "Residual (Target) Risk Likelihood",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Likelihood",
      "description": "Risk Likelihood",
      "codedValues": [
       {
        "name": "Almost Certain",
        "code": "5"
       },
       {
        "name": "Likely",
        "code": "4"
       },
       {
        "name": "Possible",
        "code": "3"
       },
       {
        "name": "Unlikely",
        "code": "2"
       },
       {
        "name": "Rare",
        "code": "1"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "residual_consequence",
     "type": "esriFieldTypeString",
     "alias": "Residual (Target) Risk Consequence",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Consequence",
      "description": "Risk Consequence",
      "codedValues": [
       {
        "name": "Extreme",
        "code": "5"
       },
       {
        "name": "Severe",
        "code": "4"
       },
       {
        "name": "Moderate",
        "code": "3"
       },
       {
        "name": "Minor",
        "code": "2"
       },
       {
        "name": "Insignificant",
        "code": "1"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "residual_risk_level",
     "type": "esriFieldTypeString",
     "alias": "Residual (Target) Risk Level",
     "length": 255,
     "domain": null
    },
    {
     "name": "risk_status",
     "type": "esriFieldTypeString",
     "alias": "Risk Status",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Risk_Status",
      "description": "Risk Status",
      "codedValues": [
       {
        "name": "Draft",
        "code": "Draft"
       },
       {
        "name": "Live-Threat",
        "code": "Live-Threat"
       },
       {
        "name": "Live-Parked",
        "code": "Live-Parked"
       },
       {
        "name": "Impacted",
        "code": "Impacted"
       },
       {
        "name": "Closed",
        "code": "Closed"
       },
       {
        "name": "Rejected",
        "code": "Rejected"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "residual_risk_level_num",
     "type": "esriFieldTypeInteger",
     "alias": "residual_risk_level_num",
     "domain": null
    },
    {
     "name": "parentrowid",
     "type": "esriFieldTypeGUID",
     "alias": "parentrowid",
     "length": 38,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "risk_identifier",
     "type": "esriFieldTypeString",
     "alias": "Risk Identifier",
     "length": 30,
     "domain": null
    },
    {
     "name": "hsims_link",
     "type": "esriFieldTypeString",
     "alias": "HSIMS Link",
     "length": 255,
     "domain": null
    },
    {
     "name": "risk_type",
     "type": "esriFieldTypeString",
     "alias": "Risk Type - Generic",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Risk_Type",
      "description": "",
      "codedValues": [
       {
        "name": "Unintentional Hazard",
        "code": "Unintentional Hazard"
       },
       {
        "name": "Intentional Threat",
        "code": "Intentional Threat"
       },
       {
        "name": "Natural Hazard",
        "code": "Natural Hazard"
       },
       {
        "name": "Excessive Load",
        "code": "Excessive Load"
       },
       {
        "name": "Reduced Capacity",
        "code": "Reduced Capacity"
       },
       {
        "name": "Temporary Works",
        "code": "Temporary Works"
       },
       {
        "name": "Other",
        "code": "Other"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "risk_type_specific",
     "type": "esriFieldTypeString",
     "alias": "Risk Type - Specific",
     "length": 1000,
     "domain": {
      "type": "codedValue",
      "name": "RR_Risk_Type_Specific",
      "description": "",
      "codedValues": [
       {
        "name": "Vehicle Impact",
        "code": "Vehicle Impact"
       },
       {
        "name": "Vessel Impact",
        "code": "Vessel Impact"
       },
       {
        "name": "Train Impact",
        "code": "Train Impact"
       },
       {
        "name": "Fire",
        "code": "Fire"
       },
       {
        "name": "Attack on structure (Terror, Crime, War)",
        "code": "Attack on structure (Terror, Crime, War)"
       },
       {
        "name": "Arson",
        "code": "Arson"
       },
       {
        "name": "Excessive loading",
        "code": "Excessive loading"
       },
       {
        "name": "Flood / Scour",
        "code": "Flood / Scour"
       },
       {
        "name": "Sea level rise",
        "code": "Sea level rise"
       },
       {
        "name": "Wind",
        "code": "Wind"
       },
       {
        "name": "Snow / Ice",
        "code": "Snow / Ice"
       },
       {
        "name": "Earthquake",
        "code": "Earthquake"
       },
       {
        "name": "Tsunami",
        "code": "Tsunami"
       },
       {
        "name": "Lahar",
        "code": "Lahar"
       },
       {
        "name": "Mud / Landslide",
        "code": "Mud / Landslide"
       },
       {
        "name": "Tree falls",
        "code": "Tree falls"
       },
       {
        "name": "Excessive load (overburden)",
        "code": "Excessive load (overburden)"
       },
       {
        "name": "Excessive normal load",
        "code": "Excessive normal load"
       },
       {
        "name": "Excessive overload",
        "code": "Excessive overload"
       },
       {
        "name": "Temporary works",
        "code": "Temporary works"
       },
       {
        "name": "Material deterioration",
        "code": "Material deterioration"
       },
       {
        "name": "Design, assessment, permit system error",
        "code": "Design, assessment, permit system error"
       },
       {
        "name": "Other defects or damage",
        "code": "Other defects or damage"
       },
       {
        "name": "Falsework failure",
        "code": "Falsework failure"
       },
       {
        "name": "Other",
        "code": "Other"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "treatment_status",
     "type": "esriFieldTypeString",
     "alias": "Treatment Status",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_TreatmentStatus",
      "description": "Treatment status",
      "codedValues": [
       {
        "name": "Live",
        "code": "Live"
       },
       {
        "name": "Proposed",
        "code": "Proposed"
       },
       {
        "name": "Completed - successful",
        "code": "Completed - successful"
       },
       {
        "name": "Completed - unsuccessful",
        "code": "Completed - unsuccessful"
       },
       {
        "name": "Rejected",
        "code": "Rejected"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "date_added",
     "type": "esriFieldTypeDate",
     "alias": "date_added_to_RR",
     "length": 8,
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "risk_consequence_addinfo",
     "type": "esriFieldTypeString",
     "alias": "Risk Consequence(s) with additional info",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "risk_consequence_specific",
     "type": "esriFieldTypeString",
     "alias": "Risk Consequence(s) - Specific",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "treatment_progress",
     "type": "esriFieldTypeString",
     "alias": "Risk Treatment Progress Updates",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "current_likelihood_def",
     "type": "esriFieldTypeString",
     "alias": "current_likelihood_def",
     "length": 255,
     "domain": null
    },
    {
     "name": "current_consequence_def",
     "type": "esriFieldTypeString",
     "alias": "current_consequence_def",
     "length": 255,
     "domain": null
    },
    {
     "name": "residual_likelihood_def",
     "type": "esriFieldTypeString",
     "alias": "residual_likelihood_def",
     "length": 255,
     "domain": null
    },
    {
     "name": "residual_consequence_def",
     "type": "esriFieldTypeString",
     "alias": "residual_consequence_def",
     "length": 255,
     "domain": null
    },
    {
     "name": "rr_category",
     "type": "esriFieldTypeString",
     "alias": "Risk Register Category",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "UUID_742",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_44982_parent",
     "fields": "parentrowid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "risk_identifier",
     "fields": "risk_identifier",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "gdb_ct3_742",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "WSPGIS.GISADMIN.wsp_bridges_risk_treatment",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "GlobalID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    },
    {
     "id": 0,
     "name": "WSPGIS.GISADMIN.WSP_Bridges_Risk_Locations",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "parentrowid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1699935435000
   },
   "serviceItemId": "805491ae5fa644e89d111a51f9ad7c7a"
  },
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 2,
   "name": "wsp_bridges_risk_treatment",
   "type": "Table",
   "description": null,
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "treatment_actions",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "parentrowid",
     "type": "esriFieldTypeGUID",
     "alias": "parentrowid",
     "length": 38,
     "domain": null
    },
    {
     "name": "treatment_actions",
     "type": "esriFieldTypeString",
     "alias": "Treatment Actions",
     "length": 2000,
     "domain": null
    },
    {
     "name": "t_treatment_owner",
     "type": "esriFieldTypeString",
     "alias": "Risk Treatment Owner",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_Treatment_Owners",
      "description": "",
      "codedValues": [
       {
        "name": "WSP",
        "code": "WSP"
       },
       {
        "name": "Waka Kotahi",
        "code": "Waka Kotahi"
       },
       {
        "name": "TREC",
        "code": "TREC"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "planned_treatment_date",
     "type": "esriFieldTypeString",
     "alias": "Planned Treatment Date",
     "length": 255,
     "domain": null
    },
    {
     "name": "treatment_cost",
     "type": "esriFieldTypeInteger",
     "alias": "Treatment Cost ($)",
     "domain": null
    },
    {
     "name": "treatment_progress",
     "type": "esriFieldTypeString",
     "alias": "Treatment Progress",
     "length": 2000,
     "domain": null
    },
    {
     "name": "treatment_status",
     "type": "esriFieldTypeString",
     "alias": "Treatment Status",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "RR_TreatmentStatus",
      "description": "Treatment status",
      "codedValues": [
       {
        "name": "Live",
        "code": "Live"
       },
       {
        "name": "Proposed",
        "code": "Proposed"
       },
       {
        "name": "Completed - successful",
        "code": "Completed - successful"
       },
       {
        "name": "Completed - unsuccessful",
        "code": "Completed - unsuccessful"
       },
       {
        "name": "Rejected",
        "code": "Rejected"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "t_residual_likelihood",
     "type": "esriFieldTypeInteger",
     "alias": "Residual Likelihood",
     "domain": {
      "type": "codedValue",
      "name": "RR_Likelihood_Int",
      "description": "Residual Likelihood (integer)",
      "codedValues": [
       {
        "name": "Rare",
        "code": 1
       },
       {
        "name": "Unlikely",
        "code": 2
       },
       {
        "name": "Possible",
        "code": 3
       },
       {
        "name": "Likely",
        "code": 4
       },
       {
        "name": "Almost Certain",
        "code": 5
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "t_residual_consequence",
     "type": "esriFieldTypeInteger",
     "alias": "Residual Consequence",
     "domain": {
      "type": "codedValue",
      "name": "RR_Consequence_Int",
      "description": "Residual Consequence (integer)",
      "codedValues": [
       {
        "name": "Insignificant",
        "code": 1
       },
       {
        "name": "Minor",
        "code": 2
       },
       {
        "name": "Moderate",
        "code": 3
       },
       {
        "name": "Severe",
        "code": 4
       },
       {
        "name": "Extreme",
        "code": 5
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "t_residual_risk_level",
     "type": "esriFieldTypeString",
     "alias": "Residual Risk Level",
     "length": 255,
     "domain": null
    },
    {
     "name": "t_residual_risk_level_num",
     "type": "esriFieldTypeInteger",
     "alias": "Residual Risk Level (score)",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "treatment_number",
     "type": "esriFieldTypeInteger",
     "alias": "Treatment Number",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "UUID_1597",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "gdb_ct3_1597",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_586590_paren",
     "fields": "parentrowid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "WSPGIS.GISADMIN.WSP_Bridges_Identified_Risks",
     "relatedTableId": 1,
     "role": "esriRelRoleDestination",
     "keyField": "parentrowid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1741038801000
   },
   "serviceItemId": "805491ae5fa644e89d111a51f9ad7c7a"
  }
 ]
}