Query service: Difference between revisions
Jump to navigation
Jump to search
TrMendenhall (talk | contribs) (Added another query example) |
TrMendenhall (talk | contribs) 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><br> | |||
<nowiki> <http://www.w3.org/2000/01/rdf-schema#label> ?label .</nowiki><br> | |||
<nowiki> OPTIONAL</nowiki><br> | |||
<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><br> | |||
<nowiki> ?b <http://cul-dlc-test.wiki.opencura.com/prop/direct/P5> ?MarcOrgCode .}</nowiki><br> | |||
<nowiki> }</nowiki><br> | |||
<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
- SELECT ?label ?HyacinthURI ?LCNAFID ?MarcOrgCode
- Get the URIs for all library locations in the Hyacinth Locations vocabulary (Q-numbers only)
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