{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 2,
 "name": "WCElementsInsp",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SERVICETYPE",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "RECEIVEDDATE",
   "type": "esriFieldTypeDate",
   "alias": "RECEIVEDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "TIMEARRIVED",
   "type": "esriFieldTypeDate",
   "alias": "TIMEARRIVED",
   "length": 8,
   "domain": null
  },
  {
   "name": "TIMECOMPLETED",
   "type": "esriFieldTypeDate",
   "alias": "TIMECOMPLETED",
   "length": 8,
   "domain": null
  },
  {
   "name": "SERVICEREQUEST",
   "type": "esriFieldTypeInteger",
   "alias": "SERVICEREQUEST",
   "domain": null
  },
  {
   "name": "WORKORDER",
   "type": "esriFieldTypeDouble",
   "alias": "WORKORDER",
   "domain": null
  },
  {
   "name": "WORKORDERTASK",
   "type": "esriFieldTypeDouble",
   "alias": "WORKORDERTASK",
   "domain": null
  },
  {
   "name": "SERVICETYPE",
   "type": "esriFieldTypeString",
   "alias": "SERVICETYPE",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspSERV",
    "description": "WaterCurbInspSERV",
    "codedValues": [
     {
      "name": "Pre-Flushing",
      "code": "Pre-Flushing"
     },
     {
      "name": "Flushing Program",
      "code": "Flushing Program"
     },
     {
      "name": "Pre-Construction",
      "code": "Pre-Construction"
     },
     {
      "name": "Emergency",
      "code": "Emergency"
     },
     {
      "name": "Maintenance",
      "code": "Maintenance"
     },
     {
      "name": "Preventative Maintenance",
      "code": "Preventative Maintenance"
     },
     {
      "name": "Post-Construction",
      "code": "Post-Construction"
     },
     {
      "name": "Watermain Relining",
      "code": "Watermain Relining"
     },
     {
      "name": "Others",
      "code": "Others"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PIPEMATERIALCITY",
   "type": "esriFieldTypeString",
   "alias": "PIPEMATERIALCITY",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCFPIPEMATERIALCITY",
    "description": "WaterCFPIPEMATERIALCITY",
    "codedValues": [
     {
      "name": "Copper",
      "code": "Copper"
     },
     {
      "name": "Lead",
      "code": "Lead"
     },
     {
      "name": "Poly B",
      "code": "Poly B"
     },
     {
      "name": "Poly E",
      "code": "Poly E"
     },
     {
      "name": "Camaloid",
      "code": "Camaloid"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PIPEMATERIALPRIVATE",
   "type": "esriFieldTypeString",
   "alias": "PIPEMATERIALPRIVATE",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCFPIPEMATERIALCITY",
    "description": "WaterCFPIPEMATERIALCITY",
    "codedValues": [
     {
      "name": "Copper",
      "code": "Copper"
     },
     {
      "name": "Lead",
      "code": "Lead"
     },
     {
      "name": "Poly B",
      "code": "Poly B"
     },
     {
      "name": "Poly E",
      "code": "Poly E"
     },
     {
      "name": "Camaloid",
      "code": "Camaloid"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CBOCONDITION",
   "type": "esriFieldTypeString",
   "alias": "CBOCONDITION",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspBO",
    "description": "WaterCurbInspBO",
    "codedValues": [
     {
      "name": "Operable",
      "code": "Operable"
     },
     {
      "name": "Cannot Locate",
      "code": "Cannot Locate"
     },
     {
      "name": "Stuck Lid",
      "code": "Stuck Lid"
     },
     {
      "name": "Full/Debris",
      "code": "Full/Debris"
     },
     {
      "name": "Misaligned Box",
      "code": "Misaligned Box"
     },
     {
      "name": "Bent Rod",
      "code": "Bent Rod"
     },
     {
      "name": "Too High",
      "code": "Too High"
     },
     {
      "name": "Too Low",
      "code": "Too Low"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CSCONDITION",
   "type": "esriFieldTypeString",
   "alias": "CSCONDITION",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspSTOP",
    "description": "WaterCurbInspSTOP",
    "codedValues": [
     {
      "name": "Non-Operable",
      "code": "Non-Operable"
     },
     {
      "name": "Corroded",
      "code": "Corroded"
     },
     {
      "name": "No Check pin",
      "code": "No Check pin"
     },
     {
      "name": "Passing",
      "code": "Passing"
     },
     {
      "name": "Pass",
      "code": "Pass"
     },
     {
      "name": "Drain Hole",
      "code": "Drain Hole"
     },
     {
      "name": "Packing Gland",
      "code": "Packing Gland"
     },
     {
      "name": "Tee Head off",
      "code": "Tee Head off"
     },
     {
      "name": "Frozen",
      "code": "Frozen"
     },
     {
      "name": "Leak",
      "code": "Leak"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Operable",
      "code": "Operable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ACTION",
   "type": "esriFieldTypeString",
   "alias": "ACTION",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspACTION",
    "description": "WaterCurbInspACTION",
    "codedValues": [
     {
      "name": "Replaced Curb Box and Rod",
      "code": "Replaced Curb Box and Rod"
     },
     {
      "name": "Flushed",
      "code": "Flushed"
     },
     {
      "name": "Raised",
      "code": "Raised"
     },
     {
      "name": "Lower",
      "code": "Lower"
     },
     {
      "name": "Steamed",
      "code": "Steamed"
     },
     {
      "name": "Thawed",
      "code": "Thawed"
     },
     {
      "name": "No Action",
      "code": "No Action"
     },
     {
      "name": "Hydrovac Failed",
      "code": "Hydrovac Failed"
     },
     {
      "name": "Located and Operated",
      "code": "Located and Operated"
     },
     {
      "name": "Pulled Rod",
      "code": "Pulled Rod"
     },
     {
      "name": "Hydrovac Successful",
      "code": "Hydrovac Successful"
     },
     {
      "name": "Repaired",
      "code": "Repaired"
     },
     {
      "name": "Inspected",
      "code": "Inspected"
     },
     {
      "name": "Turned on",
      "code": "Turned on"
     },
     {
      "name": "Turned off",
      "code": "Turned off"
     },
     {
      "name": "Seized",
      "code": "Seized"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BOXRODQTY",
   "type": "esriFieldTypeInteger",
   "alias": "BOXRODQTY",
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 255,
   "domain": null
  },
  {
   "name": "SERVICEDBY",
   "type": "esriFieldTypeString",
   "alias": "SERVICEDBY",
   "length": 255,
   "domain": null
  },
  {
   "name": "VEHICLEUNIT",
   "type": "esriFieldTypeInteger",
   "alias": "VEHICLEUNIT",
   "domain": null
  },
  {
   "name": "DATEREFFERED",
   "type": "esriFieldTypeDate",
   "alias": "DATEREFFERED",
   "length": 8,
   "domain": null
  },
  {
   "name": "PLANSMADEBY",
   "type": "esriFieldTypeString",
   "alias": "PLANSMADEBY",
   "length": 255,
   "domain": null
  },
  {
   "name": "GISID_",
   "type": "esriFieldTypeInteger",
   "alias": "GISID_",
   "domain": null
  },
  {
   "name": "MAITENANCE",
   "type": "esriFieldTypeString",
   "alias": "MAITENANCE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspMAINTE",
    "description": "WaterCurbInspMAINTE",
    "codedValues": [
     {
      "name": "Replaced Curb Box and Rod",
      "code": "Replaced Curb Box and Rod"
     },
     {
      "name": "Flushed",
      "code": "Flushed"
     },
     {
      "name": "Raised",
      "code": "Raised"
     },
     {
      "name": "Lower",
      "code": "Lower"
     },
     {
      "name": "Steamed",
      "code": "Steamed"
     },
     {
      "name": "Thawed",
      "code": "Thawed"
     },
     {
      "name": "No Action",
      "code": "No Action"
     },
     {
      "name": "Hydrovacced Failed",
      "code": "Hydrovacced Failed"
     },
     {
      "name": "Others",
      "code": "Others"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "POSITIONLEFT",
   "type": "esriFieldTypeString",
   "alias": "POSITIONLEFT",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WaterCurbInspPOSITIONLEF",
    "description": "WaterCurbInspPOSITIONLEF",
    "codedValues": [
     {
      "name": "Open",
      "code": "Open"
     },
     {
      "name": "Closed",
      "code": "Closed"
     },
     {
      "name": "Partially Open",
      "code": "Partially Open"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "GDB_126844_GISID",
   "fields": "GISID_",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R1244438_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "WCElements",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GISID_",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 1000,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Canada Central Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}