-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathdump.rq
23 lines (20 loc) · 1023 Bytes
/
dump.rq
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#+ summary: Dump of all observations and variables of the database
PREFIX cedar: <http://lod.cedar-project.nl:8888/cedar/resource/>
PREFIX maritalstatus: <http://lod.cedar-project.nl/vocab/cedar-maritalstatus#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX cedarterms: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX qb: <http://purl.org/linked-data/cube#>
SELECT DISTINCT ?obs ?location ?kom ?pop ?year ?residenceStatus ?sex ?istotal ?houseType FROM <urn:graph:cedar-mini:release> WHERE {
?obs a qb:Observation.
?obs sdmx-dimension:refArea ?location.
?obs cedarterms:population ?pop.
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod ?year.
OPTIONAL {?obs cedarterms:residenceStatus ?residenceStatus.}
OPTIONAL {?obs sdmx-dimension:sex ?sex.}
OPTIONAL {?obs cedarterms:Kom ?kom.}
OPTIONAL {?obs cedarterms:isTotal ?istotal.}
OPTIONAL {?obs cedarterms:houseType ?houseType.}
}