Name: wPump

Display Field: COMPKEY

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a3e230e60e774db7a1cc1495a9106f05

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 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssetID )
• ParentAssetID ( type: esriFieldTypeString, alias: ParentAssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ParentAssetID )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Description )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location , Coded Values: )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address )
• Safety_Note ( type: esriFieldTypeString, alias: Safety_Note, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Safety_Note )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 25, defaultValue: null, modelName: District , Coded Values: )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PresZone , Coded Values: )
• Pump_Type ( type: esriFieldTypeString, alias: Pump Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PumpType , Coded Values: )
• Size ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Size )
• PCurve ( type: esriFieldTypeString, alias: Pump Curve, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PCurve )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• GreaseType ( type: esriFieldTypeString, alias: Grease Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GreaseType , Coded Values: )
• Oil_Type ( type: esriFieldTypeString, alias: Oil Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Oil_Type , Coded Values: )
• Oil_Cap ( type: esriFieldTypeString, alias: Oil Capacity, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Oil_Cap )
• Head ( type: esriFieldTypeString, alias: Head, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Head )
• Amps ( type: esriFieldTypeString, alias: Amperage, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Amps )
• Voltage ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Volts )
• Stage ( type: esriFieldTypeString, alias: Stage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Stage )
• BearingType ( type: esriFieldTypeString, alias: BearingType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BearingType , Coded Values: )
• Brg_In ( type: esriFieldTypeString, alias: Bearing Inboard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BRG1 )
• Brg_Out ( type: esriFieldTypeString, alias: Bearing Outboard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BRG2 )
• StartType ( type: esriFieldTypeString, alias: Start_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Start_Type )
• Fixed_Mobile ( type: esriFieldTypeString, alias: Fixed_Mobile, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Fixed_Mobile , Coded Values: [FIXED: FIXED OR STATIONARY] , [MOBILE: MOBILE] )
• Encl_Type ( type: esriFieldTypeString, alias: Enclosure Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Encl_Type , Coded Values: )
• SealType ( type: esriFieldTypeString, alias: Seal_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Seal_Type , Coded Values: )
• SealNum ( type: esriFieldTypeString, alias: Seal Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SealNum )
• Frame ( type: esriFieldTypeString, alias: Frame, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Frame )
• PO_Num ( type: esriFieldTypeString, alias: PO_Num, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PO_Num )
• PTag1 ( type: esriFieldTypeString, alias: Property Tag, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PTag1 )
• Engine_FuelType ( type: esriFieldTypeString, alias: Engine Fuel Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngineFuel_Type , Coded Values: )
• Eng_Manufact ( type: esriFieldTypeString, alias: Engine_Manufact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Engine_Manufact , Coded Values: )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: )
• ModelNum ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModelNum )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, editable: true, nullable: true, length: 125, defaultValue: null, modelName: SerialNum )
• MapNum ( type: esriFieldTypeString, alias: Map Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MapNum )
• BudgetNum ( type: esriFieldTypeString, alias: Budget Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BudgetNum )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LifecycleStatus , Coded Values: [In Service: In Service - In Service] , [Out of Service: Out of Service - Out of Service] , [Abandoned: Abandoned - Abandoned] , ...3 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Condition , Coded Values: )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Condition_Date )
• ConditionScore ( type: esriFieldTypeDouble, alias: Condition Score, editable: true, nullable: true, defaultValue: null, modelName: ConditionScore )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: )
• Img_Path ( type: esriFieldTypeString, alias: Image Path, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Img_Path )
• Asbuilt ( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Asbuilt )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• POF ( type: esriFieldTypeDouble, alias: POF, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: COF, editable: true, nullable: true, defaultValue: null, modelName: COF )
• BRE ( type: esriFieldTypeDouble, alias: BRE, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• HP ( type: esriFieldTypeString, alias: HP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HP )
• ImpDiam ( type: esriFieldTypeSmallInteger, alias: Impeller Diameter, editable: true, nullable: true, defaultValue: null, modelName: ImpDiam )
• PSI ( type: esriFieldTypeString, alias: PSI, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PSI )
• RPM ( type: esriFieldTypeString, alias: RPM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RPM )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phase )
• TDH ( type: esriFieldTypeString, alias: TDH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TDH )

Templates:

• Name: wPump
  Description:
  Prototype:
  Phase: null
  RPM: null
  COMPKEY: null
  LegacyID: null
  AssetID: null
  ParentAssetID: null
  Description: null
  Location: null
  Address: null
  Safety_Note: null
  District: null
  PressureZone: null
  Pump_Type: null
  Size: null
  PCurve: null
  Depth: null
  GreaseType: null
  Oil_Type: null
  Oil_Cap: null
  Head: null
  Amps: null
  Voltage: null
  Stage: null
  BearingType: null
  Brg_In: null
  Brg_Out: null
  StartType: null
  Fixed_Mobile: null
  Encl_Type: null
  SealType: null
  SealNum: null
  Frame: null
  PO_Num: null
  PTag1: null
  Engine_FuelType: null
  Eng_Manufact: null
  Manufacturer: null
  ModelNum: null
  SerialNum: null
  MapNum: null
  BudgetNum: null
  InstallationDate: null
  WarrantyDate: null
  LifecycleStatus: null
  Condition: null
  ConditionDate: null
  ConditionScore: null
  Owner: null
  Img_Path: null
  Asbuilt: null
  Comments: null
  POF: null
  COF: null
  BRE: null
  PSI: null
  ImpDiam: null
  HP: null
  TDH: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• wWell (0) -- Related To: wWell (0)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata