next
previous
items

Data table via SPARQL

Packaging waste recycling

Data table via SPARQL Published 11 Apr 2019 Last modified 24 Jun 2020

Download this dataset

Dataset preview

(Live Query)

date ugeo share target_2008 target_2025 target_2030 generated_waste recycled_waste
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "66.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "1111400"^^<http://www.w3.org/2001/XMLSchema#decimal> "743870"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "66.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "1340711"^^<http://www.w3.org/2001/XMLSchema#decimal> "896201"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "76.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "1659443"^^<http://www.w3.org/2001/XMLSchema#decimal> "1274705"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "81.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "1780492"^^<http://www.w3.org/2001/XMLSchema#decimal> "1458418"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "63.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "421145"^^<http://www.w3.org/2001/XMLSchema#decimal> "268724"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "30.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "520192"^^<http://www.w3.org/2001/XMLSchema#decimal> "160244"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "54.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "229430"^^<http://www.w3.org/2001/XMLSchema#decimal> "125594"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "59.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "72873"^^<http://www.w3.org/2001/XMLSchema#decimal> "43571"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "11.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "123066"^^<http://www.w3.org/2001/XMLSchema#decimal> "13643"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Czech Republic" "75.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#int> "65"^^<http://www.w3.org/2001/XMLSchema#int> "70"^^<http://www.w3.org/2001/XMLSchema#int> "1149843"^^<http://www.w3.org/2001/XMLSchema#decimal> "866013"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 60 rows in 0.004 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/packaging-waste-recycling-2/daviz.json

For system integrators

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



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

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 wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX stk_flow: <http://dd.eionet.europa.eu/vocabulary/eurostat/stk_flow/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT DISTINCT
bif:either(year(?date) > 2010, 2016, year(?date) ) as ?date
?ugeo

round((sum(?recycled_waste)/sum(?generated_waste))*1000)/10.0 as ?share
55 as ?target_2008
65 as ?target_2025
70 as ?target_2030
sum(?generated_waste) as ?generated_waste
sum(?recycled_waste) as ?recycled_waste
WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
    {{
      _:env_waspac sdmx-dimension:timePeriod ?date .
      _:env_waspac property:stk_flow stk_flow:DOM . 
      _:env_waspac property:waste waste:W1501 . 
      _:env_waspac sdmx-dimension:refArea ?geo . 
      _:env_waspac sdmx-attribute:unitMeasure unit:T . 
      {
        _:env_waspac property:wst_oper wst_oper:GEN .
        _:env_waspac sdmx-measure:obsValue ?generated_waste .
      } UNION {
        _:env_waspac property:wst_oper wst_oper:RCY .
        _:env_waspac sdmx-measure:obsValue ?recycled_waste .
      }


      #select the max year per country
      {
          SELECT DISTINCT
            max(?date) as ?date
            ?geo
          WHERE {{
           GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
              {{
                _:env_waspac sdmx-dimension:timePeriod ?date .
                _:env_waspac sdmx-dimension:refArea ?geo . 
              }}
          }}
          GROUP BY ?geo 
      } UNION {
        {
      #select 2005 year per country
          SELECT DISTINCT
            ?date
            ?geo
          WHERE {{
            GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
            {{
              _:env_waspac sdmx-dimension:timePeriod ?date .
              _:env_waspac sdmx-dimension:refArea ?geo .
              FILTER (year(?date) = 2005)
            }}
          }}
          GROUP BY ?geo 
        }
      }
    }}
    ?geo skos:exactMatch ?eeauri .
    ?eeauri skos:inScheme <http://dd.eionet.europa.eu/vocabulary/common/countries/> .
    ?eeauri rdfs:label ?ugeo .
}}
GROUP BY ?ugeo ?geo ?date
ORDER BY ?ugeo


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: packaging waste
Document Actions