View In:   ArcGIS Online Map Viewer

Name: w_Valve

Display Field: SYSTEM_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

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: 619302.7557812501
YMin: 4894044.18515625
XMax: 633366.4779687496
YMax: 4909654.72484375
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [173, 0, 87, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

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 )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• CREATE_BY ( type: esriFieldTypeString, alias: CREATE_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATE_BY )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST_EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GEOM_MODIFYDATE )
• LAST_EDIT_BY ( type: esriFieldTypeString, alias: LAST_EDIT_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GEOM_MODIFYBY )
• DATACAPTURE_METHOD ( type: esriFieldTypeString, alias: DATACAPTURE_METHOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATACAPTURE_METHOD , Coded Values: [GPS: GPS] , [Parcel: Parcel] , [Ortho: Ortho] , ...6 more... )
• SYSTEM_NAME ( type: esriFieldTypeString, alias: SYSTEM_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSTEM_NAME , Coded Values: [Stouffville DWS: Stouffville DWS] , [Holland Landing WWS: Holland Landing WWS] , [Keswick WWS: Keswick WWS] , ...25 more... )
• GPS_ACCURACY ( type: esriFieldTypeString, alias: GPS_ACCURACY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GPS_ACCURACY , Coded Values: [Centimetre: Centimetre] , [Sub-Metre: Sub-Metre] , [None: None] )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• ASSUMPTION_DATE ( type: esriFieldTypeDate, alias: ASSUMPTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSUMPTION_DATE )
• COMMISSION_DATE ( type: esriFieldTypeDate, alias: COMMISSION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMMISSION_DATE )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION_DESCRIPTION )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• ASSET_STATUS ( type: esriFieldTypeString, alias: ASSET_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSET_STATUS , Coded Values: [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , [REMOVED: REMOVED] , ...3 more... )
• FUNCTION_ ( type: esriFieldTypeString, alias: FUNCTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Function , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...9 more... )
• ASSET_ID ( type: esriFieldTypeString, alias: ASSET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )
• CONDITION_RATING ( type: esriFieldTypeString, alias: CONDITION_RATING, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Condition_Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• SCADA_COMM ( type: esriFieldTypeString, alias: SCADA_COMM, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SCADA_COMM , Coded Values: [1: Yes] , [0: No] )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT_NUMBER )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• MH_ASSET_ID ( type: esriFieldTypeString, alias: MH_ASSET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MH_ASSET_ID )
• DIAMETER ( type: esriFieldTypeInteger, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0: 0] , [20: 20] , [25: 25] , ...76 more... )
• PERCENTOPEN ( type: esriFieldTypeInteger, alias: PERCENTOPEN, editable: true, nullable: true, defaultValue: 100, modelName: PercentOpen , Range: [0, 100] )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: REGULATIONTYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REGULATIONTYPE , Coded Values: [Flow: Flow] , [Pressure: Pressure] )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• JOINTTYPE ( type: esriFieldTypeString, alias: JOINTTYPE, editable: true, nullable: true, length: 12, defaultValue: null, modelName: JointType , Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...4 more... )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MAKE , Coded Values: [AMER: American Darling] , [APCO: APCO] , [AVK: American AVK Co.] , ...31 more... )
• BOX_TYPE ( type: esriFieldTypeString, alias: BOX_TYPE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BOX_TYPE )
• BOX_OR_CHAMBER ( type: esriFieldTypeString, alias: BOX_OR_CHAMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BOX_OR_CHAMBER )
• BYPASS_VALVE ( type: esriFieldTypeString, alias: BYPASS_VALVE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BYPASS_VALVE , Coded Values: [1: Yes] , [0: No] )
• CLOSE_DIRECTION ( type: esriFieldTypeString, alias: CLOSE_DIRECTION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CLOSE_DIRECTION , Coded Values: [CW: Clockwise] , [CCW: Counter Clockwise] )
• MOTORIZED ( type: esriFieldTypeString, alias: MOTORIZED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MOTORIZED , Coded Values: [1: Yes] , [0: No] )
• NORMALLY_OPEN ( type: esriFieldTypeString, alias: NORMALLY_OPEN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NORMALLY_OPEN , Coded Values: [1: Yes] , [0: No] )
• FLOW_CONTROL ( type: esriFieldTypeString, alias: FLOW_CONTROL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOW_CONTROL , Coded Values: [1: Yes] , [0: No] )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVE_TYPE , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...10 more... )
• VALVE_DESIGNATION ( type: esriFieldTypeString, alias: VALVE_DESIGNATION, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Valve_Designation , Coded Values: [Branch Valve: Branch Valve] , [Main Line Valve: Main Line Valve] , [Other: Other] )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FACILITY_NAME )
• VALVECLASSIFICATION ( type: esriFieldTypeString, alias: VALVE_CLASSIFICATION, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ValveClassification , Coded Values: [Air Valve: Air Valve] , [Drain Valve: Drain Valve] , [By-Pass Valve: By-Pass Valve] , ...5 more... )
• AGE ( type: esriFieldTypeDouble, alias: Age in Years, editable: true, nullable: true, defaultValue: null, modelName: AGE )
• PRESSUREDISTRICT ( type: esriFieldTypeString, alias: PresssureDistrict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureDistrict )
• REMARKS ( type: esriFieldTypeString, alias: GENERAL REMARKS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Remarks )
• MODVLVTYPE ( type: esriFieldTypeString, alias: MODELLING VALVE TYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: MODVLVTYPE , Coded Values: [Pressure Reducing Valve (PRV): Pressure Reducing Valve (PRV)] , [Pressure Sustaining Valve (PSV): Pressure Sustaining Valve (PSV)] , [Pressure Breaker Valve (PBV): Pressure Breaker Valve (PBV)] , ...5 more... )
• VLVSETTING ( type: esriFieldTypeString, alias: VALVE SETTING, editable: true, nullable: true, length: 60, defaultValue: null, modelName: VLVSETTING )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERSHIP , Coded Values: [Aurora: Aurora] , [Chippewas of Georgina Island First Nation: Chippewas of Georgina Island First Nation] , [Durham: Durham] , ...18 more... )
• VALVE_TYP2 ( type: esriFieldTypeString, alias: VALVE_TYP2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP2 )
• VALVE_TYP3 ( type: esriFieldTypeString, alias: VALVE_TYP3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP3 )
• VALVE_TYP4 ( type: esriFieldTypeString, alias: VALVE_TYP4, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP4 )
• VALVE_TYP5 ( type: esriFieldTypeString, alias: VALVE_TYP5, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP5 )
• VALVE_TYP6 ( type: esriFieldTypeString, alias: VALVE_TYP6, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP6 )
• VALVE_TYP7 ( type: esriFieldTypeString, alias: VALVE_TYP7, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP7 )
• VALVE_LOCA ( type: esriFieldTypeString, alias: VALVE_LOCA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_LOCA )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_NAME )
• CROSS_STRE ( type: esriFieldTypeString, alias: CROSS_STRE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STRE )
• CROSS_STR2 ( type: esriFieldTypeString, alias: CROSS_STR2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STR2 )
• WORK_AREA ( type: esriFieldTypeString, alias: WORK_AREA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORK_AREA )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_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: w_Valve
  Description:
  Prototype:
  WORK_AREA: null
  CROSS_STR2: null
  ANCILLARYROLE: null
  ENABLED: 1
  CREATE_DATE: null
  CREATE_BY: null
  LAST_EDIT_DATE: null
  LAST_EDIT_BY: null
  DATACAPTURE_METHOD: null
  SYSTEM_NAME: null
  GPS_ACCURACY: null
  INSTALL_DATE: null
  ASSUMPTION_DATE: null
  COMMISSION_DATE: null
  LOCATION_DESCRIPTION: null
  ROTATION: null
  ASSET_STATUS: null
  FUNCTION_: null
  ASSET_ID: null
  CONDITION_RATING: null
  SCADA_COMM: null
  PROJECT_NUMBER: null
  ELEVATION: null
  MH_ASSET_ID: null
  DIAMETER: null
  PERCENTOPEN: 100
  REGULATIONTYPE: null
  TURNSTOCLOSE: null
  JOINTTYPE: null
  MAKE: null
  BOX_TYPE: null
  BOX_OR_CHAMBER: null
  BYPASS_VALVE: null
  CLOSE_DIRECTION: null
  MOTORIZED: null
  NORMALLY_OPEN: null
  FLOW_CONTROL: null
  VALVE_TYPE: null
  VALVE_DESIGNATION: null
  FACILITY_NAME: null
  VALVECLASSIFICATION: null
  AGE: null
  PRESSUREDISTRICT: null
  REMARKS: null
  MODVLVTYPE: null
  VLVSETTING: null
  OWNERSHIP: null
  VALVE_TYP2: null
  VALVE_TYP3: null
  VALVE_TYP4: null
  VALVE_TYP5: null
  VALVE_TYP6: null
  VALVE_TYP7: null
  VALVE_LOCA: null
  STREET_NAME: null
  CROSS_STRE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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 Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata