PREFIX xsd: PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX iisgv: PREFIX iisgv2: PREFIX gg: PREFIX geo: PREFIX bio: PREFIX bif: PREFIX hdngv: PREFIX hdngvar: SELECT DISTINCT ?amco ?population ?deceased_n ?share_deceased ?wktColor ?wktTooltip ?province ?wkt WHERE { { select ?amco ?wkt ?hdnggemeente ?population ?deceased_n (xsd:float(?deceased_n / xsd:float(?population) * 100) as ?share_deceased ) ?province { select ?amco ?wkt ?hdnggemeente ?population (count(?deceased) as ?deceased_n) ?province { { select (max(?wktyear) as ?max) ?gg_gemeente ?province { ?gg_gemeente geo:hasGeometry ?geo . ?gg_gemeente gg:inProvince ?province . ?geo gg:year ?wktyear . FILTER(?wktyear <= "1918"^^xsd:gYear) } GROUP BY ?gg_gemeente ?province } ?gg_gemeente geo:hasGeometry [gg:year ?max ; geo:asWKT ?wkt ] . ?death a bio:Death . ?death iisgv:deceased ?deceased . ?death bio:date ?death_date . ?death iisgv:event_location ?gemeente . ?gemeente gg:amsterdamCode ?amco . ?amco ^gg:amsterdamCode ?gg_gemeente . BIND(year(?date) as ?year) FILTER(?death_date >= "1919-02-01"^^ && ?death_date <= "1919-02-27"^^) ?hdnggemeente schema:hasObservation ?observation . ?observation hdngvar:BEV1 ?pop_m ; hdngvar:BEV2 ?pop_f . ?observation hdngv:year "1918"^^xsd:gYear. ?hdnggemeente gg:amsterdamCode ?amco2 filter(?amco = ?amco2) BIND(xsd:int(?pop_f + xsd:int(?pop_m)) as ?population) } }} FILTER(?population > 2000) FILTER(?province != ) # BIND ( IF ( ?share_deceased > 20, 1, IF ( ?share_deceased > 10, 0.7, IF (?share_deceased > 5, 0.50, 0.0 ))) AS ?category) # use this for self-assigned categories BIND((?share_deceased - 0.05) / (7.8 - 0.05) as ?index) # use this to normalize death share > norm = (x-xmin) / (xmax - xmin) BIND(concat('reds,', str(?index)) as ?wktColor) BIND(concat(xsd:double(?share_deceased),'_', STRAFTER(STR(?hdnggemeente), 'gemeente/')) as ?wktTooltip) } ORDER BY DESC (?share_deceased)

Documentation

Triply