Name: wPump

Display Field: EquipmentID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 048a4e7c003e4f8c99ad04ffcdd66587

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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 )
• EquipmentID ( type: esriFieldTypeString, alias: EquipmentID, length: 20 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 50 )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• Description ( type: esriFieldTypeString, alias: Description, length: 70 )
• Floor ( type: esriFieldTypeString, alias: Floor, length: 20 )
• Room ( type: esriFieldTypeString, alias: Room, length: 50 )
• Make ( type: esriFieldTypeString, alias: Make, length: 20 )
• Model ( type: esriFieldTypeString, alias: Model, length: 20 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 20 )
• LubeType ( type: esriFieldTypeString, alias: LubeType, length: 10 )
• RPM ( type: esriFieldTypeSmallInteger, alias: RPM )
• EfficiencyRating ( type: esriFieldTypeString, alias: EfficiencyRating, length: 5 )
• EquipmentType ( type: esriFieldTypeString, alias: EquipmentType, length: 5 )
• Voltage ( type: esriFieldTypeSmallInteger, alias: Voltage )
• Rotation ( type: esriFieldTypeString, alias: Rotation, length: 5 )
• GPM ( type: esriFieldTypeSmallInteger, alias: GPM )
• HeadPressure ( type: esriFieldTypeDouble, alias: HeadPressure )
• BldgID ( type: esriFieldTypeString, alias: BuildingID, length: 20 )
• ChemFdSysID ( type: esriFieldTypeString, alias: ChemicalFeedSystemID, length: 20 )
• PmpStaID ( type: esriFieldTypeString, alias: PumpStationID, length: 20 )
• SampPumpID ( type: esriFieldTypeString, alias: SamplePumpSystemID, length: 20 )
• StorageID ( type: esriFieldTypeString, alias: StorageID, length: 20 )
• TreatStorID ( type: esriFieldTypeString, alias: TreatmentStorageID, length: 20 )
• GroundsID ( type: esriFieldTypeString, alias: GroundsID, length: 50 )
• StructureID ( type: esriFieldTypeString, alias: StructureID, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, length: 255 )
• CREATEDDATE ( type: esriFieldTypeDate, alias: CREATEDDATE, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, length: 255 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [ABAND: Abandoned] , [ACT: Active] , [CONST: Construction Phase] , ...6 more... )

Relationships:

• wBuilding (48) -- Related To: Water Building (29)
• wStructure (26) -- Related To: Water Structure (28)
• wStorage_1 (4) -- Related To: wStorage (6)
• wTreatmentStorage (53) -- Related To: Water Treatment Storage (30)
• wPumpStation_1 (13) -- Related To: wPumpStation (7)
• wGrounds (71) -- Related To: Water Grounds (32)

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

  Iteminfo   Thumbnail   Metadata