Name: ValveInspection

Display Field: InspectionDate

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• ValveNumber_1 ( type: esriFieldTypeString , alias: Valve Number , length: 50 )
• InspectionDate ( type: esriFieldTypeDate , alias: Inspection Date , length: 8 )
• InspectedBy ( type: esriFieldTypeString , alias: Inspected By , length: 50 )
• Leaking ( type: esriFieldTypeString , alias: Leaking? , length: 10 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• Turned ( type: esriFieldTypeString , alias: Valve Turned? , length: 10 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• ValveExists ( type: esriFieldTypeString , alias: Replaced, Moved, Etc? , length: 35 )
• MovedTo ( type: esriFieldTypeString , alias: Moved To , length: 50 )
• NeedsRaising ( type: esriFieldTypeString , alias: Needs Raising , length: 50 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• ValveKey ( type: esriFieldTypeString , alias: Short Key or Long Key , length: 50 , Coded Values: [LONG: Long Key] , [SHORT: Short Key] , [OTH: Other] )
• ValveBox ( type: esriFieldTypeString , alias: Box Comments , length: 20 )
• MarkerPresent ( type: esriFieldTypeString , alias: Marker Present? , length: 10 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• InspectionGrade ( type: esriFieldTypeString , alias: Grade(Pass/Fail) , length: 10 , Coded Values: [PASS: Pass] , [FAIL: Fail] , [OTH: Other] )
• InspectionYear ( type: esriFieldTypeInteger , alias: Inspection Year )
• InspectionQuarter ( type: esriFieldTypeInteger , alias: Inspection Quarter )
• DatePassed ( type: esriFieldTypeDate , alias: Date Passed , length: 8 )
• DateFail ( type: esriFieldTypeDate , alias: Date Fail , length: 8 )
• Comments ( type: esriFieldTypeString , alias: Comments , length: 150 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• Condition ( type: esriFieldTypeString , alias: Condition , length: 50 , Coded Values: [B: Bad] , [BF: Blind Flanged] , [CAP: Capped Off] , ...9 more... )
• ValveFound ( type: esriFieldTypeString , alias: Found , length: 50 , Coded Values: [Closed: Closed] , [Open: Open] , [UNK: Unknown] )
• ValveOperable ( type: esriFieldTypeString , alias: Operable , length: 50 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• ValveLub ( type: esriFieldTypeString , alias: Lub , length: 50 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• 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 )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )

Relationships:

• Valve (3) -- Related To: Gas Valve (8)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata