Name: sPump

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SubType

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• AssetID ( type: esriFieldTypeString , alias: AssetID , editable: true , nullable: false , length: 30 )
• LegacyID ( type: esriFieldTypeString , alias: LegacyID , editable: true , nullable: true , length: 30 )
• InstallDate ( type: esriFieldTypeDate , alias: InstallDate , editable: true , nullable: true , length: 8 )
• SubType ( type: esriFieldTypeInteger , alias: Sub Tpye , editable: true , nullable: false )
• Status ( type: esriFieldTypeString , alias: Status , editable: true , nullable: true , length: 20 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Inactive: Inactive] , ...7 more... )
• WarrantyDate ( type: esriFieldTypeDate , alias: WarrantyDate , editable: true , nullable: true , length: 8 )
• Condition ( type: esriFieldTypeString , alias: Condition , editable: true , nullable: false , length: 10 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• ConditionDate ( type: esriFieldTypeDate , alias: ConditionDate , editable: true , nullable: true , length: 8 )
• PrimaryImage ( type: esriFieldTypeString , alias: PrimaryImage , editable: true , nullable: false , length: 250 )
• PumpType ( type: esriFieldTypeString , alias: PumpType , editable: true , nullable: true , length: 20 , Coded Values: [Centrifugal: Centrifugal] , [Ejector: Ejector] , [Grinder: Grinder] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 20 , Coded Values: [Chicago: Chicago] , [Flygt: Flygt] , [Fairbanks-Morris: Fairbanks-Morris] , ...13 more... )
• Model ( type: esriFieldTypeString , alias: Model , editable: true , nullable: true , length: 20 )
• Serial ( type: esriFieldTypeString , alias: Serial , editable: true , nullable: true , length: 20 )
• DesignCapacity ( type: esriFieldTypeDouble , alias: DesignCapacity , editable: true , nullable: true )
• TotalDynamicHead ( type: esriFieldTypeInteger , alias: TotalDynamicHead , editable: true , nullable: true )
• DEVICE_UID ( type: esriFieldTypeString , alias: DEVICE_UID , editable: true , nullable: true , length: 30 )
• DEVICE_SID ( type: esriFieldTypeString , alias: DEVICE_SID , editable: true , nullable: true , length: 10 )
• FEATURE_ID ( type: esriFieldTypeString , alias: FEATURE_ID , editable: true , nullable: true , length: 10 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• StationFacilityID ( type: esriFieldTypeString , alias: StationFacilityID , editable: true , nullable: true , length: 50 )
• InletDiameter ( type: esriFieldTypeDouble , alias: InletDiameter , editable: true , nullable: true , Coded Values: [2: 2"] , [2.5: 2.5"] , [3: 3"] , ...25 more... )
• OutletDiameter ( type: esriFieldTypeDouble , alias: OutletDiameter , editable: true , nullable: true , Coded Values: [2: 2"] , [2.5: 2.5"] , [3: 3"] , ...25 more... )
• ImpellerSize ( type: esriFieldTypeDouble , alias: ImpellerSize , editable: true , nullable: true , Coded Values: [1: 1"] , [2: 2"] , [3: 3"] , ...18 more... )
• Description ( type: esriFieldTypeString , alias: Description , editable: true , nullable: true , length: 50 )
• Voltage ( type: esriFieldTypeDouble , alias: Voltage , editable: true , nullable: true )
• Amperage ( type: esriFieldTypeDouble , alias: Amperage , editable: true , nullable: true )

Types:

ID: 1
Name: Dry Pit
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Dry Pit
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 1
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Dry Pit Submersible
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Dry Pit Submersible
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 2
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Submersible
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Submersible
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 3
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Self Prime
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Self Prime
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 4
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Vacuum Prime
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Vacuum Prime
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 5
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Split Case
Domains:
• Status:
  Inherited
• Condition:
  Inherited
• PumpType:
  Inherited
• Manufacturer:
  Inherited
• InletDiameter:
  Inherited
• OutletDiameter:
  Inherited
• ImpellerSize:
  Inherited
Templates:
• Name: Split Case
  Description:
  Prototype:
  Voltage: null
  Amperage: null
  AssetID:
  LegacyID: null
  InstallDate: null
  SubType: 6
  Status: null
  WarrantyDate: null
  Condition:
  ConditionDate: null
  PrimaryImage:
  PumpType: null
  Manufacturer: null
  Model: null
  Serial: null
  DesignCapacity: null
  TotalDynamicHead: null
  DEVICE_UID: null
  DEVICE_SID: null
  FEATURE_ID: null
  Description: null
  StationFacilityID: null
  InletDiameter: null
  OutletDiameter: null
  ImpellerSize: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• sMotor (14) -- Related To: sMotor (35)
• sPumpController (15) -- Related To: sPumpController (37)
• sValve (16) -- Related To: sValve (40)
• ssLiftStation (3) -- Related To: Sewer Lift Station (1)

Capabilities: Create,Delete,Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates