You are here: Home / Data and maps / Data visualisations / Semantic Data Service (sparql repository) / WASTE003 - Trend in the amount of WEEE collected from households in 28 European countries (kg/capita/year), 2006-2008-2010

WASTE003 - Trend in the amount of WEEE collected from households in 28 European countries (kg/capita/year), 2006-2008-2010

SPARQL

Download this dataset

Dataset preview

(Live Query)

country collected_from_private_households_2006 collected_from_private_households_2008 collected_from_private_households_2010 collection_target
"AT" "7.4"^^<http://www.w3.org/2001/XMLSchema#double> "8.8"^^<http://www.w3.org/2001/XMLSchema#double> "8.7"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"BE" "7.2"^^<http://www.w3.org/2001/XMLSchema#double> "8.1"^^<http://www.w3.org/2001/XMLSchema#double> "9.3"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"BG" "" "5.1"^^<http://www.w3.org/2001/XMLSchema#double> "5.9"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"CY" "" "2.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.1"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"CZ" "" "4.3"^^<http://www.w3.org/2001/XMLSchema#double> "5.0"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"DE" "8.6"^^<http://www.w3.org/2001/XMLSchema#double> "7.8"^^<http://www.w3.org/2001/XMLSchema#double> "8.8"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"DK" "10.8"^^<http://www.w3.org/2001/XMLSchema#double> "13.9"^^<http://www.w3.org/2001/XMLSchema#double> "14.8"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"EE" "4.3"^^<http://www.w3.org/2001/XMLSchema#double> "4.4"^^<http://www.w3.org/2001/XMLSchema#double> "4.2"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"EL" "0.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.9"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"ES" "3.6"^^<http://www.w3.org/2001/XMLSchema#double> "6.3"^^<http://www.w3.org/2001/XMLSchema#double> "3.2"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>

Received 28 rows in 0.000 seconds.


http://www.eea.europa.eu/data-and-maps/daviz/sds/waste003-trend-in-the-amount/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 wo: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#> 
PREFIX w: <http://rdfdata.eionet.europa.eu/eurostat/dic/waste#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> 

SELECT 

?geo as ?country
sum(xsd:double(?v2006)) as ?collected_from_private_households_2006
sum(xsd:double(?v2008)) as ?collected_from_private_households_2008
sum(xsd:double(?v2010)) as ?collected_from_private_households_2010
4 as ?collection_target

WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waselee.rdf.gz> { 

        
        _:env_waselee sdmx-attribute:unitMeasure u:KG_HAB .
        _:env_waselee property:waste w:TOTAL .
        _:env_waselee property:geo ?ugeo .
        _:env_waselee property:wst_oper wo:COL_HH .
        { 
        _:env_waselee sdmx-measure:obsValue ?v2006 .
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2006-01-01"^^xsd:date)
        } UNION { 
        _:env_waselee sdmx-measure:obsValue ?v2008 .
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2008-01-01"^^xsd:date)
        } UNION { 
        _:env_waselee sdmx-measure:obsValue ?v2010 .        
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2010-01-01"^^xsd:date)
        } 
  } 
  ?ugeo skos:prefLabel ?country .
  ?ugeo skos:notation ?geo .
}  group by ?ugeo ?geo order by ?geo


European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100