Name: Hydrant Maintenance

Display Field: Facility_Identifier

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ad70ab8f51fc4da6a4d39fac96323779

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

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

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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: OBJECTID )
• Facility_Identifier ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Identifier )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• Residual_Hydrant ( type: esriFieldTypeString, alias: Residual Hydrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Residual_Hydrant )
• Make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Make )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Model )
• Flushed ( type: esriFieldTypeString, alias: Flushed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flushed , Coded Values: [Yes: Yes] , [No: No] )
• Lubed ( type: esriFieldTypeString, alias: Lubed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lubed , Coded Values: [Yes: Yes] , [No: No] )
• Oil ( type: esriFieldTypeString, alias: Oil, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Oil , Coded Values: [Yes: Yes] , [No: No] )
• Drains ( type: esriFieldTypeString, alias: Drains, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Drains , Coded Values: [Yes: Yes] , [No: No] )
• DURATION ( type: esriFieldTypeString, alias: Duration, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DURATION )
• WATERSAMPLERESULT ( type: esriFieldTypeString, alias: Water Sample Result, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WATERSAMPLERESULT )
• FLOWRATE ( type: esriFieldTypeString, alias: Flow Rate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOWRATE )
• DYNAMICPRESSURE ( type: esriFieldTypeString, alias: Dynamic Pressure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DYNAMICPRESSURE )
• VARIABLEFLOW ( type: esriFieldTypeString, alias: Variable Flow, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VARIABLEFLOW )
• DURATIONMINUTES ( type: esriFieldTypeString, alias: Duration Minutes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DURATIONMINUTES )
• DURATIONSECONDS ( type: esriFieldTypeString, alias: Duration Seconds, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DURATIONSECONDS )
• DISCOLORATIONDURATIONMINUTES ( type: esriFieldTypeString, alias: Discoloration Duration Minutes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DISCOLORATIONDURATIONMINUTES )
• DISCOLORATIONDURATIONSECONDS ( type: esriFieldTypeString, alias: Discoloration Duration Seconds, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DISCOLORATIONDURATIONSECONDS )
• Pitot ( type: esriFieldTypeString, alias: Pitot, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pitot )
• INSPECTEDBY ( type: esriFieldTypeString, alias: Inspected by, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSPECTEDBY )
• PAINT ( type: esriFieldTypeString, alias: Paint, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PAINT , Coded Values: [Yes: Yes] , [No: No] )
• FLAG ( type: esriFieldTypeString, alias: Flag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLAG )
• AUXVALVE ( type: esriFieldTypeString, alias: Aux valve, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUXVALVE )
• AUXVALVEKEYABLE ( type: esriFieldTypeString, alias: Aux Valve Keyable, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUXVALVEKEYABLE )
• Issue ( type: esriFieldTypeString, alias: Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Issue )
• HydrantGLOBAL ( type: esriFieldTypeGUID, alias: Field, editable: true, nullable: true, length: 38, defaultValue: null, modelName: HydrantGLOBAL )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• ACTUALRESIDUAL ( type: esriFieldTypeDouble, alias: Actual Residual, editable: true, nullable: true, defaultValue: null, modelName: ACTUALRESIDUAL )
• COEFFICIENT ( type: esriFieldTypeDouble, alias: Coefficient, editable: true, nullable: true, defaultValue: null, modelName: COEFFICIENT )
• COLOR ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COLOR )
• COLORADDITIONAL ( type: esriFieldTypeString, alias: Color Additional, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COLORADDITIONAL )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONDITION )
• DISCHARGE ( type: esriFieldTypeDouble, alias: Discharge, editable: true, nullable: true, defaultValue: null, modelName: DISCHARGE )
• FLOW ( type: esriFieldTypeDouble, alias: Flow, editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• FLOWHYDRANT ( type: esriFieldTypeString, alias: Flow Hydrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOWHYDRANT )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• NOZZLESIZE ( type: esriFieldTypeString, alias: Nozzle Size, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NOZZLESIZE )
• NUMNOZZLE ( type: esriFieldTypeString, alias: Num Nozzle, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NUMNOZZLE )
• NUMPUMPPORT ( type: esriFieldTypeString, alias: Num Pump Port, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NUMPUMPPORT )
• OBSTRUCTIONS ( type: esriFieldTypeString, alias: Obstructions, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OBSTRUCTIONS )
• OUTLETDIAMETER ( type: esriFieldTypeDouble, alias: Outlet Diameter, editable: true, nullable: true, defaultValue: null, modelName: OUTLETDIAMETER )
• PITOTD ( type: esriFieldTypeDouble, alias: Pitot ID, editable: true, nullable: true, defaultValue: null, modelName: PITOTD )
• PITOTGAUGEFLOW ( type: esriFieldTypeDouble, alias: Pitot Gauge Flow, editable: true, nullable: true, defaultValue: null, modelName: PITOTGAUGEFLOW )
• PSI ( type: esriFieldTypeDouble, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• PUMPSIZE ( type: esriFieldTypeString, alias: Pump Size, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PUMPSIZE )
• RAISEORLOWER ( type: esriFieldTypeString, alias: Raise or Lower, editable: true, nullable: true, length: 25, defaultValue: null, modelName: RAISEORLOWER )
• RESIDUAL ( type: esriFieldTypeDouble, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• STATIC ( type: esriFieldTypeDouble, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• YEAR ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 25, defaultValue: null, modelName: YEAR )
• DISCOLORATIONDURATION ( type: esriFieldTypeString, alias: DISCOLORATIONDURATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DISCOLORATIONDURATION )
• STATICPRESSIRE ( type: esriFieldTypeString, alias: STATICPRESSIRE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STATICPRESSIRE )
• PORTFLUSHED ( type: esriFieldTypeString, alias: PORTFLUSHED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PORTFLUSHED )
• Flow_Test_Activity ( type: esriFieldTypeString, alias: Flow Test Activity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flow_Test_Activity )
• unMigration_duration ( type: esriFieldTypeDouble, alias: unMigration_duration, editable: true, nullable: true, defaultValue: null, modelName: unMigration_duration )
• unMigration_flowrate ( type: esriFieldTypeDouble, alias: unMigration_flowrate, editable: true, nullable: true, defaultValue: null, modelName: unMigration_flowrate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Hydrant Maintenance
  Description:
  Prototype:
  unMigration_flowrate: null
  unMigration_duration: null
  Facility_Identifier: null
  Inspection_Date: null
  Residual_Hydrant: null
  Make: null
  Model: null
  Flushed: null
  Lubed: null
  Oil: null
  Drains: null
  DURATION: null
  WATERSAMPLERESULT: null
  FLOWRATE: null
  DYNAMICPRESSURE: null
  VARIABLEFLOW: null
  DURATIONMINUTES: null
  DURATIONSECONDS: null
  DISCOLORATIONDURATIONMINUTES: null
  DISCOLORATIONDURATIONSECONDS: null
  Pitot: null
  INSPECTEDBY: null
  PAINT: null
  FLAG: null
  AUXVALVE: null
  AUXVALVEKEYABLE: null
  Issue: null
  HydrantGLOBAL: null
  ADDRESS: null
  ACTUALRESIDUAL: null
  COEFFICIENT: null
  COLOR: null
  COLORADDITIONAL: null
  CONDITION: null
  DISCHARGE: null
  FLOW: null
  FLOWHYDRANT: null
  NOTES: null
  NOZZLESIZE: null
  NUMNOZZLE: null
  NUMPUMPPORT: null
  OBSTRUCTIONS: null
  OUTLETDIAMETER: null
  PITOTD: null
  PITOTGAUGEFLOW: null
  PSI: null
  PUMPSIZE: null
  RAISEORLOWER: null
  RESIDUAL: null
  STATIC: null
  YEAR: null
  DISCOLORATIONDURATION: null
  STATICPRESSIRE: null
  PORTFLUSHED: null
  Flow_Test_Activity: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.wHydrant (0) -- Related To: Hydrants (28)

Capabilities: Query

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata