{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 20,
 "name": "SCC_ASSET_CH_INSP",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "created_date",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "inspAssetNo",
   "type": "esriFieldTypeInteger",
   "alias": "Asset ID",
   "domain": null
  },
  {
   "name": "inspId",
   "type": "esriFieldTypeInteger",
   "alias": "Legacy Inspection ID",
   "domain": null
  },
  {
   "name": "externalID",
   "type": "esriFieldTypeString",
   "alias": "External ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "inspAssetType",
   "type": "esriFieldTypeString",
   "alias": "Asset type",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "assetType",
    "description": "Description",
    "codedValues": [
     {
      "name": "AcoDrain",
      "code": "AcoDrain"
     },
     {
      "name": "BeanieBlocks",
      "code": "BeanieBlocks"
     },
     {
      "name": "Catchpit",
      "code": "Catchpit"
     },
     {
      "name": "Connector",
      "code": "Connector"
     },
     {
      "name": "Cover",
      "code": "Cover"
     },
     {
      "name": "Culvert",
      "code": "Culvert"
     },
     {
      "name": "DishChannel",
      "code": "DishChannel"
     },
     {
      "name": "Ditch",
      "code": "Ditch"
     },
     {
      "name": "Filter",
      "code": "Filter"
     },
     {
      "name": "GhostNode",
      "code": "GhostNode"
     },
     {
      "name": "Grip",
      "code": "Grip"
     },
     {
      "name": "Gully",
      "code": "Gully"
     },
     {
      "name": "Headwall",
      "code": "Headwall"
     },
     {
      "name": "HydroBrake",
      "code": "HydroBrake"
     },
     {
      "name": "Inlet",
      "code": "Inlet"
     },
     {
      "name": "Interceptor",
      "code": "Interceptor"
     },
     {
      "name": "KerbDrain",
      "code": "KerbDrain"
     },
     {
      "name": "Manhole",
      "code": "Manhole"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Outfall",
      "code": "Outfall"
     },
     {
      "name": "Outlet",
      "code": "Outlet"
     },
     {
      "name": "Pipe",
      "code": "Pipe"
     },
     {
      "name": "PumpingStation",
      "code": "PumpingStation"
     },
     {
      "name": "RoddingEye",
      "code": "RoddingEye"
     },
     {
      "name": "Slot",
      "code": "Slot"
     },
     {
      "name": "Soakaway",
      "code": "Soakaway"
     },
     {
      "name": "TrashScreen",
      "code": "TrashScreen"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "crewArcReason",
   "type": "esriFieldTypeString",
   "alias": "Crew archive reason",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "archiveReasonInspection",
    "description": "archiveReason for inspections",
    "codedValues": [
     {
      "name": "Yes, Found",
      "code": "Local Authority"
     },
     {
      "name": "Not Found",
      "code": "Not Found"
     },
     {
      "name": "Duplicate",
      "code": "Duplicate"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspAccessible",
   "type": "esriFieldTypeString",
   "alias": "Access condition",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "accessInspection",
    "description": "access for inspections",
    "codedValues": [
     {
      "name": "Excavation Required",
      "code": "Excavation Required"
     },
     {
      "name": "Inaccessible",
      "code": "Inaccessible"
     },
     {
      "name": "OK",
      "code": "OK"
     },
     {
      "name": "Private Land",
      "code": "Private Land"
     },
     {
      "name": "TM Required",
      "code": "TM"
     },
     {
      "name": "ToDo OOH",
      "code": "ToDo OOH"
     },
     {
      "name": "Vehicle Over",
      "code": "Vehicle Over"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspTm",
   "type": "esriFieldTypeString",
   "alias": "What TM was used",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "tmInspection",
    "description": "tm for inspections",
    "codedValues": [
     {
      "name": "15 Min Delay Boards",
      "code": "15 Min Delay Boards"
     },
     {
      "name": "2-Way Lights",
      "code": "2-Way Lights"
     },
     {
      "name": "Lane Closure",
      "code": "Lane Closure"
     },
     {
      "name": "Multi-Phase Lights",
      "code": "Multi-Phase Lights"
     },
     {
      "name": "No Parking Cone",
      "code": "No Parking Cone"
     },
     {
      "name": "Out Of Hours",
      "code": "Out Of Hours"
     },
     {
      "name": "Parking Bay Suspension",
      "code": "Parking Bay Suspension"
     },
     {
      "name": "Priority Signs",
      "code": "Priority Signs"
     },
     {
      "name": "Road Closure",
      "code": "Road Closure"
     },
     {
      "name": "Standard Chapter 8",
      "code": "Standard Chapter 8"
     },
     {
      "name": "Stop & Go",
      "code": "Stop & Go"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspWorkType",
   "type": "esriFieldTypeString",
   "alias": "Inspection type",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "workType",
    "description": "Work type",
    "codedValues": [
     {
      "name": "Cyclical",
      "code": "Cyclical"
     },
     {
      "name": "Cyclical - Remote",
      "code": "CycRemote"
     },
     {
      "name": "Day Works",
      "code": "Day Works"
     },
     {
      "name": "Emergency",
      "code": "Emergency"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspshift",
   "type": "esriFieldTypeString",
   "alias": "Day or night shift",
   "length": 12,
   "domain": null
  },
  {
   "name": "inspOpArrive",
   "type": "esriFieldTypeString",
   "alias": "Operational on arrival",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "opArriveLeaveInspection",
    "description": "opArriveLeave for inspections",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Slow Runner",
      "code": "Slow Runner"
     },
     {
      "name": "Yes - Junction Flowing",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspGenCon",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition of structure",
   "domain": {
    "type": "codedValue",
    "name": "condition",
    "description": "Condition",
    "codedValues": [
     {
      "name": "Not Set",
      "code": 99
     },
     {
      "name": "Good",
      "code": 0
     },
     {
      "name": "Average",
      "code": 1
     },
     {
      "name": "Needs attention or repair",
      "code": 2
     },
     {
      "name": "Poor",
      "code": 3
     },
     {
      "name": "Unknown",
      "code": 4
     },
     {
      "name": "Legacy option do not use",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspCctv",
   "type": "esriFieldTypeString",
   "alias": "CCTV Survey",
   "length": 25,
   "domain": null
  },
  {
   "name": "inspSiltDefect",
   "type": "esriFieldTypeString",
   "alias": "Specify if defective",
   "length": 40,
   "domain": {
    "type": "codedValue",
    "name": "siltDefectInspection",
    "description": "siltDefect for inspections",
    "codedValues": [
     {
      "name": "Ditch Maintenance Required",
      "code": "Ditch Maintenance Required"
     },
     {
      "name": "Domestic Refuse",
      "code": "Domestic Refuse"
     },
     {
      "name": "Excessive Debris",
      "code": "Excessive Debris"
     },
     {
      "name": "Further Investigation",
      "code": "Further Investigation"
     },
     {
      "name": "Leaves",
      "code": "Leaves"
     },
     {
      "name": "Litter",
      "code": "Litter"
     },
     {
      "name": "Needles",
      "code": "Needles"
     },
     {
      "name": "None",
      "code": "None"
     },
     {
      "name": "Offset Pot",
      "code": "Offset Pot"
     },
     {
      "name": "Oil and Fat",
      "code": "Oil and Fat"
     },
     {
      "name": "Required Dig Out",
      "code": "Required Dig Out"
     },
     {
      "name": "Roots",
      "code": "Roots"
     },
     {
      "name": "Suspected Broken Pipe",
      "code": "Suspected Broken Pipe"
     },
     {
      "name": "Swan Neck (no access to outlet)",
      "code": "Swan Neck (no access to outlet)"
     },
     {
      "name": "Tarmac / Stone",
      "code": "Tarmac / Stone"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspRunning",
   "type": "esriFieldTypeString",
   "alias": "Running",
   "length": 7,
   "domain": {
    "type": "codedValue",
    "name": "yesnoInspection",
    "description": "yesno for inspections",
    "codedValues": [
     {
      "name": "no",
      "code": "no"
     },
     {
      "name": "yes",
      "code": "yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspCleaned",
   "type": "esriFieldTypeString",
   "alias": "Drainage cleaned",
   "length": 7,
   "domain": {
    "type": "codedValue",
    "name": "yesnoInspection",
    "description": "yesno for inspections",
    "codedValues": [
     {
      "name": "no",
      "code": "no"
     },
     {
      "name": "yes",
      "code": "yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspComments",
   "type": "esriFieldTypeString",
   "alias": "Inspection related comments",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "inspDrop",
    "description": "Inspection comments drop down",
    "codedValues": [
     {
      "name": "3rd Party site blocking access",
      "code": "3rd Party site blocking access"
     },
     {
      "name": "Can't reach with gully boom",
      "code": "Can't reach with gully boom"
     },
     {
      "name": "Filled with concrete",
      "code": "Filled with concrete"
     },
     {
      "name": "Filled with tarmac",
      "code": "Filled with tarmac"
     },
     {
      "name": "Road access too narrow",
      "code": "Road access too narrow"
     },
     {
      "name": "Skip over Gully",
      "code": "Skip over Gully"
     },
     {
      "name": "Too close to parked vehicle",
      "code": "Too close to parked vehicle"
     },
     {
      "name": "Vegetation blocking access",
      "code": "Vegetation blocking access"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspCommentsOther",
   "type": "esriFieldTypeString",
   "alias": "Other inspection related comments",
   "length": 350,
   "domain": null
  },
  {
   "name": "inspJetCompleted",
   "type": "esriFieldTypeString",
   "alias": "Jetted",
   "length": 7,
   "domain": {
    "type": "codedValue",
    "name": "yesnoInspection",
    "description": "yesno for inspections",
    "codedValues": [
     {
      "name": "no",
      "code": "no"
     },
     {
      "name": "yes",
      "code": "yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspJettingTime",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Jetting time",
   "domain": {
    "type": "codedValue",
    "name": "jeTime",
    "description": "Time spent jetting",
    "codedValues": [
     {
      "name": "15 Mins",
      "code": 15
     },
     {
      "name": "30 Mins",
      "code": 30
     },
     {
      "name": "45 Mins",
      "code": 45
     },
     {
      "name": "60 Mins",
      "code": 60
     },
     {
      "name": "75 Mins",
      "code": 75
     },
     {
      "name": "90 Mins",
      "code": 90
     },
     {
      "name": "105 Mins",
      "code": 105
     },
     {
      "name": "120 Mins",
      "code": 120
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspJettingComments",
   "type": "esriFieldTypeString",
   "alias": "Jetting related comments",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "jetDrop",
    "description": "Jetting comments drop down",
    "codedValues": [
     {
      "name": "No access to jet",
      "code": "No access to jet"
     },
     {
      "name": "Suspected collapsed pipe",
      "code": "Suspected collapsed pipe"
     },
     {
      "name": "Jetted 1m to blockage",
      "code": "Jetted 1m to blockage"
     },
     {
      "name": "Jetted 2m to blockage",
      "code": "Jetted 2m to blockage"
     },
     {
      "name": "Jetted 3m to blockage",
      "code": "Jetted 3m to blockage"
     },
     {
      "name": "Jetted 4m to blockage",
      "code": "Jetted 4m to blockage"
     },
     {
      "name": "Jetted 5m to blockage",
      "code": "Jetted 5m to blockage"
     },
     {
      "name": "Jetted 6m to blockage",
      "code": "Jetted 6m to blockage"
     },
     {
      "name": "Jetted 7m to blockage",
      "code": "Jetted 7m to blockage"
     },
     {
      "name": "Jetted 8m to blockage",
      "code": "Jetted 8m to blockage"
     },
     {
      "name": "Jetted 9m to blockage",
      "code": "Jetted 9m to blockage"
     },
     {
      "name": "Jetted 10m to blockage",
      "code": "Jetted 10m to blockage"
     },
     {
      "name": "Jetted 11m to blockage",
      "code": "Jetted 11m to blockage"
     },
     {
      "name": "Jetted 12m to blockage",
      "code": "Jetted 12m to blockage"
     },
     {
      "name": "Jetted 13m to blockage",
      "code": "Jetted 13m to blockage"
     },
     {
      "name": "Jetted 14m to blockage",
      "code": "Jetted 14m to blockage"
     },
     {
      "name": "Jetted 15m to blockage",
      "code": "Jetted 15m to blockage"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspJettingCommentsOther",
   "type": "esriFieldTypeString",
   "alias": "Other jetting related comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "inspOpLeave",
   "type": "esriFieldTypeString",
   "alias": "Was drainage operational on departure",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "opArriveLeaveInspection",
    "description": "opArriveLeave for inspections",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Slow Runner",
      "code": "Slow Runner"
     },
     {
      "name": "Yes - Junction Flowing",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspPhotoComments",
   "type": "esriFieldTypeString",
   "alias": "Photo related comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "lineString",
   "type": "esriFieldTypeString",
   "alias": "Line string",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "inspRelGlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "Asset GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "sourceGlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "sourceGlobalID",
   "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": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "inspTmReq",
   "type": "esriFieldTypeString",
   "alias": "TM is required",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "tmInspection",
    "description": "tm for inspections",
    "codedValues": [
     {
      "name": "15 Min Delay Boards",
      "code": "15 Min Delay Boards"
     },
     {
      "name": "2-Way Lights",
      "code": "2-Way Lights"
     },
     {
      "name": "Lane Closure",
      "code": "Lane Closure"
     },
     {
      "name": "Multi-Phase Lights",
      "code": "Multi-Phase Lights"
     },
     {
      "name": "No Parking Cone",
      "code": "No Parking Cone"
     },
     {
      "name": "Out Of Hours",
      "code": "Out Of Hours"
     },
     {
      "name": "Parking Bay Suspension",
      "code": "Parking Bay Suspension"
     },
     {
      "name": "Priority Signs",
      "code": "Priority Signs"
     },
     {
      "name": "Road Closure",
      "code": "Road Closure"
     },
     {
      "name": "Standard Chapter 8",
      "code": "Standard Chapter 8"
     },
     {
      "name": "Stop & Go",
      "code": "Stop & Go"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "duplicate",
   "type": "esriFieldTypeString",
   "alias": "duplicate",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "yesnoInspection",
    "description": "yesno for inspections",
    "codedValues": [
     {
      "name": "no",
      "code": "no"
     },
     {
      "name": "yes",
      "code": "yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "UUID_136",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_582_inspRelG",
   "fields": "inspRelGlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "gdb_ct3_136",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "ASSET_CH",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "inspRelGlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{F5C4A24E-6647-4D23-AC48-04C8C2419660}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 200000,
 "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,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "GMT Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1699098418000
 },
 "serviceItemId": "3efec8729f794e7a86718ff7f5769e14"
}