Name: Water Valve Maintenance

Display Field: MaintenanceType

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0c8c6e4d24af4e3e88e04e950ef85cd6

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 )
• MaintenanceType ( type: esriFieldTypeString, alias: Maintenance Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceType , Coded Values: [Valve Repair: Valve Repair] , [Valve Replacement: Valve Replacement] , [Valve Turning: Valve Turning] )
• DateRequested ( type: esriFieldTypeDate, alias: Date Requested, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRequested )
• DatePerformed ( type: esriFieldTypeDate, alias: Date Performed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DatePerformed )
• PerformedBy ( type: esriFieldTypeString, alias: Performed By (Full Name), editable: true, nullable: true, length: 255, defaultValue: null, modelName: PerformedBy )
• HighLowKeepOFF ( type: esriFieldTypeString, alias: High/Low Keep OFF, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HighLowKeepOFF , Coded Values: [Yes: Yes] , [No: No] )
• PullUpTight ( type: esriFieldTypeString, alias: Pull Up Tight?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PullUpTight , Coded Values: [Yes: Yes] , [No: No] )
• TurnsHard ( type: esriFieldTypeString, alias: Turn Hard?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TurnsHard , Coded Values: [Yes: Yes] , [No: No] )
• DoNotTurn ( type: esriFieldTypeString, alias: Do NOT Turn, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DoNotTurn , Coded Values: [Yes: Yes] , [No: No] )
• BlockerTruckNeeded ( type: esriFieldTypeString, alias: Blocker Truck Needed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BlockerTruckNeeded , Coded Values: [Yes: Yes] , [No: No] )
• NumTurns ( type: esriFieldTypeInteger, alias: # of Turns, editable: true, nullable: true, defaultValue: null, modelName: NumTurns )
• Torque ( type: esriFieldTypeInteger, alias: Torque, editable: true, nullable: true, defaultValue: null, modelName: Torque )
• PrimaryIssue ( type: esriFieldTypeString, alias: Primary Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PrimaryIssue , Coded Values: [No Problem Found: No Problem Found] , [Box Shifted or Broken: Box Shifted or Broken] , [Needs to be Vac'd: Needs to be Vac'd] , ...10 more... )
• SecondaryIssues ( type: esriFieldTypeString, alias: Secondary Issues, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SecondaryIssues , Coded Values: [No Problem Found: No Problem Found] , [Box Shifted or Broken: Box Shifted or Broken] , [Needs to be Vac'd: Needs to be Vac'd] , ...10 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RepairType ( type: esriFieldTypeString, alias: RepairType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RepairType , Coded Values: [Leaking: Leaking] , [Nut Rounded: Nut Rounded] , [Nut Missing: Nut Missing] , ...9 more... )
• ReplaceType ( type: esriFieldTypeString, alias: ReplaceType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReplaceType , Coded Values: [Leaking: Leaking] , [Nut Rounded: Nut Rounded] , [Nut Missing: Nut Missing] , ...2 more... )
• MaintID ( type: esriFieldTypeString, alias: Maintenance ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintID )
• LayerDataUpdated ( type: esriFieldTypeDate, alias: Layer Data Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LayerDataUpdated )
• LayerUpdatedby ( type: esriFieldTypeString, alias: Layer Data Updated by, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LayerUpdatedby )
• RequestedBy ( type: esriFieldTypeString, alias: Requested By (Full Name), editable: true, nullable: true, length: 255, defaultValue: null, modelName: RequestedBy )
• LongKeyNeeded ( type: esriFieldTypeString, alias: Long Key Needed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LongKeyNeeded , Coded Values: [Yes: Yes] , [No: No] )
• DateStarted ( type: esriFieldTypeDate, alias: Date Started, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateStarted )
• StartedBy ( type: esriFieldTypeString, alias: Started By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StartedBy )
• BlockTruckRequested ( type: esriFieldTypeDate, alias: Blocker Truck Requested Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BlockTruckRequested )
• BlockTruckRequestedBy ( type: esriFieldTypeString, alias: Block Truck Requested By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BlockTruckRequestedBy )
• BlockedDate ( type: esriFieldTypeDate, alias: Blocked Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BlockedDate )
• BlockerTruckPerson ( type: esriFieldTypeString, alias: Blocker Truck Person, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BlockerTruckPerson )
• LongkeyRequestedDate ( type: esriFieldTypeDate, alias: LongkeyRequestedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LongkeyRequestedDate )
• LongkeyRequestedBy ( type: esriFieldTypeString, alias: Longkey Requested By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LongkeyRequestedBy )
• JackhammerNeeded ( type: esriFieldTypeString, alias: JackhammerNeeded, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JackhammerNeeded , Coded Values: [Yes: Yes] , [No: No] )
• JackhammerRequestDate ( type: esriFieldTypeDate, alias: Jackhammer Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JackhammerRequestDate )
• JackhammerRequestBy ( type: esriFieldTypeString, alias: Jackhammer Request By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JackhammerRequestBy )
• JackhammeredDate ( type: esriFieldTypeDate, alias: Jackhammerd Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JackhammeredDate )
• JackhammerdBy ( type: esriFieldTypeString, alias: Jackhammerd By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JackhammerdBy )
• VacNeeded ( type: esriFieldTypeString, alias: Vac Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VacNeeded , Coded Values: [Yes: Yes] , [No: No] )
• VacRequestDate ( type: esriFieldTypeDate, alias: Vac Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VacRequestDate )
• VacRequestBy ( type: esriFieldTypeString, alias: Vac Request By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VacRequestBy )
• VaccedDate ( type: esriFieldTypeDate, alias: Vacced Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VaccedDate )
• VaccedBy ( type: esriFieldTypeString, alias: Vacced By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VaccedBy )
• CaughtTurned ( type: esriFieldTypeString, alias: Caught and Turned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CaughtTurned , Coded Values: [Yes: Yes] , [No: No] )
• TurnDirection ( type: esriFieldTypeString, alias: Turn Direction, editable: true, nullable: true, length: 255, defaultValue: Regular, modelName: TurnDirection , Coded Values: [Regular: Regular] , [Reverse: Reverse] )

Templates:

• Name: Water Valve Maintenance
  Description:
  Prototype:
  CaughtTurned: null
  TurnDirection: Regular
  MaintenanceType: null
  DateRequested: null
  DatePerformed: null
  PerformedBy: null
  HighLowKeepOFF: null
  PullUpTight: null
  TurnsHard: null
  DoNotTurn: null
  BlockerTruckNeeded: null
  NumTurns: null
  Torque: null
  PrimaryIssue: null
  SecondaryIssues: null
  Comments: null
  RepairType: null
  ReplaceType: null
  MaintID: null
  LayerDataUpdated: null
  LayerUpdatedby: null
  RequestedBy: null
  LongKeyNeeded: null
  DateStarted: null
  StartedBy: null
  BlockTruckRequested: null
  BlockTruckRequestedBy: null
  BlockedDate: null
  BlockerTruckPerson: null
  LongkeyRequestedDate: null
  LongkeyRequestedBy: null
  JackhammerNeeded: null
  JackhammerRequestDate: null
  JackhammerRequestBy: null
  JackhammeredDate: null
  JackhammerdBy: null
  VacNeeded: null
  VacRequestDate: null
  VacRequestBy: null
  VaccedDate: null
  VaccedBy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GIS_CityUtilities.DBO.water_hydrant_valve (2) -- Related To: Hydrant Valve (3)
• GIS_CityUtilities.DBO.water_valve (0) -- Related To: Water Valve (0)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

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