Name: HVAC

Display Field: NAMEPLATE

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2814a347a60249589a33dcc30449a8a9

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 20 )
• RELATEID ( type: esriFieldTypeString, alias: RELATEID, length: 20 )
• LOCATIONID ( type: esriFieldTypeString, alias: LOCATIONID, length: 20 )
• WARRANTY ( type: esriFieldTypeDate, alias: WARRANTY, length: 8 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 50 )
• EQUIPMENTTYPE ( type: esriFieldTypeString, alias: EQUIPMENTTYPE, length: 50 )
• EQUIPMENTID ( type: esriFieldTypeString, alias: EQUIPMENTID, length: 20 )
• SPECNO ( type: esriFieldTypeString, alias: SPECNO, length: 30 )
• PLANSNO ( type: esriFieldTypeString, alias: PLANSNO, length: 15 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 50 )
• MODELNO ( type: esriFieldTypeString, alias: MODELNO, length: 50 )
• SERIALNO ( type: esriFieldTypeString, alias: SERIALNO, length: 50 )
• DRIVETYPE ( type: esriFieldTypeString, alias: DRIVETYPE, length: 20 )
• NAMEPLATE ( type: esriFieldTypeString, alias: NAMEPLATE, length: 250 )
• PHASE ( type: esriFieldTypeSmallInteger, alias: PHASE )
• FREQUENCY_HZ ( type: esriFieldTypeSmallInteger, alias: FREQUENCY_HZ )
• HP ( type: esriFieldTypeString, alias: HP, length: 20 )
• WATTS ( type: esriFieldTypeString, alias: WATTS, length: 20 )
• VOLTS ( type: esriFieldTypeString, alias: VOLTS, length: 30 )
• AMPS ( type: esriFieldTypeString, alias: AMPS, length: 30 )
• NAT_GAS_BTU ( type: esriFieldTypeString, alias: NAT_GAS_BTU, length: 70 )
• CFM ( type: esriFieldTypeString, alias: CFM, length: 20 )
• BELT ( type: esriFieldTypeString, alias: BELT, length: 20 )
• FILTER ( type: esriFieldTypeString, alias: FILTER, length: 30 )
• REFRIGERANT ( type: esriFieldTypeString, alias: REFRIGERANT, length: 50 )
• FAN_RPM ( type: esriFieldTypeString, alias: FAN_RPM, length: 20 )
• NewAssetID ( type: esriFieldTypeString, alias: NewAssetID, length: 50 )

Relationships:

• SDE.UTL_bldgs (44) -- Related To: Maint Buildings (43)
• SDE.UTL_Digester (26) -- Related To: Digester (40)
• SDE.UTL_structures (20) -- Related To: Maint Structures (39)
• SDE.UTL_Basin (36) -- Related To: Basin (42)
• SDE.UTL_Lift_stations (15) -- Related To: Lift Stations (36)

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

  Iteminfo   Thumbnail   Metadata