This query accepts a place URI and returns events that took place there. The goal is both to do something that Arches currently cannot, and also to provide users with some guidance about how events relate to locations in the data model.

Introduction #

There are certain limits to Arches, as currently presented. One of them is relating places and events—at least in certain ways. In this entry, we do so, focusing on a query that begins with a place, and which returns all auction events that took place there. It also returns a more exact location (street address, etc.), if it exists.

This ought to be helpful to anyone who ever wondered, for example, what auction events too place in London? A major reason this is hard, as the data is currently constructed, is because very few events are explicitly tagged as taking place in London. Rather, they are connected to very specific resources for auction houses, addresses, and social establishments. These sub-locations do have

Query #

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT * WHERE {
  ?location crm:P89_falls_within <https://data.getty.edu/provenance/328a2a56-2ccb-3ab1-96ea-28c25e07afe8> .
  ?location rdfs:label ?location_label .
  ?activity crm:P7_took_place_at ?location .
  ?activity rdfs:label ?activity_label .
  ?activity a crm:E7_Activity .
  ?activity crm:P2_has_type <http://vocab.getty.edu/aat/300054751> .
} LIMIT 1000

Commentary #

• Line 1: