Name: Sewer Pump Station Pumps

Display Field: DESCRIPTIVE_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

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 )
• CW_ASSETID ( type: esriFieldTypeString, alias: CW ASSETID, length: 50 )
• PARENT_FACILITY ( type: esriFieldTypeString, alias: PARENT FACILITY PARENT FACILITY, length: 50 )
• DESCRIPTIVE_NAME ( type: esriFieldTypeString, alias: DESCRIPTIVE NAME, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 250 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [UNKNOWN: UNKNOWN] , [ABANDONED: ABANDONED] , [IN CONSTRUCTION: IN CONSTRUCTION] , ...3 more... )
• MOTOR_MANUFACTURER ( type: esriFieldTypeString, alias: MOTOR MANUFACTURER , length: 50 )
• MOTOR_MODEL ( type: esriFieldTypeString, alias: MOTOR MODEL , length: 50 )
• MOTOR_SERIAL_NUMBER ( type: esriFieldTypeString, alias: MOTOR SERIAL NUMBER , length: 50 )
• FRAME_DESIGNATION ( type: esriFieldTypeString, alias: FRAME DESIGNATION , length: 50 )
• MOTOR_REWINDING_DATE ( type: esriFieldTypeDate, alias: MOTOR REWINDING DATE , length: 8 )
• DRIVE_BEARING ( type: esriFieldTypeString, alias: DRIVE BEARING , length: 50 )
• OPPOSITE_DRIVE_BEARING ( type: esriFieldTypeString, alias: OPPOSITE DRIVE BEARING , length: 50 )
• BEARING_SERVICE_DATE ( type: esriFieldTypeDate, alias: BEARING SERVICE DATE , length: 8 )
• SEAL_TYPE ( type: esriFieldTypeString, alias: SEAL TYPE , length: 50 )
• SEAL_SERVICE_DATE ( type: esriFieldTypeDate, alias: SEAL SERVICE DATE , length: 8 )
• PUMP_MANUFACTURER ( type: esriFieldTypeString, alias: PUMP MANUFACTURER , length: 50 )
• PUMP_MODEL ( type: esriFieldTypeString, alias: PUMP MODEL , length: 50 )
• PUMP_WETTED_MATERIAL ( type: esriFieldTypeString, alias: PUMP WETTED MATERIAL , length: 50 )
• INTAKE_PIPE_SIZE ( type: esriFieldTypeDouble, alias: INTAKE PIPE SIZE (IN) )
• DISCHARGE_PIPE_SIZE ( type: esriFieldTypeDouble, alias: DISCHARGE PIPE SIZE (IN) )
• IMPELLER_SIZE ( type: esriFieldTypeDouble, alias: IMPELLER SIZE (IN) )
• IMPELLER_BORE ( type: esriFieldTypeDouble, alias: IMPELLER BORE (IN) )
• IMPELLER_MATERIAL ( type: esriFieldTypeString, alias: IMPELLER MATERIAL , length: 50 )
• IMPELLER_VANES ( type: esriFieldTypeSmallInteger, alias: IMPELLER VANES )
• VOLUTE_DESCRIPTION ( type: esriFieldTypeString, alias: VOLUTE DESCRIPTION , length: 50 )
• VOLUTE_SERIAL_NUMBER ( type: esriFieldTypeString, alias: VOLUTE SERIAL NUMBER , length: 50 )
• SHAFT_OUTER_DIAMETER ( type: esriFieldTypeDouble, alias: SHAFT OUTER DIAMETER (IN) )
• OUTPUT_POWER ( type: esriFieldTypeDouble, alias: OUTPUT POWER (HP) )
• MAXIMUM_LIFT ( type: esriFieldTypeSmallInteger, alias: MAXIMUM LIFT (FT) )
• SPEED_RPM ( type: esriFieldTypeSmallInteger, alias: SPEED (RPM) )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: VOLTAGE )
• ELEC_CURRENT ( type: esriFieldTypeDouble, alias: ELEC CURRENT (FLA) )
• SUBMERSIBLE ( type: esriFieldTypeString, alias: SUBMERSIBLE , length: 10 , Coded Values: [Y: YES] , [N: NO] )
• EXPECTED_LIFE ( type: esriFieldTypeSmallInteger, alias: EXPECTED LIFE (YRS) )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: INSTALLATION DATE , length: 8 )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: REPLACEMENT COST )
• FIELD_INSPECTION_DATE ( type: esriFieldTypeDate, alias: FIELD INSPECTION DATE , length: 8 )
• FIELD_INSPECTION_CONDITION ( type: esriFieldTypeSmallInteger, alias: FIELD INSPECTION CONDITION , Coded Values: [0: 0 - UNKNOWN CONDITION] , [1: 1 - EXCELLENT CONDITION] , [2: 2 - MINOR DEFECTS ONLY] , ...3 more... )
• FIELD_NOTES ( type: esriFieldTypeString, alias: FIELD NOTES , length: 512 )
• MAPPING_NOTES ( type: esriFieldTypeString, alias: MAPPING NOTES , length: 512 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST EDITED DATE, length: 8 )

Relationships:

• Sewer_Pump_Station (0) -- Related To: Sewer Pump Stations (0)

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

  Iteminfo   Thumbnail   Metadata