View In:   ArcGIS Online Map Viewer

Name: Water_Hydrants

Display Field: installdat

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9ee8f3bcdc4645bbba38cd8e303cdda3

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 88257.92760000005
YMin: 5956947.6775
XMax: 91647.34399999958
YMax: 5960914.6162
Spatial Reference: 102185  (3401)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Query With LOD Spatial Reference: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• installdat ( modelName: installdat, nullable: true, editable: true, defaultValue: null, length: 24, alias: installdat, type: esriFieldTypeString )
• facilityid ( modelName: facilityid, nullable: true, editable: true, defaultValue: null, length: 255, alias: FacilityID, type: esriFieldTypeString )
• locdesc ( modelName: locdesc, nullable: true, editable: true, defaultValue: null, length: 200, alias: locdesc, type: esriFieldTypeString )
• lastservic ( modelName: lastservic, nullable: true, editable: true, defaultValue: null, length: 24, alias: lastservic, type: esriFieldTypeString )
• colour ( modelName: colour, nullable: true, editable: true, defaultValue: null, length: 254, alias: colour, type: esriFieldTypeString )
• comments ( modelName: comments, nullable: true, editable: true, defaultValue: null, length: 254, alias: comments, type: esriFieldTypeString )
• condition ( modelName: condition, nullable: true, editable: true, defaultValue: null, length: 254, alias: condition, type: esriFieldTypeString )
• psi ( modelName: psi, nullable: true, editable: true, defaultValue: null, alias: psi, type: esriFieldTypeDouble )
• gpm ( modelName: gpm, nullable: true, editable: true, defaultValue: null, alias: gpm, type: esriFieldTypeDouble )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 254, alias: status, type: esriFieldTypeString )
• type ( modelName: type, nullable: true, editable: true, defaultValue: null, length: 254, alias: type, type: esriFieldTypeString )
• install_ye ( modelName: install_ye, nullable: true, editable: true, defaultValue: null, alias: install_ye, type: esriFieldTypeInteger )
• last_inspe ( modelName: last_inspe, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_inspe, type: esriFieldTypeDate )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: null, length: 255, alias: OwnedBy, type: esriFieldTypeString )
• mainby ( modelName: mainby, nullable: true, editable: true, defaultValue: null, length: 255, alias: MainBy, type: esriFieldTypeString )
• last_ins_1 ( modelName: last_ins_1, nullable: true, editable: true, defaultValue: null, length: 254, alias: last_ins_1, type: esriFieldTypeString )
• last_maint ( modelName: last_maint, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_maint, type: esriFieldTypeDate )
• asset_id ( nullable: true, editable: true, defaultValue: null, length: 254, type: esriFieldTypeString, modelName: asset_id, alias: asset_id )
• asset_type ( modelName: asset_type, nullable: true, editable: true, defaultValue: null, length: 254, alias: asset_type, type: esriFieldTypeString )
• extra_nu_1 ( modelName: extra_nu_1, nullable: true, editable: true, defaultValue: null, alias: extra_nu_1, type: esriFieldTypeDouble )
• dates ( modelName: dates, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• conditions ( modelName: conditions, nullable: true, editable: true, defaultValue: null, length: 256, alias: Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• assessors ( modelName: assessors, nullable: true, editable: true, defaultValue: null, length: 256, alias: Assessors, type: esriFieldTypeString , Coded Values: [Chris Longoz: Chris Longoz] , [Raymond McKenzie: Raymond McKenzie] , [Dustin Haglund: Dustin Haglund] , ...6 more... )
• paint_in_adequate_condition ( modelName: paint_in_adequate_condition, nullable: true, editable: true, defaultValue: null, length: 256, alias: Paint in Adequate Condition, type: esriFieldTypeString , Coded Values: [Good: Good] , [Sun Faded: Sun Faded] , [Paint Peeling: Paint Peeling] , ...1 more... )
• operating_nut_opens_smoothly ( modelName: operating_nut_opens_smoothly, nullable: true, editable: true, defaultValue: null, length: 256, alias: Operating Nut opens Smoothly, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• plugged_or_drainer ( modelName: plugged_or_drainer, nullable: true, editable: true, defaultValue: null, length: 256, alias: Plugged or Drainer, type: esriFieldTypeString , Coded Values: [Plugged: Plugged] , [Drainer: Drainer] )
• hydrant_leaking ( modelName: hydrant_leaking, nullable: true, editable: true, defaultValue: null, length: 256, alias: Hydrant Leaking, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• physical_damage_to_hydrant ( modelName: physical_damage_to_hydrant, nullable: true, editable: true, defaultValue: null, length: 256, alias: Physical Damage to Hydrant, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• hydrant_value_to_grade ( modelName: hydrant_value_to_grade, nullable: true, editable: true, defaultValue: null, length: 256, alias: Hydrant Value to Grade, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [Too High: Too High] , [Too Low: Too Low] , ...1 more... )
• hydrant_near_grade ( modelName: hydrant_near_grade, nullable: true, editable: true, defaultValue: null, length: 256, alias: Hydrant Near Grade, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No - Low: No - Low] , [No - High: No - High] )
• adequate_accessibility_to_hydra ( modelName: adequate_accessibility_to_hydra, nullable: true, editable: true, defaultValue: null, length: 256, alias: Adequate Accessibility to Hydrant, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No : No ] )
• hydrant_valve_accessible ( modelName: hydrant_valve_accessible, nullable: true, editable: true, defaultValue: null, length: 256, alias: Hydrant Valve Accessible, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• field ( modelName: field, nullable: true, editable: true, defaultValue: null, alias: Field, type: esriFieldTypeInteger )
• replaced ( modelName: replaced, nullable: true, editable: true, defaultValue: No, length: 256, alias: Replaced?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• years ( modelName: years, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• type_of_work ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: type_of_work, alias: Type of Work , Coded Values: [Repaired: Repaired] , [Replaced: Replaced] , [Inspected: Inspected] )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 1000, alias: Notes, type: esriFieldTypeString )
• private ( modelName: private, nullable: true, editable: true, defaultValue: null, length: 255, alias: Private, type: esriFieldTypeString )
• flow_rate ( modelName: flow_rate, nullable: true, editable: true, defaultValue: null, length: 255, alias: Flow_Rate, type: esriFieldTypeString )
• pitot_pressure ( nullable: true, editable: true, defaultValue: null, alias: Pitot pressure, type: esriFieldTypeInteger )
• residual_pressure ( nullable: true, editable: true, defaultValue: null, alias: Residual pressure, type: esriFieldTypeInteger )
• static_pressure ( nullable: true, editable: true, defaultValue: null, alias: Static pressure, type: esriFieldTypeInteger )
• inspected ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Inspected, type: esriFieldTypeString , Coded Values: [Completed: Completed] , [Repair: Needs] , [Out of Service: Out of Service] )
• isolation_valve_condition ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Isolation Valve Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• bonnet_color ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Bonnet Color, type: esriFieldTypeString , Coded Values: [Yellow: Yellow] , [Blue: Blue] , [Green: Green] , ...1 more... )
• hydrant_turns ( nullable: true, editable: true, defaultValue: null, alias: Hydrant Turns, type: esriFieldTypeInteger )
• isolation_turns ( nullable: true, editable: true, defaultValue: null, alias: Isolation Turns, type: esriFieldTypeInteger )
• location_address ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Location address, type: esriFieldTypeString )
• surface_cracks ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Surface Cracks, type: esriFieldTypeString , Coded Values: [Ok: Ok] , [No (requires action): No (requires action)] )
• measured_flow_gpm ( nullable: true, editable: true, defaultValue: null, alias: Measured Flow GPM, type: esriFieldTypeInteger )
• out_of_service ( nullable: true, defaultValue: No, editable: true, length: 256, alias: Out of Service, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• longitude ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Longitude, type: esriFieldTypeString )
• latitude ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Latitude, type: esriFieldTypeString )

Templates:

• Name: Water_Hydrants
  Description:
  Prototype:
  last_inspe: null
  measured_flow_gpm: null
  facilityid: null
  notes: null
  hydrant_leaking: null
  out_of_service: No
  hydrant_value_to_grade: null
  asset_id: null
  type: null
  years: null
  extra_nu_1: null
  install_ye: null
  ownedby: null
  location_address: null
  hydrant_near_grade: null
  lastservic: null
  gpm: null
  hydrant_valve_accessible: null
  dates: null
  bonnet_color: null
  inspected: null
  condition: null
  field: null
  installdat: null
  conditions: null
  status: null
  physical_damage_to_hydrant: null
  private: null
  flow_rate: null
  psi: null
  adequate_accessibility_to_hydra: null
  hydrant_turns: null
  last_ins_1: null
  static_pressure: null
  isolation_turns: null
  isolation_valve_condition: null
  operating_nut_opens_smoothly: null
  mainby: null
  asset_type: null
  last_maint: null
  comments: null
  type_of_work: null
  assessors: null
  replaced: No
  pitot_pressure: null
  plugged_or_drainer: null
  residual_pressure: null
  colour: null
  paint_in_adequate_condition: null
  surface_cracks: null
  locdesc: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata