{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 33,
 "name": "HydrantHistory",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "assetkey",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "assetkey",
   "type": "esriFieldTypeString",
   "alias": "Asset Key",
   "length": 20,
   "domain": null
  },
  {
   "name": "workorderkey",
   "type": "esriFieldTypeString",
   "alias": "Workorder Key",
   "length": 50,
   "domain": null
  },
  {
   "name": "staticpressure",
   "type": "esriFieldTypeDouble",
   "alias": "Static Pressure",
   "domain": null
  },
  {
   "name": "residualpressure",
   "type": "esriFieldTypeDouble",
   "alias": "Residual Pressure",
   "domain": null
  },
  {
   "name": "pitotpressure",
   "type": "esriFieldTypeDouble",
   "alias": "Pitot Pressure",
   "domain": null
  },
  {
   "name": "flow",
   "type": "esriFieldTypeDouble",
   "alias": "Flow",
   "domain": null
  },
  {
   "name": "nozzlediameter",
   "type": "esriFieldTypeDouble",
   "alias": "Nozzle Diameter",
   "domain": {
    "type": "codedValue",
    "name": "FH_Size1",
    "description": "",
    "codedValues": [
     {
      "name": "2",
      "code": 2
     },
     {
      "name": "2.5",
      "code": 2.5
     },
     {
      "name": "4",
      "code": 4
     },
     {
      "name": "4.5",
      "code": 4.5
     },
     {
      "name": "5.25",
      "code": 5.25
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "flowduration",
   "type": "esriFieldTypeInteger",
   "alias": "Flow Duration",
   "domain": null
  },
  {
   "name": "gallonsused",
   "type": "esriFieldTypeInteger",
   "alias": "GallonsUsed",
   "domain": null
  },
  {
   "name": "attachmentid1",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID1",
   "domain": null
  },
  {
   "name": "attachmentid2",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID2",
   "domain": null
  },
  {
   "name": "workdate",
   "type": "esriFieldTypeDate",
   "alias": "WorkDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "workby",
   "type": "esriFieldTypeString",
   "alias": "WorkBy",
   "length": 50,
   "domain": null
  },
  {
   "name": "worktype",
   "type": "esriFieldTypeString",
   "alias": "WorkType",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "FH_WorkType",
    "description": "",
    "codedValues": [
     {
      "name": "2 Hydrant Fire Flow Test",
      "code": "2 Hydrant Fire Flow Test"
     },
     {
      "name": "1 Hydrant Fire Flow Test",
      "code": "1 Hydrant Fire Flow Test"
     },
     {
      "name": "Hydrant Maintenance",
      "code": "Hydrant Maintenance"
     },
     {
      "name": "Hydrant Maintenance w/Flush",
      "code": "Hydrant Maintenance w/Flush"
     },
     {
      "name": "Fire Hydrant Flush",
      "code": "Fire Hydrant Flush"
     },
     {
      "name": "Simple Asset Data update",
      "code": "Simple Asset Data update"
     },
     {
      "name": "Hydrant Install/Review/Update",
      "code": "Hydrant Install/Review/Update"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "comments",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Comments",
   "length": 1000,
   "domain": null
  },
  {
   "name": "paint",
   "type": "esriFieldTypeString",
   "alias": "Paint Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "FH_Paint",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Needs Painted",
      "code": "Needs Painted"
     },
     {
      "name": "Needs Stenciled",
      "code": "Needs Stenciled"
     },
     {
      "name": "Needs Paint and Stencil",
      "code": "Needs Paint and Stencil"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "stencil",
   "type": "esriFieldTypeString",
   "alias": "Stencil",
   "length": 50,
   "domain": null
  },
  {
   "name": "flowat20",
   "type": "esriFieldTypeDouble",
   "alias": "Flow at 20",
   "domain": null
  },
  {
   "name": "caps",
   "type": "esriFieldTypeString",
   "alias": "Caps Condition",
   "length": 50,
   "domain": null
  },
  {
   "name": "chains",
   "type": "esriFieldTypeString",
   "alias": "Chains Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "pipe_condition",
    "description": "",
    "codedValues": [
     {
      "name": "Excellent",
      "code": "excellent"
     },
     {
      "name": "Good",
      "code": "good"
     },
     {
      "name": "Fair",
      "code": "fair"
     },
     {
      "name": "Poor",
      "code": "poor"
     },
     {
      "name": "Failure Imminent",
      "code": "failure_imminent"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "drainage",
   "type": "esriFieldTypeString",
   "alias": "Drainage Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "nozzle",
   "type": "esriFieldTypeString",
   "alias": "Nozzle",
   "length": 50,
   "domain": null
  },
  {
   "name": "nozzleleaks",
   "type": "esriFieldTypeString",
   "alias": "Nozzle Leaks",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "nozzlegreased",
   "type": "esriFieldTypeString",
   "alias": "Nozzle Greased",
   "length": 50,
   "domain": null
  },
  {
   "name": "residuallocation",
   "type": "esriFieldTypeString",
   "alias": "Residual PSI Reading Location",
   "length": 50,
   "domain": null
  },
  {
   "name": "clearance",
   "type": "esriFieldTypeString",
   "alias": "Clearance",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "height",
   "type": "esriFieldTypeString",
   "alias": "Height",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "obstruction",
   "type": "esriFieldTypeString",
   "alias": "Obstruction",
   "length": 50,
   "domain": null
  },
  {
   "name": "commentzone",
   "type": "esriFieldTypeString",
   "alias": "Clear Zone Obstructions Comment",
   "length": 250,
   "domain": null
  },
  {
   "name": "leadnozzle",
   "type": "esriFieldTypeString",
   "alias": "Lead Nozzle",
   "length": 50,
   "domain": null
  },
  {
   "name": "capthreadseal",
   "type": "esriFieldTypeString",
   "alias": "Cap Thread Seal",
   "length": 50,
   "domain": null
  },
  {
   "name": "commentcapnozzle",
   "type": "esriFieldTypeString",
   "alias": "Comment Cap/Nozzle",
   "length": 250,
   "domain": {
    "type": "codedValue",
    "name": "FH_CapsChains",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "Repaired",
      "code": "Repaired"
     },
     {
      "name": "Replaced",
      "code": "Replaced"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "initialcondition",
   "type": "esriFieldTypeString",
   "alias": "Initial Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "EasyHard",
    "description": "",
    "codedValues": [
     {
      "name": "Easy",
      "code": "Easy"
     },
     {
      "name": "Hard",
      "code": "Hard"
     },
     {
      "name": "Medium",
      "code": "Medium"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "stemoiledexercised",
   "type": "esriFieldTypeString",
   "alias": "Stem Oiled/Exercised",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "finalcondition",
   "type": "esriFieldTypeString",
   "alias": "Final Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "EasyHard",
    "description": "",
    "codedValues": [
     {
      "name": "Easy",
      "code": "Easy"
     },
     {
      "name": "Hard",
      "code": "Hard"
     },
     {
      "name": "Medium",
      "code": "Medium"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "additionalwork",
   "type": "esriFieldTypeString",
   "alias": "Additional Work",
   "length": 250,
   "domain": {
    "type": "codedValue",
    "name": "FH_AddWork",
    "description": "",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Replace",
      "code": "Replace"
     },
     {
      "name": "Future Replace",
      "code": "Future Replace"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "commentaddwork",
   "type": "esriFieldTypeString",
   "alias": "Additional Work Comment",
   "length": 250,
   "domain": null
  },
  {
   "name": "beginturbidity",
   "type": "esriFieldTypeDouble",
   "alias": "Beginning Turbidity",
   "domain": null
  },
  {
   "name": "begincl2",
   "type": "esriFieldTypeDouble",
   "alias": "Beginning Chlorine",
   "domain": null
  },
  {
   "name": "beginwatertemp",
   "type": "esriFieldTypeDouble",
   "alias": "Beginning Water Temperature",
   "domain": null
  },
  {
   "name": "endturbidity",
   "type": "esriFieldTypeDouble",
   "alias": "Ending Turbidity",
   "domain": null
  },
  {
   "name": "endcl2",
   "type": "esriFieldTypeDouble",
   "alias": "Ending Chlorine",
   "domain": null
  },
  {
   "name": "ph",
   "type": "esriFieldTypeDouble",
   "alias": "pH",
   "domain": null
  },
  {
   "name": "pitot",
   "type": "esriFieldTypeDouble",
   "alias": "Pitot",
   "domain": null
  },
  {
   "name": "testduration",
   "type": "esriFieldTypeDouble",
   "alias": "Test Duration",
   "domain": null
  },
  {
   "name": "issue",
   "type": "esriFieldTypeString",
   "alias": "Issue",
   "length": 250,
   "domain": null
  },
  {
   "name": "flowrate",
   "type": "esriFieldTypeString",
   "alias": "Flow Rate",
   "length": 50,
   "domain": null
  },
  {
   "name": "DataValidComment",
   "type": "esriFieldTypeString",
   "alias": "DataValidComment",
   "length": 500,
   "domain": null
  },
  {
   "name": "WorkInitials",
   "type": "esriFieldTypeString",
   "alias": "Work Initials",
   "length": 255,
   "domain": null
  },
  {
   "name": "attachmentid3",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID3",
   "domain": null
  },
  {
   "name": "WorkingHours",
   "type": "esriFieldTypeInteger",
   "alias": "WorkingHours",
   "domain": null
  },
  {
   "name": "Man_Hours_Breakdown",
   "type": "esriFieldTypeString",
   "alias": "Man Hours Breakdown",
   "length": 500,
   "domain": null
  },
  {
   "name": "Pressure",
   "type": "esriFieldTypeInteger",
   "alias": "Pressure",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "GUID",
   "type": "esriFieldTypeGUID",
   "alias": "GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "DataValid_Comment",
   "type": "esriFieldTypeString",
   "alias": "Data Valid Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "SolidStem",
   "type": "esriFieldTypeString",
   "alias": "Solid Stem",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PaintStencil",
   "type": "esriFieldTypeString",
   "alias": "Paint/Stencil",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FH_Paint",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Needs Painted",
      "code": "Needs Painted"
     },
     {
      "name": "Needs Stenciled",
      "code": "Needs Stenciled"
     },
     {
      "name": "Needs Paint and Stencil",
      "code": "Needs Paint and Stencil"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DataValid",
   "type": "esriFieldTypeString",
   "alias": "Data Valid",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Active Work",
      "code": "Active Work"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R439_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_439",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_5785_GUID",
   "fields": "GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_439",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "GIS_PROD.GDB_ADMIN.wHydrant",
   "relatedTableId": 20,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "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
 },
 "dateFieldsTimeReference": null,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}