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)
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.
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
- Permalink to this version
- 73da3ad3b63d4c3d8462a16a5627ac25
- Permalink to latest version
- UWK1H4ON2S
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/packaging-waste-generation-per-capita or scan the QR code.
PDF generated on 03 Jul 2020, 06:57 PM
Document Actions
Share with others