Population in location


By datagraft_publisher

Last modification over 3 years ago -  2017-01-30 09:22:11 UTC

What is a population of locations and total number of persons employed in Human health and social work activities

Query text

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpedia-resource: <http://dbpedia.org/resource/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX claylab: <http://www.example.no/claylab/>
PREFIX age: <http://example.no/claylab/employed_persons/Age/>
PREFIX dbpprop: <http://dbpedia.org/property/>

SELECT ?title (SUM(?Number) AS ?EmployedFemales) ?TotalPopulation WHERE {

?measure claylab:Number ?Number .
?measure claylab:location ?title .
?measure dbpedia-owl:Year "2011"^^<http://www.w3.org/2001/XMLSchema#int> .
?measure claylab:involvedIn ?involvedIn .
?measure claylab:involvedIn "86-88 Human health and social work activities" .

SERVICE <http://dbpedia.org/sparql> {
?y dbpprop:name ?name .
?y dbpedia-owl:populationTotal ?TotalPopulation .
FILTER (STR(?name) = ?title)
} GROUP BY ?title ?TotalPopulation
HAVING (SUM(?Number)>200)