Name: Valve Maintenance

Display Field: Facility_Identifier

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ad70ab8f51fc4da6a4d39fac96323779

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

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

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• Facility_Identifier ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Identifier )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspected_By )
• Inspected_Turns ( type: esriFieldTypeString, alias: Inspected Turns, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspected_Turns )
• Unable_to_Turn ( type: esriFieldTypeString, alias: Unable to Turn, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Unable_to_Turn )
• Inspected_Size ( type: esriFieldTypeString, alias: Inspected Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspected_Size )
• Location_of_Valve ( type: esriFieldTypeString, alias: Location of Valve, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location_of_Valve )
• Valve_Access ( type: esriFieldTypeString, alias: Valve Access, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Valve_Access )
• Valve_Keyable ( type: esriFieldTypeString, alias: Valve Keyable, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Valve_Keyable )
• Harrware_Condition ( type: esriFieldTypeString, alias: Harrware Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Harrware_Condition )
• Dead_end ( type: esriFieldTypeString, alias: Dead end, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Dead_end )
• Inspection_notes ( type: esriFieldTypeString, alias: Inspection notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspection_notes )
• Surface_Type ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surface_Type )
• Pump_Down ( type: esriFieldTypeString, alias: Pump Down, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pump_Down )
• Could_Not_Locate ( type: esriFieldTypeString, alias: Could Not Locate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Could_Not_Locate )
• Unable_To_Turn_Reason ( type: esriFieldTypeString, alias: Unable To Turn Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Unable_To_Turn_Reason )
• Do_Not_Open ( type: esriFieldTypeString, alias: Do Not Open, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Do_Not_Open )
• Issue ( type: esriFieldTypeString, alias: Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Issue )
• ValveGLOBAL ( type: esriFieldTypeGUID, alias: Valve GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ValveGLOBAL )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONDITION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• GISNOTES ( type: esriFieldTypeString, alias: GIS Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISNOTES )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• MACHINETURN ( type: esriFieldTypeString, alias: Machine Turn, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MACHINETURN )
• NUMTURNS ( type: esriFieldTypeDouble, alias: Num Turns, editable: true, nullable: true, defaultValue: null, modelName: NUMTURNS )
• POSITION ( type: esriFieldTypeString, alias: Position, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POSITION )
• ROTATION ( type: esriFieldTypeString, alias: Rotation, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ROTATION )
• TIMESEXERCISED ( type: esriFieldTypeSmallInteger, alias: Time Exercised, editable: true, nullable: true, defaultValue: null, modelName: TIMESEXERCISED )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVETYPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Valve Maintenance
  Description:
  Prototype:
  VALVETYPE: null
  TIMESEXERCISED: null
  Facility_Identifier: null
  Inspection_Date: null
  Inspected_By: null
  Inspected_Turns: null
  Unable_to_Turn: null
  Inspected_Size: null
  Location_of_Valve: null
  Valve_Access: null
  Valve_Keyable: null
  Harrware_Condition: null
  Dead_end: null
  Inspection_notes: null
  Surface_Type: null
  Pump_Down: null
  Could_Not_Locate: null
  Unable_To_Turn_Reason: null
  Do_Not_Open: null
  Issue: null
  ValveGLOBAL: null
  CONDITION: null
  DIAMETER: null
  GISNOTES: null
  LOCATION: null
  MACHINETURN: null
  NUMTURNS: null
  POSITION: null
  ROTATION: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.wSystemValve (1) -- Related To: System Valves (29)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata