Name: MCC

Display Field: AssetType

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

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetType ( type: esriFieldTypeString, alias: AssetType, length: 255 , Coded Values: [Aerator: Aerator] , [Air Compressor: Air Compressor] , [Air Handler: Air Handler] , ...63 more... )
• Asset ( type: esriFieldTypeString, alias: Asset, length: 255 )
• Process ( type: esriFieldTypeString, alias: Process, length: 255 , Coded Values: [Raw Water: Raw Water] , [Residuals: Residuals] , [Treated Water: Treated Water] , ...2 more... )
• Subprocess ( type: esriFieldTypeString, alias: Subprocess, length: 255 , Coded Values: [Chemical Bulk Tanks: Chemical Bulk Tanks] , [Chemical System: Chemical System] , [Drying Bed Pump Station: Drying Bed Pump Station] , ...35 more... )
• Assembly ( type: esriFieldTypeString, alias: Assembly, length: 255 , Coded Values: [Air Scour System: Air Scour System] , [Ammonia: Ammonia] , [Belt Filter Press System: Belt Filter Press System] , ...30 more... )
• LegacyAssetID ( type: esriFieldTypeString, alias: LegacyAssetID, length: 255 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 255 )
• ModelType ( type: esriFieldTypeString, alias: ModelType, length: 255 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 255 )
• ConditionRating ( type: esriFieldTypeDouble, alias: ConditionRating )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 255 )
• DisplayID ( type: esriFieldTypeString, alias: DisplayID, length: 255 )
• Plant ( type: esriFieldTypeString, alias: Plant, length: 255 , Coded Values: [TGB-WTP: Timothy G. Broome WTP] , [CJCR-WWTP: Central Johnston County Regional WWTP] )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Active: Active] , [Inactive: Inactive] , [Retired: Retired] )
• Manual_Location ( type: esriFieldTypeString, alias: Manual_Location, length: 255 )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, length: 255 )
• Voltage ( type: esriFieldTypeString, alias: Voltage, length: 255 )
• Power_kW ( type: esriFieldTypeDouble, alias: Power_kW )
• Range_ ( type: esriFieldTypeString, alias: Range, length: 255 )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower )
• Flow_gpm ( type: esriFieldTypeString, alias: Flow_gpm, length: 255 )
• Head_ft ( type: esriFieldTypeString, alias: Head_ft, length: 255 )
• RotationalSpeed_rpm ( type: esriFieldTypeString, alias: RotationalSpeed_rpm, length: 255 )
• Power_kVA ( type: esriFieldTypeDouble, alias: Power_kVA )
• Size_in ( type: esriFieldTypeDouble, alias: Size_in )
• Pressure_psi ( type: esriFieldTypeString, alias: Pressure_psi, length: 255 )
• ParentAssetID ( type: esriFieldTypeString, alias: ParentAssetID, length: 255 )

Relationships:

• TBG_Assemblies (0) -- Related To: TBG_Assemblies (0)
• TGB_Processes (4) -- Related To: TGB_Processes (2)
• Plants (6) -- Related To: TGB (3)
• TGB_Subprocesses (2) -- Related To: TGB_Subprocesses (1)

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

  Iteminfo   Thumbnail   Metadata