Name: ValveInspection

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: ValveInspection
  Description:
  Prototype:
  ValveFound: null
  Condition: null
  ValveLub: null
  InspectionDate: null
  Leaking: null
  Turned: null
  ValveExists: null
  MovedTo: null
  NeedsRaising: null
  ValveKey: null
  ValveBox: null
  MarkerPresent: null
  InspectedBy: null
  InspectionGrade: null
  InspectionYear: null
  InspectionQuarter: null
  DatePassed: null
  DateFail: null
  Comments: null
  ValveOperable: null
  ValveNumber_1: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Create,Query,Update,Sync,Delete,Extract,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: false
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata