Name: WW_Pumps
Display Field: Asset_Number
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 00e160d0c44e4f9f8be806f0e12b9930
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
Lift_Station
(
type: esriFieldTypeString, alias: Lift_Station, length: 1073741822
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 1073741822
)
-
Pump_Type
(
type: esriFieldTypeString, alias: Pump_Type, length: 1073741822
)
-
Pump_Number
(
type: esriFieldTypeString, alias: Pump_Number, length: 1073741822
)
-
Asset_Number
(
type: esriFieldTypeString, alias: Asset_Number, length: 1073741822
)
-
Model_Number
(
type: esriFieldTypeString, alias: Model_Number, length: 1073741822
)
-
Serial_Number
(
type: esriFieldTypeString, alias: Serial_Number, length: 1073741822
)
-
Drive_unit_number
(
type: esriFieldTypeString, alias: Drive_unit_number, length: 1073741822
)
-
Impeller_Code
(
type: esriFieldTypeString, alias: Impeller_Code, length: 1073741822
)
-
Horsepower
(
type: esriFieldTypeDouble, alias: Horsepower
)
-
Volts
(
type: esriFieldTypeInteger, alias: Volts
)
-
Phase
(
type: esriFieldTypeInteger, alias: Phase
)
-
Full_load_amps
(
type: esriFieldTypeDouble, alias: Full_load_amps
)
-
RPM
(
type: esriFieldTypeInteger, alias: RPM
)
-
Weight
(
type: esriFieldTypeString, alias: Weight, length: 1073741822
)
-
Wiring_Order
(
type: esriFieldTypeString, alias: Wiring_Order, length: 1073741822
)
-
Rebuild_Kit
(
type: esriFieldTypeString, alias: Rebuild_Kit, length: 1073741822
)
-
Stator
(
type: esriFieldTypeString, alias: Stator, length: 1073741822
)
-
Rotor
(
type: esriFieldTypeString, alias: Rotor, length: 1073741822
)
-
Impeller
(
type: esriFieldTypeString, alias: Impeller, length: 1073741822
)
-
Impeller_part
(
type: esriFieldTypeString, alias: Impeller_part, length: 1073741822
)
-
Impeller_part_oring
(
type: esriFieldTypeString, alias: Impeller_part_oring, length: 1073741822
)
-
Insert_ring
(
type: esriFieldTypeString, alias: Insert_ring, length: 1073741822
)
-
Volute_oring
(
type: esriFieldTypeString, alias: Volute_oring, length: 1073741822
)
-
Upper_seal
(
type: esriFieldTypeString, alias: Upper_seal, length: 1073741822
)
-
Lower_seal
(
type: esriFieldTypeString, alias: Lower_seal, length: 1073741822
)
-
Seal_Serial_num
(
type: esriFieldTypeString, alias: Seal_Serial_num, length: 1073741822
)
-
Inb_Bearing_lower
(
type: esriFieldTypeString, alias: Inb_Bearing_lower, length: 1073741822
)
-
Outb_Bearing_upr
(
type: esriFieldTypeString, alias: Outb_Bearing_upr, length: 1073741822
)
-
PT_100_sensor
(
type: esriFieldTypeString, alias: PT_100_sensor, length: 1073741822
)
-
Oil_type_Quantity
(
type: esriFieldTypeString, alias: Oil_type_Quantity, length: 1073741822
)
-
Antifreeze_Info
(
type: esriFieldTypeString, alias: Antifreeze_Info, length: 1073741822
)
-
Stationary_wear_ring
(
type: esriFieldTypeString, alias: Stationary_wear_ring, length: 1073741822
)
-
Lifting_handle
(
type: esriFieldTypeString, alias: Lifting_handle, length: 1073741822
)
-
Rotating_wear_ring
(
type: esriFieldTypeString, alias: Rotating_wear_ring, length: 1073741822
)
-
Cable
(
type: esriFieldTypeString, alias: Cable, length: 1073741822
)
-
Guide_Claw
(
type: esriFieldTypeString, alias: Guide_Claw, length: 1073741822
)
-
Inpsection_screws
(
type: esriFieldTypeString, alias: Inpsection_screws, length: 1073741822
)
-
Inpsection_screws_X
(
type: esriFieldTypeDouble, alias: Inpsection_screws_X
)
-
Inpsection_screws_Y
(
type: esriFieldTypeDouble, alias: Inpsection_screws_Y
)
-
Location
(
type: esriFieldTypeString, alias: Location Details, length: 50
)
-
Address
(
type: esriFieldTypeString, alias: Location, length: 255
)
-
Process
(
type: esriFieldTypeString, alias: Process, length: 255
)
-
Condition
(
type: esriFieldTypeDouble, alias: Condition
)
-
ConditionDate
(
type: esriFieldTypeDate, alias: Condition Date, length: 8
)
-
LifeExpectancy
(
type: esriFieldTypeSmallInteger, alias: Life Expectancy
)
-
COF
(
type: esriFieldTypeSmallInteger, alias: Consequence of Failure
)
-
POF
(
type: esriFieldTypeSmallInteger, alias: Probability of Failure
)
-
BRE
(
type: esriFieldTypeSmallInteger, alias: Business Risk of Failure
)
-
Structure
(
type: esriFieldTypeString, alias: Structure/Basin, length: 255
)
-
Room
(
type: esriFieldTypeString, alias: Room, length: 255
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata