{
 "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
 }
}