{
 "layers": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 0,
   "name": "Water Hydrant",
   "type": "Feature Layer",
   "description": "Inventory of fire hydrants owned and maintained by Madison Water Utility. Also contains known private hydrants. Private hydrants are not actively maintained in this dataset and should not be considered current. The inventory of utility maintained hydrants is actively maintained and updated daily.",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 103412,
    "latestWkid": 8193,
    "xyTolerance": 2.0E-4,
    "zTolerance": 2.0E-5,
    "mTolerance": 2.0E-5,
    "falseX": -4.503599627370495E11,
    "falseY": -4.503599627370495E11,
    "xyUnits": 10000,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 100000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       0,
       145,
       90,
       255
      ],
      "size": 4,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 771125.2385253906,
    "ymin": 456112.33999884676,
    "xmax": 857856.4724731445,
    "ymax": 518254.2264905726,
    "spatialReference": {
     "wkid": 103412,
     "latestWkid": 8193,
     "xyTolerance": 2.0E-4,
     "zTolerance": 2,
     "mTolerance": 0.001,
     "falseX": -119400400,
     "falseY": -97309100,
     "xyUnits": 3.746399781859703E7,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "CreatedBy",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "FacilityID",
     "type": "esriFieldTypeString",
     "alias": "FacilityID",
     "length": 20,
     "domain": null
    },
    {
     "name": "InstallDate",
     "type": "esriFieldTypeDate",
     "alias": "InstallDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "LifecycleStatus",
     "type": "esriFieldTypeString",
     "alias": "LifecycleStatus",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "wDomainLifecycleStatus",
      "description": "",
      "codedValues": [
       {
        "name": "Active",
        "code": "ACT"
       },
       {
        "name": "Inactive",
        "code": "INA"
       },
       {
        "name": "Proposed",
        "code": "PRO"
       },
       {
        "name": "Abandoned",
        "code": "ABN"
       },
       {
        "name": "Removed",
        "code": "REM"
       },
       {
        "name": "Retired",
        "code": "RET"
       },
       {
        "name": "Salvaged",
        "code": "SVG"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "Location",
     "type": "esriFieldTypeString",
     "alias": "LocationDescription",
     "length": 250,
     "domain": null
    },
    {
     "name": "SymbolRotation",
     "type": "esriFieldTypeDouble",
     "alias": "SymbolRotation",
     "domain": null
    },
    {
     "name": "Manufacturer",
     "type": "esriFieldTypeString",
     "alias": "Manufacturer",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "wDomainManufacturer",
      "description": "",
      "codedValues": [
       {
        "name": "American Darling",
        "code": "AMERD"
       },
       {
        "name": "American Flow Control",
        "code": "AMERF"
       },
       {
        "name": "APCO Valve & Primer",
        "code": "APCO"
       },
       {
        "name": "Cascade",
        "code": "CASCADE"
       },
       {
        "name": "Corey",
        "code": "COREY"
       },
       {
        "name": "Crispin Valve",
        "code": "CRISPIN"
       },
       {
        "name": "Henry Pratt Co",
        "code": "HPC"
       },
       {
        "name": "James Jones Company",
        "code": "JJC"
       },
       {
        "name": "John Foundry",
        "code": "JF"
       },
       {
        "name": "John Smith",
        "code": "JS"
       },
       {
        "name": "Kennedy",
        "code": "KENNEDY"
       },
       {
        "name": "M&H",
        "code": "MH"
       },
       {
        "name": "McManus",
        "code": "MCMANUS"
       },
       {
        "name": "Mueller Company",
        "code": "MUELLER"
       },
       {
        "name": "Pacific States",
        "code": "PACIFIC"
       },
       {
        "name": "Pacer",
        "code": "PACER"
       },
       {
        "name": "US Pipe",
        "code": "USPIPE"
       },
       {
        "name": "Val-Matic",
        "code": "VALMATIC"
       },
       {
        "name": "Waterous",
        "code": "WATEROUS"
       },
       {
        "name": "Unknown",
        "code": "UNK"
       },
       {
        "name": "Other",
        "code": "OTHER"
       },
       {
        "name": "Clow",
        "code": "CLOW"
       },
       {
        "name": "Rensselaer",
        "code": "REN"
       },
       {
        "name": "United Water Products",
        "code": "UNITED"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "Style",
     "type": "esriFieldTypeString",
     "alias": "Style",
     "length": 25,
     "domain": null
    },
    {
     "name": "year_manufactured",
     "type": "esriFieldTypeInteger",
     "alias": "year_manufactured",
     "domain": null
    },
    {
     "name": "InstallYear",
     "type": "esriFieldTypeSmallInteger",
     "alias": "InstallYear",
     "domain": null
    },
    {
     "name": "Hyd_Model",
     "type": "esriFieldTypeString",
     "alias": "Hyd_Model",
     "length": 25,
     "domain": null
    },
    {
     "name": "nozzle_color",
     "type": "esriFieldTypeString",
     "alias": "nozzle_color",
     "length": 10,
     "domain": null
    },
    {
     "name": "MaintainedBy",
     "type": "esriFieldTypeString",
     "alias": "MaintainedBy",
     "length": 25,
     "domain": {
      "type": "codedValue",
      "name": "wDomainMaintainedBy",
      "description": "",
      "codedValues": [
       {
        "name": "Madison Water Utility",
        "code": "MADISON WATER UTILITY"
       },
       {
        "name": "Private",
        "code": "PRIVATE"
       },
       {
        "name": "Other",
        "code": "OTHER"
       },
       {
        "name": "MWU (PVT)",
        "code": "MWU PVT"
       },
       {
        "name": "Town of Madison",
        "code": "MADTOWN"
       },
       {
        "name": "Waunona San Dist #2",
        "code": "WAUN"
       },
       {
        "name": "Lake Forest Water COOP",
        "code": "LFWC"
       },
       {
        "name": "Madison Gas and Electric",
        "code": "MGE"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "Municipality",
     "type": "esriFieldTypeString",
     "alias": "Municipality",
     "length": 30,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R391_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "G4028FacilityID",
     "fields": "FacilityID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "I4028LifecycleSt",
     "fields": "LifecycleStatus",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "idxHydrantRotati",
     "fields": "SymbolRotation",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S182_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "hasM": 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
  }
 ],
 "tables": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 1,
   "name": "Water.DATA_ADMIN6.tblLSLMaterialsInventory",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "SITEID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SITEID",
     "type": "esriFieldTypeString",
     "alias": "SITE ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "LOCATIONID",
     "type": "esriFieldTypeString",
     "alias": "LOCATIONAL IDENTIFIER",
     "length": 50,
     "domain": null
    },
    {
     "name": "LEAD_GOOSENECK",
     "type": "esriFieldTypeString",
     "alias": "LEAD GOOSENECK CURRENTLY PRESENT",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvYesNo",
      "description": "",
      "codedValues": [
       {
        "name": "Y",
        "code": "Y"
       },
       {
        "name": "N",
        "code": "N"
       },
       {
        "name": "UNK",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "MATERIAL",
     "type": "esriFieldTypeString",
     "alias": "CURRENT STREET SIDE SERVIC LINE MATERIAL",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "domInvMaterial",
      "description": "",
      "codedValues": [
       {
        "name": "CONFIRMED LEAD",
        "code": "L"
       },
       {
        "name": "CONFIRMED COPPER",
        "code": "C"
       },
       {
        "name": "CONFIRMED GALVANIZED",
        "code": "G"
       },
       {
        "name": "CONFIRMED PLASTIC",
        "code": "P"
       },
       {
        "name": "CONFIRMED DUCTILE IRON",
        "code": "DI"
       },
       {
        "name": "CONFIRMED LINED CAST IRON",
        "code": "CI-L"
       },
       {
        "name": "CONFIRMED UNLINED CAST IRON",
        "code": "CI-U"
       },
       {
        "name": "UNKNOWN - MAY CONTAIN LEAD OR GALVANIZED",
        "code": "UNK-LG"
       },
       {
        "name": "UNKNOWN - DEFINITELY DOES NOT CONTAIN LEAD OR GALVANIZED",
        "code": "UNK-NOLG"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "PREVIOUSLY_LEAD",
     "type": "esriFieldTypeString",
     "alias": "WAS STREET SIDE SERVICE LINE EVER PREVIOUSLY LEAD",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvYesNo",
      "description": "",
      "codedValues": [
       {
        "name": "Y",
        "code": "Y"
       },
       {
        "name": "N",
        "code": "N"
       },
       {
        "name": "UNK",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SIZE",
     "type": "esriFieldTypeString",
     "alias": "STREET SIDE SERVICE LINE SIZE",
     "length": 10,
     "domain": null
    },
    {
     "name": "INSTALLDATE",
     "type": "esriFieldTypeInteger",
     "alias": "STREET SIDE SERVICE LINE INSTALL DATE",
     "domain": null
    },
    {
     "name": "POMATERIAL",
     "type": "esriFieldTypeString",
     "alias": "CURRENT PROPERTY SIDE SERVICE LINE MATERIAL",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "domInvMaterial",
      "description": "",
      "codedValues": [
       {
        "name": "CONFIRMED LEAD",
        "code": "L"
       },
       {
        "name": "CONFIRMED COPPER",
        "code": "C"
       },
       {
        "name": "CONFIRMED GALVANIZED",
        "code": "G"
       },
       {
        "name": "CONFIRMED PLASTIC",
        "code": "P"
       },
       {
        "name": "CONFIRMED DUCTILE IRON",
        "code": "DI"
       },
       {
        "name": "CONFIRMED LINED CAST IRON",
        "code": "CI-L"
       },
       {
        "name": "CONFIRMED UNLINED CAST IRON",
        "code": "CI-U"
       },
       {
        "name": "UNKNOWN - MAY CONTAIN LEAD OR GALVANIZED",
        "code": "UNK-LG"
       },
       {
        "name": "UNKNOWN - DEFINITELY DOES NOT CONTAIN LEAD OR GALVANIZED",
        "code": "UNK-NOLG"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "POSIZE",
     "type": "esriFieldTypeString",
     "alias": "PROPERTY SIZE SERVICE LINE SIZE",
     "length": 10,
     "domain": null
    },
    {
     "name": "POINSTALLDATE",
     "type": "esriFieldTypeInteger",
     "alias": "PROPERTY SIDE SERVICE LINE INSTALL DATE",
     "domain": null
    },
    {
     "name": "BUILDINGTYPE",
     "type": "esriFieldTypeString",
     "alias": "BUILDING TYPE",
     "length": 10,
     "domain": {
      "type": "codedValue",
      "name": "domInvBuildingType",
      "description": "",
      "codedValues": [
       {
        "name": "SINGLE-FAMILY RESIDENTIAL",
        "code": "SF"
       },
       {
        "name": "MULTI-FAMILY RESIDENTIAL",
        "code": "MF"
       },
       {
        "name": "SCHOOL OR CHILD CARE",
        "code": "SCH/CC"
       },
       {
        "name": "RESIDENTIAL & IN-HOME CHILD CARE",
        "code": "RES/CC"
       },
       {
        "name": "NONRESIDENTIAL ONLY, NO SCHOOL OR CHILD CARE",
        "code": "NONRES"
       },
       {
        "name": "MIXED RESIDENTIAL & NONRESIDENTIAL, NO SCHOOL OR CHILD CARE",
        "code": "MIX"
       },
       {
        "name": "OTHER",
        "code": "O"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "POE_TREATMENT",
     "type": "esriFieldTypeString",
     "alias": "POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvYesNo",
      "description": "",
      "codedValues": [
       {
        "name": "Y",
        "code": "Y"
       },
       {
        "name": "N",
        "code": "N"
       },
       {
        "name": "UNK",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BUILDINGMATERIAL1",
     "type": "esriFieldTypeString",
     "alias": "BUILDING PLUMBING MATERIAL 1",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvBldgPlumbingMat",
      "description": "",
      "codedValues": [
       {
        "name": "COPPER WITH LEAD SOLDER",
        "code": "CLS"
       },
       {
        "name": "COPPER, NO LEAD SOLDER",
        "code": "C"
       },
       {
        "name": "OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER",
        "code": "O"
       },
       {
        "name": "UNKNOWN",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BUILDINGMATERIAL2",
     "type": "esriFieldTypeString",
     "alias": "BUILDING PLUMBING MATERIAL 2",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvBldgPlumbingMat",
      "description": "",
      "codedValues": [
       {
        "name": "COPPER WITH LEAD SOLDER",
        "code": "CLS"
       },
       {
        "name": "COPPER, NO LEAD SOLDER",
        "code": "C"
       },
       {
        "name": "OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER",
        "code": "O"
       },
       {
        "name": "UNKNOWN",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BUILDINGMATERIALINSTALLDATE",
     "type": "esriFieldTypeInteger",
     "alias": "BUILDING PLUMBING MATERIAL INSTALL DATE",
     "domain": null
    },
    {
     "name": "COMMENTS",
     "type": "esriFieldTypeString",
     "alias": "COMMENTS",
     "length": 255,
     "domain": null
    },
    {
     "name": "BASIS_MAT_CLASS",
     "type": "esriFieldTypeString",
     "alias": "BASIS OF STREET SIDE MATERIAL CLASSIFICATION",
     "length": 30,
     "domain": {
      "type": "codedValue",
      "name": "domInvBasisofMatClass",
      "description": "",
      "codedValues": [
       {
        "name": "PREVIOUS MATERIALS EVALUATION",
        "code": "PREVIOUS EVAL"
       },
       {
        "name": "INSTALLATION RECORD (EG TAP CARD)",
        "code": "INSTALLATION RECORD"
       },
       {
        "name": "INSTALLATION AFTER LEAD BAN (1986)",
        "code": "INSTALLED AFTER LEAD BAN"
       },
       {
        "name": "SERVICE LINE DIAMETER IS > 2 INCHES",
        "code": "DIAMETER > 2 INCHES"
       },
       {
        "name": "SERVICE LINE REPORT OR REPLACEMENT RECORD",
        "code": "SL REPAIR/REPLACE RECORD"
       },
       {
        "name": "WATER SAMPLING ONLY WITH NO RECORDS",
        "code": "WATER SAMPLING ONLY"
       },
       {
        "name": "FIELD INSPECTION ONLY WITH NO RECORDS",
        "code": "FIELD INSPECTION ONLY"
       },
       {
        "name": "OTHER- DESCRIBE IN NOTES",
        "code": "OTHER - DESCRIBE IN NOTES"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "MAT_FIELD_VERIFIED",
     "type": "esriFieldTypeString",
     "alias": "WAS STREET SIDE MATERIAL FIELD VERIFIED",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvYesNo",
      "description": "",
      "codedValues": [
       {
        "name": "Y",
        "code": "Y"
       },
       {
        "name": "N",
        "code": "N"
       },
       {
        "name": "UNK",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "DATE_VERIFIED",
     "type": "esriFieldTypeDate",
     "alias": "DATE OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE",
     "length": 8,
     "domain": null
    },
    {
     "name": "METHOD_VERIFIED",
     "type": "esriFieldTypeString",
     "alias": "METHOD OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "domInvPropSideVerif",
      "description": "",
      "codedValues": [
       {
        "name": "CUSTOMER SELF IDENTIFICATION",
        "code": "CUSTOMER SELF ID"
       },
       {
        "name": "CCTV AT CURB STOP - INTERNAL",
        "code": "CCTV - INTERNAL"
       },
       {
        "name": "CCTV AT CURB STOP - EXTERNAL",
        "code": "CCTV - EXTERNAL"
       },
       {
        "name": "MECHANICAL EXCAVATION  AT ONE LOCATION",
        "code": "MECH EXCAV"
       },
       {
        "name": "VISUAL INSPECTION AT THE METER PIT",
        "code": "VISUAL INSPECTION AT METER"
       },
       {
        "name": "VISUAL INSPECTION DURING CONSTRUCTION OR REPAIR",
        "code": "VISUAL INSP DURING INSTALL OR REPAIR"
       },
       {
        "name": "CROSS CONNECTION SURVEY",
        "code": "CROSS CONNECTION SURVEY"
       },
       {
        "name": "OTHER - DESCRIBE IN NOTES",
        "code": "OTHER"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BASIS_PO_MAT_CLASS",
     "type": "esriFieldTypeString",
     "alias": "BASIS OF PROPERTY SIDE MATERIAL CLASSIFICATION",
     "length": 30,
     "domain": {
      "type": "codedValue",
      "name": "domInvBasisofMatClass",
      "description": "",
      "codedValues": [
       {
        "name": "PREVIOUS MATERIALS EVALUATION",
        "code": "PREVIOUS EVAL"
       },
       {
        "name": "INSTALLATION RECORD (EG TAP CARD)",
        "code": "INSTALLATION RECORD"
       },
       {
        "name": "INSTALLATION AFTER LEAD BAN (1986)",
        "code": "INSTALLED AFTER LEAD BAN"
       },
       {
        "name": "SERVICE LINE DIAMETER IS > 2 INCHES",
        "code": "DIAMETER > 2 INCHES"
       },
       {
        "name": "SERVICE LINE REPORT OR REPLACEMENT RECORD",
        "code": "SL REPAIR/REPLACE RECORD"
       },
       {
        "name": "WATER SAMPLING ONLY WITH NO RECORDS",
        "code": "WATER SAMPLING ONLY"
       },
       {
        "name": "FIELD INSPECTION ONLY WITH NO RECORDS",
        "code": "FIELD INSPECTION ONLY"
       },
       {
        "name": "OTHER- DESCRIBE IN NOTES",
        "code": "OTHER - DESCRIBE IN NOTES"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "PO_MAT_FIELD",
     "type": "esriFieldTypeString",
     "alias": "WATER PROPERTY SIDE MATERIAL FIELD VERIFIED",
     "length": 5,
     "domain": {
      "type": "codedValue",
      "name": "domInvYesNo",
      "description": "",
      "codedValues": [
       {
        "name": "Y",
        "code": "Y"
       },
       {
        "name": "N",
        "code": "N"
       },
       {
        "name": "UNK",
        "code": "UNK"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "DATE_PO_VERIFIED",
     "type": "esriFieldTypeDate",
     "alias": "DATE OF PROPERTY SIDE FIELD VERIFICATION",
     "length": 8,
     "domain": null
    },
    {
     "name": "METHOD_PO_VERIFIED",
     "type": "esriFieldTypeString",
     "alias": "METHOD OF PROPERTY SIDE FIELD VERIFICATION",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "domInvPropSideVerif",
      "description": "",
      "codedValues": [
       {
        "name": "CUSTOMER SELF IDENTIFICATION",
        "code": "CUSTOMER SELF ID"
       },
       {
        "name": "CCTV AT CURB STOP - INTERNAL",
        "code": "CCTV - INTERNAL"
       },
       {
        "name": "CCTV AT CURB STOP - EXTERNAL",
        "code": "CCTV - EXTERNAL"
       },
       {
        "name": "MECHANICAL EXCAVATION  AT ONE LOCATION",
        "code": "MECH EXCAV"
       },
       {
        "name": "VISUAL INSPECTION AT THE METER PIT",
        "code": "VISUAL INSPECTION AT METER"
       },
       {
        "name": "VISUAL INSPECTION DURING CONSTRUCTION OR REPAIR",
        "code": "VISUAL INSP DURING INSTALL OR REPAIR"
       },
       {
        "name": "CROSS CONNECTION SURVEY",
        "code": "CROSS CONNECTION SURVEY"
       },
       {
        "name": "OTHER - DESCRIBE IN NOTES",
        "code": "OTHER"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "NOTES_MAT_CLASS",
     "type": "esriFieldTypeString",
     "alias": "NOTES_MAT_CLASS",
     "length": 200,
     "domain": null
    },
    {
     "name": "ServiceLateralID",
     "type": "esriFieldTypeString",
     "alias": "ServiceLateralID",
     "length": 25,
     "domain": null
    },
    {
     "name": "PropertyID",
     "type": "esriFieldTypeString",
     "alias": "PropertyID",
     "length": 12,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R659_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "idxPropertyID",
     "fields": "PropertyID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "idxLateralID",
     "fields": "ServiceLateralID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "idxPrevLead",
     "fields": "PREVIOUSLY_LEAD",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}