Columbia Wikibase Test

Query service: Difference between revisions

Page Discussion

Query service (view source)

Revision as of 19:50, 21 December 2022

11 bytes added ,  1 year ago
Fixed an error in one of the SPARQL queries
(Updated page to reflect migration from WBStack to wikibase.cloud)
(Fixed an error in one of the SPARQL queries)
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
* Queries are made in SPARQL
* Queries are made in SPARQL
* Note that you cannot use the standard Wikidata prefixes when constructing your query.  Instead, fill in the P# and Q# in the following:
* Note that you cannot use the standard Wikidata prefixes when constructing your query.  Instead, fill in the P# and Q# in the following:
** Property: <nowiki><http://cul-dlc-test.wikibase.cloud/prop/direct/P#></nowiki>
** Property: <nowiki><https://cul-dlc-test.wikibase.cloud/prop/direct/P#></nowiki>
** Item: <nowiki><http://cul-dlc-test.wikibase.cloud/entity/Q#></nowiki>
** Item: <nowiki><https://cul-dlc-test.wikibase.cloud/entity/Q#></nowiki>
* Example queries
* Example queries
** Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
** Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
*** <nowiki>SELECT * WHERE { ?libraryQnumber <http://cul-dlc-test.wikibase.cloud/prop/direct/P1> <http://cul-dlc-test.wikibase.cloud/entity/Q3> . }</nowiki>
*** <nowiki>SELECT * WHERE { ?libraryQnumber <https://cul-dlc-test.wikibase.cloud/prop/direct/P1> <https://cul-dlc-test.wikibase.cloud/entity/Q3> . }</nowiki>
** Get the labels for all library locations in the Hyacinth Locations vocabulary
** Get the labels for all library locations in the Hyacinth Locations vocabulary
*** <nowiki>SELECT ?label WHERE { ?b <http://cul-dlc-test.wikibase.cloud/prop/direct/P1> <http://cul-dlc-test.wikibase.cloud/entity/Q3> ; <http://www.w3.org/2000/01/rdf-schema#label> ?label .}</nowiki>
*** <nowiki>SELECT ?label WHERE { ?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P1> <https://cul-dlc-test.wikibase.cloud/entity/Q3> ; <http://www.w3.org/2000/01/rdf-schema#label> ?label .}</nowiki>
** Get labels, local Hyacinth URIs, LCNAF IDs, and MarcOrg codes for Hyacinth Locations vocabulary
** Get labels, local Hyacinth URIs, LCNAF IDs, and MarcOrg codes for Hyacinth Locations vocabulary
*** <nowiki> SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode</nowiki><br>
*** <nowiki> SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode</nowiki><br>
<nowiki> WHERE { ?b <http://cul-dlc-test.wikibase.cloud/prop/direct/P1> <http://cul-dlc-test.wikibase.cloud/entity/Q3> ;</nowiki><br>
<nowiki> WHERE { ?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P1> <https://cul-dlc-test.wikibase.cloud/entity/Q3> ;</nowiki><br>
<nowiki> <http://www.w3.org/2000/01/rdf-schema#label> ?label .</nowiki><br>
<nowiki> <http://www.w3.org/2000/01/rdf-schema#label> ?label .</nowiki><br>
<nowiki> OPTIONAL</nowiki><br>
<nowiki> OPTIONAL {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P2> ?HyacinthURI .}</nowiki><br>
<nowiki> {?b <http://cul-dlc-test.wikibase.cloud/prop/direct/P2> ?HyacinthURI .</nowiki><br>
<nowiki> OPTIONAL {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P4> ?LCNAFID .}</nowiki><br>
<nowiki> ?b <http://cul-dlc-test.wikibase.cloud/prop/direct/P4> ?LCNAFID .</nowiki><br>
<nowiki> OPTIONAL {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P5> ?MarcOrgCode .}</nowiki><br>
<nowiki> ?b <http://cul-dlc-test.wikibase.cloud/prop/direct/P5> ?MarcOrgCode .}</nowiki><br>
<nowiki> }</nowiki><br>
<nowiki> }</nowiki><br>
<nowiki> ORDER BY ?label</nowiki><br>
<nowiki> ORDER BY ?label</nowiki><br>
Retrieved from "https://cul-dlc-test.wikibase.cloud/wiki/Special:MobileDiff/987...997"