query-f13addfa9c682989e973641e85366f0c

rq turtle/ttl

All NFDI associated organisationssace as csv for direct import in umap. Before that: change header column "placeLabel" to "name" and "placeDescription" to "description"

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?placeLabel ?placeDescription ?lat ?long {
    {
     ?place wdt:P463 wd:Q105757481 .
   } UNION {
     ?p wdt:P31 wd:Q98270496 .
     ?p wdt:P1416 ?place .
   } 
   ?place p:P625 ?coords_sample .
  {
    SELECT (SAMPLE(?coords_stmt) AS ?coords_sample) {
      {
        ?place wdt:P463 wd:Q105757481 .
      } UNION {
        ?p wdt:P31 wd:Q98270496 .
        ?p wdt:P1416 ?place .
      }
      ?place p:P625 ?coords_stmt .
    } GROUP BY ?place
  }
  ?coords_sample ps:P625 ?coords;
                 psv:P625 [
                   wikibase:geoLatitude ?lat;
                   wikibase:geoLongitude ?long
                 ] .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
}
ORDER BY ?placeLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?coords") v6("?coords_sample") v5("?coords_stmt") v7("?lat"):::projected v8("?long"):::projected v3("?p") v2("?place") v1("?placeLabel"):::projected a1((" ")) c2(["wd:Q105757481"]):::iri c12(["bd:serviceParam"]):::iri c14(["de,en"]):::literal c4(["wd:Q98270496"]):::iri subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P31"--> c4 v3 --"p:direct/P1416"--> v2 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P463"--> c2 end union0r <== or ==> union0l end v2 --"p:P625"--> v6 subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P31"--> c4 v3 --"p:direct/P1416"--> v2 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P463"--> c2 end union1r <== or ==> union1l end v2 --"p:P625"--> v5 bind1[/"sample(?coords_stmt)"/] v5 --o bind1 bind1 --as--o v6 v6 --"p:statement/P625"--> v6 a1 --"wikibase:geoLatitude"--> v7 a1 --"wikibase:geoLongitude"--> v8 v6 --"p:statement/value/P625"--> a1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end