PREFIX rdf: PREFIX rdfs: PREFIX microdim: PREFIX microheights: PREFIX xsd: PREFIX Sex: PREFIX Country: PREFIX DatasetType: PREFIX geo: PREFIX bif: select ?wkt ?cor ?iso_height ?country_cshapes ?countrydate ?observations ?wktTooltip ?wktColor { { select ?wkt ?countrydate ?iso_height ?cor ?country_cshapes (avg(?height) as ?avg_height) { { ?sub microdim:sample_type ?DatasetType ; microdim:byear ?Birthyear ; microdim:sex ?Gender ; microdim:ht_cm ?height ; microdim:age ?AgeOfIndividual; microdim:countryOfResidence ?CoR; microdim:countryOfBirth ?CountryOfBirth . VALUES ?CountryOfBirth {Country:de} ?CountryOfBirth microdim:isoAlpha2 ?iso_height . ?country_cshapes ?iso_cshapes . ?country_cshapes ?countrydate . ?country_cshapes geo:hasGeometry / geo:asWKT ?wkt . BIND(STR(?iso_cshapes) as ?iso_cshapes2). FILTER(REGEX(?iso_height, "[A-Z]")). FILTER(?iso_height = ?iso_cshapes2). FILTER (?countrydate > "2000-01-01"^^xsd:date). } UNION { ?sub microdim:sample_type ?DatasetType ; microdim:byear ?Birthyear ; microdim:sex ?Gender ; microdim:ht_cm ?height ; microdim:age ?AgeOfIndividual; microdim:countryOfResidence ?CoR; microdim:countryOfBirth ?CountryOfBirth . VALUES ?CountryOfBirth {Country:in} ?CountryOfBirth microdim:isoAlpha2 ?iso_height . ?country_cshapes ?iso_cshapes . ?country_cshapes ?countrydate . ?country_cshapes geo:hasGeometry / geo:asWKT ?wkt . BIND(STR(?iso_cshapes) as ?iso_cshapes2). FILTER(REGEX(?iso_height, "[A-Z]")). FILTER(?iso_height = ?iso_cshapes2). FILTER (?countrydate > "2000-01-01"^^xsd:date). } UNION { ?sub microdim:sample_type ?DatasetType ; microdim:byear ?Birthyear ; microdim:sex ?Gender ; microdim:ht_cm ?height ; microdim:age ?AgeOfIndividual; microdim:countryOfResidence ?CoR; microdim:countryOfBirth ?CountryOfBirth . VALUES ?CountryOfBirth {Country:ph} ?CountryOfBirth microdim:isoAlpha2 ?iso_height . ?country_cshapes ?iso_cshapes . ?country_cshapes ?countrydate . ?country_cshapes geo:hasGeometry / geo:asWKT ?wkt . BIND(STR(?iso_cshapes) as ?iso_cshapes2). FILTER(REGEX(?iso_height, "[A-Z]")). FILTER(?iso_height = ?iso_cshapes2). FILTER (?countrydate > "2000-01-01"^^xsd:date). } UNION { ?sub microdim:sample_type ?DatasetType ; microdim:byear ?Birthyear ; microdim:sex ?Gender ; microdim:ht_cm ?height ; microdim:age ?AgeOfIndividual; microdim:countryOfResidence ?CoR; microdim:countryOfBirth ?CountryOfBirth . VALUES ?CountryOfBirth {Country:pk} ?CountryOfBirth microdim:isoAlpha2 ?iso_height . ?country_cshapes ?iso_cshapes . ?country_cshapes ?countrydate . ?country_cshapes geo:hasGeometry / geo:asWKT ?wkt . BIND(STR(?iso_cshapes) as ?iso_cshapes2). FILTER(REGEX(?iso_height, "[A-Z]")). FILTER(?iso_height = ?iso_cshapes2). FILTER (?countrydate > "2000-01-01"^^xsd:date). } } } bind(xsd:int(?avg_height) as ?avg_height2). bind((?avg_height2) as ?wktTooltip). #bind((bif:log((?observations / 58)) / 12) as ?observations2) bind(concat('viridis,', bif:sqrt(?avg_height - 150) /6 ) as ?wktColor) . }

JettenL

The Great Divergence