Name: Incidents in BC

Display Field: INCIDENT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Incidents in BC locations are a subset of all other incidents that are reported to the BCER through an incident reporting system. The incidents layer represents pipeline incidents that occurred on pipelines that are in active, deactivated or abandoned status and includes a brief description of the incident cause. The associated attribute table contains details that elaborate on the incident information.Data PropertiesAttributes / Column NameField AliasData TypeData PrecisionCommentsOBJECTIDOBJECTIDObject ID10Unique row value assigned by databaseSHAPESHAPEGeometry (Point)INCIDENT_IDIncident IDText15Unique identifier for each incident.SITE_TYPESite TypeText255Type of site where the incident occurred. e.g., pipeline, Riser, etc.PERMIT_HOLDERPermit HolderText255Name of the company responsible for the pipeline.INCIDENT_DATEIncident DateDateDate when the incident occurred.UTMZONEUTM ZoneShort5UTMNORTHINGUTM NorthingDouble10UTMEASTINGUTM EastingDouble9SPILL_FLAGSpill (Y/N)Text3Indicates whether a spill occurred, i.e., Yes, NoSPILL_PRODUCTSpill ProductText255Type of product spilled (if applicable)SPILL_VOLUME_M3Spill Volume (m3)Double4Spill volume (if applicable) in cubic meters.SPILL_VOLUME_STATUSSpill Volume StatusText18When no spill volume is reported the status indicates the reason why: Null, Unknown, Not Applicable, Historical No Data. When a spill volume has a value this value will be null.CAUSECauseText255CAUSE is a value indicating of failure cause classification of the incident, e.g., Metal Loss, Construction Defect, Cracking, External Factors, etc… CAUSE_DESCRIPTIONCause DescriptionText1000Renewal Triggers and Service Levels Nightly

Service Item Id: ddcc81d81dc1457e86b36674b6f07126

Copyright Text: BC Energy Regulator

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 704320.8759
YMin: 383431.8947
XMax: 1799663.6977
YMax: 1660842.1195
Spatial Reference: 102190  (3005)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: Incident
Description: N/A
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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• INCIDENT_ID ( type: esriFieldTypeString, alias: Incident ID, length: 15 )
• SITE_TYPE ( type: esriFieldTypeString, alias: Site Type, length: 255 )
• PERMIT_HOLDER ( type: esriFieldTypeString, alias: Permit Holder, length: 255 )
• INCIDENT_DATE ( type: esriFieldTypeDate, alias: Incident Date, length: 8 )
• SPILL_FLAG ( type: esriFieldTypeString, alias: Spill (Y/N), length: 3 )
• SPILL_PRODUCT ( type: esriFieldTypeString, alias: Spill Product, length: 255 )
• SPILL_VOLUME_M3 ( type: esriFieldTypeDouble, alias: Spill Volume (m3) )
• SPILL_VOLUME_STATUS ( type: esriFieldTypeString, alias: Spill Volume Status, length: 18 )
• CAUSE ( type: esriFieldTypeString, alias: Cause, length: 255 )
• CAUSE_DESCRIPTION ( type: esriFieldTypeString, alias: Cause Description, length: 1000 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata