{
 "layers": [
  {
   "currentVersion": 11.1,
   "cimVersion": "3.1.0",
   "id": 0,
   "name": "Water Hydrants",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102745,
    "latestWkid": 5646,
    "xyTolerance": 0.0032808333333333335,
    "zTolerance": 2.0E-5,
    "mTolerance": 2.0E-5,
    "falseX": -17463800,
    "falseY": -46132600,
    "xyUnits": 3048.0060960121914,
    "falseZ": 0,
    "zUnits": 400000,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       0,
       112,
       255,
       255
      ],
      "size": 12,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0.6
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 1438115.2840203382,
    "ymin": 710030.3119273409,
    "xmax": 1462813.5610672534,
    "ymax": 740172.4849105924,
    "spatialReference": {
     "wkid": 102745,
     "latestWkid": 5646,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -16807500,
     "falseY": -48256900,
     "xyUnits": 3048.0060960121928,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "SDELOADER.Infrastructure_wHydrant.FACILITYID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "SDELOADER.Infrastructure_wHydrant.OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "SHAPE",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.ASSETID",
     "type": "esriFieldTypeString",
     "alias": "ASSETID",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.FACILITYID",
     "type": "esriFieldTypeString",
     "alias": "FACILITYID",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.INSTALLDATE",
     "type": "esriFieldTypeDate",
     "alias": "INSTALLDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LOCDESC",
     "type": "esriFieldTypeString",
     "alias": "LOCDESC",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.ROTATION",
     "type": "esriFieldTypeDouble",
     "alias": "ROTATION",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.MANUFACTURER",
     "type": "esriFieldTypeString",
     "alias": "MANUFACTURER",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantManufacturer",
      "description": "The name of the hydrant manufacturer",
      "codedValues": [
       {
        "name": "American Darling",
        "code": "American Darling"
       },
       {
        "name": "Dresser",
        "code": "Dresser"
       },
       {
        "name": "Kennedy Valve",
        "code": "Kennedy Valve"
       },
       {
        "name": "M&H Valve",
        "code": "M&H Valve"
       },
       {
        "name": "M&H Valve / Dresser",
        "code": "M&H Valve / Dresser"
       },
       {
        "name": "Mueller Company",
        "code": "Mueller Company"
       },
       {
        "name": "US Pipe",
        "code": "US Pipe"
       },
       {
        "name": "Wood-Matthews",
        "code": "Wood-Matthews"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "Eddy",
        "code": "Eddy"
       },
       {
        "name": "Traverse City",
        "code": "Traverse City"
       },
       {
        "name": "Waterous",
        "code": "Waterous"
       },
       {
        "name": "Lange",
        "code": "Lange"
       },
       {
        "name": "Smith",
        "code": "Smith"
       },
       {
        "name": "RD Wood",
        "code": "RD Wood"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.OPERABLE",
     "type": "esriFieldTypeDouble",
     "alias": "OPERABLE",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LASTSERVICE",
     "type": "esriFieldTypeDate",
     "alias": "LASTSERVICE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.ENABLED",
     "type": "esriFieldTypeString",
     "alias": "ENABLED",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.ACTIVEFLAG",
     "type": "esriFieldTypeDouble",
     "alias": "ACTIVEFLAG",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LASTUPDATE",
     "type": "esriFieldTypeDate",
     "alias": "LASTUPDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LASTEDITOR",
     "type": "esriFieldTypeString",
     "alias": "LASTEDITOR",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.GPSDATE",
     "type": "esriFieldTypeDate",
     "alias": "GPSDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.GPSSTATUS",
     "type": "esriFieldTypeString",
     "alias": "GPSSTATUS",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.GPSID",
     "type": "esriFieldTypeDouble",
     "alias": "GPSID",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.NORTHING",
     "type": "esriFieldTypeDouble",
     "alias": "NORTHING",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.EASTING",
     "type": "esriFieldTypeDouble",
     "alias": "EASTING",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.NEWORREPLACE",
     "type": "esriFieldTypeString",
     "alias": "NEWORREPLACE",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.MODEL",
     "type": "esriFieldTypeString",
     "alias": "MODEL",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LASTFLOWDATE",
     "type": "esriFieldTypeDate",
     "alias": "LASTFLOWDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LASTFLUSHDATE",
     "type": "esriFieldTypeDate",
     "alias": "LASTFLUSHDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.MAINSIZE",
     "type": "esriFieldTypeString",
     "alias": "MAINSIZE",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.HAS_TAG",
     "type": "esriFieldTypeString",
     "alias": "HAS_TAG",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.DEMELEV",
     "type": "esriFieldTypeDouble",
     "alias": "DEMELEV",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.MANUYEAR",
     "type": "esriFieldTypeString",
     "alias": "MANUYEAR",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.CLASS",
     "type": "esriFieldTypeString",
     "alias": "CLASS",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.STATICPRES",
     "type": "esriFieldTypeString",
     "alias": "STATICPRES",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.RESIDPRES",
     "type": "esriFieldTypeString",
     "alias": "RESIDPRES",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.FLOW",
     "type": "esriFieldTypeString",
     "alias": "FLOW",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.SUPELEV",
     "type": "esriFieldTypeString",
     "alias": "SUPELEV",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.PoF",
     "type": "esriFieldTypeString",
     "alias": "PoF",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.CoF",
     "type": "esriFieldTypeString",
     "alias": "CoF",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.GlobalID",
     "type": "esriFieldTypeString",
     "alias": "GlobalID",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.OWNEDBY",
     "type": "esriFieldTypeString",
     "alias": "OWNEDBY",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.MAINTBY",
     "type": "esriFieldTypeString",
     "alias": "MAINTBY",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.created_date",
     "type": "esriFieldTypeString",
     "alias": "created_date",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.GlobalID_1",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID_1",
     "length": 38,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrant.LifeStatus",
     "type": "esriFieldTypeString",
     "alias": "Life Status",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "wLifeStatus",
      "description": "Infrastructure is Active (in use) or Abandoned",
      "codedValues": [
       {
        "name": "Active (in use)",
        "code": "Active"
       },
       {
        "name": "Abandoned in place",
        "code": "Abandoned In"
       },
       {
        "name": "Abandoned (removed)",
        "code": "Abandoned Ex"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OBJECTID",
     "type": "esriFieldTypeInteger",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSSTART",
     "type": "esriFieldTypeDate",
     "alias": "Start DateTime",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSDATE",
     "type": "esriFieldTypeDate",
     "alias": "Inspection Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.ASSETID",
     "type": "esriFieldTypeString",
     "alias": "Asset ID",
     "length": 20,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.NOTES",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.HYDRCOND",
     "type": "esriFieldTypeString",
     "alias": "Hydrant Condition",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "wOpsConditionText",
      "description": "The operational condition of the facility or asset",
      "codedValues": [
       {
        "name": "New",
        "code": "New"
       },
       {
        "name": "Good",
        "code": "Good"
       },
       {
        "name": "Fair",
        "code": "Fair"
       },
       {
        "name": "Poor",
        "code": "Poor"
       },
       {
        "name": "Failed",
        "code": "Failed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OPERHARD",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Hard to Operate",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OPERABLE",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Operable",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.CORRODED",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Corroded",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.FLOW",
     "type": "esriFieldTypeDouble",
     "alias": "Flow Rate (Gall/Min)",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.STATIC",
     "type": "esriFieldTypeDouble",
     "alias": "Static Pressure (PSI)",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.MTCERQRD",
     "type": "esriFieldTypeString",
     "alias": "Maintenance Required",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSEND",
     "type": "esriFieldTypeDate",
     "alias": "End DateTime",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.WORKKEY",
     "type": "esriFieldTypeString",
     "alias": "Workorder ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSPECTID",
     "type": "esriFieldTypeString",
     "alias": "Inspection ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.FACILITYKEY",
     "type": "esriFieldTypeString",
     "alias": "Hydrant ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSPECTOR",
     "type": "esriFieldTypeString",
     "alias": "Inspection User",
     "length": 50,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.INSSTATUS",
     "type": "esriFieldTypeString",
     "alias": "Inspection Status",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "InspectStatus",
      "description": "The status of the inspection",
      "codedValues": [
       {
        "name": "Unassigned",
        "code": "Unassigned"
       },
       {
        "name": "Assigned",
        "code": "Assigned"
       },
       {
        "name": "In Progress",
        "code": "In Progress"
       },
       {
        "name": "Completed",
        "code": "Completed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.ROTATION",
     "type": "esriFieldTypeDouble",
     "alias": "Rotation",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.LASTUPDATE",
     "type": "esriFieldTypeDate",
     "alias": "Last Update Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.LASTEDITOR",
     "type": "esriFieldTypeString",
     "alias": "Last Editor",
     "length": 50,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.GlobalID",
     "type": "esriFieldTypeGUID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.WorkOrderSub",
     "type": "esriFieldTypeString",
     "alias": "Workorder Sub-Type",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wWordOrderSub",
      "description": "Water Resources Asset Work sub-type",
      "codedValues": [
       {
        "name": "Inspection",
        "code": "IS"
       },
       {
        "name": "Repair",
        "code": "RP"
       },
       {
        "name": "Replacement",
        "code": "RPL"
       },
       {
        "name": "Exercise",
        "code": "EX"
       },
       {
        "name": "Flushing",
        "code": "FL"
       },
       {
        "name": "Flow Test",
        "code": "FT"
       },
       {
        "name": "Leak Detection",
        "code": "LD"
       },
       {
        "name": "Shut Off",
        "code": "SO"
       },
       {
        "name": "Clean Out",
        "code": "CO"
       },
       {
        "name": "New Install",
        "code": "NI"
       },
       {
        "name": "Pothole Repair (>3\")",
        "code": "PR"
       },
       {
        "name": "Shallow Pothole Repair",
        "code": "PRS"
       },
       {
        "name": "Patch",
        "code": "PAT"
       },
       {
        "name": "Painting",
        "code": "PAINT"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.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": "Dresser",
        "code": "Dresser"
       },
       {
        "name": "Kennedy Valve",
        "code": "Kennedy Valve"
       },
       {
        "name": "M&H Valve",
        "code": "M&H Valve"
       },
       {
        "name": "M&H Valve / Dresser",
        "code": "M&H Valve / Dresser"
       },
       {
        "name": "Mueller Company",
        "code": "Mueller Company"
       },
       {
        "name": "US Pipe",
        "code": "US Pipe"
       },
       {
        "name": "Wood-Matthews",
        "code": "Wood-Matthews"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "Eddy",
        "code": "Eddy"
       },
       {
        "name": "Traverse City",
        "code": "Traverse City"
       },
       {
        "name": "Waterous",
        "code": "Waterous"
       },
       {
        "name": "Lange",
        "code": "Lange"
       },
       {
        "name": "Smith",
        "code": "Smith"
       },
       {
        "name": "RD Wood",
        "code": "RD Wood"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.MODEL",
     "type": "esriFieldTypeString",
     "alias": "Model",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantModel",
      "description": "The Model name of the hydrant",
      "codedValues": [
       {
        "name": "1280 (Kennedy)",
        "code": "1280"
       },
       {
        "name": "B62B (American Darling)",
        "code": "B62B"
       },
       {
        "name": "B50B (American Darling)",
        "code": "B50B"
       },
       {
        "name": "K-10 (Kennedy)",
        "code": "K-10"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "K81D (Kennedy)",
        "code": "K81D"
       },
       {
        "name": "B62B-1 (American Darling)",
        "code": "B62B-1"
       },
       {
        "name": "B62B-5 (American Darling)",
        "code": "B62B-5"
       },
       {
        "name": "K81A",
        "code": "K81A"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.MODELYR",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Model Year",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.RESIDUAL",
     "type": "esriFieldTypeInteger",
     "alias": "Residual Pressure (PSI)",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.PAINT",
     "type": "esriFieldTypeString",
     "alias": "Paint",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantPaint",
      "description": "Assessment of Hydrant Paint",
      "codedValues": [
       {
        "name": "OK",
        "code": "OK"
       },
       {
        "name": "Repainted",
        "code": "Repainted"
       },
       {
        "name": "Needed",
        "code": "Needed"
       },
       {
        "name": "Other",
        "code": "Other"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OPERNUT",
     "type": "esriFieldTypeString",
     "alias": "Operating Nut",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantOperatingNut",
      "description": "Assessment of operating nut",
      "codedValues": [
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Working",
        "code": "Working"
       },
       {
        "name": "Greased",
        "code": "Greased"
       },
       {
        "name": "Replace",
        "code": "Replace"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.GATEVALVE",
     "type": "esriFieldTypeString",
     "alias": "Gate Valve Located?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.TURNSOPEN",
     "type": "esriFieldTypeDouble",
     "alias": "Turns to Open",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.DIRECTIONOPEN",
     "type": "esriFieldTypeString",
     "alias": "Direction to Open",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wDirectionToOpen",
      "description": "right or left indicator",
      "codedValues": [
       {
        "name": "Right",
        "code": "Right"
       },
       {
        "name": "Left",
        "code": "Left"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.FLUSHED",
     "type": "esriFieldTypeString",
     "alias": "Flushed?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.TOTALRUN",
     "type": "esriFieldTypeDouble",
     "alias": "Total Flush Time (min)",
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.CLEARANCE",
     "type": "esriFieldTypeString",
     "alias": "3' Clearance?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.RISERHEIGHT",
     "type": "esriFieldTypeString",
     "alias": "Riser Height",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "Condition",
      "description": "Excellent to Imm Attn",
      "codedValues": [
       {
        "name": "Excellent",
        "code": "Excellent"
       },
       {
        "name": "Good",
        "code": "Good"
       },
       {
        "name": "Fair",
        "code": "Fair"
       },
       {
        "name": "Poor",
        "code": "Poor"
       },
       {
        "name": "Very Poor",
        "code": "Very Poor"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "Needs Attention",
        "code": "Needs Attention"
       },
       {
        "name": "Needs Immediate Attention",
        "code": "Needs Immediat Attn"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.TAGNUM",
     "type": "esriFieldTypeString",
     "alias": "Tag Number",
     "length": 4,
     "domain": null
    },
    {
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.chlorine",
     "type": "esriFieldTypeSingle",
     "alias": "Free Chlorine",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "SDELOADER.Infrastructure_wHydrant.Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "SHAPE"
   },
   "indexes": [
    {
     "name": "R2966_pk",
     "fields": "SDELOADER.Infrastructure_wHydrant.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_38910_ASSETI",
     "fields": "SDELOADER.Infrastructure_wHydrant.ASSETID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_38910_FACILI",
     "fields": "SDELOADER.Infrastructure_wHydrant.FACILITYID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_2966",
     "fields": "SDELOADER.Infrastructure_wHydrant.GlobalID_1",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_OID_2966",
     "fields": "SDELOADER.Infrastructure_wHydrant.GlobalID_1,SDELOADER.Infrastructure_wHydrant.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S1946_idx",
     "fields": "SDELOADER.Infrastructure_wHydrant.Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "R1660_SDE_ROWID_UK",
     "fields": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "G4156FACILITYKEY",
     "fields": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.FACILITYKEY",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_4156_ASSETID",
     "fields": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.ASSETID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_1660",
     "fields": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_1660",
     "fields": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder.GlobalID,SDELOADER.Infrastructure_wHydrantFlushingWorkorder.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "SDELOADER.Infrastructure_wHydrantFlushingWorkorder",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "ASSETID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{F55E05FD-02EC-42C1-80D1-151396871066}"
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "hasZ": 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,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "e5af365677794daba31644ad794744b4"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.1,
   "cimVersion": "3.1.0",
   "id": 1,
   "name": "btvgis.SDELOADER.Infrastructure_wHydrantFlushingWorkorder",
   "type": "Table",
   "description": null,
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "INSDATE",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "INSSTART",
     "type": "esriFieldTypeDate",
     "alias": "Start DateTime",
     "length": 8,
     "domain": null
    },
    {
     "name": "INSDATE",
     "type": "esriFieldTypeDate",
     "alias": "Inspection Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "ASSETID",
     "type": "esriFieldTypeString",
     "alias": "Asset ID",
     "length": 20,
     "domain": null
    },
    {
     "name": "NOTES",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "HYDRCOND",
     "type": "esriFieldTypeString",
     "alias": "Hydrant Condition",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "wOpsConditionText",
      "description": "The operational condition of the facility or asset",
      "codedValues": [
       {
        "name": "New",
        "code": "New"
       },
       {
        "name": "Good",
        "code": "Good"
       },
       {
        "name": "Fair",
        "code": "Fair"
       },
       {
        "name": "Poor",
        "code": "Poor"
       },
       {
        "name": "Failed",
        "code": "Failed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "OPERHARD",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Hard to Operate",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "OPERABLE",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Operable",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "CORRODED",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Corroded",
     "domain": {
      "type": "codedValue",
      "name": "BooleanDomain",
      "description": "A 0/1 boolean domain",
      "codedValues": [
       {
        "name": "False",
        "code": 0
       },
       {
        "name": "True",
        "code": 1
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "FLOW",
     "type": "esriFieldTypeDouble",
     "alias": "Flow Rate (Gall/Min)",
     "domain": null
    },
    {
     "name": "STATIC",
     "type": "esriFieldTypeDouble",
     "alias": "Static Pressure (PSI)",
     "domain": null
    },
    {
     "name": "MTCERQRD",
     "type": "esriFieldTypeString",
     "alias": "Maintenance Required",
     "length": 255,
     "domain": null
    },
    {
     "name": "INSEND",
     "type": "esriFieldTypeDate",
     "alias": "End DateTime",
     "length": 8,
     "domain": null
    },
    {
     "name": "WORKKEY",
     "type": "esriFieldTypeString",
     "alias": "Workorder ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "INSPECTID",
     "type": "esriFieldTypeString",
     "alias": "Inspection ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "FACILITYKEY",
     "type": "esriFieldTypeString",
     "alias": "Hydrant ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "INSPECTOR",
     "type": "esriFieldTypeString",
     "alias": "Inspection User",
     "length": 50,
     "domain": null
    },
    {
     "name": "INSSTATUS",
     "type": "esriFieldTypeString",
     "alias": "Inspection Status",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "InspectStatus",
      "description": "The status of the inspection",
      "codedValues": [
       {
        "name": "Unassigned",
        "code": "Unassigned"
       },
       {
        "name": "Assigned",
        "code": "Assigned"
       },
       {
        "name": "In Progress",
        "code": "In Progress"
       },
       {
        "name": "Completed",
        "code": "Completed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "ROTATION",
     "type": "esriFieldTypeDouble",
     "alias": "Rotation",
     "domain": null
    },
    {
     "name": "LASTUPDATE",
     "type": "esriFieldTypeDate",
     "alias": "Last Update Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "LASTEDITOR",
     "type": "esriFieldTypeString",
     "alias": "Last Editor",
     "length": 50,
     "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": "WorkOrderSub",
     "type": "esriFieldTypeString",
     "alias": "Workorder Sub-Type",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wWordOrderSub",
      "description": "Water Resources Asset Work sub-type",
      "codedValues": [
       {
        "name": "Inspection",
        "code": "IS"
       },
       {
        "name": "Repair",
        "code": "RP"
       },
       {
        "name": "Replacement",
        "code": "RPL"
       },
       {
        "name": "Exercise",
        "code": "EX"
       },
       {
        "name": "Flushing",
        "code": "FL"
       },
       {
        "name": "Flow Test",
        "code": "FT"
       },
       {
        "name": "Leak Detection",
        "code": "LD"
       },
       {
        "name": "Shut Off",
        "code": "SO"
       },
       {
        "name": "Clean Out",
        "code": "CO"
       },
       {
        "name": "New Install",
        "code": "NI"
       },
       {
        "name": "Pothole Repair (>3\")",
        "code": "PR"
       },
       {
        "name": "Shallow Pothole Repair",
        "code": "PRS"
       },
       {
        "name": "Patch",
        "code": "PAT"
       },
       {
        "name": "Painting",
        "code": "PAINT"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "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": "Dresser",
        "code": "Dresser"
       },
       {
        "name": "Kennedy Valve",
        "code": "Kennedy Valve"
       },
       {
        "name": "M&H Valve",
        "code": "M&H Valve"
       },
       {
        "name": "M&H Valve / Dresser",
        "code": "M&H Valve / Dresser"
       },
       {
        "name": "Mueller Company",
        "code": "Mueller Company"
       },
       {
        "name": "US Pipe",
        "code": "US Pipe"
       },
       {
        "name": "Wood-Matthews",
        "code": "Wood-Matthews"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "Eddy",
        "code": "Eddy"
       },
       {
        "name": "Traverse City",
        "code": "Traverse City"
       },
       {
        "name": "Waterous",
        "code": "Waterous"
       },
       {
        "name": "Lange",
        "code": "Lange"
       },
       {
        "name": "Smith",
        "code": "Smith"
       },
       {
        "name": "RD Wood",
        "code": "RD Wood"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "MODEL",
     "type": "esriFieldTypeString",
     "alias": "Model",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantModel",
      "description": "The Model name of the hydrant",
      "codedValues": [
       {
        "name": "1280 (Kennedy)",
        "code": "1280"
       },
       {
        "name": "B62B (American Darling)",
        "code": "B62B"
       },
       {
        "name": "B50B (American Darling)",
        "code": "B50B"
       },
       {
        "name": "K-10 (Kennedy)",
        "code": "K-10"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "K81D (Kennedy)",
        "code": "K81D"
       },
       {
        "name": "B62B-1 (American Darling)",
        "code": "B62B-1"
       },
       {
        "name": "B62B-5 (American Darling)",
        "code": "B62B-5"
       },
       {
        "name": "K81A",
        "code": "K81A"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "MODELYR",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Model Year",
     "domain": null
    },
    {
     "name": "RESIDUAL",
     "type": "esriFieldTypeInteger",
     "alias": "Residual Pressure (PSI)",
     "domain": null
    },
    {
     "name": "PAINT",
     "type": "esriFieldTypeString",
     "alias": "Paint",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantPaint",
      "description": "Assessment of Hydrant Paint",
      "codedValues": [
       {
        "name": "OK",
        "code": "OK"
       },
       {
        "name": "Repainted",
        "code": "Repainted"
       },
       {
        "name": "Needed",
        "code": "Needed"
       },
       {
        "name": "Other",
        "code": "Other"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "OPERNUT",
     "type": "esriFieldTypeString",
     "alias": "Operating Nut",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wHydrantOperatingNut",
      "description": "Assessment of operating nut",
      "codedValues": [
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Working",
        "code": "Working"
       },
       {
        "name": "Greased",
        "code": "Greased"
       },
       {
        "name": "Replace",
        "code": "Replace"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "GATEVALVE",
     "type": "esriFieldTypeString",
     "alias": "Gate Valve Located?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "TURNSOPEN",
     "type": "esriFieldTypeDouble",
     "alias": "Turns to Open",
     "domain": null
    },
    {
     "name": "DIRECTIONOPEN",
     "type": "esriFieldTypeString",
     "alias": "Direction to Open",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "wDirectionToOpen",
      "description": "right or left indicator",
      "codedValues": [
       {
        "name": "Right",
        "code": "Right"
       },
       {
        "name": "Left",
        "code": "Left"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "FLUSHED",
     "type": "esriFieldTypeString",
     "alias": "Flushed?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "TOTALRUN",
     "type": "esriFieldTypeDouble",
     "alias": "Total Flush Time (min)",
     "domain": null
    },
    {
     "name": "CLEARANCE",
     "type": "esriFieldTypeString",
     "alias": "3' Clearance?",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "YesNoUnableToVerify",
      "description": "A yes/no indicator",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Unable to Verify",
        "code": "Unable to Verify"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "RISERHEIGHT",
     "type": "esriFieldTypeString",
     "alias": "Riser Height",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "Condition",
      "description": "Excellent to Imm Attn",
      "codedValues": [
       {
        "name": "Excellent",
        "code": "Excellent"
       },
       {
        "name": "Good",
        "code": "Good"
       },
       {
        "name": "Fair",
        "code": "Fair"
       },
       {
        "name": "Poor",
        "code": "Poor"
       },
       {
        "name": "Very Poor",
        "code": "Very Poor"
       },
       {
        "name": "Unknown",
        "code": "Unknown"
       },
       {
        "name": "Needs Attention",
        "code": "Needs Attention"
       },
       {
        "name": "Needs Immediate Attention",
        "code": "Needs Immediat Attn"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "TAGNUM",
     "type": "esriFieldTypeString",
     "alias": "Tag Number",
     "length": 4,
     "domain": null
    },
    {
     "name": "chlorine",
     "type": "esriFieldTypeSingle",
     "alias": "Free Chlorine",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R1660_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "G4156FACILITYKEY",
     "fields": "FACILITYKEY",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_4156_ASSETID",
     "fields": "ASSETID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_1660",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_1660",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "SDELOADER.Infrastructure_wHydrant",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "ASSETID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{F55E05FD-02EC-42C1-80D1-151396871066}"
    }
   ],
   "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,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "e5af365677794daba31644ad794744b4"
  }
 ]
}