Data table via SPARQL

EPE by specialised producers and public sector, split by environmental domain, EU-28

Data table via SPARQL Published 30 Aug 2016 Last modified 16 Nov 2016

This is an old version, kept for reference only.

Go to latest version

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date	dom	obsValue	deflator
"2003"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"2.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"90.13"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"2.92"^^<http://www.w3.org/2001/XMLSchema#decimal>	"92.29"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"3.92"^^<http://www.w3.org/2001/XMLSchema#decimal>	"94.43"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"4.38"^^<http://www.w3.org/2001/XMLSchema#decimal>	"96.66"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"3.56"^^<http://www.w3.org/2001/XMLSchema#decimal>	"99.37"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"3.96"^^<http://www.w3.org/2001/XMLSchema#decimal>	"99.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"5.61"^^<http://www.w3.org/2001/XMLSchema#decimal>	"98"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"4.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"3.53"^^<http://www.w3.org/2001/XMLSchema#decimal>	"101.24"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"Ambient air climate"	"3.23"^^<http://www.w3.org/2001/XMLSchema#decimal>	"103.71"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 52 rows in 0.035 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/epe-by-specialised-producers-and/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX caparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX nace_r2:<http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX indic_em: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_em/>
PREFIX env_exp: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_exp/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX env_dom: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_dom/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

#heavy technical debt in this one
SELECT DISTINCT
year(?date) as ?date
?dom

round(sum(xsd:double(?obsValue)) / ( (sum(?CP_MEUR)/sum(?CLV10_MEUR) )*10.0))/100.0 as ?obsValue

#(sum(xsd:double(?obsValue))) as ?obsValue
round((sum(?CP_MEUR)/sum(?CLV10_MEUR))*10000)/100.0 as ?deflator
WHERE {
 {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_exp1r2.rdf.gz>
    {
      _:env_ac_exp1r2 sdmx-dimension:timePeriod ?date . 
      _:env_ac_exp1r2 sdmx-dimension:refArea geo:EU28 . 
      _:env_ac_exp1r2 property:nace_r2 ?nace_r2 . 
      FILTER (?nace_r2 in (nace_r2:EP_GOV, nace_r2:EP_BUS, nace_r2:EP_SPE))
      _:env_ac_exp1r2 sdmx-attribute:unitMeasure unit:MIO_EUR .    
      _:env_ac_exp1r2 property:env_exp env_exp:EE1000 .

      #_:env_ac_exp1r2 property:env_dom ?env_dom .
      #_:env_ac_exp1r2 property:env_exp ?env_exp .

      {
        { SELECT 'Ambient air climate' as ?dom {}}
        _:env_ac_exp1r2 property:env_dom env_dom:ED1110 .
        _:env_ac_exp1r2 sdmx-measure:obsValue ?obsValue .
      } UNION {
        { SELECT 'Wastewater' as ?dom {}}
        _:env_ac_exp1r2 property:env_dom env_dom:ED1120 .
        _:env_ac_exp1r2 sdmx-measure:obsValue ?obsValue .
      } UNION {
        { SELECT 'Waste' as ?dom {}}
        _:env_ac_exp1r2 property:env_dom env_dom:ED1130 .
        _:env_ac_exp1r2 sdmx-measure:obsValue ?obsValue .
      } UNION {
        { SELECT 'Others' as ?dom {}}
        _:env_ac_exp1r2 property:env_dom env_dom:ED1200 .
        _:env_ac_exp1r2 sdmx-measure:obsValue ?obsValue .
    }
    }
 } UNION {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
  {
    {
      { SELECT 'Ambient air climate' as ?dom {}}
    } UNION {
      { SELECT 'Wastewater' as ?dom {}}
    } UNION {
      { SELECT 'Waste' as ?dom {}}
    } UNION {
      { SELECT 'Others' as ?dom {}}
    }
    _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
    _:nama_10_gdp property:na_item na_item:B1GQ . 
    _:nama_10_gdp sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CLV10_MEUR .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CP_MEUR .
    }
   }
 }
 FILTER (year(?date) >= 2003)
}
GROUP BY ?date ?dom
ORDER BY  ?dom ?date