{
 "currentVersion": 11.4,
 "cimVersion": "3.4.0",
 "id": 32,
 "name": "Water Service Account and Address",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NOTES",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ACCNT_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "ACCNT_NUM\n",
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES\n",
   "length": 256,
   "domain": null
  },
  {
   "name": "HOUSE_NUM",
   "type": "esriFieldTypeInteger",
   "alias": "HOUSE_NUM\n",
   "domain": null
  },
  {
   "name": "HOUSE_FRAC",
   "type": "esriFieldTypeString",
   "alias": "HOUSE_FRAC\n",
   "length": 10,
   "domain": null
  },
  {
   "name": "STRT_PRE",
   "type": "esriFieldTypeString",
   "alias": "STRT_PRE\n",
   "length": 10,
   "domain": null
  },
  {
   "name": "STREET",
   "type": "esriFieldTypeString",
   "alias": "STREET\n",
   "length": 100,
   "domain": null
  },
  {
   "name": "STRT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "STRT_TYPE\n",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "wStreetType",
    "description": "Type of street",
    "codedValues": [
     {
      "name": "ALLEY",
      "code": "ALY"
     },
     {
      "name": "AVENUE",
      "code": "AVE"
     },
     {
      "name": "BOULEVARD",
      "code": "BLVD"
     },
     {
      "name": "BEND",
      "code": "BND"
     },
     {
      "name": "CIRCLE",
      "code": "CIR"
     },
     {
      "name": "COURT",
      "code": "CT"
     },
     {
      "name": "DRIVE",
      "code": "DR"
     },
     {
      "name": "GLEN",
      "code": "GLN"
     },
     {
      "name": "GREEN",
      "code": "GRN"
     },
     {
      "name": "HIGHWAY",
      "code": "HWY"
     },
     {
      "name": "KNOLL",
      "code": "KNL"
     },
     {
      "name": "LANE",
      "code": "LN"
     },
     {
      "name": "LOOP",
      "code": "LOOP"
     },
     {
      "name": "PARKWAY",
      "code": "PKWY"
     },
     {
      "name": "PLACE",
      "code": "PL"
     },
     {
      "name": "ROAD",
      "code": "RD"
     },
     {
      "name": "RIDGE",
      "code": "RDG"
     },
     {
      "name": "STREET",
      "code": "ST"
     },
     {
      "name": "TERRACE",
      "code": "TER"
     },
     {
      "name": "TRAIL",
      "code": "TRL"
     },
     {
      "name": "WAY",
      "code": "WAY"
     },
     {
      "name": "HILL",
      "code": "HL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "STRT_POST",
   "type": "esriFieldTypeString",
   "alias": "STRT_POST\n",
   "length": 10,
   "domain": null
  },
  {
   "name": "H_UNIT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "H_UNIT_TYPE\n",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "wHouseUnitType",
    "description": "Category of house unit number/letter",
    "codedValues": [
     {
      "name": "APARTMENT",
      "code": "APT"
     },
     {
      "name": "BUILDING",
      "code": "BLDG"
     },
     {
      "name": "LOT",
      "code": "LOT"
     },
     {
      "name": "SUITE",
      "code": "STE"
     },
     {
      "name": "UNIT",
      "code": "UNIT"
     },
     {
      "name": "REAR",
      "code": "REAR"
     },
     {
      "name": "GLEN",
      "code": "GLEN"
     },
     {
      "name": "TERRACE",
      "code": "TERRACE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "H_UNIT",
   "type": "esriFieldTypeString",
   "alias": "H_UNIT\n",
   "length": 10,
   "domain": null
  },
  {
   "name": "ADDRESS1",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS1\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "ADDRESS2",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS2\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "LOT_NUM",
   "type": "esriFieldTypeString",
   "alias": "LOT_NUM\n",
   "length": 20,
   "domain": null
  },
  {
   "name": "BILL_GRP",
   "type": "esriFieldTypeString",
   "alias": "BILL_GRP\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "STBX_ID",
   "type": "esriFieldTypeInteger",
   "alias": "STBX_ID",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "CORP_ID",
   "type": "esriFieldTypeInteger",
   "alias": "CORP_ID",
   "domain": null
  },
  {
   "name": "PIPE_MAT",
   "type": "esriFieldTypeString",
   "alias": "Pipe Mat",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wPipeMaterial",
    "description": "Water pipe material type",
    "codedValues": [
     {
      "name": "CAST",
      "code": "CAST"
     },
     {
      "name": "CEMENT",
      "code": "CEMENT"
     },
     {
      "name": "COPPER",
      "code": "COPPER"
     },
     {
      "name": "DI",
      "code": "DI"
     },
     {
      "name": "GALV",
      "code": "GALV"
     },
     {
      "name": "HDPE",
      "code": "HDPE"
     },
     {
      "name": "PVC",
      "code": "PVC"
     },
     {
      "name": "STAINLESS",
      "code": "STAINLESS"
     },
     {
      "name": "UNKNOWN",
      "code": "UNK"
     },
     {
      "name": "LEAD",
      "code": "LEAD"
     },
     {
      "name": "PLASTIC",
      "code": "PLASTIC"
     },
     {
      "name": "BRASS",
      "code": "BRASS"
     },
     {
      "name": "BLACK IRON",
      "code": "BLACK IRON"
     },
     {
      "name": "ASBESTOS CEMENT",
      "code": "ASBESTOS CEMENT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DATE_REC",
   "type": "esriFieldTypeDate",
   "alias": "Date Rec",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R973_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_3863_STBX_ID",
   "fields": "STBX_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_973",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_973",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "SDE.wServiceConnect",
   "relatedTableId": 14,
   "role": "esriRelRoleDestination",
   "keyField": "STBX_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{3BA0FCB4-A5F1-49E6-8EEE-7684B41F0143}"
  },
  {
   "id": 1,
   "name": "SDE.wServiceValve",
   "relatedTableId": 13,
   "role": "esriRelRoleDestination",
   "keyField": "STBX_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{0FE10D90-251C-4DAE-BC9F-34C1E0A40CCE}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 3000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Central Standard Time",
  "timeZoneIANA": "Etc/GMT+6",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1694168274000
 },
 "serviceItemId": "8a71d31558cb48f8b8d08ea4ef34c250"
}