Name: HydrantHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: HydrantHistory
  Description:
  Prototype:
  PaintStencil: null
  SolidStem: null
  assetkey: null
  workorderkey: null
  staticpressure: null
  residualpressure: null
  pitotpressure: null
  flow: null
  nozzlediameter: 2.5
  flowduration: null
  gallonsused: null
  attachmentid1: null
  attachmentid2: null
  workdate: null
  workby: null
  worktype: null
  comments: null
  paint: null
  stencil: null
  flowat20: null
  caps: null
  chains: null
  drainage: null
  nozzle: null
  nozzleleaks: null
  nozzlegreased: null
  residuallocation: null
  clearance: null
  height: null
  obstruction: null
  commentzone: null
  leadnozzle: null
  capthreadseal: null
  commentcapnozzle: null
  initialcondition: null
  stemoiledexercised: null
  finalcondition: null
  additionalwork: null
  commentaddwork: null
  beginturbidity: null
  begincl2: null
  beginwatertemp: null
  endturbidity: null
  endcl2: null
  ph: null
  pitot: null
  testduration: null
  issue: null
  flowrate: null
  DataValidComment: null
  WorkInitials: null
  attachmentid3: null
  WorkingHours: null
  Man_Hours_Breakdown: null
  Pressure: null
  DataValid: null
  GUID: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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