Skip to content
Snippets Groups Projects
SparqlQueriesHellerau.js 1.54 KiB
Newer Older
esikkala's avatar
esikkala committed
const perspectiveID = 'hellerau'

export const personPropertiesFacetResults =
`   {
esikkala's avatar
esikkala committed
      ?id skos:prefLabel ?prefLabel .
      # BIND (?prefLabel__id as ?prefLabel__prefLabel)
      # BIND(CONCAT("/${perspectiveID}/page/", REPLACE(STR(?id), "^.*\\\\/(.+)", "$1")) AS ?prefLabel__dataProviderUrl)
    }
    UNION 
    {
      ?id h-schema:home_1930/gn:name ?home1930 .
    }
    UNION
    {
      ?id h-schema:home_1937/gn:name ?home1937 .
esikkala's avatar
esikkala committed
    }
`

// # https://github.com/uber/deck.gl/blob/master/docs/layers/arc-layer.md
export const hellerauMigrationsQuery = `
  SELECT DISTINCT ?id ?person__id ?person__prefLabel ?person__dataProviderUrl
    ?from__id ?from__prefLabel ?from__lat ?from__long
    ?to__id ?to__prefLabel ?to__lat ?to__long
  WHERE {
    <FILTER>
    # Koulun nimi ennen muuttoa 1925: Schule Hellerau für Rhythmus, Musik und Körperbildung.
    # Sijainti: Hellerau-Dresden: https://www.geonames.org/2906837/hellerau.html
    BIND(<https://sws.geonames.org/2906837/> as ?from__id)
    ?person__id h-schema:home_1930|h-schema:home_1937 ?to__id ;
                    skos:prefLabel ?person__prefLabel .
    BIND(CONCAT("/${perspectiveID}/page/", REPLACE(STR(?person__id), "^.*\\\\/(.+)", "$1")) AS ?person__dataProviderUrl)
    ?from__id gn:name ?from__prefLabel ;
              wgs84:lat ?from__lat ;
              wgs84:long ?from__long .
    ?to__id gn:name ?to__prefLabel ;
            wgs84:lat ?to__lat ;
            wgs84:long ?to__long .
    BIND(IRI(CONCAT(STR(?from__id), "-", REPLACE(STR(?to__id), "https://sws.geonames.org", "--->"))) as ?id)
  }
`