View In:   ArcGIS Online Map Viewer

Name: Watermain Breaks

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 655531.2819
YMin: 4853652.7625
XMax: 661943.644
YMax: 4859982.508
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: REPLACED
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: NO
  Label: Active Watermain
  Description: N/A
  Symbol:
  
• Value: YES
  Label: Replaced
  Description: N/A
  Symbol:
  
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: REPLACED

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WATERMAIN_ID ( type: esriFieldTypeString, alias: WATERMAIN_ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WATERMAIN_ID )
• BREAK_DATE ( type: esriFieldTypeDate, alias: BREAK_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BREAK_DATE )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_FROM ( type: esriFieldTypeString, alias: STREET_FROM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_FROM )
• INT_FROM ( type: esriFieldTypeString, alias: INT_FROM, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INT_FROM )
• STREET_TO ( type: esriFieldTypeString, alias: STREET_TO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_TO )
• INT_TO ( type: esriFieldTypeString, alias: INT_TO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INT_TO )
• DIST_FROM_BREAK_TO_VALVE ( type: esriFieldTypeString, alias: DIST_FROM_BREAK_TO_VALVE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DIST_FROM_BREAK_TO_VALVE )
• INT_DRAWING_NUMBER ( type: esriFieldTypeString, alias: INT_DRAWING_NUMBER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: INT_DRAWING_NUMBER )
• VALVE_LOC_IN_INT ( type: esriFieldTypeString, alias: VALVE_LOC_IN_INT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_LOC_IN_INT )
• DIR_BREAK_FROM_VALVE ( type: esriFieldTypeString, alias: DIR_BREAK_FROM_VALVE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DIR_BREAK_FROM_VALVE )
• WATERMAIN_LENGTH ( type: esriFieldTypeDouble, alias: WATERMAIN_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: WATERMAIN_LENGTH )
• PAVEMENT ( type: esriFieldTypeString, alias: PAVEMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PAVEMENT , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• GRAVEL ( type: esriFieldTypeString, alias: GRAVEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GRAVEL , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• SOD ( type: esriFieldTypeString, alias: SOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOD , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• WATERMAIN_DIAMETER ( type: esriFieldTypeDouble, alias: WATERMAIN_DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: WATERMAIN_DIAMETER )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL , Coded Values: [AC: Asbestos Cement] , [CI: Cast Iron] , [CPP: Concrete Pressure Pipe] , ...8 more... )
• BREAK_DEPTH ( type: esriFieldTypeString, alias: BREAK_DEPTH, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BREAK_DEPTH )
• INSTALL_DATE ( type: esriFieldTypeInteger, alias: INSTALL_DATE, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_DATE )
• TYPE_OF_BREAK ( type: esriFieldTypeString, alias: TYPE_OF_BREAK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE_OF_BREAK , Coded Values: [A: CIRCULAR] , [B: PIN HOLES] , [C: LONGITUDINAL] , ...4 more... )
• CAUSE_OF_BREAK ( type: esriFieldTypeString, alias: CAUSE_OF_BREAK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAUSE_OF_BREAK , Coded Values: [A: CORROSION] , [C: FROST] , [D: CONSTRUCTION] , ...4 more... )
• TYPE_OF_REPAIR ( type: esriFieldTypeString, alias: TYPE_OF_REPAIR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE_OF_REPAIR , Coded Values: [A: 'C' CLAMP] , [B: PIPE REPLACED] , [C: BOLTS REPLACED] , ...1 more... )
• REPAIR_DIAMETER ( type: esriFieldTypeDouble, alias: REPAIR_DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: REPAIR_DIAMETER )
• REPAIR_HOURS ( type: esriFieldTypeDouble, alias: REPAIR_HOURS, editable: true, nullable: true, defaultValue: null, modelName: REPAIR_HOURS )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENTS )
• REPLACED ( type: esriFieldTypeString, alias: REPLACED, editable: true, nullable: true, length: 50, defaultValue: NO, modelName: REPLACED , Coded Values: [YES: Yes] , [NO: No] , [CIPP: CIPP Lined] )
• MUNICIPALITY ( type: esriFieldTypeString, alias: MUNICIPALITY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MUNICIPALITY , Coded Values: [AJAX: Ajax] , [BROCK: Brock] , [CLARINGTON: Clarington] , ...6 more... )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SUBTYPECD, editable: true, nullable: true, defaultValue: null, modelName: SUBTYPECD )
• DATASOURCE ( type: esriFieldTypeString, alias: DATASOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATASOURCE , Coded Values: [ASCONST: As Constructed] , [CCTV: CCTV] , [FIELD: Field Locate] , ...7 more... )
• EMPLOYEE_NO ( type: esriFieldTypeString, alias: EMPLOYEE_NO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EMPLOYEE_NO )
• HYDRANT_STAMP ( type: esriFieldTypeString, alias: HYDRANT_STAMP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYDRANT_STAMP )
• LEN_TIME_FLUSHED ( type: esriFieldTypeInteger, alias: LEN_TIME_FLUSHED, editable: true, nullable: true, defaultValue: null, modelName: LEN_TIME_FLUSHED )
• TIME_OF_TEST ( type: esriFieldTypeString, alias: TIME_OF_TEST, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TIME_OF_TEST )
• BACTI_SAMPLE_TAKEN ( type: esriFieldTypeString, alias: BACTI_SAMPLE_TAKEN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BACTI_SAMPLE_TAKEN , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• LEAK_DISCOVERED_TIME ( type: esriFieldTypeString, alias: LEAK_DISCOVERED_TIME, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LEAK_DISCOVERED_TIME )
• DATE_REPAIRED ( type: esriFieldTypeDate, alias: DATE_REPAIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_REPAIRED )
• TIME_REPAIRED ( type: esriFieldTypeString, alias: TIME_REPAIRED, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TIME_REPAIRED )
• FLUSHING_COMMENTS ( type: esriFieldTypeString, alias: FLUSHING_COMMENTS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FLUSHING_COMMENTS )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• CHLORINE_RESIDUAL ( type: esriFieldTypeDouble, alias: CHLORINE_RESIDUAL, editable: true, nullable: true, defaultValue: null, modelName: CHLORINE_RESIDUAL )
• CREATIONUSER ( type: esriFieldTypeString, alias: CREATIONUSER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LASTUSER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )

Types:

ID: NO
Name: Active Watermain
Domains:
• PAVEMENT:
  Inherited
• GRAVEL:
  Inherited
• SOD:
  Inherited
• MATERIAL:
  Inherited
• TYPE_OF_BREAK:
  Inherited
• CAUSE_OF_BREAK:
  Inherited
• TYPE_OF_REPAIR:
  Inherited
• REPLACED:
  Inherited
• MUNICIPALITY:
  Inherited
• DATASOURCE:
  Inherited
• BACTI_SAMPLE_TAKEN:
  Inherited
Templates:
• Name: NO
  Description:
  Prototype:
  LASTUSER: null
  DATEMODIFIED: null
  WATERMAIN_ID: null
  BREAK_DATE: null
  STREET_NAME: null
  STREET_FROM: null
  INT_FROM: null
  STREET_TO: null
  INT_TO: null
  DIST_FROM_BREAK_TO_VALVE: null
  INT_DRAWING_NUMBER: null
  VALVE_LOC_IN_INT: null
  DIR_BREAK_FROM_VALVE: null
  WATERMAIN_LENGTH: null
  PAVEMENT: null
  GRAVEL: null
  SOD: null
  WATERMAIN_DIAMETER: null
  MATERIAL: null
  BREAK_DEPTH: null
  INSTALL_DATE: null
  TYPE_OF_BREAK: null
  CAUSE_OF_BREAK: null
  TYPE_OF_REPAIR: null
  REPAIR_DIAMETER: null
  REPAIR_HOURS: null
  COMMENTS: null
  REPLACED: NO
  MUNICIPALITY: null
  SUBTYPECD: null
  DATASOURCE: null
  EMPLOYEE_NO: null
  HYDRANT_STAMP: null
  LEN_TIME_FLUSHED: null
  TIME_OF_TEST: null
  BACTI_SAMPLE_TAKEN: null
  LEAK_DISCOVERED_TIME: null
  DATE_REPAIRED: null
  TIME_REPAIRED: null
  FLUSHING_COMMENTS: null
  X: null
  Y: null
  CHLORINE_RESIDUAL: null
  CREATIONUSER: null
  DATECREATED: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: YES
Name: Replaced
Domains:
• PAVEMENT:
  Inherited
• GRAVEL:
  Inherited
• SOD:
  Inherited
• MATERIAL:
  Inherited
• TYPE_OF_BREAK:
  Inherited
• CAUSE_OF_BREAK:
  Inherited
• TYPE_OF_REPAIR:
  Inherited
• REPLACED:
  Inherited
• MUNICIPALITY:
  Inherited
• DATASOURCE:
  Inherited
• BACTI_SAMPLE_TAKEN:
  Inherited
Templates:
• Name: YES
  Description:
  Prototype:
  LASTUSER: null
  DATEMODIFIED: null
  WATERMAIN_ID: null
  BREAK_DATE: null
  STREET_NAME: null
  STREET_FROM: null
  INT_FROM: null
  STREET_TO: null
  INT_TO: null
  DIST_FROM_BREAK_TO_VALVE: null
  INT_DRAWING_NUMBER: null
  VALVE_LOC_IN_INT: null
  DIR_BREAK_FROM_VALVE: null
  WATERMAIN_LENGTH: null
  PAVEMENT: null
  GRAVEL: null
  SOD: null
  WATERMAIN_DIAMETER: null
  MATERIAL: null
  BREAK_DEPTH: null
  INSTALL_DATE: null
  TYPE_OF_BREAK: null
  CAUSE_OF_BREAK: null
  TYPE_OF_REPAIR: null
  REPAIR_DIAMETER: null
  REPAIR_HOURS: null
  COMMENTS: null
  REPLACED: YES
  MUNICIPALITY: null
  SUBTYPECD: null
  DATASOURCE: null
  EMPLOYEE_NO: null
  HYDRANT_STAMP: null
  LEN_TIME_FLUSHED: null
  TIME_OF_TEST: null
  BACTI_SAMPLE_TAKEN: null
  LEAK_DISCOVERED_TIME: null
  DATE_REPAIRED: null
  TIME_REPAIRED: null
  FLUSHING_COMMENTS: null
  X: null
  Y: null
  CHLORINE_RESIDUAL: null
  CREATIONUSER: null
  DATECREATED: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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