Name: Valve Exercise

Display Field: YearExercised

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 )
• ExerciseID ( type: esriFieldTypeInteger, alias: Exercise ID )
• facilityid ( type: esriFieldTypeString, alias: Facility ID, length: 255 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• ProgYR ( type: esriFieldTypeString, alias: Program Year, length: 255 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
• ValveSubtype ( type: esriFieldTypeString, alias: Valve Subtype, length: 255 , Coded Values: [Butterfly: Butterfly Valve] , [Gate: Gate Valve] , [Domestic: Domestic Valve] , ...1 more... )
• YearExercised ( type: esriFieldTypeSmallInteger, alias: Year Exercised )
• opendirection ( type: esriFieldTypeString, alias: Open Direction, length: 255 , Coded Values: [Left: Left] , [Right: Right] , [Unknown: Unknown] )
• turnstoclose1 ( type: esriFieldTypeDouble, alias: Turns to Close )
• Operable ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 255 , Coded Values: [Other: Other (See Crew Remarks)] , [BVD-KVD: VanDyke] )
• Name ( type: esriFieldTypeString, alias: Full Name(s), length: 255 )
• result ( type: esriFieldTypeString, alias: Result, length: 255 , Coded Values: [Passed: Passed] , [Failed: Failed] , [PassedWO: Passed (Needs Attention)] , ...1 more... )
• ResultRemarks1 ( type: esriFieldTypeString, alias: Result Remarks, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• UTILITY_MASTER_SDE.DBO.wSystemValve (2) -- Related To: System Valve (3)

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

  Iteminfo   Thumbnail   Metadata