query-48680cd528c76cdcac15edcf9f29739e

rq turtle/ttl

SELECT MAPS/MAPS SERIES BY DATE OF PUBLICATION IN ASSECNDING ORDER SELECT DISTINCT ?map ?mapLabel ?mapDescription ?width ?width_unitLabel ?height ?height_unitLabel ?scale ?series ?seriesLabel ?publisher ?publisherLabel ?publicationDate ?placepfPublication ?placepfPublicationLabel ?depicts ?depictsLabel ?mainSubject ?mainSubjectLabel ?language ?languageLabel ?countryOfOrigin ?countryOfOriginLabel ?oclc_url ?map_url WHERE { ?map wdt:P31 wd:Q4006 . OPTIONAL {?map wdt:P953 ?map_url} . ?map wdt:P123 ?publisher ; wdt:P577 ?publicationDate ; wdt:P291 ?placepfPublication ; wdt:P921 ?mainSubject ; p:P2049 ?width_stmnode . #?map wdt:P5008 wd:Q73644758 . # CHANGE PROJECT FOCUS LIST HERE ?width_stmnode psn:P2049 ?width_valuenode . ?width_valuenode wikibase:quantityAmount ?width . ?width_valuenode wikibase:quantityUnit ?width_unit . ?map p:P2048 ?height_stmnode . ?height_stmnode psn:P2048 ?height_valuenode . ?height_valuenode wikibase:quantityAmount ?height . ?height_valuenode wikibase:quantityUnit ?height_unit . ?map wdt:P1752 ?scale ; wdt:P407 ?language ; wdt:P495 ?countryOfOrigin ; OPTIONAL {?map wdt:P243 ?oclcControlNumber } . OPTIONAL {?map wdt:P179 ?series ; wdt:P180 ?depicts } . BIND(URI(CONCAT("https://www.worldcat.org/oclc/",?oclcControlNumber)) AS ?oclc_url) #FILTER(?countryOfOrigin != wd:Q30) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }ORDER BY ASC (?publicationDate)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# SELECT MAPS/MAPS SERIES BY DATE OF PUBLICATION IN ASSECNDING ORDER
SELECT DISTINCT ?map ?mapLabel 
?mapDescription ?width ?width_unitLabel ?height ?height_unitLabel ?scale ?series ?seriesLabel
?publisher ?publisherLabel ?publicationDate ?placepfPublication 
?placepfPublicationLabel ?depicts ?depictsLabel ?mainSubject ?mainSubjectLabel ?language
?languageLabel ?countryOfOrigin ?countryOfOriginLabel ?oclc_url ?map_url
WHERE
{
 ?map wdt:P31 wd:Q4006 . 
 OPTIONAL {?map wdt:P953 ?map_url} .
 ?map wdt:P123 ?publisher ;
      wdt:P577 ?publicationDate ;
      wdt:P291 ?placepfPublication ;
      wdt:P921 ?mainSubject ;
      p:P2049 ?width_stmnode .
 #?map wdt:P5008 wd:Q73644758 . # CHANGE PROJECT FOCUS LIST HERE
 ?width_stmnode psn:P2049 ?width_valuenode .
 ?width_valuenode wikibase:quantityAmount ?width .
 ?width_valuenode wikibase:quantityUnit ?width_unit . 
 ?map p:P2048 ?height_stmnode .
 ?height_stmnode psn:P2048 ?height_valuenode .
 ?height_valuenode wikibase:quantityAmount ?height .
 ?height_valuenode wikibase:quantityUnit ?height_unit .
 ?map wdt:P1752 ?scale ;
      wdt:P407 ?language ;
      wdt:P495 ?countryOfOrigin ;
   OPTIONAL {?map wdt:P243 ?oclcControlNumber } .
   OPTIONAL {?map wdt:P179 ?series ;
                  wdt:P180 ?depicts } . 
 BIND(URI(CONCAT("https://www.worldcat.org/oclc/",?oclcControlNumber)) AS ?oclc_url)
 #FILTER(?countryOfOrigin != wd:Q30) 
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}ORDER BY ASC (?publicationDate)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v17("?countryOfOrigin"):::projected v20("?depicts"):::projected v13("?height"):::projected v11("?height_stmnode") v14("?height_unit") v12("?height_valuenode") v16("?language"):::projected v6("?mainSubject"):::projected v2("?map"):::projected v3("?map_url"):::projected v18("?oclcControlNumber") v21("?oclc_url"):::projected v5("?placepfPublication"):::projected v1("?publicationDate"):::projected v4("?publisher"):::projected v15("?scale"):::projected v19("?series"):::projected v9("?width"):::projected v7("?width_stmnode") v10("?width_unit") v8("?width_valuenode") c21(["bd:serviceParam"]):::iri c23(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q4006"]):::iri v2 --"p:direct/P31"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P953".-> v3 end v2 --"p:direct/P123"--> v4 v2 --"p:direct/P577"--> v1 v2 --"p:direct/P291"--> v5 v2 --"p:direct/P921"--> v6 v2 --"p:P2049"--> v7 v7 --"p:statement/value-normalized/P2049"--> v8 v8 --"wikibase:quantityAmount"--> v9 v8 --"wikibase:quantityUnit"--> v10 v2 --"p:P2048"--> v11 v11 --"p:statement/value-normalized/P2048"--> v12 v12 --"wikibase:quantityAmount"--> v13 v12 --"wikibase:quantityUnit"--> v14 v2 --"p:direct/P1752"--> v15 v2 --"p:direct/P407"--> v16 v2 --"p:direct/P495"--> v17 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P243".-> v18 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P179".-> v19 v2 --"p:direct/P180"--> v20 end bind0[/"concat('https://www.worldcat.org/oclc/',?oclcControlNumber)"/] v18 --o bind0 bind0 --as--o v21 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c21 --"wikibase:language"--> c23 end