{
 "currentVersion": 11.4,
 "cimVersion": "3.4.0",
 "id": 33,
 "name": "HydrantMaintenanceInspection",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "PRESSURE",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "PRESSURE",
   "type": "esriFieldTypeDouble",
   "alias": "Pressure (PSI)",
   "domain": null
  },
  {
   "name": "FACILITYKEY",
   "type": "esriFieldTypeString",
   "alias": "Facility ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "INSPECTOR",
   "type": "esriFieldTypeString",
   "alias": "Inspector",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wDist_Inspector",
    "description": "List of Water Distribution Staff",
    "codedValues": [
     {
      "name": "Alex Lorack",
      "code": "AL"
     },
     {
      "name": "Brian Bailey",
      "code": "BB"
     },
     {
      "name": "Dave Exline",
      "code": "DE"
     },
     {
      "name": "Dave Worby",
      "code": "DW"
     },
     {
      "name": "Eric Gringer",
      "code": "EG"
     },
     {
      "name": "Michael Willis",
      "code": "MW"
     },
     {
      "name": "Nate Swartzentruber",
      "code": "NS"
     },
     {
      "name": "Tony Stipes",
      "code": "TS"
     },
     {
      "name": "Justin Sellers",
      "code": "JS"
     },
     {
      "name": "David Bontrager",
      "code": "DB"
     },
     {
      "name": "Shawn Ostrander",
      "code": "SO"
     },
     {
      "name": "Kyle Westfall",
      "code": "KW"
     },
     {
      "name": "Bill Donahue",
      "code": "BD"
     },
     {
      "name": "Mathew Solinger",
      "code": "MS"
     },
     {
      "name": "Garrit Thomann",
      "code": "GT"
     },
     {
      "name": "Michael Frieden",
      "code": "MF"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "length": 1000,
   "domain": null
  },
  {
   "name": "DateInspected",
   "type": "esriFieldTypeDate",
   "alias": "Date Inspected",
   "length": 8,
   "domain": null
  },
  {
   "name": "HydAccessible",
   "type": "esriFieldTypeString",
   "alias": "Hydrant Accessible?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "HydDrains",
   "type": "esriFieldTypeString",
   "alias": "Hydrant Drains?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "HydFlushed",
   "type": "esriFieldTypeString",
   "alias": "Hyd Flushed?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "HydPaint",
   "type": "esriFieldTypeString",
   "alias": "Paint Req'd?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LocatorBox",
   "type": "esriFieldTypeString",
   "alias": "Locator Box?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "RepairsNeeded",
   "type": "esriFieldTypeString",
   "alias": "Repairs Needed",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "RepairNotes",
   "type": "esriFieldTypeString",
   "alias": "Repair Notes",
   "length": 200,
   "domain": null
  },
  {
   "name": "FlushTime",
   "type": "esriFieldTypeDouble",
   "alias": "Flush Time in Minutes",
   "domain": null
  },
  {
   "name": "WaterLoss",
   "type": "esriFieldTypeDouble",
   "alias": "Water Loss in Gallons",
   "domain": null
  },
  {
   "name": "TotalChlorine",
   "type": "esriFieldTypeDouble",
   "alias": "Total Chlorine",
   "domain": null
  },
  {
   "name": "InspectionStatus",
   "type": "esriFieldTypeString",
   "alias": "InspectionStatus",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "wHydrantInspectStatus",
    "description": "Hydrant Inspection Status",
    "codedValues": [
     {
      "name": "Complete",
      "code": "Complete"
     },
     {
      "name": "Complete Needs Work Order",
      "code": "Needs Work Order"
     },
     {
      "name": "In Progress",
      "code": "In Progress"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "HydOperational",
   "type": "esriFieldTypeString",
   "alias": "Hyd Operational?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wYesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "NOT APPLICABLE",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Repairs_1",
   "type": "esriFieldTypeString",
   "alias": "Repairs 1",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "wHydRepairs",
    "description": "Hydrant Repairs",
    "codedValues": [
     {
      "name": "Bolt",
      "code": "Bolt"
     },
     {
      "name": "Broken Flange",
      "code": "Broken Flange"
     },
     {
      "name": "Coupler",
      "code": "Coupler"
     },
     {
      "name": "Crooked",
      "code": "Crooked"
     },
     {
      "name": "Does Not Drain",
      "code": "Does Not Drain"
     },
     {
      "name": "Does Not Shut Off",
      "code": "Does Not Shut Off"
     },
     {
      "name": "Drains Slow",
      "code": "Drains Slow"
     },
     {
      "name": "Hydrant High",
      "code": "Hydrant High"
     },
     {
      "name": "Hydrant Hit",
      "code": "Hydrant Hit"
     },
     {
      "name": "Hydrant Low",
      "code": "Hydrant Low"
     },
     {
      "name": "Leaks",
      "code": "Leaks"
     },
     {
      "name": "Locator Box Issue",
      "code": "Locator Box Issue"
     },
     {
      "name": "Nozzle Threads Damaged",
      "code": "Nozzle Threads Damaged"
     },
     {
      "name": "Oil/Grease",
      "code": "Oil/Grease"
     },
     {
      "name": "Operator",
      "code": "Operator"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Shaft Dropped",
      "code": "Shaft Dropped"
     },
     {
      "name": "Stem",
      "code": "Stem"
     },
     {
      "name": "Turns Hard",
      "code": "Turns Hard"
     },
     {
      "name": "Wiring",
      "code": "Wiring"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Repairs_2",
   "type": "esriFieldTypeString",
   "alias": "Repairs 2",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "wHydRepairs",
    "description": "Hydrant Repairs",
    "codedValues": [
     {
      "name": "Bolt",
      "code": "Bolt"
     },
     {
      "name": "Broken Flange",
      "code": "Broken Flange"
     },
     {
      "name": "Coupler",
      "code": "Coupler"
     },
     {
      "name": "Crooked",
      "code": "Crooked"
     },
     {
      "name": "Does Not Drain",
      "code": "Does Not Drain"
     },
     {
      "name": "Does Not Shut Off",
      "code": "Does Not Shut Off"
     },
     {
      "name": "Drains Slow",
      "code": "Drains Slow"
     },
     {
      "name": "Hydrant High",
      "code": "Hydrant High"
     },
     {
      "name": "Hydrant Hit",
      "code": "Hydrant Hit"
     },
     {
      "name": "Hydrant Low",
      "code": "Hydrant Low"
     },
     {
      "name": "Leaks",
      "code": "Leaks"
     },
     {
      "name": "Locator Box Issue",
      "code": "Locator Box Issue"
     },
     {
      "name": "Nozzle Threads Damaged",
      "code": "Nozzle Threads Damaged"
     },
     {
      "name": "Oil/Grease",
      "code": "Oil/Grease"
     },
     {
      "name": "Operator",
      "code": "Operator"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Shaft Dropped",
      "code": "Shaft Dropped"
     },
     {
      "name": "Stem",
      "code": "Stem"
     },
     {
      "name": "Turns Hard",
      "code": "Turns Hard"
     },
     {
      "name": "Wiring",
      "code": "Wiring"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R3014_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_19186_FACILI",
   "fields": "FACILITYKEY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_3014",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_OID_3014",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "SDE.wHydrantR",
   "relatedTableId": 10,
   "role": "esriRelRoleDestination",
   "keyField": "FACILITYKEY",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}"
  },
  {
   "id": 4,
   "name": "SDE.wHydrantR",
   "relatedTableId": 178,
   "role": "esriRelRoleDestination",
   "keyField": "FACILITYKEY",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 3000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "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": "Central Standard Time",
  "timeZoneIANA": "Etc/GMT+6",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1694167777000
 },
 "serviceItemId": "8a71d31558cb48f8b8d08ea4ef34c250"
}