search

CEDAR-project / Queries

Set of queries for the CEDAR Dutch historical census dataset
MIT License
2 stars 3 forks source link

Correct errors with houses getting values for sex #2

Open albertmeronyo opened 8 years ago

albertmeronyo commented 8 years ago

Check out results with this query:

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 * FROM urn:graph:cedar-mini:release WHERE { ?obs a qb:Observation . ?obs cedar:population ?pop . ?obs sdmx-dimension:refArea ?municipality . ?obs sdmx-dimension:sex ?sex . ?obs cedar:residenceStatus http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig . ?obs cedar:houseType ?house . ?slice a qb:Slice. ?slice qb:observation ?obs. ?slice sdmx-dimension:refPeriod ?year . FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) . FILTER (?year IN (1859, 1869, 1879, 1889, 1899, 1909, 1920)) . FILTER (?sex IN (sdmx-code:sex-M, sdmx-code:sex-F)) . }

AshkanA commented 8 years ago

just had a look at the results for bewoonde schepen tijdelijk aanwezig in the dump and this issue (the need to avoid a specific filter excluding the demographic variables) results in incorrect mappings for e.g. 1879 (municipality 10004) and other years where this problem occurs.