{
 "layers": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 3,
   "name": "IowaCity.SDE.wHydrantR",
   "type": "Feature Layer",
   "description": "General locations of fire hydrants connected to the Iowa City drinking water distribution system, including hydrants connected through private water service lines. Fire hydrants of sister water utilities are included where the Iowa City Water Division may use them for general system/interconnection maintenance. Information attached to each fire hydrants includes make and model, general location description, size, size of lateral connection, size of water pipe fed from, existence of auxiliary valve, flushing route and order, and dead-end designation. This feature class is based on information submitted through construction as-builts and field observations.",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102676,
    "latestWkid": 3418,
    "vcsWkid": 105703,
    "latestVcsWkid": 6360,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.003280833333333333,
    "mTolerance": 0.001,
    "falseX": -119240500,
    "falseY": -96507600,
    "xyUnits": 3048.0060960121928,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "spatialReference": {
    "wkid": 102676,
    "latestWkid": 3418,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.003280833333333333,
    "mTolerance": 0.001,
    "falseX": -119240500,
    "falseY": -96507600,
    "xyUnits": 3048.0060960121928,
    "falseZ": -100000,
    "zUnits": 3048.006096012192,
    "falseM": -100000,
    "mUnits": 10000
   },
   "sourceHeightModelInfo": {
    "heightModel": "gravity_related_height",
    "vertCRS": "NAVD_1988_Foot_US",
    "heightUnit": "us-foot"
   },
   "copyrightText": "City of Iowa City Water Division",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       85,
       255,
       0,
       255
      ],
      "size": 12,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        85,
        255,
        0,
        255
       ],
       "width": 0
      }
     }
    },
    "scaleSymbols": false,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": false,
   "extent": {
    "xmin": 2151996.9765985236,
    "ymin": 591935.928136677,
    "xmax": 2197106.087535587,
    "ymax": 623631.1866296022,
    "spatialReference": {
     "wkid": 102676,
     "latestWkid": 3418,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.003280833333333333,
     "mTolerance": 0.001,
     "falseX": -119240500,
     "falseY": -96507600,
     "xyUnits": 3048.0060960121928,
     "falseZ": -100000,
     "zUnits": 3048.006096012192,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "HYD_ID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "HYD_ID",
     "type": "esriFieldTypeString",
     "alias": "HYD_ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "OWNERSHIP",
     "type": "esriFieldTypeString",
     "alias": "OWNERSHIP",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "wOwnership",
      "description": "Ownership of water assests",
      "codedValues": [
       {
        "name": "City",
        "code": "City"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Private",
        "code": "Private"
       },
       {
        "name": "Raw",
        "code": "Raw"
       },
       {
        "name": "Killed-City",
        "code": "Killed-City"
       },
       {
        "name": "Killed-Private",
        "code": "Killed-Private"
       },
       {
        "name": "Killed-Raw",
        "code": "Killed-Raw"
       },
       {
        "name": "Proposed-City",
        "code": "Proposed-City"
       },
       {
        "name": "Proposed-Private",
        "code": "Proposed-Private"
       },
       {
        "name": "U of Iowa",
        "code": "U of Iowa"
       },
       {
        "name": "Coralville",
        "code": "Coralville"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "MAP_NUM",
     "type": "esriFieldTypeString",
     "alias": "MAP_NUM",
     "length": 20,
     "domain": null
    },
    {
     "name": "LOCATION",
     "type": "esriFieldTypeString",
     "alias": "LOCATION",
     "length": 256,
     "domain": null
    },
    {
     "name": "MANUFACTURER",
     "type": "esriFieldTypeString",
     "alias": "MANUFACTURER",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantManufacturer",
      "description": "The name of the hydrant manufacturer",
      "codedValues": [
       {
        "name": "AMERICAN DARLING",
        "code": "AMERICAN DARLING"
       },
       {
        "name": "CLOW",
        "code": "CLOW"
       },
       {
        "name": "EDDY",
        "code": "EDDY"
       },
       {
        "name": "IOWA",
        "code": "IOWA"
       },
       {
        "name": "KENNEDY",
        "code": "KENNEDY"
       },
       {
        "name": "LUDLOW",
        "code": "LUDLOW"
       },
       {
        "name": "M&H",
        "code": "M&H"
       },
       {
        "name": "MUELLER",
        "code": "MUELLER"
       },
       {
        "name": "TRAVERSE CITY",
        "code": "TRAVERSE CITY"
       },
       {
        "name": "WATEROUS",
        "code": "WATEROUS"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "HYD_MODEL",
     "type": "esriFieldTypeString",
     "alias": "HYD_MODEL",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantModel",
      "description": "Model of fire hydrant",
      "codedValues": [
       {
        "name": "F-2545",
        "code": "F-2545"
       },
       {
        "name": "F-2500",
        "code": "F-2500"
       },
       {
        "name": "MK-73",
        "code": "MK-73"
       },
       {
        "name": "B-84-B-5",
        "code": "B-84-B-5"
       },
       {
        "name": "Improved",
        "code": "Improved"
       },
       {
        "name": "K-81-A",
        "code": "K-81-A"
       },
       {
        "name": "Super Centurion",
        "code": "Super Centurion"
       },
       {
        "name": "Centurion",
        "code": "Centurion"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "YEAR_MAN",
     "type": "esriFieldTypeSmallInteger",
     "alias": "YEAR_MAN",
     "domain": null
    },
    {
     "name": "HYD_SIZE",
     "type": "esriFieldTypeDouble",
     "alias": "HYD_SIZE",
     "domain": null
    },
    {
     "name": "NOZZLE_NUM",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NOZZLE_NUM",
     "domain": null
    },
    {
     "name": "BURY_DEPTH",
     "type": "esriFieldTypeDouble",
     "alias": "BURY_DEPTH",
     "domain": null
    },
    {
     "name": "HYD_EXTEN",
     "type": "esriFieldTypeSingle",
     "alias": "HYD_EXTEN",
     "domain": null
    },
    {
     "name": "YEAR_INST",
     "type": "esriFieldTypeSmallInteger",
     "alias": "YEAR_INST",
     "domain": null
    },
    {
     "name": "AUX_VAL",
     "type": "esriFieldTypeString",
     "alias": "AUX_VAL",
     "length": 5,
     "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": "VALVE_DIAM",
     "type": "esriFieldTypeSingle",
     "alias": "VALVE_DIAM",
     "domain": null
    },
    {
     "name": "ROUTE_NUM",
     "type": "esriFieldTypeString",
     "alias": "ROUTE_NUM",
     "length": 20,
     "domain": null
    },
    {
     "name": "ROUTE_ORDER",
     "type": "esriFieldTypeDouble",
     "alias": "ROUTE_ORDER",
     "domain": null
    },
    {
     "name": "DEAD_END",
     "type": "esriFieldTypeString",
     "alias": "DEAD_END",
     "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": "DE_NUM",
     "type": "esriFieldTypeString",
     "alias": "DE_NUM",
     "length": 10,
     "domain": null
    },
    {
     "name": "DE_ORDER",
     "type": "esriFieldTypeDouble",
     "alias": "DE_ORDER",
     "domain": null
    },
    {
     "name": "STATIC_PRES",
     "type": "esriFieldTypeSmallInteger",
     "alias": "STATIC_PRES",
     "domain": null
    },
    {
     "name": "DATE_REC",
     "type": "esriFieldTypeDate",
     "alias": "DATE_REC",
     "length": 8,
     "domain": null
    },
    {
     "name": "MAIN_DIAM",
     "type": "esriFieldTypeSmallInteger",
     "alias": "MAIN_DIAM",
     "domain": null
    },
    {
     "name": "NOTES",
     "type": "esriFieldTypeString",
     "alias": "NOTES",
     "length": 500,
     "domain": null
    },
    {
     "name": "BILLING",
     "type": "esriFieldTypeString",
     "alias": "BILLING",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantBilling",
      "description": "Entity billed for private hydrant maintenance program",
      "codedValues": [
       {
        "name": "U OF I",
        "code": "U OF I"
       },
       {
        "name": "UI-DUAL",
        "code": "UI-DUAL"
       },
       {
        "name": "UNIVERSITY HEIGHTS",
        "code": "UNIVERSITY HEIGHTS"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "EASTING",
     "type": "esriFieldTypeDouble",
     "alias": "EASTING",
     "domain": null
    },
    {
     "name": "NORTHING",
     "type": "esriFieldTypeDouble",
     "alias": "NORTHING",
     "domain": null
    },
    {
     "name": "GPS_ACCURACY",
     "type": "esriFieldTypeString",
     "alias": "GPS_ACCURACY",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wGPSAccuracy",
      "description": "Accuracy category for GPS point",
      "codedValues": [
       {
        "name": "CAD 3FT TO 300FT",
        "code": "CAD"
       },
       {
        "name": "GPS RECREATIONAL GRADE 10M TO 30FT",
        "code": "REC"
       },
       {
        "name": "GPS MAPPING GRADE 4IN TO 1M",
        "code": "MAP"
       },
       {
        "name": "GPS RTK SURVEY GRADE 2CM",
        "code": "SVY"
       },
       {
        "name": "UNKNOWN",
        "code": "UNK"
       },
       {
        "name": "CANNOT RECORD GPS",
        "code": "NON"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "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": "LAT_DIAM",
     "type": "esriFieldTypeSingle",
     "alias": "LAT_DIAM",
     "domain": null
    },
    {
     "name": "SHAPE",
     "type": "esriFieldTypeGeometry",
     "alias": "SHAPE",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "GPM",
     "type": "esriFieldTypeDouble",
     "alias": "Gallons per Minute",
     "domain": null
    },
    {
     "name": "Storz_Conn",
     "type": "esriFieldTypeString",
     "alias": "Storz_Connection",
     "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": "ANN_BAC_SAM_HYD",
     "type": "esriFieldTypeString",
     "alias": "Annual Bacterial Sample Hydrant",
     "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": "HYDRANT_BILLED",
     "type": "esriFieldTypeString",
     "alias": "HYDRANT_BILLED",
     "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": "ADDRESS",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS",
     "length": 256,
     "domain": null
    },
    {
     "name": "ACCOUNT_NUMBER",
     "type": "esriFieldTypeString",
     "alias": "ACCOUNT_NUMBER",
     "length": 25,
     "domain": null
    },
    {
     "name": "BILLING_NAME",
     "type": "esriFieldTypeString",
     "alias": "BILLING_NAME",
     "length": 256,
     "domain": null
    },
    {
     "name": "BILLING_CONTACT",
     "type": "esriFieldTypeString",
     "alias": "BILLING_CONTACT",
     "length": 100,
     "domain": null
    },
    {
     "name": "BILLING_ADDRESS",
     "type": "esriFieldTypeString",
     "alias": "BILLING_ADDRESS",
     "length": 256,
     "domain": null
    },
    {
     "name": "BILLING_CITY_ST_ZIP",
     "type": "esriFieldTypeString",
     "alias": "BILLING_CITY_ST_ZIP",
     "length": 100,
     "domain": null
    },
    {
     "name": "CONTACT_INFO",
     "type": "esriFieldTypeString",
     "alias": "CONTACT_INFO",
     "length": 100,
     "domain": null
    },
    {
     "name": "CID",
     "type": "esriFieldTypeDouble",
     "alias": "CID",
     "domain": null
    },
    {
     "name": "R_PREFIX",
     "type": "esriFieldTypeDouble",
     "alias": "R_PREFIX",
     "domain": null
    },
    {
     "name": "DEEDHOLDER",
     "type": "esriFieldTypeString",
     "alias": "DEEDHOLDER",
     "length": 256,
     "domain": null
    },
    {
     "name": "PROJECT_NUMBER",
     "type": "esriFieldTypeString",
     "alias": "PROJECT_NUMBER",
     "length": 100,
     "domain": null
    },
    {
     "name": "PROJECT_TYPE",
     "type": "esriFieldTypeString",
     "alias": "PROJECT_TYPE",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wProjectType",
      "description": "The type of water main project",
      "codedValues": [
       {
        "name": "New",
        "code": "N"
       },
       {
        "name": "Replacement",
        "code": "R"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    }
   ],
   "geometryField": {
    "name": "SHAPE",
    "type": "esriFieldTypeGeometry",
    "alias": "SHAPE"
   },
   "indexes": [
    {
     "name": "R498_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_498",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_498",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_957_HYD_ID",
     "fields": "HYD_ID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S456_idx",
     "fields": "SHAPE",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "SDE.HydrantMaintenanceInspection",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "HYD_ID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}"
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "maxSelectionCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": true,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1694167777000
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "7bc86292d3a540db8598ac1a5de732f5"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 2,
   "name": "HydrantMaintenanceInspection",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "OBJECTID",
   "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": "Zach Knoop",
        "code": "ZK"
       },
       {
        "name": "Tony Stipes",
        "code": "TS"
       },
       {
        "name": "Shawn Ostrander",
        "code": "SO"
       },
       {
        "name": "Nate Swartzentruber",
        "code": "NS"
       },
       {
        "name": "Mario Medellin",
        "code": "MM"
       },
       {
        "name": "Mason Letts",
        "code": "ML"
       },
       {
        "name": "Garrit Thomann",
        "code": "GT"
       },
       {
        "name": "Dominic Waikel",
        "code": "DW"
       },
       {
        "name": "Dave Exline",
        "code": "DE"
       },
       {
        "name": "Christopher Waikel",
        "code": "CW"
       },
       {
        "name": "Michael Willis",
        "code": "_MW"
       },
       {
        "name": "Mathew Solinger",
        "code": "_MS"
       },
       {
        "name": "Michael Frieden",
        "code": "_MF"
       },
       {
        "name": "Kyle Westfall",
        "code": "_KW"
       },
       {
        "name": "Justin Sellers",
        "code": "_JS"
       },
       {
        "name": "Eric Gringer",
        "code": "_EG"
       },
       {
        "name": "Dave Worby",
        "code": "_DW"
       },
       {
        "name": "David Bontrager",
        "code": "_DB"
       },
       {
        "name": "Bill Donahue",
        "code": "_BD"
       },
       {
        "name": "Brian Bailey",
        "code": "_BB"
       },
       {
        "name": "Alex Lorack",
        "code": "_AL"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "DateInspected",
     "type": "esriFieldTypeDate",
     "alias": "Date Inspected",
     "length": 8,
     "domain": null
    },
    {
     "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": "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": "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": "RepairNotes",
     "type": "esriFieldTypeString",
     "alias": "Repair Notes",
     "length": 200,
     "domain": null
    },
    {
     "name": "FlushTime",
     "type": "esriFieldTypeDouble",
     "alias": "Flush Time in Minutes",
     "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": "NOTES",
     "type": "esriFieldTypeString",
     "alias": "NOTES",
     "length": 1000,
     "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": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "SDE.wHydrantR",
     "relatedTableId": 3,
     "role": "esriRelRoleDestination",
     "keyField": "FACILITYKEY",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}"
    }
   ],
   "capabilities": "Map,Query,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,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1694167777000
   },
   "serviceItemId": "7bc86292d3a540db8598ac1a5de732f5"
  }
 ]
}