Manitoba Oil and Gas Data Sources

Manitoba Data Releases

Manitoba v1.0 (August 2019)

This was the first release of Manitoba oil and gas data on WellWiki. The data was obtained from the Growth Enterprise and Trade branch of the province of Manitoba. It was provided in an Oracle dump file which we converted into a MySQL database using the "OraDump to MySQL" conversion software. From this database we made use of the following tables:

• Company_Codes: Contains the name and abbreviated name of each Manitoba operator.

• UWI: Contains directional drilling data as well as the UWI, total depth, true vertical depth, and plug back depth for each well.

• Units: Contains Manitoba facility data.

• Field_codes: Lists all of the fields found in Manitoba.

• Well_treatments: Contains Manitoba fracking treatment data.

• Well: For each well this table lists the license number, license date, licensee, surface rights owner, license status, license status date, operator, well name, ground elevation, and kelly bushing elevation.

• Perfs: Contains perforation treatment data.

• Production_Data: Provides monthly waste and production data.

• Well_License: Provides spud dates.

• Drilling_Rigs: Provides contractor names and rig numbers for spuds.

• Pool_List: Lists pools found in Manitoba.

We used the TIGER/Line coordinate system to map each well, for which lat/lon data were available, to their respective division and subdivision.

Overall, this release resulted in the generation of 10,474 Manitoba Well Pages, 603 Manitoba Operator Pages, and 98 Manitoba Division and Subdivision Pages. The team for this project consisted of Joel Gehman, Cole Miller, Alireza Azimi, and Ankesh Kumar. Funding for the project was provided in part by financial support from the Social Sciences and Humanities Research Council of Canada and the University of Alberta, as well as in-kind support University of Alberta School of Business.