Municipality Change Events

All events since 1960

Query

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX gont: <https://gont.ch/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX ech71: <http://classifications.data.admin.ch/code/ech0071/> SELECT ?parent ?parent_name ?child ?child_name ?abmode ?admode WHERE { ?event a gont:MunicipalityChangeEvent ; gont:id ?eventid ; gont:date ?eventdate . ?parent a gont:MunicipalityVersion ; gont:shortName ?parent_name ; gont:abolitionMode ?abmode ; gont:abolitionEvent ?event . ?child a gont:MunicipalityVersion ; gont:shortName ?_child_name ; gont:admissionMode ?admode ; gont:admissionEvent ?event . FILTER(?admode IN (ech71:20, ech71:21, ech71:23, ech71:24, ech71:26)). FILTER(?abmode IN (ech71:24, ech71:26, ech71:29, ech71:23)). BIND (CONCAT(?_child_name, ' (', str(year(?eventdate)),')') AS ?child_name). } ORDER BY ?eventid