Skip to content

Instantly share code, notes, and snippets.

@michimau

michimau/gist:86565f6db6c93cf0c861fbab01614f62

Created May 2, 2022 07:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michimau/86565f6db6c93cf0c861fbab01614f62 to your computer and use it in GitHub Desktop.
Save michimau/86565f6db6c93cf0c861fbab01614f62 to your computer and use it in GitHub Desktop.
Download ZIP
themes Jose
Raw
gistfile1.txt
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX data: <http://www.eea.europa.eu/portal_types/Data#>
PREFIX schema: <http://schema.org/>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT DISTINCT
?data
#count(?themes) AS ?count_themes
?productID
?identifier
sql:GROUP_CONCAT_DISTINCT(?themes, ' | ') as ?themes
WHERE {
?data a data:Data .
?data rdfs:label ?dataLabel .
?data data:themes ?themes .
?data schema:productID ?productID .
?data dcterms:identifier ?identifier .
}
ORDER BY ?data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment