PREFIX xsd: PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX iisgv: PREFIX iisgv2: PREFIX gg: PREFIX geo: PREFIX bio: PREFIX bif: SELECT DISTINCT ?gg_gemeente ?n ?wktColor ?wktTooltip ?wkt WHERE { { select (count(?id) as ?n) ?gg_gemeente ?max ?wkt { { select (max(?wktyear) as ?max) ?gg_gemeente { ?gg_gemeente geo:hasGeometry ?geo . ?geo gg:year ?wktyear . FILTER(?wktyear <= "1920"^^xsd:gYear) } } ?gg_gemeente geo:hasGeometry [gg:year ?max ; geo:asWKT ?wkt ] . ?id schema:Residence ?gemeente . ?gemeente gg:Municipality ?gg_gemeente . FILTER NOT EXISTS { ?gg_gemeente gg:startDate ?startdate FILTER(?startdate >= "1921-01-01"^^) } # FILTER NOT EXISTS { #to select only municipalities that existed, but for some reason throws out whole Friesland # ?gg_gemeente gg:endDate ?enddate # FILTER(?enddate <= "1918-01-01"^^)} } } BIND ( IF ( ?n > 70, 1, IF ( ?n > 40, 0.75, IF (?n >= 20, 0.50, IF(?n >=10, 0.35, 0.1 )))) AS ?category) BIND(concat('reds,', (?category)) as ?wktColor) BIND(concat((?n),'_', STRAFTER(STR(?gg_gemeente), 'gemeentenaam/')) as ?wktTooltip) } ORDER BY desc (?n)

Documentation

Triply