Name: Hydrants History

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• workorderkey ( type: esriFieldTypeString, alias: Workorder Key, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkActivity )
• staticpressure ( type: esriFieldTypeDouble, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: StaticPSI )
• residualpressure ( type: esriFieldTypeDouble, alias: Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: ResidualPSI )
• pitotpressure ( type: esriFieldTypeDouble, alias: Pitot Pressure, editable: true, nullable: true, defaultValue: null, modelName: PitotReading )
• flow ( type: esriFieldTypeDouble, alias: Flow, editable: true, nullable: true, defaultValue: null, modelName: GallonsUsed )
• baselineflow ( type: esriFieldTypeDouble, alias: Flow at Baseline Pressure, editable: true, nullable: true, defaultValue: null, modelName: FlowBaseline )
• nozzlediameter ( type: esriFieldTypeDouble, alias: Nozzle Diameter, editable: true, nullable: true, defaultValue: null, modelName: OutletSize )
• flowduration ( type: esriFieldTypeInteger, alias: Flow Duration, editable: true, nullable: true, defaultValue: null, modelName: FlowDuration )
• diffusertype ( type: esriFieldTypeString, alias: Diffuser Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Diffuser )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: WorkComments )
• nozzlecoefficient ( type: esriFieldTypeDouble, alias: Nozzle Coefficient, editable: true, nullable: true, defaultValue: 0.9, modelName: OutletCoefficient )
• meterreadstart ( type: esriFieldTypeInteger, alias: MeterReadStart, editable: true, nullable: true, defaultValue: null, modelName: MeterReadStart )
• meterreadend ( type: esriFieldTypeInteger, alias: MeterReadEnd, editable: true, nullable: true, defaultValue: null, modelName: MeterReadEnd )
• turbiditystart ( type: esriFieldTypeDouble, alias: TurbidityStart, editable: true, nullable: true, defaultValue: null, modelName: TurbidityStart )
• turbidityend ( type: esriFieldTypeDouble, alias: TurbidityEnd, editable: true, nullable: true, defaultValue: null, modelName: TurbidityEnd )
• cl2start ( type: esriFieldTypeDouble, alias: CL2Start, editable: true, nullable: true, defaultValue: null, modelName: CL2Start )
• cl2end ( type: esriFieldTypeDouble, alias: CL2End, editable: true, nullable: true, defaultValue: null, modelName: CL2End )
• temperaturestart ( type: esriFieldTypeSmallInteger, alias: TemperatureStart, editable: true, nullable: true, defaultValue: null, modelName: TemperatureStart )
• temperatureend ( type: esriFieldTypeSmallInteger, alias: Temperature End, editable: true, nullable: true, defaultValue: null, modelName: TemperatureEnd )
• timestart ( type: esriFieldTypeDate, alias: TimeStart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TimeStart )
• timeend ( type: esriFieldTypeDate, alias: TimeEnd, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TimeEnd )
• gallonsused ( type: esriFieldTypeInteger, alias: GallonsUsed, editable: true, nullable: true, defaultValue: null, modelName: GallonsUsed )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1, editable: true, nullable: true, defaultValue: null, modelName: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2, editable: true, nullable: true, defaultValue: null, modelName: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkDate )
• workby ( type: esriFieldTypeString, alias: WorkBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkBy )
• worktype ( type: esriFieldTypeString, alias: WorkType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkType )
• pipe_diameter ( type: esriFieldTypeDouble, alias: pipe_diameter, editable: true, nullable: true, defaultValue: null, modelName: pipe_diameter )
• length_flushed ( type: esriFieldTypeSmallInteger, alias: length_flushed, editable: true, nullable: true, defaultValue: null, modelName: length_flushed )
• mfgyear ( type: esriFieldTypeDouble, alias: mfgyear, editable: true, nullable: true, defaultValue: null, modelName: mfgyear )
• visualcond ( type: esriFieldTypeString, alias: visualcond, editable: true, nullable: true, length: 25, defaultValue: null, modelName: visualcond , Coded Values: [Fair: Fair] , [Good: Good] , [Needs Maintenance: Needs Maintenance] )
• burydepth ( type: esriFieldTypeDouble, alias: burydepth, editable: true, nullable: true, defaultValue: null, modelName: burydepth )
• tablets ( type: esriFieldTypeInteger, alias: tablets, editable: true, nullable: true, defaultValue: null, modelName: tablets )
• mfg ( type: esriFieldTypeString, alias: mfg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mfg , 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, editable: true, nullable: true, length: 10, defaultValue: null, modelName: isovalve , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Hydrants History
  Description:
  Prototype:
  mfg: null
  isovalve: null
  assetkey: null
  workorderkey: null
  staticpressure: null
  residualpressure: null
  pitotpressure: null
  flow: null
  baselineflow: null
  nozzlediameter: null
  flowduration: null
  diffusertype: null
  comments: null
  nozzlecoefficient: 0.9
  meterreadstart: null
  meterreadend: null
  turbiditystart: null
  turbidityend: null
  cl2start: null
  cl2end: null
  temperaturestart: null
  temperatureend: null
  timestart: null
  timeend: null
  gallonsused: null
  attachmentid1: null
  attachmentid2: null
  workdate: null
  workby: null
  worktype: null
  pipe_diameter: null
  length_flushed: null
  mfgyear: null
  visualcond: null
  burydepth: null
  tablets: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata