Name: SDE.DBO.wValve_Inspections

Display Field: OBJECTID_1

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• OBJECTID_1 ( type: esriFieldTypeString, alias: OBJECTID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OBJECTID_1 )
• Facility_Identifier ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Identifier )
• Type_of_Valve_Operation ( type: esriFieldTypeString, alias: Type of Valve Operation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Type_of_Valve_Operation , Coded Values: [Routine Maintenance: Routine Maintenance] , [Main Isolation: Main Isolation] , [Repair: Repair] , ...2 more... )
• Valve_Box_Condition ( type: esriFieldTypeString, alias: Valve Box Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Valve_Box_Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Was_Valve_Exercised ( type: esriFieldTypeString, alias: Was Valve Exercised, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Was_Valve_Exercised , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Ease_of_Valve_Operation ( type: esriFieldTypeString, alias: Ease of Valve Operation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Ease_of_Valve_Operation , Coded Values: [Easy: Easy] , [Moderate: Moderate] , [Difficult: Difficult] , ...1 more... )
• Direction_to_Close ( type: esriFieldTypeString, alias: Direction to Close, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Direction_to_Close , Coded Values: [Clockwise: Clockwise] , [Counterclockwise: Counterclockwise] )
• Number_of_Turns ( type: esriFieldTypeString, alias: Number of Turns, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Number_of_Turns )
• Does_Valve_Close_Completely ( type: esriFieldTypeString, alias: Does Valve Close Completely, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Does_Valve_Close_Completely , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Are_Repairs_Needed ( type: esriFieldTypeString, alias: Are Repairs Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Are_Repairs_Needed , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Flow_Rate_GPM ( type: esriFieldTypeString, alias: Flow Rate GPM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flow_Rate_GPM )
• Field_Notes ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Field_Notes )
• Valve_Status ( type: esriFieldTypeString, alias: Valve Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Valve_Status , Coded Values: [Operational: Operational] , [Out of Service: Out of Service] , [Abandoned: Abandoned] )
• Date_Operated ( type: esriFieldTypeString, alias: Date Operated, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Date_Operated )
• Operated_By ( type: esriFieldTypeString, alias: Operated By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operated_By )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GlobalID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )

Templates:

• Name: SDE.DBO.wValve_Inspections
  Description:
  Prototype:
  GlobalID: null
  GUID: null
  OBJECTID_1: null
  Facility_Identifier: null
  Type_of_Valve_Operation: null
  Valve_Box_Condition: null
  Was_Valve_Exercised: null
  Ease_of_Valve_Operation: null
  Direction_to_Close: null
  Number_of_Turns: null
  Does_Valve_Close_Completely: null
  Are_Repairs_Needed: null
  Flow_Rate_GPM: null
  Field_Notes: null
  Valve_Status: null
  Date_Operated: null
  Operated_By: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.DBO.wSystemValve (1) -- Related To: wSystemValve (4)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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