Query service: Difference between revisions
Jump to navigation
Jump to search
TrMendenhall (talk | contribs) (Updated page to reflect migration from WBStack to wikibase.cloud) |
TrMendenhall (talk | contribs) (Fixed error -- wikibase.cloud uses https, whereas WBStack used http) |
||
| 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>< | ** Property: <nowiki><https://cul-dlc-test.wikibase.cloud/prop/direct/P#></nowiki> | ||
** Item: <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 < | *** <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 < | *** <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 < | <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</nowiki><br> | ||
<nowiki> {?b < | <nowiki> {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P2> ?HyacinthURI .</nowiki><br> | ||
<nowiki> ?b < | <nowiki> ?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P4> ?LCNAFID .</nowiki><br> | ||
<nowiki> ?b < | <nowiki> ?b <https://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> | ||
Revision as of 18:36, 21 December 2022
Using the query service
- Query service lives here
- General documentation on WbStack's query service has not been migrated to wikibase.cloud
- 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: <https://cul-dlc-test.wikibase.cloud/prop/direct/P#>
- Item: <https://cul-dlc-test.wikibase.cloud/entity/Q#>
- Example queries
- Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
- SELECT * WHERE { ?libraryQnumber <https://cul-dlc-test.wikibase.cloud/prop/direct/P1> <https://cul-dlc-test.wikibase.cloud/entity/Q3> . }
- Get the labels for all library locations in the Hyacinth Locations vocabulary
- 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 .}
- Get labels, local Hyacinth URIs, LCNAF IDs, and MarcOrg codes for Hyacinth Locations vocabulary
- SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode
- SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode
- Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
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 .
OPTIONAL
{?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P2> ?HyacinthURI .
?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P4> ?LCNAFID .
?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P5> ?MarcOrgCode .}
}
ORDER BY ?label