Data table via SPARQL

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

Data table via SPARQL Published 18 Jun 2018 Last modified 02 Oct 2018

Topics: Environment and health

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	others	waste	wastewater	air_climate
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"96938.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"109332.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"56775.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4313.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"94808.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"108784.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"56746.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4408.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"98022.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"110395.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"57418"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4999.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int>	"97837.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"112416.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"59744.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4774.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"95389.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"118316"^^<http://www.w3.org/2001/XMLSchema#decimal>	"59563.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5061.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"95067.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"120399.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"61027"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5621.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"92311.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"121032.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"61725.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5728.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"88445.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"120757.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"61645.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5878.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int>	"83359.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"124896.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"60986.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4820.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int>	"86806.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"123228.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"61459.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5282.7"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 12 rows in 0.001 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/epe-by-specialised-producers-and-1/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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX env_econ: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_econ/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>

SELECT DISTINCT
?date
round((?total - (?waste + ?wastewater + ?air_climate))/?deflator*1000)/10.0 as ?others
round(?waste/?deflator*1000)/10.0 as ?waste
round(?wastewater/?deflator*1000)/10.0 as ?wastewater
round(?air_climate/?deflator*1000)/10.0 as ?air_climate
{
  SELECT DISTINCT
    year(?date) as ?date
    (sum(COALESCE(?pepssp_waste,0)) + sum(COALESCE(?pepsnsp_waste,0)) + sum(COALESCE(?pepsgg_waste,0))) as ?waste

    (sum(COALESCE(?pepssp_wastewater,0)) + sum(COALESCE(?pepsnsp_wastewater,0)) + sum(COALESCE(?pepsgg_wastewater,0))) as ?wastewater

   (sum(COALESCE(?pepssp_air_climate,0)) + sum(COALESCE(?pepsnsp_air_climate,0)) + sum(COALESCE(?pepsgg_air_climate,0))) as ?air_climate

   (sum(?total1) + (sum(?total2)-sum(?pepssp_EPS_P2_EPS_SP)) + sum(?total3)) as ?total
    sum(COALESCE(?deflator,0)) as ?deflator 

  WHERE {
   {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepssp.rdf.gz>
      {
        _:env_ac_pepssp sdmx-dimension:timePeriod ?date .
        _:env_ac_pepssp property:env_econ env_econ:EPS_P11 .
        _:env_ac_pepssp sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepssp sdmx-attribute:unitMeasure unit:MIO_EUR .
        {
          _:env_ac_pepssp property:ceparema ceparema:CEPA3 .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_waste .
        } UNION {
          _:env_ac_pepssp property:ceparema ceparema:CEPA2 .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_wastewater .
        } UNION {
          _:env_ac_pepssp property:ceparema ceparema:CEPA1 .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_air_climate .
        } 
      }
   } UNION {      
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsnsp.rdf.gz>
      {
        _:env_ac_pepsnsp sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsnsp property:nace_r2 nace_r2:EP_BUS .
        _:env_ac_pepsnsp sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsnsp sdmx-attribute:unitMeasure unit:MIO_EUR .
        _:env_ac_pepsnsp property:env_econ env_econ:EPS_P1_ANC .
        {
          _:env_ac_pepsnsp property:ceparema ceparema:CEPA3 .
          _:env_ac_pepsnsp sdmx-measure:obsValue ?pepsnsp_waste .
        } UNION {
          _:env_ac_pepsnsp property:ceparema ceparema:CEPA2 .
          _:env_ac_pepsnsp sdmx-measure:obsValue ?pepsnsp_wastewater .
        } UNION {
          _:env_ac_pepsnsp property:ceparema ceparema:CEPA1 .
          _:env_ac_pepsnsp sdmx-measure:obsValue ?pepsnsp_air_climate .
        }
      } 
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsgg.rdf.gz>
      {
        _:env_ac_pepsgg sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsgg property:env_econ env_econ:EPS_P1 .
        _:env_ac_pepsgg sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsgg sdmx-attribute:unitMeasure unit:MIO_EUR .
        {
          _:env_ac_pepsgg property:ceparema ceparema:CEPA3 .
          _:env_ac_pepsgg sdmx-measure:obsValue ?pepsgg_waste .
        } UNION {
          _:env_ac_pepsgg property:ceparema ceparema:CEPA2 .        
          _:env_ac_pepsgg sdmx-measure:obsValue ?pepsgg_wastewater .
        } UNION {
          _:env_ac_pepsgg property:ceparema ceparema:CEPA1 .
          _:env_ac_pepsgg sdmx-measure:obsValue ?pepsgg_air_climate .
        } 
      } 
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
      {
        _: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:PD10_EUR .
        _:nama_10_gdp sdmx-measure:obsValue ?deflator .
      }
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsgg.rdf.gz>
      {
        _:env_ac_pepsgg_total sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsgg_total property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepsgg_total sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsgg_total sdmx-attribute:unitMeasure unit:MIO_EUR .
        _:env_ac_pepsgg_total property:env_econ ?env_econ_pepsgg .
        FILTER (?env_econ_pepsgg in (env_econ:EPS_P1, env_econ:EPS_P51G_NP))
        _:env_ac_pepsgg_total sdmx-measure:obsValue ?total1 .
      } 
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepssp.rdf.gz>
      {
        _:env_ac_pepssp_total sdmx-dimension:timePeriod ?date .
        _:env_ac_pepssp_total property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepssp_total sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepssp_total sdmx-attribute:unitMeasure unit:MIO_EUR .
        {
          _:env_ac_pepssp_total property:env_econ env_econ:EPS_P11 .
          _:env_ac_pepssp_total sdmx-measure:obsValue ?total2 .
        } UNION {
          _:env_ac_pepssp_total property:env_econ env_econ:EPS_P2_EPS_SP .
          _:env_ac_pepssp_total sdmx-measure:obsValue ?pepssp_EPS_P2_EPS_SP .
        } UNION {
          _:env_ac_pepssp_total property:env_econ env_econ:EPS_P51G_NP .
          _:env_ac_pepssp_total sdmx-measure:obsValue ?total2 .
        }
      }      
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsnsp.rdf.gz>
      {
        _:env_ac_pepsnsp_total sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsnsp_total property:nace_r2 nace_r2:EP_BUS .
        _:env_ac_pepsnsp_total property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepsnsp_total sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsnsp_total sdmx-attribute:unitMeasure unit:MIO_EUR .
        _:env_ac_pepsnsp_total property:env_econ ?env_econ .
        FILTER (?env_econ in (env_econ:EPS_P1_ANC, env_econ:EPS_P51G_NP))
        _:env_ac_pepsnsp_total sdmx-measure:obsValue ?total3 .
      
      } 
    }
    FILTER (year(?date) >= 2006)
  }
}

Permalinks

Permalink to this version: ba84b49e5a084b49a2530f23383d2aea
Permalink to latest version: PF1OZY7Q2G

Geographic coverage

Austria Belgium Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom