Name: WaterHydrantMaint

Display Field: MaintenceType

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 )
• MaintenceType ( type: esriFieldTypeString, alias: Maintence Type, length: 255 , Coded Values: [Roping: Hydrant Roping] , [Painting: Hydrant Painting] , [Inspection: Hydrant Inspection] , ...2 more... )
• DateRequested ( type: esriFieldTypeDate, alias: Date Requested, length: 8 )
• DatePerformed ( type: esriFieldTypeDate, alias: Date Performed, length: 8 )
• PerformedBy ( type: esriFieldTypeString, alias: Performed By, length: 255 )
• Flushed ( type: esriFieldTypeString, alias: Flushed?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• FlushTime ( type: esriFieldTypeInteger, alias: Flush Time (min) )
• ChlorineTest ( type: esriFieldTypeString, alias: Chlorine Test, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• TurbidityTest ( type: esriFieldTypeString, alias: Turbidity Test?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PressureTest ( type: esriFieldTypeString, alias: Pressure Test?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• SoundTest ( type: esriFieldTypeString, alias: Sound Test?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PaintQuality ( type: esriFieldTypeSmallInteger, alias: Paint Quality , Coded Values: [1: 1 (Poor)] , [2: 2 (Fair)] , [3: 3 (Good)] )
• YearMakeCorrect ( type: esriFieldTypeString, alias: Year Make Correct?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PrimaryIssue ( type: esriFieldTypeString, alias: Primary Issue, length: 255 , Coded Values: [Cannot Turn: Cannot Turn] , [Turns Hard: Turns Hard] , [No Drain: No Drain] , ...4 more... )
• SecondaryIssue ( type: esriFieldTypeString, alias: Secondary Issue, length: 255 , Coded Values: [Cannot Turn: Cannot Turn] , [Turns Hard: Turns Hard] , [No Drain: No Drain] , ...4 more... )
• Roped ( type: esriFieldTypeString, alias: Roped?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• RopedDate ( type: esriFieldTypeDate, alias: Roped Date, length: 8 )
• Pumped ( type: esriFieldTypeString, alias: Pumped?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PumpDate ( type: esriFieldTypeDate, alias: Pump Date, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Greased ( type: esriFieldTypeString, alias: Greased?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Thawed ( type: esriFieldTypeString, alias: Thawed?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• ThawedDate ( type: esriFieldTypeDate, alias: Thawed Date, length: 8 )
• AWID ( type: esriFieldTypeString, alias: AW ID, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• YearMakeUpdate ( type: esriFieldTypeString, alias: Update of Year and Make, length: 255 )
• SandblastedDate ( type: esriFieldTypeDate, alias: Sandblasted Date, length: 8 )
• PrimedDate ( type: esriFieldTypeDate, alias: Prime Coat, length: 8 )
• Color ( type: esriFieldTypeString, alias: Color?, length: 255 , Coded Values: [Red: Red] , [Blue: Blue] )
• PaintDate1 ( type: esriFieldTypeDate, alias: 1st Paint Date, length: 8 )
• Beads ( type: esriFieldTypeString, alias: Beads Added, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Chlorine_Results ( type: esriFieldTypeDouble, alias: Chlorine Results_old )
• PressureWash_By ( type: esriFieldTypeString, alias: Pressure Wash By, length: 255 )
• Primed_By ( type: esriFieldTypeString, alias: Primed By, length: 255 )
• Paint_By ( type: esriFieldTypeString, alias: Painted By, length: 255 )
• Chlorine_Start ( type: esriFieldTypeDouble, alias: Chlorine Start Results )
• Chlorine_End ( type: esriFieldTypeDouble, alias: Chlorine End Results )
• PilotPressure ( type: esriFieldTypeDouble, alias: Pitot Pressure )

Relationships:

• GIS_CityUtilities.DBO.water_hydrant (0) -- Related To: Hydrant (5)

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

  Iteminfo   Thumbnail   Metadata