Name: Sewer Pump Station Pumps

Display Field: DESCRIPTIVE_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CW_ASSETID ( type: esriFieldTypeString, alias: CW ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CW_ASSETID_ )
• PARENT_FACILITY ( type: esriFieldTypeString, alias: PARENT FACILITY PARENT FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PARENT_FACILITY_ )
• DESCRIPTIVE_NAME ( type: esriFieldTypeString, alias: DESCRIPTIVE NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTIVE_NAME )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [UNKNOWN: UNKNOWN] , [ABANDONED: ABANDONED] , [IN CONSTRUCTION: IN CONSTRUCTION] , ...3 more... )
• MOTOR_MANUFACTURER ( type: esriFieldTypeString, alias: MOTOR MANUFACTURER , editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOTOR_MANUFACTURER_ )
• MOTOR_MODEL ( type: esriFieldTypeString, alias: MOTOR MODEL , editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOTOR_MODEL_ )
• MOTOR_SERIAL_NUMBER ( type: esriFieldTypeString, alias: MOTOR SERIAL NUMBER , editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOTOR_SERIAL_NUMBER_ )
• FRAME_DESIGNATION ( type: esriFieldTypeString, alias: FRAME DESIGNATION , editable: true, nullable: true, length: 50, defaultValue: null, modelName: FRAME_DESIGNATION_ )
• MOTOR_REWINDING_DATE ( type: esriFieldTypeDate, alias: MOTOR REWINDING DATE , editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOTOR_REWINDING_DATE_ )
• DRIVE_BEARING ( type: esriFieldTypeString, alias: DRIVE BEARING , editable: true, nullable: true, length: 50, defaultValue: null, modelName: DRIVE_BEARING_ )
• OPPOSITE_DRIVE_BEARING ( type: esriFieldTypeString, alias: OPPOSITE DRIVE BEARING , editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPPOSITE_DRIVE_BEARING_ )
• BEARING_SERVICE_DATE ( type: esriFieldTypeDate, alias: BEARING SERVICE DATE , editable: true, nullable: true, length: 8, defaultValue: null, modelName: BEARING_SERVICE_DATE_ )
• SEAL_TYPE ( type: esriFieldTypeString, alias: SEAL TYPE , editable: true, nullable: true, length: 50, defaultValue: null, modelName: SEAL_TYPE_ )
• SEAL_SERVICE_DATE ( type: esriFieldTypeDate, alias: SEAL SERVICE DATE , editable: true, nullable: true, length: 8, defaultValue: null, modelName: SEAL_SERVICE_DATE_ )
• PUMP_MANUFACTURER ( type: esriFieldTypeString, alias: PUMP MANUFACTURER , editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_MANUFACTURER_ )
• PUMP_MODEL ( type: esriFieldTypeString, alias: PUMP MODEL , editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_MODEL_ )
• PUMP_WETTED_MATERIAL ( type: esriFieldTypeString, alias: PUMP WETTED MATERIAL , editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_WETTED_MATERIAL_ )
• INTAKE_PIPE_SIZE ( type: esriFieldTypeDouble, alias: INTAKE PIPE SIZE (IN), editable: true, nullable: true, defaultValue: null, modelName: INTAKE_PIPE_SIZE_ )
• DISCHARGE_PIPE_SIZE ( type: esriFieldTypeDouble, alias: DISCHARGE PIPE SIZE (IN) , editable: true, nullable: true, defaultValue: null, modelName: DISCHARGE_PIPE_SIZE_ )
• IMPELLER_SIZE ( type: esriFieldTypeDouble, alias: IMPELLER SIZE (IN), editable: true, nullable: true, defaultValue: null, modelName: IMPELLER_SIZE_ )
• IMPELLER_BORE ( type: esriFieldTypeDouble, alias: IMPELLER BORE (IN) , editable: true, nullable: true, defaultValue: null, modelName: IMPELLER_BORE_ )
• IMPELLER_MATERIAL ( type: esriFieldTypeString, alias: IMPELLER MATERIAL , editable: true, nullable: true, length: 50, defaultValue: null, modelName: IMPELLER_MATERIAL_ )
• IMPELLER_VANES ( type: esriFieldTypeSmallInteger, alias: IMPELLER VANES , editable: true, nullable: true, defaultValue: null, modelName: IMPELLER_VANES_ )
• VOLUTE_DESCRIPTION ( type: esriFieldTypeString, alias: VOLUTE DESCRIPTION , editable: true, nullable: true, length: 50, defaultValue: null, modelName: VOLUTE_DESCRIPTION_ )
• VOLUTE_SERIAL_NUMBER ( type: esriFieldTypeString, alias: VOLUTE SERIAL NUMBER , editable: true, nullable: true, length: 50, defaultValue: null, modelName: VOLUTE_SERIAL_NUMBER_ )
• SHAFT_OUTER_DIAMETER ( type: esriFieldTypeDouble, alias: SHAFT OUTER DIAMETER (IN) , editable: true, nullable: true, defaultValue: null, modelName: SHAFT_OUTER_DIAMETER_ )
• OUTPUT_POWER ( type: esriFieldTypeDouble, alias: OUTPUT POWER (HP) , editable: true, nullable: true, defaultValue: null, modelName: OUTPUT_POWER )
• MAXIMUM_LIFT ( type: esriFieldTypeSmallInteger, alias: MAXIMUM LIFT (FT) , editable: true, nullable: true, defaultValue: null, modelName: MAXIMUM_LIFT_ )
• SPEED_RPM ( type: esriFieldTypeSmallInteger, alias: SPEED (RPM) , editable: true, nullable: true, defaultValue: null, modelName: SPEED_RPM_ )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: VOLTAGE , editable: true, nullable: true, defaultValue: null, modelName: VOLTAGE_ )
• ELEC_CURRENT ( type: esriFieldTypeDouble, alias: ELEC CURRENT (FLA) , editable: true, nullable: true, defaultValue: null, modelName: ELEC_CURRENT )
• SUBMERSIBLE ( type: esriFieldTypeString, alias: SUBMERSIBLE , editable: true, nullable: true, length: 10, defaultValue: null, modelName: SUBMERSIBLE_ , Coded Values: [Y: YES] , [N: NO] )
• EXPECTED_LIFE ( type: esriFieldTypeSmallInteger, alias: EXPECTED LIFE (YRS) , editable: true, nullable: true, defaultValue: null, modelName: EXPECTED_LIFE_ )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: INSTALLATION DATE , editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE_ )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: REPLACEMENT COST , editable: true, nullable: true, defaultValue: null, modelName: REPLACEMENT_COST_ )
• FIELD_INSPECTION_DATE ( type: esriFieldTypeDate, alias: FIELD INSPECTION DATE , editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIELD_INSPECTION_DATE_ )
• FIELD_INSPECTION_CONDITION ( type: esriFieldTypeSmallInteger, alias: FIELD INSPECTION CONDITION , editable: true, nullable: true, defaultValue: null, modelName: 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 , editable: true, nullable: true, length: 512, defaultValue: null, modelName: FIELD_NOTES_ )
• MAPPING_NOTES ( type: esriFieldTypeString, alias: MAPPING NOTES , editable: true, nullable: true, length: 512, defaultValue: null, modelName: MAPPING_NOTES_ )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST EDITED DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: Sewer Pump Station Pumps
  Description:
  Prototype:
  MAPPING_NOTES: null
  CW_ASSETID: null
  PARENT_FACILITY: null
  DESCRIPTIVE_NAME: null
  LOCATION: null
  STATUS: null
  MOTOR_MANUFACTURER: null
  MOTOR_MODEL: null
  MOTOR_SERIAL_NUMBER: null
  FRAME_DESIGNATION: null
  MOTOR_REWINDING_DATE: null
  DRIVE_BEARING: null
  OPPOSITE_DRIVE_BEARING: null
  BEARING_SERVICE_DATE: null
  SEAL_TYPE: null
  SEAL_SERVICE_DATE: null
  PUMP_MANUFACTURER: null
  PUMP_MODEL: null
  PUMP_WETTED_MATERIAL: null
  INTAKE_PIPE_SIZE: null
  DISCHARGE_PIPE_SIZE: null
  IMPELLER_SIZE: null
  IMPELLER_BORE: null
  IMPELLER_MATERIAL: null
  IMPELLER_VANES: null
  VOLUTE_DESCRIPTION: null
  VOLUTE_SERIAL_NUMBER: null
  SHAFT_OUTER_DIAMETER: null
  OUTPUT_POWER: null
  MAXIMUM_LIFT: null
  SPEED_RPM: null
  VOLTAGE: null
  ELEC_CURRENT: null
  SUBMERSIBLE: null
  EXPECTED_LIFE: null
  INSTALLATION_DATE: null
  REPLACEMENT_COST: null
  FIELD_INSPECTION_DATE: null
  FIELD_INSPECTION_CONDITION: null
  FIELD_NOTES: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata