earthcube/geodexui

Sparql mismatch

Closed this issue · 1 comments

valentinedwv commented

`PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
prefix schema: http://schema.org/
prefix sschema: https://schema.org/
SELECT distinct ?subj ?g ?pubname (GROUP_CONCAT(DISTINCT ?placename; SEPARATOR=", ") AS ?placenames)
(GROUP_CONCAT(DISTINCT ?kwu; SEPARATOR=", ") AS ?kw)
?datep (MIN(?url) as ?disurl) ?score ?name ?description ?resourceType ?urlContent ?dis
WHERE {
?lit bds:search "${q}" .
?lit bds:matchAllTerms "false" .
?lit bds:relevance ?score .
?subj ?p ?lit .

      VALUES (?dataset) { ( schema:Dataset ) ( sschema:Dataset ) }
        BIND ( IF ( exists { ?subj a ?dataset .}, "data", "tool")  AS ?resourceType ).

        graph ?g { ?subj schema:description|sschema:description ?description . }
        filter( ?score > 0.04).
        OPTIONAL { ?subj schema:name ?name .
                  ?subj schema:datePublished ?datep .
                  ?subj schema:publisher/schema:name ?pubname .
                ?subj schema:spatialCoverage/schema:name ?placename .
                ?subj schema:keywords ?kwu .
             ?s schema:distribution|sschema:distribution ?dis .
            ?dis schema:contentUrl |sschema:contentUrl  ?urlContent .
            ?subj schema:distribution/schema:url|schema:subjectOf/schema:url ?url .
              }


    }
    GROUP BY ?subj ?g ?datep ?pubname ?name ?description ?url ?score ?resourceType ?urlContent ?dis
    ORDER BY DESC(?score)
    LIMIT ${n}
    OFFSET ${o}`