next
previous
items

Data table via SPARQL

Packaging waste generation per capita and by country

Data table via SPARQL Published 22 Oct 2013 Last modified 15 Apr 2024
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.059 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.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 287, in run_with_timeout
    ret = func(*args, **kwargs)
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 215, in query_and_get_result
    result = sparql.query(*args, timeout = kwargs.get("timeout", 0) or 0)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 747, in query
    return s.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 416, in query
    return q.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 571, in query
    response = self._request(statement, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 558, in _request
    response = self._build_response(query, opener, buf, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 543, in _build_response
    timeout if timeout > 0 else None)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 514, 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