Name: Pump

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• InstallDate ( type: esriFieldTypeDate , alias: Install Date , length: 8 )
• RehabDate ( type: esriFieldTypeDate , alias: Rehab Date , length: 8 )
• SerialNo ( type: esriFieldTypeString , alias: Serial Number , length: 30 )
• ModelNo ( type: esriFieldTypeString , alias: Model Number , length: 30 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , length: 55 , Coded Values: [Flygt_Xylem: Flygt/Xylem] , [Shinmaywa: Shinmaywa] , [Other: Other] )
• GPMRated ( type: esriFieldTypeDouble , alias: GPM Rated )
• THDRated ( type: esriFieldTypeDouble , alias: THD Rated )
• RPM ( type: esriFieldTypeDouble , alias: RPM )
• Voltage ( type: esriFieldTypeDouble , alias: Voltage , Coded Values: [230: 230] , [480: 480] , [230.48: 230.480] , ...2 more... )
• HP ( type: esriFieldTypeDouble , alias: HP )
• Material ( type: esriFieldTypeString , alias: Material , length: 100 , Coded Values: [Asbestos Cement: Asbestos Cement] , [Brick: Brick] , [Cast Iron: Cast Iron] , ...23 more... )
• Size ( type: esriFieldTypeString , alias: Size , length: 75 )
• Amperage ( type: esriFieldTypeDouble , alias: Amperage )
• ComponentID ( type: esriFieldTypeString , alias: Component ID , length: 55 )
• ParentID ( type: esriFieldTypeString , alias: Parent ID , length: 55 )
• Description ( type: esriFieldTypeString , alias: Description , length: 255 )
• COF ( type: esriFieldTypeDouble , alias: COF )
• LOF ( type: esriFieldTypeDouble , alias: LOF )
• Process ( type: esriFieldTypeString , alias: Process , length: 55 , Coded Values: [Mechanical: Mechanical] , [ICE: ICE] , [Civil: Civil] )
• Subprocess ( type: esriFieldTypeString , alias: Subprocess , length: 75 , Coded Values: [Valves: Valves] , [Electrical: Electrical] , [Control: Control] , ...3 more... )
• Service ( type: esriFieldTypeString , alias: Service , length: 30 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Retired: Retired] )
• Name ( type: esriFieldTypeString , alias: Name , length: 75 )
• Location ( type: esriFieldTypeString , alias: Location , length: 75 )
• GeneralCondition ( type: esriFieldTypeSmallInteger , alias: General Condition , Coded Values: [1: 1 - Excellent] , [2: 2 - Good] , [3: 3 - Fair] , ...2 more... )
• Vibration ( type: esriFieldTypeSmallInteger , alias: Vibration , Coded Values: [1: 1 - Excellent] , [2: 2 - Good] , [3: 3 - Fair] , ...2 more... )
• ExcessiveHeat ( type: esriFieldTypeSmallInteger , alias: Excessive Heat , Coded Values: [1: 1 - Excellent] , [2: 2 - Good] , [3: 3 - Fair] , ...2 more... )
• ExcessiveNoise ( type: esriFieldTypeSmallInteger , alias: Excessive Noise , Coded Values: [1: 1 - Excellent] , [2: 2 - Good] , [3: 3 - Fair] , ...2 more... )
• FacilityType ( type: esriFieldTypeString , alias: Facility Type , length: 55 , Coded Values: [Lift Station: Lift Station] , [Treatment Plant: Treatment Plant] )
• 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 )
• Notes ( type: esriFieldTypeString , alias: Notes , length: 255 )
• Impeller ( type: esriFieldTypeString , alias: Impeller , length: 10 )
• MixFlushValve ( type: esriFieldTypeString , alias: Mix/Flush Valve , length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Address ( type: esriFieldTypeString , alias: Address , length: 130 )
• EstimatedUse_Yrs ( type: esriFieldTypeSmallInteger , alias: Estimated Useful Life (yrs) )
• BRE ( type: esriFieldTypeDouble , alias: Business Risk Exposure )

Relationships:

• LS_Process (10) -- Related To: LS_Process (1)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata