SparqlQueriesPerspective4.js

export const federatedSearchSparqlQueries = {
  norse: {
    geoQuery: `
    { ?place geof:within ( <LATMIN> <LONGMIN> <LATMAX> <LONGMAX>) }
    `,
    resultQuery: `
    PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
    PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
    PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
    SELECT ?id ?prefLabel ?documentLabel ?document ?referenceLabel ?reference ?broaderTypeLabel ?broaderTypeLabel ?broaderAreaLabel ?coordinates ?lat ?long ?source WHERE { GRAPH <https://norseworld.nordiska.uu.se> {
    <QUERY>
    ?place crm:P1_is_identified_by ?id .
    ?id rdfs:label ?prefLabel .
  
    
    ?place wgs:lat ?lat;
      wgs:long ?long ;
      <https://norseworld.nordiska.uu.se/Type_of_locality> ?broaderTypeLabel .

      BIND(?place as ?coordinates)
      BIND("Norseworld" AS ?source)

      OPTIONAL {
        ?place crm:P70i_is_documented_in ?document .
        ?document rdfs:label ?documentLabel .
      }

      OPTIONAL {
        ?place crm:P67i_is_referred_to_by ?reference .
        ?reference rdfs:label ?referenceLabel .
      }
  }
}
    `
  },
  saga: {
    geoQuery: `{ ?id geof:within ( <LATMIN> <LONGMIN> <LATMAX> <LONGMAX>) }`,
    resultQuery: `
        PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
        PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
        PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
        PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
        SELECT ?id ?prefLabel ?broaderType ?broaderTypeLabel ?broaderAreaLabel ?lat ?long ?coordinates ?source WHERE {GRAPH <https://sagamap.is/graphs/> {
        <QUERY>
        ?id rdfs:label ?prefLabel .
        ?id crm:P2_has_type ?broaderType .
        ?broaderType rdfs:label ?broaderTypeLabel .
        
        ?id crm:P89_falls_within/rdfs:label ?broaderAreaLabel ;
            wgs:lat ?lat;
            wgs:long ?long .

        BIND("Sagamap" AS ?source)
    }}
    `
  },
  nsdb: {
    geoQuery: `{ ?coordinates geof:within ( <LATMIN> <LONGMIN> <LATMAX> <LONGMAX>) .
                 ?place crm:P189i_is_approximated_by ?coordinates .}`,
    resultQuery: `
    PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
    PREFIX geof: <http://www.opengis.net/def/function/geosparql/>

      SELECT ?id ?prefLabel ?broaderType ?broaderTypeLabel ?broaderAreaLabel ?coordinates ?lat ?long ?source WHERE  { GRAPH <https://data.spraksamlingane.no/stadnamn/nos-hs/nsdb> {
        <QUERY>
        ?id crm:P1i_identifies ?place ;
            rdfs:label ?prefLabel .


        ?place crm:P2_has_type ?broaderType .
        GRAPH <https://data.spraksamlingane.no/stadnamn/nos-hs/sosi> {
          ?broaderType skos:prefLabel ?broaderTypeLabel .
        }

        ?place crm:P189i_is_approximated_by ?municipality .

        ?municipality rdfs:label ?municipalityLabel .
        ?municipality crm:P89_falls_within ?county .
        ?county rdfs:label ?countyLabel .
        
        BIND(CONCAT(?municipalityLabel, ", ", ?countyLabel) as ?broaderAreaLabel)

        ?place crm:P189i_is_approximated_by ?coordinates .
        ?coordinates crm:P168_place_is_defined_by ?point;
                    crm:P2_has_type ?coordinate_type .
                bind( replace( str(?point), "^[^0-9\\\\.]*([0-9\\\\.]+) .*$", "$1" ) as ?long )
                bind( replace( str(?point), "^.* ([0-9\\\\.]+)[^0-9\\\\.]*$", "$1" ) as ?lat )


      BIND("NSDB" AS ?source)
      BIND("violet" AS ?markerColor)

      }
    }
    `
  },
  tgn: {
    // Getty LOD documentation:
    // http://vocab.getty.edu/queries#Places_by_Type
    // https://groups.google.com/forum/#!topic/gettyvocablod/r4wsSJyne84
    // https://confluence.ontotext.com/display/OWLIMv54/OWLIM-SE+Full-text+Search
    // http://vocab.getty.edu/queries#Combination_Full-Text_and_Exact_String_Match
    // http://vocab.getty.edu/doc/#TGN_Place_Types
    resultQuery: `
        SELECT ?id (COALESCE(?labelEn,?labelGVP) AS ?prefLabel) ?broaderTypeLabel
          ?broaderAreaLabel ?source ?lat ?long ?markerColor
        WHERE {
            ?id luc:term "<QUERYTERM>" ;
            skos:inScheme tgn: ;
            gvp:placeTypePreferred [
              gvp:prefLabelGVP [
                xl:literalForm ?broaderTypeLabel;
                dct:language gvp_lang:en
              ]
            ];
            gvp:broaderPreferred/xl:prefLabel/xl:literalForm ?broaderAreaLabel .
          OPTIONAL {
            ?id xl:prefLabel [
              xl:literalForm ?labelEn ;
              dct:language gvp_lang:en
            ]
          }
          OPTIONAL {
            ?id gvp:prefLabelGVP [xl:literalForm ?labelGVP]
          }
          OPTIONAL {
            ?id foaf:focus ?place .
            ?place wgs:lat ?lat ;
                   wgs:long ?long .
          }
          FILTER EXISTS {
            ?id xl:prefLabel/gvp:term+?term .
            FILTER (LCASE(STR(?term))="<QUERYTERM>")
          }
          BIND("TGN" AS ?source)
          BIND("orange" AS ?markerColor)
        }
        `
  },
  kotus: {
    resultQuery: `
        PREFIX text: <http://jena.apache.org/text#>
        PREFIX spatial: <http://jena.apache.org/spatial#>
        PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
        PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
        PREFIX owl: <http://www.w3.org/2002/07/owl#>
        PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
        PREFIX gs: <http://www.opengis.net/ont/geosparql#>
        PREFIX hipla-schema: <http://ldf.fi/schema/hipla/>
        PREFIX na-schema: <http://ldf.fi/schema/kotus-names-archive/>
        PREFIX wgs84: <http://www.w3.org/2003/01/geo/wgs84_pos#>
        SELECT ?id ?prefLabel ?namesArchiveLink ?typeLabel ?broaderTypeLabel
        ?broaderAreaLabel ?source ?lat ?long ?modifier ?basicElement ?collector
        ?collectionYear ?markerColor ?positioningAccuracy
        WHERE {
          <QUERY>
          ?id skos:prefLabel ?prefLabel .
          ?id na-schema:parish ?broaderAreaLabel .
          ?id owl:sameAs ?namesArchiveLink .
          BIND("NA" AS ?source)
          BIND("violet" AS ?markerColor)
          BIND("-" AS ?missingValue)
          OPTIONAL {
            ?id a ?type .
            OPTIONAL {
              ?type skos:prefLabel ?typeLabel_ .
              ?type rdfs:subClassOf/skos:prefLabel ?broaderTypeLabel_ .
            }
          }
          BIND(COALESCE(?typeLabel_, ?missingValue) as ?typeLabel)
          BIND(COALESCE(?broaderTypeLabel_, ?missingValue) as ?broaderTypeLabel)
          OPTIONAL {
            ?id wgs84:lat ?lat .
            ?id wgs84:long ?long .
          }
          OPTIONAL { ?id na-schema:positioning_accuracy ?positioningAccuracy }
          OPTIONAL {
            ?id na-schema:place_name_modifier ?modifier ;
               na-schema:place_name_basic_element ?basicElement .
          }
          OPTIONAL { ?id na-schema:collector ?collector }
          OPTIONAL { ?id na-schema:stamp_date ?collectionYear }
        }
      `
  }
}