View In:   ArcGIS Online Map Viewer

Name: Water Valves

Display Field: Asset_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Water valve dataset for the entire Town of Cochrane.Data is appended from CAD during data integration for each construction phase.W3 indicated that the following attributes should have the default values listed:Normal Position - OpenCasing Type - CCap Type - CClose Direction - Clockwise

Service Item Id: 599c66ab237241c69f8978d880e314ff

Copyright Text: Update History: 2018-02-07, add features in TW Phase 4 for TCA. wgb 2018-02-06, add features in HH Phase 1MF for TCA. wgb 2018-01-19, added comments to 1 features to review TCA report Q3. wgb 2016-10-20, added RS Ph8. wgb 2016-10-17, added SSR Ph14. wgb 2016-10-14 Updates for Sunset Ridge Phase 19A and 19 O/S PL 2016-08-16 Added 3 new found valves PL 2016-07-20 Added valves in Fireside Phase 5 PL 20150205, added FS Ph4 features and FAC'd them. wgb*** Update: 20140807, added features for Fireside Ph2 data integration on RN1421. WGB*** Updated on 2014-06 by WGB, added SSR-PH13, 21 features.*** May 20, 2014. SIP 2013 updates. SP*** February 04, 2014. FAC info updated for 2013. SP*** October 25, 2013. Fireside Phase 3 data addded. ST*** ****October 17, 2013. Riversong Phase 7 data addded. ST ****July 19, 2013. Removed wat_val_589 as per request from W3 Manager. Attributes of removed valve: diameter = 400mm, install year = 2000, FAC date = 31/12/2001.SP ****June 17, 2013. Willows Phase 1 data addded. ST ****June 06, 2013. Riversong Phase 5 data addded. ST

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

Supports Datum Transformation: true

Extent:

XMin: -42020.289599999785
YMin: 5668791.814099999
XMax: -29487.230399999768
YMax: 5676091.738500001
Spatial Reference: 102187  (3776)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 178, 255, 255]
Size: 7.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, editable: false, nullable: false, length: 30, defaultValue: null, modelName: Asset_ID )
• Type ( type: esriFieldTypeString, alias: Type, editable: false, nullable: true, length: 200, defaultValue: Main, modelName: Type , Coded Values: [Main: Main] , [Hydrant: Hydrant] , [Pressure Reducing Valve: Pressure Reducing Valve] , ...2 more... )
• Diameter_mm ( type: esriFieldTypeDouble, alias: Diameter (mm), editable: false, nullable: true, defaultValue: null, modelName: Diameter_mm , Coded Values: [0: 0] , [10: 10] , [20: 20] , ...17 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: false, nullable: true, length: 10, defaultValue: Active, modelName: Status , Coded Values: [Active: Active] , [Retired: Retired] )
• FAC ( type: esriFieldTypeString, alias: FAC, editable: false, nullable: true, length: 5, defaultValue: N, modelName: FAC , Coded Values: [Y: Yes] , [N: No] )
• FAC_Date ( type: esriFieldTypeDate, alias: FAC Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: FAC_Date )
• Useful_Life ( type: esriFieldTypeSmallInteger, alias: Useful Life, editable: false, nullable: true, defaultValue: null, modelName: Useful_Life )
• Current_Replacement_Cost ( type: esriFieldTypeInteger, alias: Current Replacement Cost, editable: false, nullable: true, defaultValue: null, modelName: Current_Replacement_Cost )
• CRC_Date ( type: esriFieldTypeDate, alias: Current Replacement Cost Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CRC_Date )
• Install_Year ( type: esriFieldTypeSmallInteger, alias: Install Year, editable: false, nullable: true, defaultValue: null, modelName: Install_Year )
• Neighbourhood ( type: esriFieldTypeString, alias: Neighbourhood, editable: false, nullable: true, length: 100, defaultValue: null, modelName: Neighbourhood , Coded Values: [Bow Meadows: Bow Meadows] , [Bow Ridge: Bow Ridge] , [Cochrane Heights: Cochrane Heights] , ...29 more... )
• Source ( type: esriFieldTypeString, alias: Source, editable: false, nullable: true, length: 300, defaultValue: Consultant Submission, modelName: Source , Coded Values: [Consultant Submission: Consultant Submission] , [Field Verified: Field Verified] , [Office Non-Verified: Office Non-Verified] , ...1 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: false, nullable: true, length: 200, defaultValue: null, modelName: Manufacturer , Coded Values: [Singer: Singer] , [Cla-Val: Cla-Val] , [Mueller: Mueller] , ...1 more... )
• Close_Direction ( type: esriFieldTypeString, alias: Close Direction, editable: true, nullable: true, length: 50, defaultValue: Clockwise, modelName: Close_Direction , Coded Values: [Clockwise: Clockwise] , [Counter Clockwise: Counter Clockwise] )
• Cap_Type ( type: esriFieldTypeString, alias: Cap Type, editable: true, nullable: true, length: 50, defaultValue: C, modelName: Cap_Type , Coded Values: [A: A] , [C: C] )
• Casing_Type ( type: esriFieldTypeString, alias: Casing Type, editable: true, nullable: true, length: 50, defaultValue: C, modelName: Casing_Type , Coded Values: [A: A] , [B: B] , [C: C] )
• PhaseName ( type: esriFieldTypeString, alias: Phase Name, editable: false, nullable: true, length: 150, defaultValue: null, modelName: PhaseName , Coded Values: [100 Jumping Pound Common: 100 Jumping Pound Common] , [1960: 1960] , [1961: 1961] , ...249 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: false, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• Normal_Position ( type: esriFieldTypeString, alias: Normal Position, editable: true, nullable: true, length: 50, defaultValue: Open, modelName: Normal_Position , Coded Values: [Closed: Closed] , [Open: Open] )

Templates:

• Name: Water Valves
  Description:
  Prototype:
  Normal_Position: Open
  Cap_Type: C
  Close_Direction: Clockwise
  Casing_Type: C
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• P_FieldCollection.GIS.wat_valves_Inspections (0) -- Related To: Water Valve Inspections (1)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

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