Name: HydrantHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderkey ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• staticpressure ( type: esriFieldTypeDouble, alias: Static Pressure )
• residualpressure ( type: esriFieldTypeDouble, alias: Residual Pressure )
• pitotpressure ( type: esriFieldTypeDouble, alias: Pitot Pressure )
• flow ( type: esriFieldTypeDouble, alias: Flow )
• nozzlediameter ( type: esriFieldTypeDouble, alias: Nozzle Diameter , Coded Values: [2: 2] , [2.5: 2.5] , [4: 4] , ...2 more... )
• flowduration ( type: esriFieldTypeInteger, alias: Flow Duration )
• gallonsused ( type: esriFieldTypeInteger, alias: GallonsUsed )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: WorkType, length: 50 , Coded Values: [2 Hydrant Fire Flow Test: 2 Hydrant Fire Flow Test] , [1 Hydrant Fire Flow Test: 1 Hydrant Fire Flow Test] , [Hydrant Maintenance: Hydrant Maintenance] , ...4 more... )
• comments ( type: esriFieldTypeString, alias: Maintenance Comments, length: 1000 )
• paint ( type: esriFieldTypeString, alias: Paint Condition, length: 50 , Coded Values: [Good: Good] , [Needs Painted: Needs Painted] , [Needs Stenciled: Needs Stenciled] , ...1 more... )
• stencil ( type: esriFieldTypeString, alias: Stencil, length: 50 )
• flowat20 ( type: esriFieldTypeDouble, alias: Flow at 20 )
• caps ( type: esriFieldTypeString, alias: Caps Condition, length: 50 )
• chains ( type: esriFieldTypeString, alias: Chains Condition, length: 50 , Coded Values: [excellent: Excellent] , [good: Good] , [fair: Fair] , ...2 more... )
• drainage ( type: esriFieldTypeString, alias: Drainage Condition, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• nozzle ( type: esriFieldTypeString, alias: Nozzle, length: 50 )
• nozzleleaks ( type: esriFieldTypeString, alias: Nozzle Leaks, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• nozzlegreased ( type: esriFieldTypeString, alias: Nozzle Greased, length: 50 )
• residuallocation ( type: esriFieldTypeString, alias: Residual PSI Reading Location, length: 50 )
• clearance ( type: esriFieldTypeString, alias: Clearance, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• height ( type: esriFieldTypeString, alias: Height, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• obstruction ( type: esriFieldTypeString, alias: Obstruction, length: 50 )
• commentzone ( type: esriFieldTypeString, alias: Clear Zone Obstructions Comment, length: 250 )
• leadnozzle ( type: esriFieldTypeString, alias: Lead Nozzle, length: 50 )
• capthreadseal ( type: esriFieldTypeString, alias: Cap Thread Seal, length: 50 )
• commentcapnozzle ( type: esriFieldTypeString, alias: Comment Cap/Nozzle, length: 250 , Coded Values: [Yes: Yes] , [Repaired: Repaired] , [Replaced: Replaced] )
• initialcondition ( type: esriFieldTypeString, alias: Initial Condition, length: 50 , Coded Values: [Easy: Easy] , [Hard: Hard] , [Medium: Medium] )
• stemoiledexercised ( type: esriFieldTypeString, alias: Stem Oiled/Exercised, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• finalcondition ( type: esriFieldTypeString, alias: Final Condition, length: 50 , Coded Values: [Easy: Easy] , [Hard: Hard] , [Medium: Medium] )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work, length: 250 , Coded Values: [No: No] , [Replace: Replace] , [Future Replace: Future Replace] )
• commentaddwork ( type: esriFieldTypeString, alias: Additional Work Comment, length: 250 )
• beginturbidity ( type: esriFieldTypeDouble, alias: Beginning Turbidity )
• begincl2 ( type: esriFieldTypeDouble, alias: Beginning Chlorine )
• beginwatertemp ( type: esriFieldTypeDouble, alias: Beginning Water Temperature )
• endturbidity ( type: esriFieldTypeDouble, alias: Ending Turbidity )
• endcl2 ( type: esriFieldTypeDouble, alias: Ending Chlorine )
• ph ( type: esriFieldTypeDouble, alias: pH )
• pitot ( type: esriFieldTypeDouble, alias: Pitot )
• testduration ( type: esriFieldTypeDouble, alias: Test Duration )
• issue ( type: esriFieldTypeString, alias: Issue, length: 250 )
• flowrate ( type: esriFieldTypeString, alias: Flow Rate, length: 50 )
• DataValidComment ( type: esriFieldTypeString, alias: DataValidComment, length: 500 )
• WorkInitials ( type: esriFieldTypeString, alias: Work Initials, length: 255 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: AttachmentID3 )
• WorkingHours ( type: esriFieldTypeInteger, alias: WorkingHours )
• Man_Hours_Breakdown ( type: esriFieldTypeString, alias: Man Hours Breakdown, length: 500 )
• Pressure ( type: esriFieldTypeInteger, alias: Pressure )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• DataValid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, length: 255 )
• SolidStem ( type: esriFieldTypeString, alias: Solid Stem, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• PaintStencil ( type: esriFieldTypeString, alias: Paint/Stencil, length: 255 , Coded Values: [Good: Good] , [Needs Painted: Needs Painted] , [Needs Stenciled: Needs Stenciled] , ...1 more... )
• DataValid ( type: esriFieldTypeString, alias: Data Valid, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )

Relationships:

• GIS_PROD.GDB_ADMIN.wHydrant (0) -- Related To: Hydrant (20)

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

  Iteminfo   Thumbnail   Metadata