Layers:

Layer: Water Valves (0)

Name: Water Valves

Display Field: Asset_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 599c66ab237241c69f8978d880e314ff

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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:
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: 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] , ...260 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] )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter (mm), editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [10: 10] , [20: 20] , [25: 25] , ...16 more... )
Templates:
• Name: Water Valves
  Description:
  Prototype:
  Normal_Position: Open
  Diameter: null
  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)

Tables:

Table: Water Valve Inspections (1)

Name: Water Valve Inspections

Display Field: created_date

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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 )
• W3_Operator ( type: esriFieldTypeString, alias: Operator Name, editable: true, nullable: true, length: 120, defaultValue: null, modelName: W3_Operator , Coded Values: [Shawn Tooth: Shawn Tooth] , [Mike Lange: Mike Lange] , [Kevin Johnson: Kevin Johnson] , ...15 more... )
• Valve_Located ( type: esriFieldTypeString, alias: Can you locate the valve?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Valve_Located , Coded Values: [Y: Yes] , [N: No] )
• Cap_Seized ( type: esriFieldTypeString, alias: Is the valve cap seized?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Cap_Seized , Coded Values: [Y: Yes] , [N: No] )
• Cap_Replacement ( type: esriFieldTypeString, alias: Does the cap need to be replaced?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Cap_Replacement , Coded Values: [Y: Yes] , [N: No] )
• Casing_Attention ( type: esriFieldTypeString, alias: Does the valve casing require attention?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Casing_Attention , Coded Values: [Y: Yes] , [N: No] )
• Rock_Catcher_Present ( type: esriFieldTypeString, alias: Is rock catcher/dust cover present?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Rock_Catcher_Present , Coded Values: [Y: Yes] , [N: No] )
• Water_Surfacing ( type: esriFieldTypeString, alias: Is there water surfacing in the valve case?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Water_Surfacing , Coded Values: [Y: Yes] , [N: No] )
• Rod_Condition ( type: esriFieldTypeString, alias: Rod Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rod_Condition , Coded Values: [Good: Good] , [Broken: Broken] , [Missing: Missing] , ...1 more... )
• Operating_Clearance ( type: esriFieldTypeString, alias: Is there sufficient operating clearance?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Operating_Clearance , Coded Values: [Y: Yes] , [N: No] )
• Close_Turns ( type: esriFieldTypeSmallInteger, alias: Number of turns to close the valve, editable: true, nullable: true, defaultValue: null, modelName: Close_Turns )
• Valve_Close_Fully ( type: esriFieldTypeString, alias: Does the valve close fully?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Valve_Close_Fully , Coded Values: [Y: Yes] , [N: No] )
• Operating_Condition ( type: esriFieldTypeString, alias: Operating Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operating_Condition , Coded Values: [Good: Good] , [Inoperable: Inoperable] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: Comments )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Inspection Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Water Valve Inspections
  Description:
  Prototype:
  ParentGUID: null
  W3_Operator: null
  Valve_Located: null
  Cap_Seized: null
  Cap_Replacement: null
  Casing_Attention: null
  Rock_Catcher_Present: null
  Water_Surfacing: null
  Rod_Condition: null
  Operating_Clearance: null
  Close_Turns: null
  Valve_Close_Fully: null
  Operating_Condition: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• P_FieldCollection.GIS.wat_valves (0) -- Related To: Water Valves (0)