Name: Water Valve Maintenance

Display Field: MaintenanceType

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 662d1384480849cb859f072483d05d65

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata