Data Mining OpenEI.org

From Enipedia
Jump to: navigation, search

Contents

[edit] Data Mining OpenEI.org

[edit] Further Examples

OpenEI.org has a sparql endpoint here where you can perform your own queries

As described in the first link to the blog post, the queries below use data contained in infoboxes for Energy Generation Facilities. An example box is shown below: BearCreekWindFarm.png

[edit] Total renewable capacity installed per year

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX eiprop: <http://openei.org/resources/Property-3A> 
select (xsd:string(fn:substring(str(?onlineDate), 1, 4)) as ?onlineYear) (fn:round(sum(?capacity)) as ?totalCapacity)  where {
   service <http://en.openei.org/sparql> {
      ?plant eiprop:GeneratingCapacity ?capacity .
      ?plant eiprop:CommercialOnlineDate ?onlineDate .
   }
} group by ?onlineDate order by ?onlineDate

[edit] Who buys the most renewable energy?

PREFIX prop: <http://openei.org/resources/Property-3A> 
select sum(?capacity) as ?totalCapacity ?energyPurchaser where {
?plant prop:GeneratingCapacity ?capacity .
?plant prop:EnergyPurchaser ?energyPurchaser 
} group by ?energyPurchaser order by DESC(?totalCapacity)

answer

[edit] Who owns the most renewable energy?

PREFIX prop: <http://openei.org/resources/Property-3A> 
select sum(?capacity) as ?totalCapacity ?owner where {
?plant prop:GeneratingCapacity ?capacity .
?plant prop:Owner ?owner 
} group by ?owner order by DESC(?totalCapacity)

answer

[edit] What's the installed capacity per facility type

PREFIX prop: <http://openei.org/resources/Property-3A> 
select sum(?capacity) as ?totalCapacity ?facilityType where {
?plant prop:GeneratingCapacity ?capacity .
?plant prop:FacilityType ?facilityType 
} group by ?facilityType order by DESC(?totalCapacity)

answer

[edit] What's the installed capacity per sector

PREFIX prop: <http://openei.org/resources/Property-3A> 
select sum(?capacity) as ?totalCapacity ?sector where {
?plant prop:GeneratingCapacity ?capacity .
?plant prop:Sector ?sector 
} group by ?sector order by DESC(?totalCapacity)

answer

Personal tools
Namespaces

Variants
Actions
Navigation
Portals
Advanced
Toolbox