Name: Normal Position Closed Valves

Display Field: PhaseName

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

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

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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:
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: false
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata