next
previous
items

Packaging waste generation per capita and by country

Data table via SPARQL Published 22 Oct 2013 Last modified 27 Jun 2020
draft used for: http://www.eea.europa.eu/data-and-maps/figures/packaging-waste-generation-per-capita-and-by-country-12

Download this dataset

Dataset preview

(Live Query)

date kg_pro_capita population waste ugeo
"1997-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "138.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "15929932"^^<http://www.w3.org/2001/XMLSchema#decimal> "2206000"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"1998-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "139.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "15942232"^^<http://www.w3.org/2001/XMLSchema#decimal> "2230000"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"1999-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "141.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "15964922"^^<http://www.w3.org/2001/XMLSchema#decimal> "2260000"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2000-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "146.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "16004372"^^<http://www.w3.org/2001/XMLSchema#decimal> "2340000"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2001-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "136.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "16041892"^^<http://www.w3.org/2001/XMLSchema#decimal> "2193300"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2002-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "131.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "16127280"^^<http://www.w3.org/2001/XMLSchema#decimal> "2118000"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2003-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "143.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "16200546"^^<http://www.w3.org/2001/XMLSchema#decimal> "2319944"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2004-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "135.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "16285146"^^<http://www.w3.org/2001/XMLSchema#decimal> "2203678"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2005-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "135.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "16402718"^^<http://www.w3.org/2001/XMLSchema#decimal> "2222800"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"
"2006-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "141.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "16508596"^^<http://www.w3.org/2001/XMLSchema#decimal> "2332704"^^<http://www.w3.org/2001/XMLSchema#decimal> "AT"

Received 528 rows in 0.104 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/packaging-waste-generation-per-capita/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



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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#> 
PREFIX a: <http://rdfdata.eionet.europa.eu/eurostat/dic/age#>
PREFIX s: <http://rdfdata.eionet.europa.eu/eurostat/dic/sex#>
PREFIX wst: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX flow: <http://rdfdata.eionet.europa.eu/eurostat/dic/flow#>
PREFIX waste: <http://rdfdata.eionet.europa.eu/eurostat/dic/waste#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT
    ?date
    (round(sum(?waste)*10000/sum(?population)))/10.0 as ?kg_pro_capita
    #((round(sum(?waste)*100/sum(?population))*10000)) as ?kg_pro_capita
    sum(?population) as ?population 
    (sum(?waste)) as ?waste
    ?ugeo
  {{
  SELECT
    ?date
    ?population 
    ?waste
    ?ugeo
    ?memberOfcode
  WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> { 
    {
    _:env_waspac sdmx-dimension:timePeriod ?date . FILTER (?date >= "1997-01-01"^^xsd:date)
    _:env_waspac property:geo ?geo .
    _:env_waspac property:unit u:T .
    _:env_waspac property:wst_oper wst:GEN .
    _:env_waspac property:flow flow:DOMESTIC .
    _:env_waspac property:waste waste:W1501 .
    _:env_waspac sdmx-measure:obsValue ?waste .
     }}
    } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz> { 
    {
    _:demo_pjan sdmx-dimension:timePeriod ?date . FILTER (?date >= "1997-01-01"^^xsd:date)
    _:demo_pjan property:geo ?geo .
    _:demo_pjan sdmx-dimension:age a:TOTAL .
    _:demo_pjan property:sex s:T .
    _:demo_pjan sdmx-measure:obsValue ?population .     
    }}
  }
  ?geo skos:prefLabel ?country .
  ?geo skos:notation ?ugeo .
  ?eeageo owl:sameAs ?geo . 
  ?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> . 
  ?memberOf skos:member ?eeageo . 
  ?memberOf skos:notation ?memberOfcode .
 }  
}
FILTER (?memberOfcode IN ('EEA33'))
}
GROUP BY ?date ?ugeo ORDER BY ?ugeo ?date

Error when running query:

Error. Traceback (most recent call last):
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.1-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 267, in run_with_timeout
    ret = func(*args, **kwargs)
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.1-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 196, in query_and_get_result
    result = sparql.query(*args, timeout = kwargs.get("timeout", 0) or 0)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 701, in query
    return s.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 390, in query
    return q.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 540, in query
    response = self._request(statement, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 527, in _request
    response = self._build_response(query, opener, buf, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 514, in _build_response
    timeout if timeout > 0 else None)
  File "/plone/buildout-cache/eggs/sparql_client-3.7-py2.7.egg/sparql.py", line 487, in _get_response
    response = opener.open(request, timeout=timeout)
  File "/usr/local/lib/python2.7/urllib2.py", line 421, in open
    protocol = req.get_type()
  File "/usr/local/lib/python2.7/urllib2.py", line 283, in get_type
    raise ValueError, "unknown url type: %s" % self.__original
ValueError: unknown url type: semantic.eea.europa.eu/sparql


Permalinks

Document Actions