PREFIX microdim: PREFIX sex: PREFIX coded_occs: PREFIX jobhoard: PREFIX xsd: SELECT ?bdec ?AVG_Height_Labourer ?AVG_Height_DayLabourer ?AVG_Height_Farmer ?AVG_Height_Shoemaker ?AVG_AllOcc_Height_Male_Age20to55 { SELECT ?bdec (AVG(?height_HISCO_99900_Male_Age20to55) as ?AVG_Height_Labourer) (AVG(?height_HISCO_99920_Male_Age20to55) as ?AVG_Height_DayLabourer) (AVG(?height_HISCO_61220_Male_Age20to55) as ?AVG_Height_Farmer) (AVG(?height_HISCO_80110_Male_Age20to55) as ?AVG_Height_Shoemaker) (AVG(?AllOcc_Height_Male_Age20to55) as ?AVG_AllOcc_Height_Male_Age20to55) WHERE { { ?microheights_individual microdim:occupation ?occupation_microheight . ?uri_mh coded_occs:URI_MH ?occupation_microheight . ?uri_mh jobhoard:hisco ?hisco . ?microheights_individual microdim:ht_cm ?height_HISCO_99900_Male_Age20to55 ; microdim:sex sex:male ; microdim:bdec ?bdec; microdim:age ?age . FILTER(?age > 19 && ?age < 56) BIND(xsd:integer(STRAFTER(STR(?hisco), "/code/hisco/")) as ?hisco_integer) FILTER(?hisco_integer = 99900) VALUES ?bdec {"1720"^^xsd:gYear "1730"^^xsd:gYear "1740"^^xsd:gYear "1750"^^xsd:gYear "1760"^^xsd:gYear "1770"^^xsd:gYear "1780"^^xsd:gYear "1790"^^xsd:gYear "1800"^^xsd:gYear "1810"^^xsd:gYear "1820"^^xsd:gYear "1830"^^xsd:gYear "1840"^^xsd:gYear "1850"^^xsd:gYear "1860"^^xsd:gYear "1870"^^xsd:gYear "1880"^^xsd:gYear "1890"^^xsd:gYear "1900"^^xsd:gYear "1910"^^xsd:gYear} } UNION{ ?microheights_individual microdim:occupation ?occupation_microheight . ?uri_mh coded_occs:URI_MH ?occupation_microheight . ?uri_mh jobhoard:hisco ?hisco . ?microheights_individual microdim:ht_cm ?height_HISCO_99920_Male_Age20to55 ; microdim:sex sex:male ; microdim:bdec ?bdec; microdim:age ?age . FILTER(?age > 19 && ?age < 56) BIND(xsd:integer(STRAFTER(STR(?hisco), "/code/hisco/")) as ?hisco_integer) FILTER(?hisco_integer = 99920) VALUES ?bdec {"1720"^^xsd:gYear "1730"^^xsd:gYear "1740"^^xsd:gYear "1750"^^xsd:gYear "1760"^^xsd:gYear "1770"^^xsd:gYear "1780"^^xsd:gYear "1790"^^xsd:gYear "1800"^^xsd:gYear "1810"^^xsd:gYear "1820"^^xsd:gYear "1830"^^xsd:gYear "1840"^^xsd:gYear "1850"^^xsd:gYear "1860"^^xsd:gYear "1870"^^xsd:gYear "1880"^^xsd:gYear "1890"^^xsd:gYear "1900"^^xsd:gYear "1910"^^xsd:gYear} } UNION{ ?microheights_individual microdim:occupation ?occupation_microheight . ?uri_mh coded_occs:URI_MH ?occupation_microheight . ?uri_mh jobhoard:hisco ?hisco . ?microheights_individual microdim:ht_cm ?height_HISCO_61220_Male_Age20to55 ; microdim:sex sex:male ; microdim:bdec ?bdec; microdim:age ?age . FILTER(?age > 19 && ?age < 56) #FILTER_AGE OPTIE 3: voor selectie 20-55 BIND(xsd:integer(STRAFTER(STR(?hisco), "/code/hisco/")) as ?hisco_integer) FILTER(?hisco_integer = 61220) VALUES ?bdec {"1720"^^xsd:gYear "1730"^^xsd:gYear "1740"^^xsd:gYear "1750"^^xsd:gYear "1760"^^xsd:gYear "1770"^^xsd:gYear "1780"^^xsd:gYear "1790"^^xsd:gYear "1800"^^xsd:gYear "1810"^^xsd:gYear "1820"^^xsd:gYear "1830"^^xsd:gYear "1840"^^xsd:gYear "1850"^^xsd:gYear "1860"^^xsd:gYear "1870"^^xsd:gYear "1880"^^xsd:gYear "1890"^^xsd:gYear "1900"^^xsd:gYear "1910"^^xsd:gYear} } UNION{ ?microheights_individual microdim:occupation ?occupation_microheight . ?uri_mh coded_occs:URI_MH ?occupation_microheight . ?uri_mh jobhoard:hisco ?hisco . ?microheights_individual microdim:ht_cm ?height_HISCO_80110_Male_Age20to55 ; microdim:sex sex:male ; microdim:bdec ?bdec; microdim:age ?age . FILTER(?age > 19 && ?age < 56) BIND(xsd:integer(STRAFTER(STR(?hisco), "/code/hisco/")) as ?hisco_integer) FILTER(?hisco_integer = 80110) VALUES ?bdec {"1720"^^xsd:gYear "1730"^^xsd:gYear "1740"^^xsd:gYear "1750"^^xsd:gYear "1760"^^xsd:gYear "1770"^^xsd:gYear "1780"^^xsd:gYear "1790"^^xsd:gYear "1800"^^xsd:gYear "1810"^^xsd:gYear "1820"^^xsd:gYear "1830"^^xsd:gYear "1840"^^xsd:gYear "1850"^^xsd:gYear "1860"^^xsd:gYear "1870"^^xsd:gYear "1880"^^xsd:gYear "1890"^^xsd:gYear "1900"^^xsd:gYear "1910"^^xsd:gYear} } UNION{ ?microheights_individual microdim:occupation ?occupation_microheight. ?microheights_individual microdim:ht_cm ?AllOcc_Height_Male_Age20to55 ; microdim:sex sex:male ; microdim:bdec ?bdec; microdim:age ?age . FILTER(?age > 19 && ?age < 56). VALUES ?bdec {"1720"^^xsd:gYear "1730"^^xsd:gYear "1740"^^xsd:gYear "1750"^^xsd:gYear "1760"^^xsd:gYear "1770"^^xsd:gYear "1780"^^xsd:gYear "1790"^^xsd:gYear "1800"^^xsd:gYear "1810"^^xsd:gYear "1820"^^xsd:gYear "1830"^^xsd:gYear "1840"^^xsd:gYear "1850"^^xsd:gYear "1860"^^xsd:gYear "1870"^^xsd:gYear "1880"^^xsd:gYear "1890"^^xsd:gYear "1900"^^xsd:gYear "1910"^^xsd:gYear} } }} ORDER BY ASC (?bdec)

DS-Q-6

API

Variables