British Columbia Oil and Gas Data Sources

BC Oil and Gas Commission resources

British Columbia Well Data was obtained from

1) OIL AND GAS COMMISSION DATA DOWNLOADS

2) OIL AND GAS COMMISSION 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