Query service: Difference between revisions

From Columbia Wikibase Test
Jump to navigation Jump to search
(Added another query example)
m (Fixed typos in query added in previous edit)
Line 12: Line 12:
*** <nowiki>SELECT ?label WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> ; <http://www.w3.org/2000/01/rdf-schema#label> ?label .}</nowiki>
*** <nowiki>SELECT ?label WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/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> SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode</nowiki><br>
*** <nowiki> WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> ;  
<nowiki> WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> ;</nowiki><br>
*** <nowiki> <http://www.w3.org/2000/01/rdf-schema#label> ?label .
<nowiki> <http://www.w3.org/2000/01/rdf-schema#label> ?label .</nowiki><br>
*** <nowiki> OPTIONAL  
<nowiki> OPTIONAL</nowiki><br>
*** <nowiki> {?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P2> ?HyacinthURI .
<nowiki> {?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P2> ?HyacinthURI .</nowiki><br>
*** <nowiki> ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P4> ?LCNAFID .
<nowiki> ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P4> ?LCNAFID .</nowiki><br>
*** <nowiki> ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P5> ?MarcOrgCode .}
<nowiki> ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P5> ?MarcOrgCode .}</nowiki><br>
*** <nowiki> }
<nowiki> }</nowiki><br>
*** <nowiki> ORDER BY ?label
<nowiki> ORDER BY ?label</nowiki><br>

Revision as of 19:28, 26 May 2021

Using the query service

  • Query service lives here
  • Documentation on WbStack's query service (general)
  • 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:
    • Property: <http://cul-dlc-test.wiki.opencura.com/prop/direct/P#>
    • Item: <http://cul-dlc-test.wiki.opencura.com/entity/Q#>
  • Example queries
    • Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
      • SELECT * WHERE { ?libraryQnumber <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> . }
    • Get the labels for all library locations in the Hyacinth Locations vocabulary
      • SELECT ?label WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> ; <http://www.w3.org/2000/01/rdf-schema#label> ?label .}
    • Get labels, local Hyacinth URIs, LCNAF IDs, and MarcOrg codes for Hyacinth Locations vocabulary
      • SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode

WHERE { ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P1> <http://cul-dlc-test.wiki.opencura.com/entity/Q3> ;
<http://www.w3.org/2000/01/rdf-schema#label> ?label .
OPTIONAL
{?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P2> ?HyacinthURI .
?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P4> ?LCNAFID .
?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P5> ?MarcOrgCode .}
}
ORDER BY ?label