Name: faHVAC

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 15000

Supported Query Formats: JSON

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

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 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• FEATURESTATUS ( type: esriFieldTypeString, alias: FEATURESTATUS, length: 20 , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Removed: Removed] , ...7 more... )
• FEATURETYPE ( type: esriFieldTypeString, alias: FEATURETYPE, length: 30 , Coded Values: [Air Handler: Air Handler] , [Boiler: Boiler] , [Chiller: Chiller] , ...15 more... )
• EQDESCRIPTION ( type: esriFieldTypeString, alias: EQDESCRIPTION, length: 100 )
• AREA_WING ( type: esriFieldTypeString, alias: AREA_WING, length: 30 , Coded Values: [CC- Admin: CC- Admin] , [CC- Gym: CC- Gym] , [CC- Lower Floor: CC- Lower Floor] , ...51 more... )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, length: 20 , Coded Values: [Main Floor: Main Floor] , [Lower Floor: Lower Floor] , [Upper Floor: Upper Floor] , ...3 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 25 )
• MODELNO ( type: esriFieldTypeString, alias: MODELNO, length: 50 )
• SERIALNO ( type: esriFieldTypeString, alias: SERIALNO, length: 50 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• PARENTASSET ( type: esriFieldTypeString, alias: PARENTASSET, length: 20 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 130 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 30 , Coded Values: [Mercer Island: Mercer Island] , [Mercer Island (by Easement): Mercer Island (by Easement)] , [Private: Private] , ...9 more... )
• FILTERS ( type: esriFieldTypeString, alias: FILTERS, length: 50 )
• BELTS ( type: esriFieldTypeString, alias: BELTS, length: 20 )
• TONNAGE ( type: esriFieldTypeDouble, alias: TONNAGE )
• MANUFACTUREDATE ( type: esriFieldTypeDate, alias: MANUFACTUREDATE, length: 8 )
• CONTRACTORID ( type: esriFieldTypeString, alias: CONTRACTORID, length: 30 )
• CONTRACTORID2 ( type: esriFieldTypeString, alias: CONTRACTORID2, length: 30 )
• CONTRACTORTYPE ( type: esriFieldTypeString, alias: CONTRACTORTYPE, length: 30 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• LIFEEXPECTANCY ( type: esriFieldTypeSmallInteger, alias: LIFEEXPECTANCY )
• REMAININGLIFE ( type: esriFieldTypeSmallInteger, alias: REMAININGLIFE )
• COF ( type: esriFieldTypeSmallInteger, alias: COF )
• POF ( type: esriFieldTypeSmallInteger, alias: POF )
• BRE ( type: esriFieldTypeSmallInteger, alias: BRE )
• SYMBOLROTATION ( type: esriFieldTypeDouble, alias: SYMBOLROTATION )
• UPDATESOURCE ( type: esriFieldTypeString, alias: UPDATESOURCE, length: 255 )
• UPDATEBY ( type: esriFieldTypeString, alias: UPDATEBY, length: 20 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata