Data Mining OpenEI.org

Data Mining OpenEI.org

• Step-by-step examples, visualized using R stats package: Data Mining OpenEI, NREL's Semantic Wiki

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:

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

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

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

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

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