View In:   ArcGIS Online Map Viewer

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 Properties Attributes / Column Name Field Alias Data Type Data Precision Comments OBJECTID OBJECTID Object ID 10 Unique row value assigned by database SHAPE SHAPE Geometry (Point) Geometry column INCIDENT_ID Incident ID Text 15 Unique identifier for each incident. SITE_TYPE Site Type Text 255 Type of site where the incident occurred. e.g., pipeline, Riser, etc.<o:p></o:p> PERMIT_HOLDER Permit Holder Text 255 Name of the company responsible for the pipeline. INCIDENT_DATE Incident Date Date Date when the incident occurred. UTMZONE UTM Zone Short 5 UTMNORTHING UTM Northing Double 10> UTMEASTING<o:p></o:p> UTM Easting Double 9 SPILL_FLAG Spill (Y/N) Text 3> Indicates whether a spill occurred, i.e., Yes, No SPILL_PRODUCT Spill Product Text 255> Type of product spilled (if applicable) CAUSE Cause Text< 255 CAUSE is a value indicating of failure cause classification of the incident, e.g., Metal Loss, Construction Defect, Cracking, External Factors, etc… CAUSE_DESCRIPTION Cause Description Text 1000 Renewal Triggers and Service Levels  NightlyContact InformationFor further information please contact  BC Energy Regulator geospatial@bc-er.ca

Service Item Id: 5de76632f8e8421b8b07def7792a6827

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 704320.8759
YMin: 383431.8947
XMax: 1799550.6667
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: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INCIDENT_ID ( type: esriFieldTypeString, alias: INCIDENT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INCIDENT_ID )
• SITE_TYPE ( type: esriFieldTypeString, alias: SITE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SITE_TYPE )
• PERMIT_HOLDER ( type: esriFieldTypeString, alias: PERMIT_HOLDER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERMIT_HOLDER )
• INCIDENT_DATE ( type: esriFieldTypeDate, alias: INCIDENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INCIDENT_DATE )
• SPILL_FLAG ( type: esriFieldTypeString, alias: SPILL_FLAG, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SPILL_FLAG )
• SPILL_PRODUCT ( type: esriFieldTypeString, alias: SPILL_PRODUCT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SPILL_PRODUCT )
• CAUSE ( type: esriFieldTypeString, alias: CAUSE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAUSE )
• CAUSE_DESCRIPTION ( type: esriFieldTypeString, alias: CAUSE_DESCRIPTION, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: CAUSE_DESCRIPTION )

Templates:

• Name: Incidents in BC
  Description:
  Prototype:
  CAUSE: null
  CAUSE_DESCRIPTION: null
  INCIDENT_ID: null
  SITE_TYPE: null
  PERMIT_HOLDER: null
  INCIDENT_DATE: null
  SPILL_FLAG: null
  SPILL_PRODUCT: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,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

Child Resources:   Field Groups   Contingent Values

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