Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
#+ summary: Onbewoonde Huizen binnen de Kom
#+ tags:
#+ - Harmonized Tables 1859-1920
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality ?year (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-OnbewoondeHuizen> .
?obs cedar:Kom <http://lod.cedar-project.nl/vocab/cedar-Kom#BinnenKom> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod ?year .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (?year IN (1830, 1840, 1849, 1859, 1869, 1879, 1889, 1899, 1909, 1920, 1930, 1940, 1950, 1960, 1971, 1980, 1990, 2000, 2010)) .
} GROUP BY ?municipality ?year ORDER BY ?municipality