View In:   ArcGIS Online Map Viewer

Name: WaterValves

Display Field: ENTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

Max Scale: 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: 531867.46262471
YMin: 4809245.72102861
XMax: 542343.77762471
YMax: 4819866.24292861
Spatial Reference: 26917  (26917)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 112, 255, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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

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 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• VALVE_FUNCTION ( type: esriFieldTypeString, alias: VALVE_FUNCTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_FUNCTION , Coded Values: [Control Valve: Control Valve] , [Flushing Valve: Flushing Valve] , [Hydrant Valve: Hydrant Valve] , ...3 more... )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVE_TYPE , Coded Values: [Butterfly Valve: Butterfly Valve] , [Curb Stop: Curb Stop] , [Gate Valve: Gate Valve] , ...9 more... )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID, editable: true, nullable: true, defaultValue: null, modelName: ASSET_ID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENTNAME )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID, editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID, editable: true, nullable: true, defaultValue: null, modelName: VAIL_ID )
• CIVIC_ADDRESS ( type: esriFieldTypeString, alias: CIVIC_ADDRESS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CIVIC_ADDRESS )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OWNER , Coded Values: [City of Waterloo: City of Waterloo] , [City of Kitchener: City of Kitchener] , [Region of Waterloo: Region of Waterloo] , ...10 more... )
• VALVE_MAKE ( type: esriFieldTypeString, alias: VALVE_MAKE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_MAKE , Coded Values: [AMERD: AMERD] , [COREY: COREY] , [CLOW: CLOW] , ...18 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASBUILTNUMBER )
• POSITION_ACCURACY ( type: esriFieldTypeString, alias: POSITION_ACCURACY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POSITION , Coded Values: [Digitized +/- 2m: Digitized +/- 2m] , [Total Station +/- 0.5m: Total Station +/- 0.5m] , [AutoCAD Drawings +/- 1m: AutoCAD Drawings +/- 1m] , ...9 more... )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [25: 25] , [50: 50] , [100: 100] , ...15 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSUMPTIONSTATUS , Coded Values: [Assumed by City of Waterloo: Assumed by City of Waterloo] , [NA: NA] , [On Maintenance: On Maintenance] )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTOFMAINTDATE )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINALACCEPTANCEDATE )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMOVED_DATE )
• OPENSTATUS ( type: esriFieldTypeString, alias: OPENSTATUS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OPENSTATUS , Coded Values: [Open: Open] , [Closed: Closed] )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• SURFACE_ELEVATION ( type: esriFieldTypeDouble, alias: SURFACE_ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: SURFACE_ELEVATION )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, editable: false, nullable: true, length: 16, defaultValue: null, modelName: CREATE_USER )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: UPDATE_DATE )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, editable: false, nullable: true, length: 16, defaultValue: null, modelName: UPDATE_USER )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LASTACTIVITY , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...6 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATEDBY )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OPERATIONALSTATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATIONALSTATUS , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• TURNTOOPERATE ( type: esriFieldTypeDouble, alias: TURNTOOPERATE, editable: true, nullable: true, defaultValue: null, modelName: TURNTOOPERATE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• GPSX ( type: esriFieldTypeDouble, alias: GPSX, editable: true, nullable: true, defaultValue: null, modelName: GPSX )
• GPSY ( type: esriFieldTypeDouble, alias: GPSY, editable: true, nullable: true, defaultValue: null, modelName: GPSY )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LINKEDDOCUMENTS )
• OPERATIONALCOMMENTS ( type: esriFieldTypeString, alias: OPERATIONALCOMMENTS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OPERATIONALCOMMENTS )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: CLOCKWISETOCLOSE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CLOCKWISETOCLOSE )
• UPDATEGPS ( type: esriFieldTypeString, alias: UPDATEGPS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: UPDATEGPS )
• MANUALTURN ( type: esriFieldTypeString, alias: MANUALTURN, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MANUALTURN , Coded Values: [Y: Y] , [N: N] )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ADDRESS )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, editable: true, nullable: true, defaultValue: null, modelName: HIGHTORQUE )
• TORQUEDATA ( type: esriFieldTypeString, alias: TORQUEDATA, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TORQUEDATA )
• GLAND_LEAK ( type: esriFieldTypeString, alias: GLAND_LEAK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GLAND_LEAK , Coded Values: [No gland leak: No gland leak] , [Steady: Steady] , [Stops when jammed: Stops when jammed] , ...1 more... )
• OPERATING_NUT ( type: esriFieldTypeString, alias: OPERATING_NUT, editable: true, nullable: true, length: 16, defaultValue: null, modelName: OPERATING_NUT , Coded Values: [Good Condition: Good Condition] , [Broken Off: Broken Off] , [Rounded: Rounded] , ...2 more... )
• VALVE_BROKEN ( type: esriFieldTypeString, alias: VALVE_BROKEN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_BROKEN , Coded Values: [Good Condition: Good Condition] , [Valve Broken Open: Valve Broken Open] , [Valve Broken Closed: Valve Broken Closed] , ...3 more... )
• VALVE_BOX ( type: esriFieldTypeString, alias: VALVE_BOX, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_BOX , Coded Values: [Good Condition: Good Condition] , [Valve Box Broken: Valve Box Broken] , [Valve Box Shifted: Valve Box Shifted] , ...6 more... )
• VALVE_TURNS ( type: esriFieldTypeString, alias: VALVE_TURNS, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VALVE_TURNS , Coded Values: [Normal: Normal] , [Above Normal: Above Normal] , [Below Normal: Below Normal] , ...1 more... )
• VALVE_PRIORITY ( type: esriFieldTypeString, alias: VALVE_PRIORITY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VALVE_PRIORITY , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...2 more... )
• VALVE_ACTION ( type: esriFieldTypeString, alias: VALVE_ACTION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVE_ACTION )
• MAINTENANCE_AREA ( type: esriFieldTypeString, alias: MAINTENANCE_AREA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAINTENANCE_AREA )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE_ZONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURE_ZONE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: WaterValves
  Description:
  Prototype:
  PRESSURE_ZONE: null
  MAINTENANCE_AREA: null
  LIFECYCLESTATUS: Active
  INSTALLDATE: null
  VALVE_FUNCTION: null
  VALVE_TYPE: null
  ASSET_ID: null
  ENTNAME: null
  SEGMENT_ID: null
  VAIL_ID: null
  CIVIC_ADDRESS: null
  OWNER: null
  VALVE_MAKE: null
  ASBUILTNUMBER: null
  POSITION_ACCURACY: null
  DIAMETER: null
  LOCATIONDESCRIPTION: null
  ASSUMPTIONSTATUS: null
  STARTOFMAINTDATE: null
  FINALACCEPTANCEDATE: null
  REMOVED_DATE: null
  OPENSTATUS: null
  ROTATION: null
  NOTES: null
  ANCILLARYROLE: null
  ENABLED: 1
  SURFACE_ELEVATION: null
  VALVE_ACTION: null
  VALVE_PRIORITY: null
  VALVE_TURNS: null
  VALVE_BOX: null
  ACTIVITYID: null
  LASTACTIVITY: null
  DATESTAMP: null
  OPTIME: null
  COMPUTERNAME: null
  OPERATEDBY: null
  OPERATIONALSTATUS: null
  TURNTOOPERATE: null
  DEPTH: null
  GPSX: null
  GPSY: null
  LINKEDDOCUMENTS: null
  OPERATIONALCOMMENTS: null
  CLOCKWISETOCLOSE: null
  UPDATEGPS: null
  MANUALTURN: null
  ADDRESS: null
  HIGHTORQUE: null
  TORQUEDATA: null
  GLAND_LEAK: null
  OPERATING_NUT: null
  VALVE_BROKEN: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATE_DATE
• Creator Field: CREATE_USER
• Edit Date Field: UPDATE_DATE
• Editor Field: UPDATE_USER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata