query-eaf43e103172f411fe940be4c243c782

rq turtle/ttl

Mappa dei luoghi di nascita degli autori di libri in Wikidata con SHARE id

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 p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
SELECT ?book ?bookLabel ?authorLabel ?SHAREid ?birthplaceLabel ?coord ?lat ?lon

WHERE {

  ?book wdt:P31 wd:Q571 .
  ?book wdt:P50 ?author .
  ?author wdt:P19 ?birthplace .
  ?author wdt:P3987 ?SHAREid .
  OPTIONAL {?birthplace wdt:P625 ?coord. }
   OPTIONAL {
    ?birthplace p:P625 ?statement.
    ?statement psv:P625 ?node.
    ?node wikibase:geoLatitude ?lat.
    ?node wikibase:geoLongitude ?lon.
   }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 2000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?SHAREid"):::projected v2("?author") v3("?birthplace") v1("?book"):::projected v5("?coord"):::projected v8("?lat"):::projected v9("?lon"):::projected v7("?node") v6("?statement") c12(["bd:serviceParam"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q571"]):::iri v1 --"p:direct/P31"--> c2 v1 --"p:direct/P50"--> v2 v2 --"p:direct/P19"--> v3 v2 --"p:direct/P3987"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P625".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:P625".-> v6 v6 --"p:statement/value/P625"--> v7 v7 --"wikibase:geoLatitude"--> v8 v7 --"wikibase:geoLongitude"--> v9 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end