Name: sPS_PUMP_ASSETS_SUBMERSIBLE

Display Field: PUMP_ASSETS_SUBMERSIBLEID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4f652d167eba41e58d38afb44241a0ca

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, 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: 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: System-maintained ObjectID )
• PUMP_ASSETS_SUBMERSIBLEID ( type: esriFieldTypeString, alias: Pump Assets Submersible ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_ASSETS_SUBMERSIBLEID )
• PUMPID ( type: esriFieldTypeString, alias: Pump ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMPID )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 25, defaultValue: ACTIVE, modelName: LIFECYCLE_STATUS )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• OWNED_BY ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 10, defaultValue: COUNTY, modelName: OWNED_BY )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 10, defaultValue: COUNTY, modelName: MAINTAINED_BY )
• RESPONSIBLE_AGENCY ( type: esriFieldTypeString, alias: Responsible Agency, editable: true, nullable: true, length: 75, defaultValue: DEPARTMENT OF PUBLIC WORKS, modelName: RESPONSIBLE_AGENCY )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CONDITION_DATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_DATE )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• WARRANTY_DATE ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTY_DATE )
• REHABILITATION_DATE ( type: esriFieldTypeDate, alias: Rehabilitation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REHABILITATION_DATE )
• REHABILITATION_TYPE ( type: esriFieldTypeString, alias: Rehabilitation Type, editable: true, nullable: true, length: 120, defaultValue: null, modelName: REHABILITATION_TYPE )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 120, defaultValue: null, modelName: MANUFACTURER )
• MFG_SERIAL_NUMBER ( type: esriFieldTypeString, alias: Manufacturer Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MFG_SERIAL_NUMBER )
• MFG_MODEL_NUMBER ( type: esriFieldTypeString, alias: Manufacturer Model Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MFG_MODEL_NUMBER )
• WORKING_CONDITION ( type: esriFieldTypeString, alias: Working Condition, editable: true, nullable: true, length: 30, defaultValue: ONLINE, modelName: WORKING_CONDITION )
• PUMP_CATEGORY ( type: esriFieldTypeString, alias: Pump Category, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PUMP_CATEGORY )
• PUMP_TYPE ( type: esriFieldTypeString, alias: Pump Type, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PUMP_TYPE )
• PUMP_SIZE ( type: esriFieldTypeDouble, alias: Pump Size, editable: true, nullable: true, defaultValue: null, modelName: PUMP_SIZE )
• PUMP_FLOW_RATE ( type: esriFieldTypeDouble, alias: Pump Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: PUMP_FLOW_RATE )
• PUMP_RPM ( type: esriFieldTypeDouble, alias: Pump RPM, editable: true, nullable: true, defaultValue: null, modelName: PUMP_RPM )
• 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: sPS_PUMP_ASSETS_SUBMERSIBLE
  Description:
  Prototype:
  PUMP_RPM: null
  PUMP_FLOW_RATE: null
  PUMP_ASSETS_SUBMERSIBLEID: null
  PUMPID: null
  LIFECYCLE_STATUS: ACTIVE
  LOCATION: null
  OWNED_BY: COUNTY
  MAINTAINED_BY: COUNTY
  RESPONSIBLE_AGENCY: DEPARTMENT OF PUBLIC WORKS
  CONDITION: null
  CONDITION_DATE: null
  INSTALL_DATE: null
  WARRANTY_DATE: null
  REHABILITATION_DATE: null
  REHABILITATION_TYPE: null
  NOTES: null
  MANUFACTURER: null
  MFG_SERIAL_NUMBER: null
  MFG_MODEL_NUMBER: null
  WORKING_CONDITION: ONLINE
  PUMP_CATEGORY: null
  PUMP_TYPE: null
  PUMP_SIZE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• sPS_PUMP_SUBMERSIBLE (66) -- Related To: sPS_PUMP_SUBMERSIBLE (75)

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 Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata