Query service: Difference between revisions
Jump to navigation
Jump to search
TrMendenhall (talk | contribs) (Fixed error -- wikibase.cloud uses https, whereas WBStack used http) |
TrMendenhall (talk | contribs) (Fixed an error in one of the SPARQL queries) |
||
Line 15: | Line 15: | ||
<nowiki> WHERE { ?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P1> <https://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> OPTIONAL {?b <https://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 <https://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 <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> |
Latest revision as of 19:50, 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 .}
OPTIONAL {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P4> ?LCNAFID .}
OPTIONAL {?b <https://cul-dlc-test.wikibase.cloud/prop/direct/P5> ?MarcOrgCode .}
}
ORDER BY ?label