-
Notifications
You must be signed in to change notification settings - Fork 2
/
hdng_metalworkers.rq
32 lines (25 loc) · 1.33 KB
/
hdng_metalworkers.rq
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX hdng: <https://iisg.amsterdam/hdng/>
PREFIX hdngv: <https://iisg.amsterdam/hdng/vocab/>
PREFIX hdngvar: <https://iisg.amsterdam/hdng/variable/>
PREFIX gg: <http://www.gemeentegeschiedenis.nl/gg-schema#>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
SELECT ?gemeente ?gg_gemeente ?metal_workers ?population ?share_metal_workers ?wkt ?wktColor ?wktTooltip WHERE {
?gemeente a hdng:gemeente ;
schema:hasObservation ?observation .
?observation hdngvar:MED1 ?metal_workers .
?observation hdngvar:BEV1 ?population .
?observation hdngv:year "1889"^^<http://www.w3.org/2001/XMLSchema#gYear> .
?gemeente gg:amsterdamCode/gg:identifies ?gg_gemeente .
?gg_gemeente geo:hasGeometry/geo:asWKT ?wkt .
FILTER(?metal_workers > 0)
FILTER(?population > 0)
BIND((xsd:float(?metal_workers / xsd:float(?population)*100 ) ) as ?share_metal_workers)
BIND(concat('viridis,', str((?share_metal_workers +2) /19)) as ?wktColor)
BIND(concat(xsd:integer(?share_metal_workers),'%','_', STRAFTER(STR(?gemeente), 'gemeente/')) as ?wktTooltip)
FILTER(?share_metal_workers > 2)
}