British Columbia v1.0 (July 2015)

British Columbia Well Data was obtained from

1) Oil and Gas Commision Data Downloads

2) Oil and Gas Commision GIS Data.

Oil and Gas Commission Data Downloads

Login is required to access this data - see "WellWiki Usernames and Passwords" in WellWiki Data on Google Drive. Following login, choose the "MENU" link, and on the next page, select "Data Downloads".

a) facindex.csv - Facility Index in Ascii Format with Comma Delimiter

• Data downloaded last updated July 12, 2015

• Used to populate bc_facility

b) prod_csv.zip - Production Data for all wells in B.C. - used zone_prd.csv from the folder

• Also available in .txt format

• Data downloaded last updated July 10, 2015

• Used to populate bc_production_values

c) well_index.csv - Well Index in Ascii Format With Comma Delimiter

• Data downloaded last updated July 16, 2015

• Used to populate bc_well

d) well_index.wri - Well Index Documentation

• used to interpret column headings in well_index.csv

e) Latlos.xls - Well Surface Location

• Data downloaded last updated Oct. 26, 2012

• used to populate bc_loc

Oil and Gas Commission GIS Data

Select the Wells link to download the well data from the Commission's Public FTP site. Connect to the server as Guest so login information is not required. The GIS data is available as shapefiles, which can be opened by a program such as the open-source QGIS. From there, the data from the attribute tables may be copied into Excel and used.

a) awbh_bc files (.dbf, .prj, .shp, .shx) - Oil and Gas Well Bottom locations for British Columbia

• Updated daily

• Used to populate bc_production

b) awsh_bc files (.dbf, .prj, .shp, .shp.xml, .shx) - Oil and Gas Well Surface locations for British Columbia

• Updated daily

• Used to populate bc_production and bc_well_operator

c) awsit_bc files (.dbf, .prj, .shp, .shx) - Well Sites for British Columbia (Polygons)

• Updated daily

• Data current from October 30, 2006 to present

• Used to populate bc_permit

British Columbia v2.0 (October 2020)

This was the second release of British Columbia oil and gas data on Wellwiki. All the data for this upgrade came from the BC Oil and Gas Commission website . We have used four different datasets from this website to fetch the data.

• Wells.csv

• Well_index.csv

• zone_prod.csv

• w_status.csv

We used Statistics Canada's 2019 Census Boundary Files to map each well, to their respective unincorporated division and, where applicable, incorporated subdivision.

Overall, this upgrade resulted in the generation of 34,540 new or modified British Columbia Well Pages; 344 new or modified British Columbia Operator Pages; 31 new or modified British Columbia Municipality Pages and 18 new or modified British Columbia County Pages. The team for this project consisted of Joel Gehman, Cole Miller, and Georgio Cheruvelil. Financial support and in-kind support for this project was provided by the University of Alberta School of Business.