Name: Pump Station Motor

Display Field: LegacyID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1b15a571ddfa4756be69f800b988be82

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: )
• Asset_Type ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EquipmentType , Coded Values: )
• Amps ( type: esriFieldTypeString, alias: Amps, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Amps )
• Engine_FuelType ( type: esriFieldTypeString, alias: Engine Fuel Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Eng_Fuel , Coded Values: )
• Fcons ( type: esriFieldTypeString, alias: Fuel Consumption, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Fcons )
• GreaseType ( type: esriFieldTypeString, alias: GreaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GreaseType )
• Brg_In ( type: esriFieldTypeString, alias: Bearing Inboard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Motor_BrgIn )
• Brg_Out ( type: esriFieldTypeString, alias: Bearing Outboard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Motor_BrgOut )
• Brg_U ( type: esriFieldTypeString, alias: Bearing Upper, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Motor_BrgUpper )
• Frame ( type: esriFieldTypeString, alias: Frame, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Motor_Frame )
• Oil_TypeUpper ( type: esriFieldTypeString, alias: Oil Type Upper, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Oil_TypeUpper )
• Oil_TypeLower ( type: esriFieldTypeString, alias: Oil Type Lower, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Oil_TypeLower )
• Poles ( type: esriFieldTypeString, alias: Poles, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Poles )
• Torq ( type: esriFieldTypeString, alias: Torq, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Torq )
• 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 )
• 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: [CITY: City of Santa Rosa] , [CNTY: Sonoma County] , [PGE: PG&E] , ...4 more... )
• 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: Horse Power, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HP )
• HZ ( type: esriFieldTypeString, alias: Hertz, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HZ )
• KVA ( type: esriFieldTypeString, alias: Kilovolt Amperage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KVA )
• KW ( type: esriFieldTypeString, alias: Kilowatts, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KW )
• RPM ( type: esriFieldTypeString, alias: Motor RPM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MRPM )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phase )
• Voltage ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Volts )

Templates:

• Name: Pump Station Motor
  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
  Asset_Type: null
  Amps: null
  Engine_FuelType: null
  Fcons: null
  GreaseType: null
  Brg_In: null
  Brg_Out: null
  Brg_U: null
  Frame: null
  Oil_TypeUpper: null
  Oil_TypeLower: null
  Poles: null
  Torq: null
  PO_Num: null
  Ptag1: 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
  KW: null
  KVA: null
  HZ: null
  HP: null
  Voltage: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Pump Station - Water (4) -- Related To: Pump Station - Water (4)

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