Name: PW.WASHOE.ASSETS_HVAC_EQUIPMENT

Display Field: AE_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: AE_HVAC_CAT

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BUILDING ( type: esriFieldTypeString, alias: BUILDING, length: 100 )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, length: 2 , Coded Values: [B: Basement] , [R: Roof] , [1: Ground Floor] , ...11 more... )
• ROOM ( type: esriFieldTypeString, alias: ROOM, length: 20 )
• SPECIFIC_LOCATION ( type: esriFieldTypeString, alias: SPECIFIC_LOCATION, length: 50 )
• SERVICE_AREA ( type: esriFieldTypeString, alias: SERVICE_AREA, length: 20 )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 12 , Coded Values: [PLUM: PLUMBING] , [HVAC: HVAC] , [FIRE: FIRE] , ...3 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 50 )
• FD_ID ( type: esriFieldTypeString, alias: FD_ID, length: 255 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 40 )
• MODEL_NUM ( type: esriFieldTypeString, alias: MODEL_NUM, length: 50 )
• SERIAL_NUM ( type: esriFieldTypeString, alias: SERIAL_NUM, length: 50 )
• COST_ORIGINAL ( type: esriFieldTypeDouble, alias: COST_ORIGINAL )
• DATE_INSTALLED ( type: esriFieldTypeDate, alias: DATE_INSTALLED, length: 8 )
• EQUIPMENT_NOTES ( type: esriFieldTypeString, alias: EQUIPMENT_NOTES, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: HVAC_GlobalID, length: 38 )
• CRITICALITY ( type: esriFieldTypeSmallInteger, alias: CRITICALITY , Coded Values: [0: MOST CRITICAL, $50k+ impact] , [25: ESSENTIAL, $25k impact] , [50: IMPORTANT, $10k impact] , ...2 more... )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION , Coded Values: [0: F – Need replaced to 20% useful life remaining] , [25: D - 20% to 40% useful life remaining] , [50: C - 40% to 60% useful life remaining] , ...2 more... )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, length: 8 )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST_EDIT_DATE, length: 8 )
• BLDG_GIS_ID ( type: esriFieldTypeGUID, alias: BLDG_GIS_ID, length: 38 )
• HP ( type: esriFieldTypeSingle, alias: HP )
• AMP ( type: esriFieldTypeSingle, alias: AMP )
• VOLT ( type: esriFieldTypeSmallInteger, alias: VOLT )
• PHASE ( type: esriFieldTypeSmallInteger, alias: PHASE )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 10 )
• AE_HVAC_CAT ( type: esriFieldTypeSmallInteger, alias: AE_HVAC_CAT )
• AE_HVAC_TYPE ( type: esriFieldTypeString, alias: AE_HVAC_TYPE, length: 150 )
• ASSET_COMP ( type: esriFieldTypeString, alias: ASSET_COMP, length: 3 , Coded Values: [COM: COMPONENT] , [ASS: PARENT ASSET] )
• PARENT ( type: esriFieldTypeString, alias: PARENT, length: 50 )
• EUL ( type: esriFieldTypeSmallInteger, alias: EUL )
• EDIT_FLAG ( type: esriFieldTypeString, alias: EDIT_FLAG, length: 3 , Coded Values: [!: !] , [-: .] )
• AE_NAME ( type: esriFieldTypeString, alias: AE_NAME, length: 100 )
• AE_ID ( type: esriFieldTypeString, alias: AE_ID, length: 50 )

Types:

ID: 31
Name: Valve and Damper Actuators
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Hydraulic: Hydraulic] , [Pneumatic: Pneumatic] , [Motorized Electric: Motorized Electric] , ...1 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 50
Name: Air Conditioners
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Window Unit: Window Unit] , [Computer Room Unit: Computer Room Unit] , [Split Package: Split System]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 51
Name: Air Handling Units
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Built-Up Heavy Duty: Built-Up Heavy Duty] , [Packaged Medium-Duty: Packaged Medium-Duty] , [Severe Duty or 100% Outside Air: Severe Duty or 100% Outside Air]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 11
Name: Cooling Towers
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Galvanized or Coated Steel: Galvanized or Coated Steel] , [Fiberglass: Fiberglass] , [Stainless Steel: Stainless Steel]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 16
Name: Fans
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Ventilating Roof-Mounted, Mild Exhaust: Ventilating Roof-Mounted, Mild Exhaust] , [Kitchen or Other Soiled Exhaust: Kitchen or Other Soiled Exhaust]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 17
Name: Furnaces
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Gas Fired: Gas Fired] , [Oil Fired: Oil Fired] , [Condensing: Condensing]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 25
Name: Package Chillers
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Reciprocating: Reciprocating] , [Centrifugal: Centrifugal] , [Screw: Screw] , ...1 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 26
Name: Pumps
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Base Mounted: Base Mounted] , [In-line: In-line] , [Sump-Submerged: Sump-Submerged] , ...2 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 43
Name: Air Terminals
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Fan-Coil Units: Fan-Coil Units] , [VAV Boxes Cooling Only: VAV Boxes Cooling Only] , [CAV Boxes: CAV Boxes] , ...3 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 44
Name: Air Washers & Humidifiers
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Spray: Spray] , [Steam: Steam] , [Pan, Wheel or Wetted Elemen: Pan, Wheel or Wetted Element]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 49
Name: Control Sensors
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Temperature: Temperature] , [Air Flow: Air Flow] , [Humidity, CO: Humidity] , ...1 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 10
Name: Controllers
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Pneumatic: Pneumatic] , [Electric: Electric] , [Electronic: Electronic] , ...1 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 14
Name: Electric Motors
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Without Soft Start: Without Soft Start] , [With Soft Start: With Soft Start]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 18
Name: Heat Exchangers
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Plate and Frame: Plate and Frame] , [Energy Recovery Wheel: Energy Recovery Wheel] , [Energy Recovery Water: Energy Recovery Water] , ...2 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 30
Name: Unit Heaters
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Gas: Gas] , [Electric: Electric] , [Hot Water: Hot Water] , ...1 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 45
Name: Boilers, Hot Water
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [Condensing: Condensing] , [Non-Condensing: Non-Condensing]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 27
Name: Air Compressors
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [All Reciprocating Air Compressors: All Reciprocating Air Compressors]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 48
Name: Evaporators
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [All Evaporators: All Evaporators]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 22
Name: Expansion Tanks
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [AC_EVAPORATOR: AC EVAPORATOR] , [AC_SPLIT_SYSTEM: AC SPLIT SYSTEM] , [AC_WINDOW: AC WINDOW] , ...44 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [All Expansion Tanks: All Expansion Tanks]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 52
Name: MISC
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_HVAC_TYPE:
  Coded Values: [1: SAND OIL SEPARATOR] , [2: TANKS (STORAGE)] , [3: HVACR] , ...10 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

Relationships:

• BUILDING (5) -- Related To: PW.WASHOE.ASSETS_LOCATIONS (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata