Portal:Oil

From Enipedia
Jump to: navigation, search

This portal is set up as a starting point for oil/petroleum-related open source data (as the follow-up of an article in The Oil Drum). Currently, the main focus is identifying external sources of data and providing first suggestions for data improvement and management. However, we encourage users to start using Enipedia as a platform for hosting and maintaining oil-related datasets. There are a lot of interesting trends occurring with open data that can enable a better overview of what is occurring in the oil industry.

Contents

[edit] What you can do with open data

[edit] OpenStreetMaps

OpenStreetMaps has much more detail than only streets. Items in OSM do not just have coordinates, but also other characteristics, such as owner, website, etc. There are currently about 3000 items marked as oil industry (http://taginfo.openstreetmap.org/tags/industrial=oil). For an example, see the Port of Hamburg (http://www.openstreetmap.org/?lat=53.4834623336792&lon=9.96153116226196&zoom=15). We also made a map of all refineries in Europe based on OSM data. See Media:RefineriesInEurope_20120801.png

[edit] Wikipedia

Querying Wikipedia provides interesting pages. Especially the ones that use Infoboxes (Infobox oil field (497 pages), Infobox oil refinery (63 pages), Infobox pipeline (232 pages)) and Categories (Oil companies by country, Oil fields by country, Oil refineries by country, Petroleum industry by country, Petroleum by country). However, when going through these pages it becomes obvious that data structuring and data cleanup is an issue. At the same time, because a lot of the data is already organised, it can be quickly queried and inconsistencies can be displayed. By using Categories and especially Infoboxes, the data in wiki-pages becomes machine-readable, we can actually query the data, and use it in overviews or models.

For an example of the data that is currently available in Wikipedia, follow one of these links that calls a SPARQL query:


[edit] What fields do we know the (peak) capacity of?

These queries can also form a part of a wiki page, as is demonstrated below (by the way, if you think the data is not right, please edit it on the corresponding Wikipedia page or create a new page with an infobox). :

wikipediaPage bbl_per_day country_name
http://en.wikipedia.org/wiki/Athabasca_oil_sands 1,300,000 Canada
http://en.wikipedia.org/wiki/Burgan_field 1,200,000 Kuwait
http://en.wikipedia.org/wiki/Safaniya_Oil_Field 1,200,000 Saudi Arabia
http://en.wikipedia.org/wiki/Shaybah_oil_field 1,000,000 Saudi Arabia
http://en.wikipedia.org/wiki/Rumaila_oil_field 960,000 Iraq
http://en.wikipedia.org/wiki/Ku-Maloob-Zaap 867,000 Mexico
http://en.wikipedia.org/wiki/Ku-Maloob-Zaap 832,000 Mexico
http://en.wikipedia.org/wiki/El_Sharara_oil_field 800,000 Libya
http://en.wikipedia.org/wiki/Samotlor_Field 750,000 Russia
http://en.wikipedia.org/wiki/Azeri–Chirag–Guneshli 684,000 Azerbaijan
http://en.wikipedia.org/wiki/Bu_Hasa_oil_field 600,000 United Arab Emirates
http://en.wikipedia.org/wiki/Prudhoe_Bay_Oil_Field 547,000 United States
http://en.wikipedia.org/wiki/Marun_Field 520,000 Iran
http://en.wikipedia.org/wiki/Upper_Zakum_oil_field 500,000 United Arab Emirates
http://en.wikipedia.org/wiki/Carabobo-3_oil_field 480,000 Venezuela
http://en.wikipedia.org/wiki/Roncador_Oil_Field 460,000 Brazil
http://en.wikipedia.org/wiki/Junín-6_oil_field 450,000 Venezuela
http://en.wikipedia.org/wiki/Tengiz_Field 450,000 Kazakhstan
http://en.wikipedia.org/wiki/Carabobo-2_oil_field 400,000 Venezuela
http://en.wikipedia.org/wiki/Carabobo-1_oil_field 400,000 Venezuela
http://en.wikipedia.org/wiki/Sakhalin-II 395,000 Russia
http://en.wikipedia.org/wiki/Waha_field 350,000 Libya
http://en.wikipedia.org/wiki/Hassi_Messaoud_oil_field 350,000 Algeria
http://en.wikipedia.org/wiki/Junín-4_oil_field 350,000 Venezuela
http://en.wikipedia.org/wiki/Bombay_High 347,197 India
http://en.wikipedia.org/wiki/Cantarell_Field 340,000 Mexico
http://en.wikipedia.org/wiki/Umm_Shaif_oil_field 300,000 United Arab Emirates
http://en.wikipedia.org/wiki/South_Magwa_oil_field 300,000 Kuwait
http://en.wikipedia.org/wiki/Ourhoud_Oil_Field 250,000 Algeria
http://en.wikipedia.org/wiki/Sakhalin-I 250,000 Russia
http://en.wikipedia.org/wiki/Thunder_Horse_Oil_Field 250,000 United States
http://en.wikipedia.org/wiki/Al_Shaheen_Oil_Field 240,000 Qatar
http://en.wikipedia.org/wiki/Dalia_(oil_field) 240,000 Angola
http://en.wikipedia.org/wiki/Junín-5_oil_field 240,000 Venezuela
http://en.wikipedia.org/wiki/Kuparuk_River_oil_field 230,000 United States
http://en.wikipedia.org/wiki/Bonga_Field 202,000 Nigeria
http://en.wikipedia.org/wiki/Junín-10_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Junín-1_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Junín-2_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Junín-3_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Junín-7_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Junín-8_oil_field 200,000 Venezuela
http://en.wikipedia.org/wiki/Mangala_Area 200,000 India
http://en.wikipedia.org/wiki/Karachaganak_Field 200,000 Kazakhstan
http://en.wikipedia.org/wiki/Majnoon_oil_field 200,000 Iraq
http://en.wikipedia.org/wiki/Girassol_oil_field 200,000 Angola
http://en.wikipedia.org/wiki/Az_Zubair_Field 195,000 Iraq
http://en.wikipedia.org/wiki/Albacora-Leste_oil_field 180,000 Brazil
http://en.wikipedia.org/wiki/Buzzard_oil_field 180,000 United Kingdom
http://en.wikipedia.org/wiki/Hebron-Ben_Nevis_oil_field 150,000 Canada
http://en.wikipedia.org/wiki/Heidrun_oil_field 140,000 Norway
http://en.wikipedia.org/wiki/Pungarayacu_oil_field 130,000 Ecuador
http://en.wikipedia.org/wiki/Ekofisk_oil_field 127,000 Norway
http://en.wikipedia.org/wiki/Elephant_Field 125,000 Libya
http://en.wikipedia.org/wiki/Rubiales_oil_field 123,000 Colombia
http://en.wikipedia.org/wiki/Sapinhoá_oil_field 120,000 Brazil
http://en.wikipedia.org/wiki/Lula_oil_field 100,000 Brazil
http://en.wikipedia.org/wiki/Uzen_oil_field 100,000 Kazakhstan
http://en.wikipedia.org/wiki/Halfaya_Field 100,000 Iraq
http://en.wikipedia.org/wiki/Luzzu_oil_field 100,000 Malta
http://en.wikipedia.org/wiki/Monte_Alpi_oil_field 95,000 Italy
http://en.wikipedia.org/wiki/Cerro_Dragón_oil_field 95,000 Argentina
http://en.wikipedia.org/wiki/Yibal 88,000 Oman
http://en.wikipedia.org/wiki/Foinaven_oilfield 85,000 Scotland
http://en.wikipedia.org/wiki/Foinaven_oilfield 85,000 United Kingdom
http://en.wikipedia.org/wiki/Jubilee_oil_field 85,000 Ghana
http://en.wikipedia.org/wiki/Val'd_Agri_oil_field 85,000 Italy
http://en.wikipedia.org/wiki/Kumkol_oil_field 78,000 Kazakhstan
http://en.wikipedia.org/wiki/Caño_Limón_oilfield 73,000 Colombia
http://en.wikipedia.org/wiki/Agbami_Field 70,000 Nigeria
http://en.wikipedia.org/wiki/Statfjord_oil_field 70,000 Scotland
http://en.wikipedia.org/wiki/Statfjord_oil_field 70,000 Norway
http://en.wikipedia.org/wiki/Norne_oil_field 70,000 Norway
http://en.wikipedia.org/wiki/Gura_Ocniței_oil_field 64,000 Romania
http://en.wikipedia.org/wiki/Korolev_oil_field 60,000 Kazakhstan
http://en.wikipedia.org/wiki/Villafortuna_oil_field 60,000 Italy
http://en.wikipedia.org/wiki/Bouri_Field 60,000 Libya
http://en.wikipedia.org/wiki/Tê_Giác_Tr?ng_oilfield 55,000 Vietnam
http://en.wikipedia.org/wiki/Tê_Giác_Trắng_oilfield 55,000 Vietnam
http://en.wikipedia.org/wiki/Elm_Coulee_Oil_Field 53,000 United States
http://en.wikipedia.org/wiki/Iracema_Oil_Field 50,000 Brazil
http://en.wikipedia.org/wiki/Tempa_Rossa_oil_field 50,000 Italy
http://en.wikipedia.org/wiki/Vaca_Muerta 45,000 Argentina
http://en.wikipedia.org/wiki/Azadegan_oil_field 40,000 Iran
http://en.wikipedia.org/wiki/Morgan_oil_field 40,000 Egypt
http://en.wikipedia.org/wiki/Gullfaks_oil_field 39,000 Norway
http://en.wikipedia.org/wiki/Panna-Mukta_oilfield 35,000 India
http://en.wikipedia.org/wiki/Vaca_Muerta 31,000 Argentina
http://en.wikipedia.org/wiki/Aishwarya_oil_fields 30,000 India
http://en.wikipedia.org/wiki/Verkhnechonsk_field 23,500 Russia
http://en.wikipedia.org/wiki/Bolde?ti-Sc?eni_oil_field 23,000 Romania
http://en.wikipedia.org/wiki/Boldești-Scăeni_oil_field 23,000 Romania
http://en.wikipedia.org/wiki/Videle_oil_field 22,000 Romania
http://en.wikipedia.org/wiki/Rhourde_El_Baguel_oil_field 20,000 Algeria
http://en.wikipedia.org/wiki/Okoro_Oilfield 18,872 Nigeria
http://en.wikipedia.org/wiki/Buștenari-Runcu_oil_field 17,600 Romania
http://en.wikipedia.org/wiki/Urengoy_gas_field 16,500 Russia
http://en.wikipedia.org/wiki/Monte_Grosso_oil_field 15,000 Italy
http://en.wikipedia.org/wiki/Lebăda_Est_oil_field 15,000 Romania
http://en.wikipedia.org/wiki/Ombrina_Mare_oil_field 13,650 Italy
http://en.wikipedia.org/wiki/Blane_oil_field 10,224 United Kingdom
http://en.wikipedia.org/wiki/Blane_oil_field 10,224 Norway
http://en.wikipedia.org/wiki/Borankol_oil_field 10,000 Kazakhstan
http://en.wikipedia.org/wiki/Lebăda_Vest_oil_field 10,000 Romania
http://en.wikipedia.org/wiki/Komsomolskoye_oil_field 10,000 Kazakhstan
http://en.wikipedia.org/wiki/Cuejdiu_oil_field 10,000 Romania
http://en.wikipedia.org/wiki/Gyda_Oil_Field 10,000 Norway
http://en.wikipedia.org/wiki/Ula_oil_field 10,000 Norway
http://en.wikipedia.org/wiki/Elsa_oil_field 10,000 Italy
http://en.wikipedia.org/wiki/Intercampo_oil_field 10,000 Venezuela
http://en.wikipedia.org/wiki/Rovegnatta_oil_field 10,000 Italy
http://en.wikipedia.org/wiki/Umit_oil_field 10,000 Kazakhstan
http://en.wikipedia.org/wiki/Tambar_oil_field 8800 Norway
http://en.wikipedia.org/wiki/Algyő_oil_field 8500 Hungary
http://en.wikipedia.org/wiki/Suplacu_de_Barcău_oil_field 8500 Romania
http://en.wikipedia.org/wiki/Dębno_oil_field 8000 Poland
http://en.wikipedia.org/wiki/Valhall_oil_field 8000 Norway
http://en.wikipedia.org/wiki/Dunga_oil_field 7000 Kazakhstan
http://en.wikipedia.org/wiki/Bat?_Raman_oil_field 7000 Turkey
http://en.wikipedia.org/wiki/Batı_Raman_oil_field 7000 Turkey
http://en.wikipedia.org/wiki/Ballsh-Hekal_oil_field 5500 Albania
http://en.wikipedia.org/wiki/Oloibiri_Oilfield 5100 Nigeria
http://en.wikipedia.org/wiki/Tazl?ul_Mare_oil_field 5000 Romania
http://en.wikipedia.org/wiki/Eugenia_oil_field 5000 Romania
http://en.wikipedia.org/wiki/Tazlăul_Mare_oil_field 5000 Romania
http://en.wikipedia.org/wiki/Pescăruș_oil_field 5000 Romania
http://en.wikipedia.org/wiki/Dambořice_oil_field 4700 Czech Republic
http://en.wikipedia.org/wiki/Zaca_Oil_Field 4682 United States
http://en.wikipedia.org/wiki/Țicleni_oil_field 4500 Romania
http://en.wikipedia.org/wiki/Tasbulat_oil_field 4000 Kazakhstan
http://en.wikipedia.org/wiki/Raman_oil_field 4000 Turkey
http://en.wikipedia.org/wiki/Arman_oil_field 3800 Kazakhstan
http://en.wikipedia.org/wiki/Br?de?ti_oil_field 3500 Romania
http://en.wikipedia.org/wiki/Mihaela_oil_field 3500 Romania
http://en.wikipedia.org/wiki/Hrušky_oil_field 3500 Czech Republic
http://en.wikipedia.org/wiki/Brădești_oil_field 3500 Romania
http://en.wikipedia.org/wiki/Călacea_oil_field 3500 Romania
http://en.wikipedia.org/wiki/Delta_VI_oil_field 3400 Romania
http://en.wikipedia.org/wiki/Moreni_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Sinoe_oil_field 3000 Romania
http://en.wikipedia.org/wiki/East_Baghdad_Field 3000 Iraq
http://en.wikipedia.org/wiki/Çamurlu_oil_field 3000 Turkey
http://en.wikipedia.org/wiki/Bobaia_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Malu_Mare_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Geamăna_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Iași-Gorj_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Iaşi-Gorj_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Cobza_oil_field 3000 Romania
http://en.wikipedia.org/wiki/Nagylengyel_oil_field 2500 Hungary
http://en.wikipedia.org/wiki/Delta_IV_oil_field 2500 Romania
http://en.wikipedia.org/wiki/Epsilon_oil_field 2000 Greece
http://en.wikipedia.org/wiki/Vipere?ti_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Satchinez_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Turnu_oil_field 2000 Romania
http://en.wikipedia.org/wiki/B?beni_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Teiș_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Teiş_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Viperești_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Băbeni_oil_field 2000 Romania
http://en.wikipedia.org/wiki/Prinos_oil_field 1900 Greece
http://en.wikipedia.org/wiki/Edison_Oil_Field 1860 United States
http://en.wikipedia.org/wiki/Garzan_oil_field 1700 Turkey
http://en.wikipedia.org/wiki/Văleni_oil_field 1700 Romania
http://en.wikipedia.org/wiki/Oprişeneşti_oil_field 1600 Romania
http://en.wikipedia.org/wiki/Oprișenești_oil_field 1600 Romania
http://en.wikipedia.org/wiki/Batı_Kozluca_oil_field 1500 Turkey
http://en.wikipedia.org/wiki/Văluţa_oil_field 1500 Romania
http://en.wikipedia.org/wiki/Văluța_oil_field 1500 Romania
http://en.wikipedia.org/wiki/Arystan_oil_field 1480 Kazakhstan
http://en.wikipedia.org/wiki/Carpinteria_Offshore_Oil_Field 1345 United States
http://en.wikipedia.org/wiki/Aktas_oil_field 1000 Kazakhstan
http://en.wikipedia.org/wiki/Turkmenoy_oil_field 1000 Kazakhstan
http://en.wikipedia.org/wiki/N?eni_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Lapo?_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Barchiz_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Salcia_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Variaş_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Lapoș_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Năeni_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Gîsca_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Variaș_oil_field 1000 Romania
http://en.wikipedia.org/wiki/Gorisht-Kocul_oil_field 925 Albania
http://en.wikipedia.org/wiki/Doina_gas_field 900 Romania
http://en.wikipedia.org/wiki/Torcești_gas_field 900 Romania
http://en.wikipedia.org/wiki/Meri?ani-Dr?ganu_oil_field 800 Romania
http://en.wikipedia.org/wiki/B?icoi_Nord_oil_field 800 Romania
http://en.wikipedia.org/wiki/Eugenia_South_oil_field 800 Romania
http://en.wikipedia.org/wiki/Pâncota_oil_field 800 Romania
http://en.wikipedia.org/wiki/Abr?mu?_oil_field 800 Romania
http://en.wikipedia.org/wiki/Bustuchin_oil_field 800 Romania
http://en.wikipedia.org/wiki/Teremia_oil_field 800 Romania
http://en.wikipedia.org/wiki/Slatina_oil_field 800 Romania
http://en.wikipedia.org/wiki/Adıyaman_oil_field 800 Turkey
http://en.wikipedia.org/wiki/Abrămuț_oil_field 800 Romania
http://en.wikipedia.org/wiki/Hinţeşti_oil_field 800 Romania
http://en.wikipedia.org/wiki/Merișani-Drăganu_oil_field 800 Romania
http://en.wikipedia.org/wiki/Băicoi_Nord_oil_field 800 Romania
http://en.wikipedia.org/wiki/Săcel_oil_field 800 Romania
http://en.wikipedia.org/wiki/Hințești_oil_field 800 Romania
http://en.wikipedia.org/wiki/Cat_Canyon_Oil_Field 795 United States
http://en.wikipedia.org/wiki/Cakran-Mollaj_oil_field 650 Albania
http://en.wikipedia.org/wiki/Saltpond_Oil_Field 550 Ghana
http://en.wikipedia.org/wiki/Moftin_oil_field 500 Romania
http://en.wikipedia.org/wiki/Zegujani_oil_field 500 Romania
http://en.wikipedia.org/wiki/Pișcolt_oil_field 500 Romania
http://en.wikipedia.org/wiki/Mountain_View_Oil_Field 438 United States
http://en.wikipedia.org/wiki/Kuçova_oil_field 400 Albania
http://en.wikipedia.org/wiki/Dinçer_oil_field 400 Turkey
http://en.wikipedia.org/wiki/İkiztepe_oil_field 400 Turkey
http://en.wikipedia.org/wiki/Diyarbakır_oil_field 250 Turkey
http://en.wikipedia.org/wiki/Șivița_oil_field 250 Romania
http://en.wikipedia.org/wiki/Şiviţa_oil_field 250 Romania
http://en.wikipedia.org/wiki/Ayoluengo_oil_field 225 Spain
http://en.wikipedia.org/wiki/Santa_Clara_Avenue_Oil_Field 211 United States
http://en.wikipedia.org/wiki/Akpo 150 Nigeria
http://en.wikipedia.org/wiki/Jimbolia_Veche_oil_field 120 Romania
http://en.wikipedia.org/wiki/Pârâieni_oil_field 120 Romania
http://en.wikipedia.org/wiki/Russell_Ranch_Oil_Field 113 United States
http://en.wikipedia.org/wiki/Saticoy_Oil_Field 113 United States
http://en.wikipedia.org/wiki/Amonicë_oil_field 90 Albania
http://en.wikipedia.org/wiki/Semitropic_Oil_Field 88 United States
http://en.wikipedia.org/wiki/Patos-Marinza_Oil_Field 12 Albania
http://en.wikipedia.org/wiki/Guijarral_Hills_Oil_Field 1.4 United States
http://en.wikipedia.org/wiki/Libra_oil_field 0 Brazil
http://en.wikipedia.org/wiki/Tuzla_oil_field 0 Bosnia and Herzegovina
http://en.wikipedia.org/wiki/Šamac_oil_field 0 Bosnia and Herzegovina
[edit] How many fields were discovered per year (for those that have wiki pages)

Also see our excellent summary page on Mines.

[edit] What to do with Wikipedia?

As already said the data quality in Wikipedia for oil fields, e.g., is rather poor. Furthermore, some of the Wikipedians have rather limited ideas about what data should and should not be included in Wikipedia. Nevertheless in our opinion Wikipedia is one of the largest public knowledge repositories and therefore also potentially one of the largest sources of public scrutiny and support. If at all possible use Wikipedia.

[edit] Scrape the data with ScraperWiki

http://scraperwiki.com allows for people to write pieces of code that are able to extract data contained on websites. We have created an example on megaprojects and refineries that are able to extract information about the oil megaprojects/refineries on Wikipedia that have their own individual articles. As you can see on the link, this data can be downloaded in CSV format and then opened up in a tool such as Excel.

There's also a map displaying all refineries we have found about on different sources and for which we have scraped data.

[edit] Enipedia

Enipedia is basically a place where we try to combine data from different sources, to curate it to improve data quality, and to use fancy display methods to make data more insightful.

If you look around, you will find an overview of gas flows that is dynamically generated from (static) CIA world factbook data. Also, a graphical overview of gas pipelines that we extracted from external sources. And much more energy and industry related stuff. We also have all the energy data per country (see e.g. the Netherlands).

If you think that a set of (publicly available) energy and industry related data should be hosted on Enipedia, go ahead and create the appropriate Infoboxes, Categories, and pages.

[edit] How to Fix Incorrect/Missing Information?

Link to log in or create an account is in the upper right of the screen
Every power plant page has an "Edit with form" link in the upper right of the screen to guide you through the processes of editing

We fully expect for there to be incorrect and missing information. New projects are always started, old ones are being decommissioned or retrofitted, and owners change or are bought out. Keeping this information up to date requires a distributed effort integrating sources from around the world. The intent behind this site is to enable collaborative editing where we explore the use of different tools that can enable people to find problems in the data and direct them to areas that need attention.

Since this is a wiki, you can create an account and edit the information used to create this visualization. To do this, in the upper right of the screen, you'll see a "Log in / create account" link which you can use.

For some instructions, mainly related to power plants, see:

Personal tools
Namespaces

Variants
Actions
Navigation
Portals
Advanced
Toolbox