View In:   ArcGIS Online Map Viewer

Name: Water Mains

Display Field: MAIN_SIZE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1124710b3e7a4596b998a5659697735a

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 25001

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 505543.37878418
YMin: 5427714.58898926
XMax: 1035341.26263428
YMax: 1.08806636282349E7
Spatial Reference: PROJCS["NAD_1983_UTM_Zone_10N",GEOGCS["NAD83 [CSRS] 4.0.0.BC.1.GVRD_2005-04-05",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-123.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Proposed
  Label: Proposed
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 1
• Value: In Service
  Label: In Service/For Construction
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 1
• Value: For Construction
  Label: In Service/For Construction
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 1
• Value: Abandoned
  Label: Abandoned
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [130, 130, 130, 255]
  Width: 1
• Value: History
  Label: History
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [190, 210, 255, 255]
  Width: 1
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: esriServerHTMLPopupTypeNone

Type ID Field: STATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MAIN_TYPE2 ( type: esriFieldTypeString, alias: MAIN TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAIN_TYPE2 , Coded Values: [Agricultural Line: Agricultural Line] , [By-Pass: By-Pass] , [Feeder: Feeder] , ...1 more... )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FACILITYID )
• MAIN_SIZE ( type: esriFieldTypeInteger, alias: MAIN SIZE (mm), editable: true, nullable: true, defaultValue: null, modelName: MAIN_SIZE , Coded Values: [18: 18] , [19: 19] , [20: 20] , ...39 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MATERIAL , Coded Values: [AC: Asbestos Cement] , [CAS: Cast Iron] , [CC: Concrete Cylinder] , ...19 more... )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE ZONE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PRESSURE_ZONE , Coded Values: [105M: 105M] , [110M: 110M] , [115M: 115M] , ...13 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATUS , Coded Values: [Proposed: Proposed] , [For Construction: For Construction] , [In Service: In Service] , ...3 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 20, defaultValue: Surrey, modelName: OWNER , Coded Values: [Surrey: Surrey] , [Private: Private] , [Other Municipality: Other Municipality] , ...5 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• POF_SCORE ( type: esriFieldTypeSmallInteger, alias: POF_SCORE, editable: true, nullable: true, defaultValue: null, modelName: POF_SCORE )
• COF_SCORE ( type: esriFieldTypeSmallInteger, alias: COF_SCORE, editable: true, nullable: true, defaultValue: null, modelName: COF_SCORE )
• LAST_FLUSHED ( type: esriFieldTypeDate, alias: LAST_FLUSHED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_FLUSHED )
• SEISMIC_PROTECTION ( type: esriFieldTypeString, alias: SEISMIC_PROTECTION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SEISMIC_PROTECTION , Coded Values: [Yes: Yes] , [No: No] )
• MAINTENANCE_RESPONSIBILITY ( type: esriFieldTypeString, alias: MAINTENANCE_RESPONSIBILITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAINTENANCE_RESPONSIBILITY , Coded Values: [Engineering: Engineering] , [Facilities: Facilities] , [Fire Department: Fire Department] , ...5 more... )
• OPERATIONAL_RESPONSIBILITY ( type: esriFieldTypeString, alias: OPERATIONAL_RESPONSIBILITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATIONAL_RESPONSIBILITY , Coded Values: [Engineering: Engineering] , [Facilities: Facilities] , [Fire Department: Fire Department] , ...5 more... )
• SEISMIC ( type: esriFieldTypeString, alias: SEISMIC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SEISMIC , Coded Values: [Yes: Yes] , [No: No] )
• CASING_PIPE ( type: esriFieldTypeString, alias: CASING_PIPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CASING_PIPE , Coded Values: [Yes: Yes] , [No: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: Proposed
Name: Proposed
Domains:
• MAIN_TYPE2:
  Inherited
• MAIN_SIZE:
  Inherited
• MATERIAL:
  Inherited
• PRESSURE_ZONE:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• SEISMIC_PROTECTION:
  Inherited
• MAINTENANCE_RESPONSIBILITY:
  Inherited
• OPERATIONAL_RESPONSIBILITY:
  Inherited
• SEISMIC:
  Inherited
• CASING_PIPE:
  Inherited
• ENABLED:
  Inherited
• RESTRAINED:
  Inherited
• GIS_ENTRY_STAGE:
  Inherited
• CORROSION_PROTECTION_TYPE:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  CASING_PIPE: null
  SEISMIC: null
  MAIN_TYPE2: null
  FACILITYID: null
  MAIN_SIZE: null
  MATERIAL: null
  PRESSURE_ZONE: null
  STATUS: Proposed
  OWNER: Surrey
  LOCATION: null
  COMMENTS: null
  POF_SCORE: null
  COF_SCORE: null
  LAST_FLUSHED: null
  SEISMIC_PROTECTION: null
  MAINTENANCE_RESPONSIBILITY: null
  OPERATIONAL_RESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: In Service
Name: In Service
Domains:
• MAIN_TYPE2:
  Inherited
• MAIN_SIZE:
  Inherited
• MATERIAL:
  Inherited
• PRESSURE_ZONE:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• SEISMIC_PROTECTION:
  Inherited
• MAINTENANCE_RESPONSIBILITY:
  Inherited
• OPERATIONAL_RESPONSIBILITY:
  Inherited
• SEISMIC:
  Inherited
• CASING_PIPE:
  Inherited
• ENABLED:
  Inherited
• RESTRAINED:
  Inherited
• GIS_ENTRY_STAGE:
  Inherited
• CORROSION_PROTECTION_TYPE:
  Inherited
Templates:
• Name: In Service
  Description:
  Prototype:
  CASING_PIPE: null
  SEISMIC: null
  MAIN_TYPE2: null
  FACILITYID: null
  MAIN_SIZE: null
  MATERIAL: null
  PRESSURE_ZONE: null
  STATUS: In Service
  OWNER: Surrey
  LOCATION: null
  COMMENTS: null
  POF_SCORE: null
  COF_SCORE: null
  LAST_FLUSHED: null
  SEISMIC_PROTECTION: null
  MAINTENANCE_RESPONSIBILITY: null
  OPERATIONAL_RESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: For Construction
Name: For Construction
Domains:
• MAIN_TYPE2:
  Inherited
• MAIN_SIZE:
  Inherited
• MATERIAL:
  Inherited
• PRESSURE_ZONE:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• SEISMIC_PROTECTION:
  Inherited
• MAINTENANCE_RESPONSIBILITY:
  Inherited
• OPERATIONAL_RESPONSIBILITY:
  Inherited
• SEISMIC:
  Inherited
• CASING_PIPE:
  Inherited
• ENABLED:
  Inherited
• RESTRAINED:
  Inherited
• GIS_ENTRY_STAGE:
  Inherited
• CORROSION_PROTECTION_TYPE:
  Inherited
Templates:
• Name: For Construction
  Description:
  Prototype:
  CASING_PIPE: null
  SEISMIC: null
  MAIN_TYPE2: null
  FACILITYID: null
  MAIN_SIZE: null
  MATERIAL: null
  PRESSURE_ZONE: null
  STATUS: For Construction
  OWNER: Surrey
  LOCATION: null
  COMMENTS: null
  POF_SCORE: null
  COF_SCORE: null
  LAST_FLUSHED: null
  SEISMIC_PROTECTION: null
  MAINTENANCE_RESPONSIBILITY: null
  OPERATIONAL_RESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Abandoned
Name: Abandoned
Domains:
• MAIN_TYPE2:
  Inherited
• MAIN_SIZE:
  Inherited
• MATERIAL:
  Inherited
• PRESSURE_ZONE:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• SEISMIC_PROTECTION:
  Inherited
• MAINTENANCE_RESPONSIBILITY:
  Inherited
• OPERATIONAL_RESPONSIBILITY:
  Inherited
• SEISMIC:
  Inherited
• CASING_PIPE:
  Inherited
• ENABLED:
  Inherited
• RESTRAINED:
  Inherited
• GIS_ENTRY_STAGE:
  Inherited
• CORROSION_PROTECTION_TYPE:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  CASING_PIPE: null
  SEISMIC: null
  MAIN_TYPE2: null
  FACILITYID: null
  MAIN_SIZE: null
  MATERIAL: null
  PRESSURE_ZONE: null
  STATUS: Abandoned
  OWNER: Surrey
  LOCATION: null
  COMMENTS: null
  POF_SCORE: null
  COF_SCORE: null
  LAST_FLUSHED: null
  SEISMIC_PROTECTION: null
  MAINTENANCE_RESPONSIBILITY: null
  OPERATIONAL_RESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: History
Name: History
Domains:
• MAIN_TYPE2:
  Inherited
• MAIN_SIZE:
  Inherited
• MATERIAL:
  Inherited
• PRESSURE_ZONE:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• SEISMIC_PROTECTION:
  Inherited
• MAINTENANCE_RESPONSIBILITY:
  Inherited
• OPERATIONAL_RESPONSIBILITY:
  Inherited
• SEISMIC:
  Inherited
• CASING_PIPE:
  Inherited
• ENABLED:
  Inherited
• RESTRAINED:
  Inherited
• GIS_ENTRY_STAGE:
  Inherited
• CORROSION_PROTECTION_TYPE:
  Inherited
Templates:
• Name: History
  Description:
  Prototype:
  CASING_PIPE: null
  SEISMIC: null
  MAIN_TYPE2: null
  FACILITYID: null
  MAIN_SIZE: null
  MATERIAL: null
  PRESSURE_ZONE: null
  STATUS: History
  OWNER: Surrey
  LOCATION: null
  COMMENTS: null
  POF_SCORE: null
  COF_SCORE: null
  LAST_FLUSHED: null
  SEISMIC_PROTECTION: null
  MAINTENANCE_RESPONSIBILITY: null
  OPERATIONAL_RESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata