next
previous
items

Data table via SPARQL

SES2_indicators_assessment_snapshot

Data table via SPARQL Published 24 Apr 2013 Last modified 12 May 2021
The query is looking for all the last issued indicator assessments - used for periodical reporting to smt.

Download this dataset

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-1"@en <http://www.eea.europa.eu/data-and-maps/indicators/eea32-heavy-metal-hm-emissions-1> "P"@en "B"@en "antogfed"@en "assessment-10"@en <http://www.eea.europa.eu/data-and-maps/indicators/eea32-heavy-metal-hm-emissions-1/assessment-10> "2019-09-04"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': None, 'starting_date': DateTime('2008/11/30 02: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-2"@en <http://www.eea.europa.eu/data-and-maps/indicators/exceedance-of-air-quality-limit-2> "S"@en "A"@en "ozturevr"@en "assessment"@en <http://www.eea.europa.eu/data-and-maps/indicators/exceedance-of-air-quality-limit-2/assessment> "2020-10-06"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': None, 'starting_date': DateTime('2005/10/10 16: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 "ozturevr"@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"@en <http://www.eea.europa.eu/data-and-maps/indicators/main-anthropogenic-air-pollutant-emissions> "P"@en "D"@en "antogfed"@en "assessment-6"@en <http://www.eea.europa.eu/data-and-maps/indicators/main-anthropogenic-air-pollutant-emissions/assessment-6> "2019-09-04"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': None, 'starting_date': DateTime('2015/02/28 05: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 270 rows in 0.015 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/ses2_indicators_assessment_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 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


Permalinks

Document Actions