Name: Hydrants History

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

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 )
• baselineflow ( type: esriFieldTypeDouble, alias: Flow at Baseline Pressure )
• nozzlediameter ( type: esriFieldTypeDouble, alias: Nozzle Diameter )
• flowduration ( type: esriFieldTypeInteger, alias: Flow Duration )
• diffusertype ( type: esriFieldTypeString, alias: Diffuser Type, length: 20 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• nozzlecoefficient ( type: esriFieldTypeDouble, alias: Nozzle Coefficient )
• meterreadstart ( type: esriFieldTypeInteger, alias: MeterReadStart )
• meterreadend ( type: esriFieldTypeInteger, alias: MeterReadEnd )
• turbiditystart ( type: esriFieldTypeDouble, alias: TurbidityStart )
• turbidityend ( type: esriFieldTypeDouble, alias: TurbidityEnd )
• cl2start ( type: esriFieldTypeDouble, alias: CL2Start )
• cl2end ( type: esriFieldTypeDouble, alias: CL2End )
• temperaturestart ( type: esriFieldTypeSmallInteger, alias: TemperatureStart )
• temperatureend ( type: esriFieldTypeSmallInteger, alias: Temperature End )
• timestart ( type: esriFieldTypeDate, alias: TimeStart, length: 8 )
• timeend ( type: esriFieldTypeDate, alias: TimeEnd, length: 8 )
• 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: 20 )
• pipe_diameter ( type: esriFieldTypeDouble, alias: pipe_diameter )
• length_flushed ( type: esriFieldTypeSmallInteger, alias: length_flushed )
• mfgyear ( type: esriFieldTypeDouble, alias: mfgyear )
• visualcond ( type: esriFieldTypeString, alias: visualcond, length: 25 , Coded Values: [Fair: Fair] , [Good: Good] , [Needs Maintenance: Needs Maintenance] )
• burydepth ( type: esriFieldTypeDouble, alias: burydepth )
• tablets ( type: esriFieldTypeInteger, alias: tablets )
• mfg ( type: esriFieldTypeString, alias: mfg, length: 50 , Coded Values: [Mueller Generic: Mueller Generic] , [Mueller Super Centurion 250: Mueller Super Centurion 250] , [Kennedy Guardian: Kennedy Guardian] , ...2 more... )
• isovalve ( type: esriFieldTypeString, alias: isovalve, length: 10 , Coded Values: [Yes: Yes] , [No: No] )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata