SES2 indicators data snapshot

Data table via SPARQL Published 24 Apr 2013 Last modified 18 Sep 2018
The query is looking for all the "Data" obejects used in the last version of the indicator specifications - used for periodical reporting to smt.

Download this dataset

Dataset preview

(Live Query)

codes d_label d_owner d_geographicCoverage d_temporalCoverage d
"AIR002" "National emissions reported to the Convention on Long-range Transboundary Air Pollution (LRTAP Convention)"@en "http://www.unece.org/env" "al at ba be bg ch cy cz de dk ee es fi fr gb gr hr hu ie is it li lt lu lv me mk mt nl no pl pt ro rs se si sk tr" "1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009" <http://www.eea.europa.eu/data-and-maps/data/national-emissions-reported-to-the-convention-on-long-range-transboundary-air-pollution-lrtap-convention-5>
"AIR003" "Air Quality e-Reporting (AQ e-Reporting)"@en "http://ec.europa.eu/index_en.htm" "" "2013" <http://www.eea.europa.eu/data-and-maps/data/aqereporting>
"AIR003" "AirBase - The European air quality database"@en "http://www.eea.europa.eu" "ad al at ba be bg ch cy cz de dk ee es fi fr gb gr hr hu ie is it li lt lu lv me mk mt nl no pl pt ro rs se si sk tr" "1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012" <http://www.eea.europa.eu/data-and-maps/data/airbase-the-european-air-quality-database-8>
"AIR004" "AirBase - The European air quality database"@en "http://www.eea.europa.eu" "ad al at ba be bg ch cy cz de dk ee es fi fr gb gr hr hu ie is it li lt lu lv me mk mt nl no pl pt ro rs se si sk tr" "1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012" <http://www.eea.europa.eu/data-and-maps/data/airbase-the-european-air-quality-database-8>
"AIR004" "Air Quality e-Reporting (AQ e-Reporting)"@en "http://ec.europa.eu/index_en.htm" "" "" <http://www.eea.europa.eu/data-and-maps/data/aqereporting-8>
"AIR004" "Interpolated air quality data"@en "http://www.eea.europa.eu" "ad al at ba be bg ch cy cz de dk ee es fi fr gb gr hr hu ie is it li lt lu lv mc me mk mt nl no pl pt ro rs se si sk sm xk" "2006 2007 2008 2009 2010" <http://www.eea.europa.eu/data-and-maps/data/interpolated-air-quality-data-2>
"AIR004" "Corine Land Cover 2006 raster data"@en "http://www.eea.europa.eu" "al at ba be bg ch cy cz de dk ee es fi fr gb hr hu ie is it li lt lu lv me mk mt nl no pl pt ro rs se si sk tr" "2006" <http://www.eea.europa.eu/data-and-maps/data/clc-2006-raster-3>
"AIR005" "National Emission Ceilings (NEC) Directive Inventory"@en "http://ec.europa.eu/dgs/environment/index_en.htm" "at be bg cy cz de dk ee es fi fr gb gr hu ie it lt lu lv mt nl pl pt ro se si sk" "1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012" <http://www.eea.europa.eu/data-and-maps/data/national-emission-ceilings-nec-directive-inventory-10>
"AIR005" "National emissions reported to the Convention on Long-range Transboundary Air Pollution (LRTAP Convention)"@en "http://www.unece.org/env" "al at ba be bg ch cy cz de dk ee es fi fr gb gr hr hu ie is it li lt lu lv me mk mt nl no pl pt ro rs se si sk tr" "1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009" <http://www.eea.europa.eu/data-and-maps/data/national-emissions-reported-to-the-convention-on-long-range-transboundary-air-pollution-lrtap-convention-5>
"APE001" "National Emission Ceilings (NEC) Directive Inventory"@en "http://ec.europa.eu/dgs/environment/index_en.htm" "at be bg cy cz de dk ee es fi fr gb gr hu ie it lt lu lv mt nl pl pt ro se si sk" "1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009" <http://www.eea.europa.eu/data-and-maps/data/national-emission-ceilings-nec-directive-inventory-6>

Received 185 rows in 0.009 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/ses2_indicators_data_snapshot/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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dcterms: <http://purl.org/dc/terms/> 
PREFIX rdf-syntax: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX s: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX d: <http://www.eea.europa.eu/portal_types/Data#>

SELECT
?codes
?d_label
?d_owner
sql:group_concat(?d_geographicCoverage,' ') AS ?d_geographicCoverage
?d_temporalCoverage
?d
{{
  SELECT 
  ?codes
  ?d_label
  ?d_owner
  sql:group_concat(?d_temporalCoverage,' ') AS ?d_temporalCoverage
  ?d_geographicCoverage
  ?d
  {{
  SELECT DISTINCT
    ?codes
    ?d_label
    ?d_owner
    ?d_temporalCoverage
    ?d_geographicCoverage
    ?d
  WHERE {
        ?s rdf-syntax:type s:Specification .
        ?s s:codes ?codes .
	OPTIONAL { ?s dcterms:isReplacedBy ?isReplacedBy . }   FILTER (!bound(?isReplacedBy)) 
	?s s:relatedItems ?d .
	OPTIONAL { ?d rdf-syntax:type ?d_type } FILTER (?d_type = d:Data)
	OPTIONAL { ?d rdfs:label ?d_label }
	OPTIONAL { ?d d:dataOwner ?d_owner }
	OPTIONAL { ?d d:temporalCoverage ?d_temporalCoverage }  
	OPTIONAL { ?d d:geographicCoverage ?d_geographicCoverage  }
	} ORDER BY ?d_temporalCoverage
  }} GROUP BY ?d ?codes ?d_label ?d_owner ?d_geographicCoverage ORDER BY ?d_geographicCoverage
}} 
GROUP BY ?d ?codes ?d_label ?d_owner ?d_temporalCoverage 
ORDER BY ?codes


Document Actions