BGR data

Back to Energy preprocessor

The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed here. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.

Series pulled from BGR

Copy Of DataDict 720

Table	Group	Definition	Years	Source	Last IFs Update	UsedInPreprocessor
SeriesEnResorOilBGRBBOE	Energy, Infrastructure	Crude oil resources	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	No
SeriesEnReserCoalBGRBBOE	Energy, Infrastructure	Coal reserves	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	No
SeriesEnReserGasBGRBBOE	Energy, Infrastructure	Natural gas reserves	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	No
SeriesEnReserOilBGRBBOE	Energy, Infrastructure	Crude oil reserves	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	No
SeriesEnResorCoalBGRBBOE	Energy, Infrastructure	Coal resources	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	Yes
SeriesEnResorGasBGRBBOE	Energy, Infrastructure	Natural gas resources	2009	BGR; "Reserves, Resources and Availability of Energy Resources 2010" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010	2012/03/01	No
SeriesEnCumProdGasBGR	Energy, Infrastructure	Natural Gas Cumulative Production	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	No
SeriesEnCumProdOilBGR	Energy, Infrastructure	Cumulative Production Oil	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	No
SeriesEnReserCBMBGR	Energy, Infrastructure	Coalbed methane reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012"	2013/04/05	Yes
SeriesEnReserGasBGR	Energy, Infrastructure	Natural gas reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/04	Yes
SeriesEnReserHeavyOilBGR	Energy, Infrastructure	Heavy Oil Reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnReserOilBGR	Energy, Infrastructure	Crude oil reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnReserOilSandsBGR	Energy, Infrastructure	Oil Sands Reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnReserShaleGasBGR	Energy, Infrastructure	Shale Gas Reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012"	2013/04/05	Yes
SeriesEnReserShaleOilBGR	Energy, Infrastructure	Shale Oil Reserves	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorCBMBGR	Energy, Infrastructure	Coalbed methane Resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorGasBGR	Energy, Infrastructure	Natural gas resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorHeavyOilBGR	Energy, Infrastructure	Heavy Oil Resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorOilBGR	Energy, Infrastructure	Crude oil resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorOilSandsBGR	Energy, Infrastructure	Oil sands resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorShaleGasBGR	Energy, Infrastructure	Shale Gas Resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorShaleOilBGR	Energy, Infrastructure	Shale Oil resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes
SeriesEnResorTightGasBGR	Energy, Infrastructure	Tight Gas Resources	2011	BGR; "Reserves, Resources and Availability of Energy Resources 2012" Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012	2013/04/05	Yes

Instructions on importing BGR data

Process of importing and blending:

In preparing these series, I first downloaded the two energy reports from the BGR website. These are located in the folder Source Data, sub folder Source Data PDFs. I then exported the appropriate tables from these two PDFs into 2 excel sheets (which can be found in folder Source Data, sub folder Source Data Excel). Next, I broke these two excel sheets down into the 17 individual series, each series onto its own excel sheet (these can be found in folder “Energy Series Extracted from Source Data”).

Each one of these 17 sheets has 5 tabs (2012, 2013, 2012 Formatted, 2013 Formatted, and Data for Import). The 2012 and 2013 tabs have the raw data pulled from the two Energy Study excel sheets in sub folder Source Data Excel. The 2012 Formatted and 2013 Formatted tabs have the same data as the 2012 and 2013 tabs, only it has been formatted into a IFS-compatible format. The Data for Import tab has these two years combined.

Finally, I took all the Data for Import tabs from the 17 sheets and combined them into one sheet (Energy Series Final Version for Import). I then imported all series into Ifs from this sheet. Once I imported the data into Ifs, I blended the series with the existing 2011 data and exported all the series to the Access table “Imported Series” in folder “Imported Series”.

Some notes on the formatting process:

In 2014, term changed from Shale Oil to Tight Oil (applies to Series EnReserShaleOil and EnResourceShaleOil) not to be confused with Tight Gas.

Table numbers don’t stay the same over different years in the energy reports.

Once all series were formatted for uploading, I replaced all “–“ with 0’s, all “n.s”. with blanks, all “<” with blanks as per convention.

Differences between resources and reserves: “…[That] part of a mineral resource, which has been fully evaluated and is deemed commercially viable to work, is called a mineral reserve [in effect, resources will always be larger than resources]”

In effect, resources shouldn’t change over time, while reserves can.

-Source: http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html; Accessed 3/6/16

Reference Data: Listed below is each BGR series I updated, all with the name of the table in the Energy Report pdf, the column of the table used, and any differences found between years (I only listed differences for the resource series).

1. EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
2. EnCumProdOilBGR: uses table Crude Oil in XXXX (year), column Cum. Production
3. EnReserCBMBGR: Coalbed Methane Reserves. Table Natural Gas Resources (under CBM)
4. EnReserGasBGR: Uses table Natural Gas in XXXX (Year), Column: Reserves
5. EnReserHeavyOilBGR: Uses table Crude Oil Reserves, Extra Heavy Oil column
6. EnReserOilBGR: Utilizes table Crude Oil in XXXX (year), column Reserves
7. EnReserOilSandsBGR: Uses table Crude Oil Reserves, column Oil Sand
8. EnReserShaleGasBGR: Uses table Natural Gas Reserves, column Shale Gas
9. EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
10. EnResorCBMBGR: Uses table Natural Gas Resources, column CBM

</ol> </ol>

• Differences in India, Libya, Mexico, S. Africa,
• EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential

</ul>

• Differences in Afghan, Albania, Austria, many differences
• EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil

• Differences in Iraq, Mexico,
• EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential

Many differences

EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand

1. Differences in Iraq

EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas

1. Differences in Algeria, Argentina, Aust, Brazil, Canada, China, Mex, many others

EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil

1. Many differences

EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas

1. Differences in Mexico

</ul>

</ul>

</ol>