Portal:Power Plants/MissingData

From Enipedia
Jump to: navigation, search

Contents

[edit] Goal

The goal of is this page to bundle all the information on missing data in Enipedia and how to improve it.

This page is part of an MSc project to help with filling in missing data and to map the dependencies between different types of data.

Some of the outcomes of this work may involve more insight on:

  • quality control checks - does a certain combination of facts conflict?
  • filling in missing data - what facts/data can be inferred from existing data?

[edit] Graphs / Tables

We do not know what is exactly possible but here some things we would like to see:

For the Carma data, emissions are in short tons (i.e. US ton), and in the queries a conversion is done to metric tonnes. Energy output is in MWh.

[edit] Load factors for the different type of power plants

The queries can be run by copy/pasting them into http://enipedia.tudelft.nl/sparql

(Total Energy Output) / (Capacity * 8760)

Results

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select ?x ?primary_fuel_type ?carmaID (?energy_2004 / (?capacityMW * 8700) as ?loadFactor_2004)
(?energy_2009 / (?capacityMW * 8700) as ?loadFactor_2009)
(?energy_Future / (?capacityMW * 8700) as ?loadFactor_Future) 
 where {
	?x prop:Generation_capacity_electrical_MW ?capacityMW . 
	?x prop:CarmaId ?carmaID . 
	?x prop:Primary_fuel_type ?primary_fuel_type . 
	?carmaPP prop3:plant_id ?carmaID .
	?carmaPP prop3:energy_2004 ?energy_2004 . 
	?carmaPP prop3:energy_2009 ?energy_2009 . 
	?carmaPP prop3:energy_Future ?energy_Future . 
	FILTER(?capacityMW > 0) . 
}


[edit] Efficiency of the fossil fuel power plants (for which it is unknown)

Coal: 101 / ( (Carbon Emissions * 1000) /(Total Energy Ouput *3.6*10^9) *10^6 )

The formula needs to be checked - results are roughly between 300 and 500

Results

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select ?x 101 / (((?carbon_2004*1000 / 1.1023) * 1000) / (?energy_2004 * 3.6 * 10e9) * 10e6) as ?efficiency_2004
101 / (((?carbon_2009*1000 / 1.1023) * 1000) / (?energy_2009 * 3.6 * 10e9) * 10e6) as ?efficiency_2009
101 / (((?carbon_Future*1000 / 1.1023) * 1000) / (?energy_Future * 3.6 * 10e9) * 10e6) as ?efficiency_Future where {
	?x prop:CarmaId ?carmaID . 
	?x prop:Primary_fuel_type a:Coal . 
	?carmaPP prop3:plant_id ?carmaID .
	?carmaPP prop3:carbon_2004 ?carbon_2004 . 
	?carmaPP prop3:carbon_2009 ?carbon_2009 . 
	?carmaPP prop3:carbon_Future ?carbon_Future . 
	?carmaPP prop3:energy_2004 ?energy_2004 . 
	?carmaPP prop3:energy_2009 ?energy_2009 . 
	?carmaPP prop3:energy_Future ?energy_Future . 
	FILTER(?carbon_2004 > 0) . 
	FILTER(?carbon_2009 > 0) . 
	FILTER(?carbon_Future > 0) . 
	FILTER(?energy_2004 > 0) . 
	FILTER(?energy_2009 > 0) . 
	FILTER(?energy_Future > 0) . 
}

Natural Gas: 55 / ( (Carbon Emissions * 1000) /(Total Energy Ouput *3.6*10^9) *10^6 )

Results

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select ?x 55 / (((?carbon_2004*1000 / 1.1023) * 1000) / (?energy_2004 * 3.6 * 10e9) * 10e6) as ?efficiency_2004
55 / (((?carbon_2009*1000 / 1.1023) * 1000) / (?energy_2009 * 3.6 * 10e9) * 10e6) as ?efficiency_2009
55 / (((?carbon_Future*1000 / 1.1023) * 1000) / (?energy_Future * 3.6 * 10e9) * 10e6) as ?efficiency_Future where {
	?x prop:CarmaId ?carmaID . 
	?x prop:Primary_fuel_type a:Natural_Gas . 
	?carmaPP prop3:plant_id ?carmaID .
	?carmaPP prop3:carbon_2004 ?carbon_2004 . 
	?carmaPP prop3:carbon_2009 ?carbon_2009 . 
	?carmaPP prop3:carbon_Future ?carbon_Future . 
	?carmaPP prop3:energy_2004 ?energy_2004 . 
	?carmaPP prop3:energy_2009 ?energy_2009 . 
	?carmaPP prop3:energy_Future ?energy_Future . 
	FILTER(?carbon_2004 > 0) . 
	FILTER(?carbon_2009 > 0) . 
	FILTER(?carbon_Future > 0) . 
	FILTER(?energy_2004 > 0) . 
	FILTER(?energy_2009 > 0) . 
	FILTER(?energy_Future > 0) . 
}

[edit] Writing SPARQL Queries on CARMA v3

These are the available properties in use for the CARMA v3 data:

rdfs:label
prop3:plant_id
prop3:CARMA_URL
prop3:carbon_2004
prop3:carbon_2009
prop3:carbon_Future
prop3:energy_2004
prop3:energy_2009
prop3:energy_Future
prop3:intensity_2004
prop3:intensity_2009
prop3:intensity_Future
prop3:continent
prop3:country
prop3:iso3
prop3:state
prop3:city_name
prop3:zip
prop3:latitude
prop3:longitude
prop3:dis
prop3:crd
prop3:name
prop3:company

Whenever you see a "?" in front of something, it means that it is a variable, and you can give it whatever name you wish. Also, the data comes from a single table so all of the queries you write will have statements of the form "some power plant" "has property" "some value". For example, to get the name, company and country for ten power plants, run the query below at http://enipedia.tudelft.nl/sparql. Make sure to include the PREFIX statement at the top of all queries.

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select * where {
?powerPlant prop3:name ?name . 
?powerPlant prop3:company ?company . 
?powerPlant prop3:country ?country . 
} LIMIT 10

This at least gives you an idea for how the data looks. If you want a list of the countries sorted alphabetically, you can do:

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select distinct (?country) where {
?powerPlant prop3:country ?country . 
} order by ?country

The documentation here refers to the Carma v2 data which is in use on the wiki pages of Enipedia. To link together the data that we've collected with the latest Carma v3 data, you need to include a statement like the one below which links together identifiers:

?x prop:CarmaId ?carmaID . 
?carmaPP prop3:plant_id ?carmaID .

[edit] Usage of the methods

The method for estimating are now generally described but they should be adapted to specific cases.

[edit] Load factor

The load factor method could be especially used for estimating the capacity of hydro and wind power. In that case the formula should be adapted depending on the country and the type of fuel used, an example of such a formula for the United Kingdom and hydro power could be seen below. The next step then would be to find the average load factor (how to do that) among these plants (and at the same time ruling out loadfactor of 0 and above 1)

PREFIX prop3: <http://enipedia.tudelft.nl/data/CARMA_v3/property/>
select ?x  ?carmaID(?energy_2009 / (?capacityMW * 8700) as ?loadFactor_2009)
 where {
	?x prop:Generation_capacity_electrical_MW ?capacityMW . 
	?x prop:CarmaId ?carmaID . 
	?x prop:Primary_fuel_type a:Hydro . 
        ?x prop:Country a:United_Kingdom . 
	?carmaPP prop3:plant_id ?carmaID .
	?carmaPP prop3:energy_2009 ?energy_2009 .  
	FILTER(?capacityMW > 0) .
        FILTER(?energy_2009 > 0) .        
} 

The problem is that this methods need to be tested, but that could cause a lot of work. You want to know if you actually could (within a reasonable margin) estimate the capacity with the average load factor. In that case you have to test it against power plants for which the capacity is unknown, meaning you have to manually find it out. 

[edit] Resources

Personal tools
Namespaces

Variants
Actions
Navigation
Portals
Advanced
Toolbox