SES2_indicators_assessment_snapshot

Data table via SPARQL Published 24 Apr 2013 Last modified 10 Jul 2018
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 | 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'},)}"
"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'},)}"
"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'},)}"
"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'},)}"
"air | human | industry" "APE005" "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-8"@en <http://www.eea.europa.eu/data-and-maps/indicators/eea32-heavy-metal-hm-emissions-1/assessment-8> "2017-08-15"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': None, 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"
"air | human | industry" "APE006" "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-8"@en <http://www.eea.europa.eu/data-and-maps/indicators/eea32-persistent-organic-pollutant-pop-emissions-1/assessment-8> "2017-08-15"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': None, 'starting_date': DateTime('2008/11/30 01:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"
"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'},)}"
"agriculture | air | human" "APE008" "emissions-of-ozone-precursors-version-2"@en <http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-ozone-precursors-version-2> "P"@en "B"@en "adamsma1"@en "assessment-4"@en <http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-ozone-precursors-version-2/assessment-4> "2014-06-27"^^<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'},)}"
"air | human | industry" "APE009" "emissions-of-primary-particles-and-5"@en <http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-primary-particles-and-5> "P"@en "B"@en "adamsma1"@en "assessment-3"@en <http://www.eea.europa.eu/data-and-maps/indicators/emissions-of-primary-particles-and-5/assessment-3> "2014-06-27"^^<http://www.w3.org/2001/XMLSchema#date> "{'ending_date': DateTime('2015/07/28 00:00:00 GMT+0'), 'starting_date': DateTime('2008/11/30 02:00:00 GMT+0'), 'frequency': ({'years_freq': '1'},)}"
"air" "APE010" "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-5"@en <http://www.eea.europa.eu/data-and-maps/indicators/main-anthropogenic-air-pollutant-emissions/assessment-5> "2017-08-15"^^<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'},)}"

Received 239 rows in 0.014 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

Error when running query:

timed out


Related content

Document Actions