Hi Eric,
This should work, although others with more SPARQL experience may have
suggestions on how to simplify it:
SELECT ?personLabel ?archivesAtLabel ?describedAt WHERE {
> ?person wdt:P106 wd:Q49757;
> wdt:P135 wd:Q213457;
> p:P485 ?archivesStatement.
> ?archivesStatement ps:P485 ?archivesAt;
> pq:P973 ?describedAt.
> SERVICE wikibase:label { bd:serviceParam wikibase:language
> "[AUTO_LANGUAGE],en". }
> }
> ORDER BY (?personLabel)
Try it! ↗ <https://w.wiki/4w2G>
My understanding is that you need to retrieve the entire statement for P485
(?archivesStatement) using p: instead of wdt:, and *then* retrieve the
value and the qualifier (using pq:).
If you want to retrieve even those poets without a P973 qualifier for P485,
you can add an "optional" wrapper around the P973 line (link
<https://w.wiki/4w2J>).
Hope this helps!
Karly
On Wed, Mar 9, 2022 at 9:07 AM Eric Lease Morgan <emor...@nd.edu> wrote:
> How can I write a WikiData SPARQL query to return the URLs of a special
> collection?
>
> I have the following query:
>
> SELECT ?personLabel ?archivesatLabel WHERE {
> ?person wdt:P106 wd:Q49757;
> wdt:P135 wd:Q213457;
> wdt:P485 ?archivesat.
> SERVICE wikibase:label { bd:serviceParam wikibase:language
> "[AUTO_LANGUAGE],en". }
> }
> ORDER BY (?person)
>
> The query finds people who are beatnik poets and have archival
> collections. The query outputs a little table such as this:
>
> personLabel archivesatLabel
> Ira Cohen Beinecke Rare
> Tuli Kupferberg Fales Library
> Michael McClure University of Victoria
> Jack Kerouac Harry Ransom Center
> Jack Kerouac University of Victoria
> Jack Kerouac Stuart A. Rose Manuscript
> John Wieners University of Delaware
>
> This is nice, but some of the artchivesat properties also point to URL's
> where the archives are described in greater detail. See, for example, the
> "record" for Ed Dorn:
>
> https://www.wikidata.org/wiki/Q5334756
>
> I want these URL's returned in my query, and the result would look
> something like this:
>
> personLabel archivesatLabel describedat
> Ira Cohen Beinecke Rare http://foobfhdhar.edu/
> Tuli Kupferberg Fales Library http://fafdsasdfobar.edu/
> Michael McClure University of Victoria http://foasdfar.edu/
> Jack Kerouac Harry Ransom Center http://fossbar.edu/
> Jack Kerouac University of Victoria http://foobasr.edu/
> Jack Kerouac Stuart A. Rose Manuscript http://foobar.edu/
> John Wieners University of Delaware http://fasdoobar.edu/
>
> But the following does NOT work:
>
> SELECT ?personLabel ?archivesatLabel ?describedat WHERE {
> ?person wdt:P106 wd:Q49757;
> wdt:P135 wd:Q213457;
> wdt:P485 ?archivesat;
> wdt:P973 ?describedat.
> SERVICE wikibase:label { bd:serviceParam wikibase:language
> "[AUTO_LANGUAGE],en". }
> }
> ORDER BY (?person)
>
>
> What am I doing wrong? Do I need an additional prefix? How can I get the
> URLs associated with describedat to be included in the output?
>
> --
> Eric Morgan
> University of Notre Dame
>
