{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 100,
 "name": "PW.WASHOE.ASSETS_SEWER_EQUIPMENT",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "BUILDING",
   "type": "esriFieldTypeString",
   "alias": "BUILDING",
   "length": 100,
   "domain": null
  },
  {
   "name": "FLOOR",
   "type": "esriFieldTypeString",
   "alias": "FLOOR",
   "length": 2,
   "domain": {
    "type": "codedValue",
    "name": "D_FLOOR",
    "description": "Floor description",
    "codedValues": [
     {
      "name": "Basement",
      "code": "B"
     },
     {
      "name": "Roof",
      "code": "R"
     },
     {
      "name": "Ground Floor",
      "code": "1"
     },
     {
      "name": "2nd Floor",
      "code": "2"
     },
     {
      "name": "3rd Floor",
      "code": "3"
     },
     {
      "name": "4th Floor",
      "code": "4"
     },
     {
      "name": "5th Floor",
      "code": "5"
     },
     {
      "name": "6th Floor",
      "code": "6"
     },
     {
      "name": "7th Floor",
      "code": "7"
     },
     {
      "name": "8th Floor",
      "code": "8"
     },
     {
      "name": "9th Floor",
      "code": "9"
     },
     {
      "name": "10th Floor",
      "code": "10"
     },
     {
      "name": "11th Floor",
      "code": "11"
     },
     {
      "name": "12th Floor",
      "code": "12"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ROOM",
   "type": "esriFieldTypeString",
   "alias": "ROOM",
   "length": 20,
   "domain": null
  },
  {
   "name": "SPECIFIC_LOCATION",
   "type": "esriFieldTypeString",
   "alias": "SPECIFIC_LOCATION",
   "length": 50,
   "domain": null
  },
  {
   "name": "SERVICE_AREA",
   "type": "esriFieldTypeString",
   "alias": "SERVICE_AREA",
   "length": 20,
   "domain": null
  },
  {
   "name": "CLASS",
   "type": "esriFieldTypeString",
   "alias": "CLASS",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "D_CLASS",
    "description": "Equipment Class",
    "codedValues": [
     {
      "name": "PLUMBING",
      "code": "PLUM"
     },
     {
      "name": "HVAC",
      "code": "HVAC"
     },
     {
      "name": "FIRE",
      "code": "FIRE"
     },
     {
      "name": "GENERAL",
      "code": "GNRL"
     },
     {
      "name": "ELECTRICAL",
      "code": "ELEC"
     },
     {
      "name": "SEWER",
      "code": "SEWR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "D_SEWR",
    "description": "Assets Sewer Equipment Type",
    "codedValues": [
     {
      "name": "AHU",
      "code": "AHU"
     },
     {
      "name": "AIR BLOWER VENTILATOR",
      "code": "AIR BLOWER VENTILATOR"
     },
     {
      "name": "AIR COMPRESSOR",
      "code": "AIR COMPRESSOR"
     },
     {
      "name": "AIR DRYER",
      "code": "AIR DRYER"
     },
     {
      "name": "ALARM",
      "code": "ALARM"
     },
     {
      "name": "BACKFLOW PREVENTER",
      "code": "BACKFLOW PREVENTER"
     },
     {
      "name": "BEARING",
      "code": "BEARING"
     },
     {
      "name": "BLOWER",
      "code": "BLOWER"
     },
     {
      "name": "BREAKER",
      "code": "BREAKER"
     },
     {
      "name": "BRUSH",
      "code": "BRUSH"
     },
     {
      "name": "BRUSH ROTOR",
      "code": "BRUSH ROTOR"
     },
     {
      "name": "BUBBLER",
      "code": "BUBBLER"
     },
     {
      "name": "CARTRIDGE",
      "code": "CARTRIDGE"
     },
     {
      "name": "CATHODIC PROTECTION SYSTEM",
      "code": "CATHODIC PROTECTION SYSTEM"
     },
     {
      "name": "CENTRIFUGE",
      "code": "CENTRIFUGE"
     },
     {
      "name": "CHAMBER",
      "code": "CHAMBER"
     },
     {
      "name": "CHEMICAL FEED SYSTEM",
      "code": "CHEMICAL FEED SYSTEM"
     },
     {
      "name": "CLARIFIER",
      "code": "CLARIFIER"
     },
     {
      "name": "COMMINUTOR",
      "code": "COMMINUTOR"
     },
     {
      "name": "COMPUTER/PLANT ALARM SYSTEM",
      "code": "COMPUTER/PLANT ALARM SYSTEM"
     },
     {
      "name": "CONDENSER",
      "code": "CONDENSER"
     },
     {
      "name": "CONTACT CHAMBER",
      "code": "CONTACT CHAMBER"
     },
     {
      "name": "CONTACTOR",
      "code": "CONTACTOR"
     },
     {
      "name": "CONTROL CENTER",
      "code": "CONTROL CENTER"
     },
     {
      "name": "CONTROL PANEL",
      "code": "CONTROL PANEL"
     },
     {
      "name": "CONTROLLER",
      "code": "CONTROLLER"
     },
     {
      "name": "CONVEYOR",
      "code": "CONVEYOR"
     },
     {
      "name": "DATASTREAM",
      "code": "DATASTREAM"
     },
     {
      "name": "DECANT VALVE",
      "code": "DECANT VALVE"
     },
     {
      "name": "DEHUMIDIFIER",
      "code": "DEHUMIDIFIER"
     },
     {
      "name": "DRIVE",
      "code": "DRIVE"
     },
     {
      "name": "DRY WELL",
      "code": "DRY WELL"
     },
     {
      "name": "ELECTRIC",
      "code": "ELECTRIC"
     },
     {
      "name": "ELECTRIC PANEL",
      "code": "ELECTRIC PANEL"
     },
     {
      "name": "ENGINE",
      "code": "ENGINE"
     },
     {
      "name": "EXHAUST FAN",
      "code": "EXHAUST FAN"
     },
     {
      "name": "FLOW METER",
      "code": "FLOW METER"
     },
     {
      "name": "GAS CHLORINE SYSTEM",
      "code": "GAS CHLORINE SYSTEM"
     },
     {
      "name": "GAS DETECTOR",
      "code": "GAS DETECTOR"
     },
     {
      "name": "GATE",
      "code": "GATE"
     },
     {
      "name": "GEAR REDUCER",
      "code": "GEAR REDUCER"
     },
     {
      "name": "GENERATOR",
      "code": "GENERATOR"
     },
     {
      "name": "GRINDER",
      "code": "GRINDER"
     },
     {
      "name": "HAND PUMP",
      "code": "HAND PUMP"
     },
     {
      "name": "HEADWORKS SCREENS",
      "code": "HEADWORKS SCREENS"
     },
     {
      "name": "HEATER",
      "code": "HEATER"
     },
     {
      "name": "HOIST",
      "code": "HOIST"
     },
     {
      "name": "INLINE FILTER",
      "code": "INLINE FILTER"
     },
     {
      "name": "METER",
      "code": "METER"
     },
     {
      "name": "MICRO SWITCH",
      "code": "MICRO SWITCH"
     },
     {
      "name": "MISCELLANEOUS",
      "code": "MISCELLANEOUS"
     },
     {
      "name": "MIXER",
      "code": "MIXER"
     },
     {
      "name": "MOTOR",
      "code": "MOTOR"
     },
     {
      "name": "MOTOR STARTER/DRIVE",
      "code": "MOTOR STARTER/DRIVE"
     },
     {
      "name": "ODOR SCRUBBER",
      "code": "ODOR SCRUBBER"
     },
     {
      "name": "OIL DRIP SYSTEM",
      "code": "OIL DRIP SYSTEM"
     },
     {
      "name": "PIEZOMETERS",
      "code": "PIEZOMETERS"
     },
     {
      "name": "PISTA GRIT REMOVAL SYSTEM",
      "code": "PISTA GRIT REMOVAL SYSTEM"
     },
     {
      "name": "PLC",
      "code": "PLC"
     },
     {
      "name": "POLYMER BLENDING UNIT",
      "code": "POLYMER BLENDING UNIT"
     },
     {
      "name": "POND",
      "code": "POND"
     },
     {
      "name": "PRESSURE WASHER",
      "code": "PRESSURE WASHER"
     },
     {
      "name": "PRV",
      "code": "PRV"
     },
     {
      "name": "PUMP",
      "code": "PUMP"
     },
     {
      "name": "ROLL UP DOOR",
      "code": "ROLL UP DOOR"
     },
     {
      "name": "ROTOR",
      "code": "ROTOR"
     },
     {
      "name": "SAFEY",
      "code": "SAFETY"
     },
     {
      "name": "SAMPLER",
      "code": "SAMPLER"
     },
     {
      "name": "SCADA PACK",
      "code": "SCADA PACK"
     },
     {
      "name": "SCREEN",
      "code": "SCREEN"
     },
     {
      "name": "SCREEN (BAR)",
      "code": "SCREEN (BAR)"
     },
     {
      "name": "SCREEN (MECHANICAL)",
      "code": "SCREEN (MECHANICAL)"
     },
     {
      "name": "SCREW PRESS",
      "code": "SCREW PRESS"
     },
     {
      "name": "SCREW PUMP",
      "code": "SCREW PUMP"
     },
     {
      "name": "SENSOR",
      "code": "SENSOR"
     },
     {
      "name": "SLUDGE LINE",
      "code": "SLUDGE LINE"
     },
     {
      "name": "SOLENOID",
      "code": "SOLENOID"
     },
     {
      "name": "SPIRAL SCREW CONVEYOR",
      "code": "SPIRAL SCREW CONVEYOR"
     },
     {
      "name": "SPRINKLER SYSTEM",
      "code": "SPRINKLER SYSTEM"
     },
     {
      "name": "TANK",
      "code": "TANK"
     },
     {
      "name": "TERTIARY FILTERS",
      "code": "TERTIARY FILTERS"
     },
     {
      "name": "THERMOMETER",
      "code": "THERMOMETER"
     },
     {
      "name": "TRANSDUCER",
      "code": "TRANSDUCER"
     },
     {
      "name": "TRANSFER SWITCH",
      "code": "TRANSFER SWITCH"
     },
     {
      "name": "TRANSFORMER",
      "code": "TRANSFORMER"
     },
     {
      "name": "UPS",
      "code": "UPS"
     },
     {
      "name": "VALVE",
      "code": "VALVE"
     },
     {
      "name": "VALVE ACTUATOR",
      "code": "VALVE ACTUATOR"
     },
     {
      "name": "VERTICAL DIFFUSION",
      "code": "VERTICAL DIFFUSION"
     },
     {
      "name": "WET WELL",
      "code": "WET WELL"
     },
     {
      "name": "WIPER",
      "code": "WIPER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MP2_ID",
   "type": "esriFieldTypeString",
   "alias": "MP2_ID",
   "length": 255,
   "domain": null
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MANUFACTURER",
   "length": 40,
   "domain": null
  },
  {
   "name": "SCADA_ID",
   "type": "esriFieldTypeString",
   "alias": "SCADA_ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "MODEL_NUM",
   "type": "esriFieldTypeString",
   "alias": "MODEL_NUM",
   "length": 50,
   "domain": null
  },
  {
   "name": "SERIAL_NUM",
   "type": "esriFieldTypeString",
   "alias": "SERIAL_NUM",
   "length": 50,
   "domain": null
  },
  {
   "name": "SUPPLIER",
   "type": "esriFieldTypeString",
   "alias": "SUPPLIER",
   "length": 40,
   "domain": null
  },
  {
   "name": "COST_ORIGINAL",
   "type": "esriFieldTypeDouble",
   "alias": "COST_ORIGINAL",
   "domain": null
  },
  {
   "name": "ACQU_DATE",
   "type": "esriFieldTypeDate",
   "alias": "ACQU_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "INST_DATE",
   "type": "esriFieldTypeDate",
   "alias": "INST_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "REMV_DATE",
   "type": "esriFieldTypeDate",
   "alias": "REMV_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "WAR_EXP_DATE",
   "type": "esriFieldTypeDate",
   "alias": "WAR_EXP_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "EUL",
   "type": "esriFieldTypeSmallInteger",
   "alias": "EUL",
   "domain": null
  },
  {
   "name": "EQUIPMENT_NOTES",
   "type": "esriFieldTypeString",
   "alias": "EQUIPMENT_NOTES",
   "length": 255,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "SECTION",
   "type": "esriFieldTypeString",
   "alias": "SECTION",
   "length": 50,
   "domain": null
  },
  {
   "name": "MAN_DATE",
   "type": "esriFieldTypeDate",
   "alias": "MANUFACTURER_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CRITICALITY",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CRITICALITY",
   "domain": {
    "type": "codedValue",
    "name": "D_CRITICALITY",
    "description": "Criticality",
    "codedValues": [
     {
      "name": "MOST CRITICAL, $50k+ impact",
      "code": 0
     },
     {
      "name": "ESSENTIAL, $25k impact",
      "code": 25
     },
     {
      "name": "IMPORTANT, $10k impact",
      "code": 50
     },
     {
      "name": "NON-ESSENTIAL, $5k impact",
      "code": 75
     },
     {
      "name": "LEAST CRITICAL, minimal $ impact",
      "code": 100
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CONDITION",
   "domain": {
    "type": "codedValue",
    "name": "D_CONDITION",
    "description": "Condition",
    "codedValues": [
     {
      "name": "F \u2013 Need replaced to 20% useful life remaining",
      "code": 0
     },
     {
      "name": "D - 20% to 40% useful life remaining",
      "code": 25
     },
     {
      "name": "C - 40% to 60% useful life remaining",
      "code": 50
     },
     {
      "name": "B - 60% to 80% useful life remaining",
      "code": 75
     },
     {
      "name": "A \u2013 80% useful life remaining to new",
      "code": 100
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CREATION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATION_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "LAST_EDIT_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDIT_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "EDIT_FLAG",
   "type": "esriFieldTypeString",
   "alias": "EDIT_FLAG",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "D_EDIT_REVIEW",
    "description": "Equipment review edit flag",
    "codedValues": [
     {
      "name": "!",
      "code": "!"
     },
     {
      "name": ".",
      "code": "-"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BLDG_GIS_ID",
   "type": "esriFieldTypeGUID",
   "alias": "BLDG_GIS_ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "TAG_ID",
   "type": "esriFieldTypeString",
   "alias": "TAG_ID",
   "length": 15,
   "domain": null
  },
  {
   "name": "PANELCIRCUIT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "PANEL_CIRCUIT\n",
   "domain": null
  },
  {
   "name": "PANELSPACE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "PANEL_SPACES\n",
   "domain": null
  },
  {
   "name": "NEMA",
   "type": "esriFieldTypeString",
   "alias": "NEMA",
   "length": 3,
   "domain": null
  },
  {
   "name": "HP",
   "type": "esriFieldTypeSingle",
   "alias": "HP",
   "domain": null
  },
  {
   "name": "VOLT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "VOLT",
   "domain": null
  },
  {
   "name": "PHASE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "PHASE",
   "domain": null
  },
  {
   "name": "FUSE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "FUSE_TYPE",
   "length": 50,
   "domain": null
  },
  {
   "name": "RATING",
   "type": "esriFieldTypeString",
   "alias": "RATING",
   "length": 15,
   "domain": null
  },
  {
   "name": "STYLE",
   "type": "esriFieldTypeString",
   "alias": "STYLE",
   "length": 40,
   "domain": null
  },
  {
   "name": "FRAME",
   "type": "esriFieldTypeString",
   "alias": "FRAME",
   "length": 10,
   "domain": null
  },
  {
   "name": "RPM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "RPM",
   "domain": null
  },
  {
   "name": "SOURCE",
   "type": "esriFieldTypeString",
   "alias": "SOURCE",
   "length": 10,
   "domain": null
  },
  {
   "name": "AMP",
   "type": "esriFieldTypeSingle",
   "alias": "AMP",
   "domain": null
  },
  {
   "name": "GPM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "GPM",
   "domain": null
  },
  {
   "name": "HZ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "HZ",
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "D_STATUS",
    "description": "Equipment service status",
    "codedValues": [
     {
      "name": "RETIRED",
      "code": "RETIRED"
     },
     {
      "name": "INVENTORY",
      "code": "INVENTORY"
     },
     {
      "name": "IN SERVICE",
      "code": "IN SERVICE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INST_DATE_INT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "INST_DATE_INT",
   "domain": null
  },
  {
   "name": "NAME",
   "type": "esriFieldTypeString",
   "alias": "NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "REPLACE_COST",
   "type": "esriFieldTypeInteger",
   "alias": "REPLACE_COST",
   "domain": null
  },
  {
   "name": "REPLACE_NOTE",
   "type": "esriFieldTypeString",
   "alias": "REPLACE_NOTE",
   "length": 250,
   "domain": null
  },
  {
   "name": "ASSET_COMP",
   "type": "esriFieldTypeString",
   "alias": "ASSET_COMP",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "D_CHILD",
    "description": "ASSET CHILD OR PARENT",
    "codedValues": [
     {
      "name": "COMPONENT",
      "code": "COM"
     },
     {
      "name": "PARENT ASSET",
      "code": "ASS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PARENT",
   "type": "esriFieldTypeString",
   "alias": "PARENT",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R475_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_475",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_475",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_15390_BLDG_G",
   "fields": "BLDG_GIS_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "LOCATION",
   "relatedTableId": 10,
   "role": "esriRelRoleDestination",
   "keyField": "BLDG_GIS_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{2DDA271C-3D4F-4A4F-95E2-E1338D65C982}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": false,
  "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": true,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}