next
previous
items

Data table via SPARQL

Waste generation per capita

Data table via SPARQL Published 03 Apr 2017 Last modified 10 Apr 2017

Download this dataset

Dataset preview

(Live Query)

date originalYear ugeo obsValue
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "425"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1839"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "2004"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "2853"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "2004"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "3285"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "4945"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2012"^^<http://www.w3.org/2001/XMLSchema#int> "Bosnia and Herzegovina" "1061"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "2004"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "2174"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "2463"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "723"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "2004"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "1134"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 69 rows in 0.039 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/waste-generation-per-capita-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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>


SELECT DISTINCT
bif:either(year(?date) >= 2008, 2014, year(?date) ) as ?date
year(?date) as ?originalYear
?ugeo
?obsValue
WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc210.rdf.gz> 
    {{
    _:tsdpc210 sdmx-dimension:timePeriod ?date . 
    _:tsdpc210 property:nace_r2 ?nace_r2 . 
    _:tsdpc210 property:hazard ?hazard . 
    _:tsdpc210 property:waste ?waste . 
    _:tsdpc210 sdmx-dimension:refArea ?geo . 
    _:tsdpc210 sdmx-attribute:unitMeasure ?unit . 
    _:tsdpc210 sdmx-measure:obsValue ?obsValue .


      #select the max year per country
      {
          SELECT DISTINCT
            max(?date) as ?date
            ?geo
          WHERE {{
           GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc210.rdf.gz> 
              {{
                _:tsdpc210 sdmx-dimension:timePeriod ?date .
                _:tsdpc210 sdmx-dimension:refArea ?geo . 
                _:tsdpc210 sdmx-measure:obsValue ?obsValueFilter .
              }}
              FILTER ( ?obsValueFilter > 0 )
          }}
          GROUP BY ?geo 
      } UNION {
        {
      #select 2004 year per country
          SELECT DISTINCT
            ?date
            ?geo
          WHERE {{
            GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc210.rdf.gz> 
            {{
              _:tsdpc210 sdmx-dimension:timePeriod ?date .
              _:tsdpc210 sdmx-dimension:refArea ?geo .
              FILTER (year(?date) = 2004)
            }}
          }}
          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: waste generation, waste
Document Actions