Name: Pump

Display Field: ASSETNAME

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString , alias: Asset ID , length: 100 )
• ASSETNAME ( type: esriFieldTypeString , alias: Asset Name , length: 255 )
• ASSETTYPE ( type: esriFieldTypeString , alias: Asset Type , length: 50 )
• ASSETOWNER ( type: esriFieldTypeString , alias: Asset Owner , length: 50 , Coded Values: [Airports: Airports] , [HHSA: HHSA] , [Parks: Parks] , ...3 more... )
• LEGACYID ( type: esriFieldTypeString , alias: Legacy ID , length: 50 )
• TAGNUMBER ( type: esriFieldTypeString , alias: Tag Number , length: 50 )
• STATUS ( type: esriFieldTypeString , alias: Status , length: 30 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Spare: Spare] )
• PARENTID ( type: esriFieldTypeString , alias: Parent ID , length: 100 )
• STARTUPDATE ( type: esriFieldTypeDate , alias: Startup Date , length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate , alias: Warranty Date , length: 8 )
• CONDITIONSCORE ( type: esriFieldTypeSmallInteger , alias: Condition Score )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , length: 8 )
• ADDRESS ( type: esriFieldTypeString , alias: Address , length: 255 )
• LOCATION ( type: esriFieldTypeString , alias: Location , length: 255 )
• SITE ( type: esriFieldTypeString , alias: Site , length: 30 , Coded Values: [JUWWTP0019: Heise Park WWTP] , [PVWWTP0007: Pine Valley WWTP] , [SVWWPS0010: Rancho San Diego PS] , ...39 more... )
• MANUFACTURER ( type: esriFieldTypeString , alias: Manufacturer , length: 30 )
• MANPHONE ( type: esriFieldTypeString , alias: Manufacturer Phone # , length: 16 )
• MANWEBSITE ( type: esriFieldTypeString , alias: Manufacturer Website , length: 30 )
• MODEL ( type: esriFieldTypeString , alias: Model , length: 30 )
• SERIALNO ( type: esriFieldTypeString , alias: Serial Number , length: 30 )
• VENDOR ( type: esriFieldTypeString , alias: Vendor , length: 30 )
• SPECLINK ( type: esriFieldTypeString , alias: Spec Link , length: 64 )
• OMLINK ( type: esriFieldTypeString , alias: O&M Link , length: 64 )
• SYSTEM ( type: esriFieldTypeString , alias: System Designator , length: 40 , Coded Values: [Conveyance: Conveyance] , [Screening: Screening] , [Grit Removal: Grit Removal] , ...10 more... )
• LOF ( type: esriFieldTypeSmallInteger , alias: LoF Score )
• COF ( type: esriFieldTypeSmallInteger , alias: CoF Score )
• RISK ( type: esriFieldTypeSmallInteger , alias: Risk Score )
• CRITICALITY ( type: esriFieldTypeString , alias: Criticality , length: 16 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• REPLACEVALUE ( type: esriFieldTypeDouble , alias: Replacement Value )
• VALUEDATE ( type: esriFieldTypeDate , alias: Valuation Date , length: 8 )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 255 )
• CREATOR ( type: esriFieldTypeString , alias: Creator , length: 30 )
• CREATEDATE ( type: esriFieldTypeDate , alias: Created , length: 8 )
• EDITOR ( type: esriFieldTypeString , alias: Editor , length: 30 )
• EDITDATE ( type: esriFieldTypeDate , alias: Edited , length: 8 )
• PMPTYPE ( type: esriFieldTypeString , alias: Type , length: 25 , Coded Values: [Chopper: Chopper] , [Scump: Scump] , [Submersible: Submersible] , ...8 more... )
• DISCHARGEHEAD ( type: esriFieldTypeSmallInteger , alias: Discharge Head )
• STATICDISPRESS ( type: esriFieldTypeSmallInteger , alias: Static Discharge Pressure )
• DYNDISPRESS ( type: esriFieldTypeSmallInteger , alias: Dynamic Discharge Pressure )
• RPM ( type: esriFieldTypeSmallInteger , alias: Rotations per Minute )
• SEALTYPE ( type: esriFieldTypeString , alias: Seal Type , length: 10 , Coded Values: [Mechanical: Mechanical] , [Packing: Packing] )
• NUMSTAGES ( type: esriFieldTypeSmallInteger , alias: Number of Stages )
• LUBEGREASE1 ( type: esriFieldTypeString , alias: Lubrication, Grease Primary , length: 30 )
• LUBEGREASE2 ( type: esriFieldTypeString , alias: Lubrication, Grease Secondary , length: 30 )
• LUBEOIL1 ( type: esriFieldTypeString , alias: Lubrication, Oil Primary , length: 30 )
• LUBEOIL2 ( type: esriFieldTypeString , alias: Lubrication, Oil Secondary , length: 30 )
• NUMIMPVANES ( type: esriFieldTypeSmallInteger , alias: Number of Impeller Vanes )
• IMPELLERMAT ( type: esriFieldTypeString , alias: Impeller Material , length: 30 )
• ROTATION ( type: esriFieldTypeString , alias: Rotation , length: 20 , Coded Values: [Clockwise: Clockwise] , [Counter-Clockwise: Counter-Clockwise] )
• DRIVETYPE ( type: esriFieldTypeString , alias: Drive , length: 8 , Coded Values: [Direct: Direct] , [Belt: Belt] , [Gearbox: Gearbox] , ...1 more... )
• COUPLINGTYPE ( type: esriFieldTypeString , alias: Coupling Type , length: 30 )
• COUPLINGMODEL ( type: esriFieldTypeString , alias: Coupling Model , length: 30 )
• BELTTYPE ( type: esriFieldTypeString , alias: Belt Type , length: 30 )
• DIAPHRAGMTYPE ( type: esriFieldTypeString , alias: Diaphragm Type , length: 30 )
• SPM ( type: esriFieldTypeSmallInteger , alias: Strokes per Minute )
• COUPLINGSIZE ( type: esriFieldTypeDouble , alias: COUPLINGSIZE )
• BELTSIZE ( type: esriFieldTypeDouble , alias: BELTSIZE )
• DISCHARGEDIAM ( type: esriFieldTypeDouble , alias: DISCHARGEDIAM )
• IMPELLERDIAM ( type: esriFieldTypeDouble , alias: IMPELLERDIAM )
• IMPSLEEVEDIAM ( type: esriFieldTypeDouble , alias: IMPSLEEVEDIAM )
• SUCTIONDIAM ( type: esriFieldTypeDouble , alias: SUCTIONDIAM )
• SERVICELIFE ( type: esriFieldTypeDouble , alias: SERVICELIFE )
• FLOWRATE ( type: esriFieldTypeString , alias: FLOWRATE , length: 50 )
• DIAPHRAGMSIZE ( type: esriFieldTypeDouble , alias: DIAPHRAGMSIZE )
• SUCTIONLIFT ( type: esriFieldTypeDouble , alias: SUCTIONLIFT )

Relationships:

• Pump Unit (274) -- Related To: Pump Unit (73)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata