Name: wValveActivity

Display Field: ENTNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• VALVE_FUNCTION ( type: esriFieldTypeString, alias: VALVE_FUNCTION, length: 20 , Coded Values: [Control Valve: Control Valve] , [Flushing Valve: Flushing Valve] , [Hydrant Valve: Hydrant Valve] , ...3 more... )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, length: 30 , Coded Values: [Butterfly Valve: Butterfly Valve] , [Curb Stop: Curb Stop] , [Gate Valve: Gate Valve] , ...9 more... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• ENTID ( type: esriFieldTypeString, alias: ENTID, length: 10 )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, length: 50 )
• ROW_ID ( type: esriFieldTypeString, alias: ROW_ID, length: 20 )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID )
• CIVIC_ADDRESS ( type: esriFieldTypeString, alias: CIVIC_ADDRESS, length: 80 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 30 )
• VALVE_MAKE ( type: esriFieldTypeString, alias: VALVE_MAKE, length: 20 )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, length: 50 )
• POSITION ( type: esriFieldTypeString, alias: POSITION, length: 50 )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, length: 200 )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, length: 30 )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, length: 8 )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, length: 8 )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, length: 8 )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: NormallyOpen , Coded Values: [0: False] , [1: True] )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 50 )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• SURFACE_ELEVATION ( type: esriFieldTypeDouble, alias: SURFACE_ELEVATION )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, length: 8 )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, length: 16 )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, length: 8 )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, length: 16 )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, length: 20 )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LastActivity, length: 4 , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...6 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, length: 8 )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, length: 5 )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, length: 30 )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, length: 30 )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OperationalStatus, length: 10 , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• VALVEFUNCTION ( type: esriFieldTypeString, alias: ValveFunction, length: 15 , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...7 more... )
• TURNTOOPERATE ( type: esriFieldTypeDouble, alias: TURNTOOPERATE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• GPSX ( type: esriFieldTypeDouble, alias: GPSX )
• GPSY ( type: esriFieldTypeDouble, alias: GPSY )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 500 )
• CREW ( type: esriFieldTypeString, alias: CREW, length: 100 )
• ASSEMBLYTYPE ( type: esriFieldTypeString, alias: AssemblyType, length: 15 , Coded Values: [AIR: Air Valve] , [BLV: Ball valve] , [BFV: Butterfly Valve] , ...11 more... )
• OPERATIONALCOMMENTS ( type: esriFieldTypeString, alias: Operational Comments, length: 200 )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: ClockwiseToClose, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• UPDATEGPS ( type: esriFieldTypeString, alias: UpdateGps, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• MANUALTURN ( type: esriFieldTypeString, alias: MANUALTURN, length: 1 , Coded Values: [Y: Y] , [N: N] )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE )
• TORQUEDATA ( type: esriFieldTypeString, alias: TORQUEDATA, length: 1073741822 )
• GLAND_LEAK ( type: esriFieldTypeString, alias: GLAND_LEAK, length: 20 , Coded Values: [No gland leak: No gland leak] , [Steady: Steady] , [Stops when jammed: Stops when jammed] , ...1 more... )
• OPERATING_NUT ( type: esriFieldTypeString, alias: OPERATING_NUT, length: 16 , Coded Values: [Good Condition: Good Condition] , [Broken Off: Broken Off] , [Rounded: Rounded] , ...2 more... )
• VALVE_BROKEN ( type: esriFieldTypeString, alias: VALVE_BROKEN, length: 20 , Coded Values: [Good Condition: Good Condition] , [Valve Broken Open: Valve Broken Open] , [Valve Broken Closed: Valve Broken Closed] , ...3 more... )
• VALVE_BOX ( type: esriFieldTypeString, alias: VALVE_BOX, length: 20 , Coded Values: [Good Condition: Good Condition] , [Valve Box Broken: Valve Box Broken] , [Valve Box Shifted: Valve Box Shifted] , ...6 more... )
• VALVE_TURNS ( type: esriFieldTypeString, alias: VALVE_TURNS, length: 12 , Coded Values: [Normal: Normal] , [Above Normal: Above Normal] , [Below Normal: Below Normal] , ...1 more... )
• VALVE_PRIORITY ( type: esriFieldTypeString, alias: VALVE_PRIORITY, length: 12 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...2 more... )
• METHOD_OF_REPAIR ( type: esriFieldTypeString, alias: METHOD_OF_REPAIR, length: 16 , Coded Values: [by hand: by hand] , [by excavation: by excavation] , [by vac dig: by vac dig] )
• GLAND_LEAK_REPAIR ( type: esriFieldTypeString, alias: GLAND_LEAK_REPAIR, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OPERATING_NUT_REPAIR ( type: esriFieldTypeString, alias: OPERATING_NUT_REPAIR, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• VALVE_BOX_REPAIR ( type: esriFieldTypeString, alias: VALVE_BOX_REPAIR, length: 16 , Coded Values: [VB raised: VB raised] , [VB lowered: VB lowered] , [VB repaired: VB repaired] )
• MAXIMO_WO ( type: esriFieldTypeString, alias: MAXIMO_WO, length: 10 )

Relationships:

• SDE_USER.wValve (0) -- Related To: System Valves (6)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata