datahub sparql

gistfile1.txt

PREFIX DataFileLink: <http://www.eea.europa.eu/portal_types/DataFileLink#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX data: <http://www.eea.europa.eu/portal_types/Data#>

SELECT 
?data
?id
?remoteUrl
min(xsd:integer(?temporalCoverage)) AS ?minYear
max(xsd:integer(?temporalCoverage)) AS ?maxYear

WHERE {
  ?DataFileLink a DataFileLink:DataFileLink .
  ?DataFileLink dcterms:title ?title . 
  ?DataFileLink DataFileLink:remoteUrl ?remoteUrl .
  ?dataTable dcterms:hasPart ?DataFileLink .
  ?data dcterms:hasPart ?dataTable .
  ?data data:id ?id .
  ?data data:temporalCoverage ?temporalCoverage .
  FILTER NOT EXISTS { ?data dcterms:isReplacedBy ?isReplacedBy }
  FILTER(strEnds(str(?remoteUrl), "download"))
}
ORDER BY ?id