Data table via SPARQL

SES2_indicators_assessment_snapshot

Data table via SPARQL Published 24 Apr 2013 Last modified 25 Jan 2023

The query is looking for all the last issued indicator assessments - used for periodical reporting to smt.

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

themes	codes	s_id	s	dpsir	typology	manager_user_id	a_id	a	a_issued	frequency_of_updates
"air \| human \| industry"	"AIR001"	"eea32-heavy-metal-hm-emissions-2"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea32-heavy-metal-hm-emissions-2>	"P"@en	"B"@en	"molnalea"@en	"assessment"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea32-heavy-metal-hm-emissions-2/assessment>	"2021-10-13"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': None, 'starting_date': DateTime('2008/11/30 04:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air \| human \| industry"	"AIR002"	"eea32-persistent-organic-pollutant-pop-emissions-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea32-persistent-organic-pollutant-pop-emissions-1>	"P"@en	"B"@en	"antogfed"@en	"assessment-10"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea32-persistent-organic-pollutant-pop-emissions-1/assessment-10>	"2019-09-04"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': None, 'starting_date': DateTime('2008/11/30 03:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air"	"AIR003"	"exceedance-of-air-quality-limit-4"@en	<http://www.eea.europa.eu/data-and-maps/indicators/exceedance-of-air-quality-limit-4>	"S"@en	"A"@en	"ortizalb"@en	"assessment"@en	<http://www.eea.europa.eu/data-and-maps/indicators/exceedance-of-air-quality-limit-4/assessment>	"2021-10-27"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': None, 'starting_date': DateTime('2005/10/10 22:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air"	"AIR004"	"exposure-of-ecosystems-to-acidification-15"@en	<http://www.eea.europa.eu/data-and-maps/indicators/exposure-of-ecosystems-to-acidification-15>	"S"@en	"B"@en	"ortizalb"@en	"assessment"@en	<http://www.eea.europa.eu/data-and-maps/indicators/exposure-of-ecosystems-to-acidification-15/assessment>	"2020-11-13"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': None, 'starting_date': DateTime('2005/11/30 08:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air"	"AIR005"	"main-anthropogenic-air-pollutant-emissions-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/main-anthropogenic-air-pollutant-emissions-1>	"P"@en	"D"@en	"molnalea"@en	"assessment"@en	<http://www.eea.europa.eu/data-and-maps/indicators/main-anthropogenic-air-pollutant-emissions-1/assessment>	"2021-10-13"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': None, 'starting_date': DateTime('2015/02/28 07:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air \| energy \| human"	"APE001"	"eea-32-sulphur-dioxide-so2-emissions-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-sulphur-dioxide-so2-emissions-1>	"P"@en	"B"@en	"adamsma1"@en	"assessment-3"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-sulphur-dioxide-so2-emissions-1/assessment-3>	"2014-01-29"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': DateTime('2015/06/16 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air \| human \| industry"	"APE002"	"eea-32-nitrogen-oxides-nox-emissions-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-nitrogen-oxides-nox-emissions-1>	"P"@en	"B"@en	"adamsma1"@en	"assessment.2010-08-19.0140149032-3"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-nitrogen-oxides-nox-emissions-1/assessment.2010-08-19.0140149032-3>	"2014-01-29"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': DateTime('2015/06/16 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"agriculture \| air \| human"	"APE003"	"eea-32-ammonia-nh3-emissions-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-ammonia-nh3-emissions-1>	"P"@en	"B"@en	"adamsma1"@en	"assessment-4"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-ammonia-nh3-emissions-1/assessment-4>	"2014-01-29"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': DateTime('2015/06/16 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"air \| human \| industry"	"APE004"	"eea-32-non-methane-volatile-1"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-non-methane-volatile-1>	"P"@en	"B"@en	"adamsma1"@en	"assessment-4"@en	<http://www.eea.europa.eu/data-and-maps/indicators/eea-32-non-methane-volatile-1/assessment-4>	"2014-01-29"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': DateTime('2015/06/16 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en
"agriculture \| air \| industry"	"APE007"	"emissions-of-acidifying-substances-version-2"@en	<http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-acidifying-substances-version-2>	"P"@en	"B"@en	"adamsma1"@en	"assessment-4"@en	<http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-acidifying-substances-version-2/assessment-4>	"2014-01-31"^^<http://www.w3.org/2001/XMLSchema#date>	"{'ending_date': DateTime('2015/07/28 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"@en

Received 275 rows in 0.026 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/ses2_indicators_assessment_snapshot/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        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 a: <http://www.eea.europa.eu/portal_types/Assessment#>

SELECT 
sql:group_concat(?themes,' | ') AS ?themes
?codes ?s_id ?s ?dpsir ?typology ?manager_user_id ?a_id ?a ?a_issued ?frequency_of_updates
{{
SELECT DISTINCT
?themes 
?codes
?s_id
?s
?dpsir
?frequency_of_updates
?typology
?manager_user_id
?a_id
?a
xsd:date(?a_issued) as ?a_issued
WHERE {
  ?s s:id ?s_id .
  ?s s:codes ?codes .
  ?s s:themes ?themes .
  ?s rdf-syntax:type ?type FILTER (?type = s:Specification)
  ?s s:dpsir ?dpsir .
  OPTIONAL { ?s s:frequency_of_updates ?frequency_of_updates . }
  OPTIONAL { ?s s:manager_user_id ?manager_user_id . }
  ?s s:typology ?typology .
  OPTIONAL { ?s dcterms:isReplacedBy ?isReplacedBy . }
  FILTER (!bound(?isReplacedBy))

  ?s dcterms:hasPart ?a .
  ?a a:id ?a_id .
  ?a rdf-syntax:type ?a_type FILTER (?a_type = a:Assessment) 
  OPTIONAL { ?a dcterms:issued ?a_issued }
  OPTIONAL { ?a dcterms:isReplacedBy ?a_isReplacedBy . }
  FILTER (!bound(?a_isReplacedBy))
} ORDER BY ?themes
}}
GROUP BY ?codes ?s_id ?s ?dpsir ?typology ?manager_user_id ?a_id ?a ?a_issued ?frequency_of_updates
ORDER BY ?codes