prefix xsd: prefix schema: prefix rdf: prefix rdfs: prefix iisgv: prefix iisgv2: prefix gg: prefix geo: prefix bio: prefix bif: select distinct ?amco ?gg_gemeente ?occ_n ?deceased_n ?occshare ?wktColor ?wkt ?wktTooltip where { { select ?amco ?wkt ?gg_gemeente (count(?occ) as ?occ_n) (count(?deceased) as ?deceased_n) { { select (max(?wktyear) as ?max) ?gg_gemeente { ?gg_gemeente geo:hasGeometry ?geo . ?geo gg:year ?wktyear . filter(?wktyear <= "1918"^^xsd:gYear) } group by ?gg_gemeente } ?gg_gemeente geo:hasGeometry [gg:year ?max ; geo:asWKT ?wkt ] . ?death a bio:Death . ?death iisgv:deceased ?deceased . optional{ ?deceased schema:hasOccupation ?occ }. ?deceased iisgv:ageYears ?age . # used to exclude children ?death bio:date ?date . ?death iisgv:event_location ?gemeente . ?gemeente gg:amsterdamCode ?amco . ?amco ^gg:amsterdamCode ?gg_gemeente . bind(year(?date) as ?year) filter(?age >= "18"^^) # FILTER(!REGEX(?occ, "zonder", "i")) # FILTER(!REGEX(?occ, "geen")) # FILTER(!REGEX(?occ, "-")) filter not exists { ?gg_gemeente gg:startDate ?startdate filter(?startdate >= "1918-01-01"^^) } filter not exists { ?gg_gemeente gg:endDate ?enddate filter(?enddate <= "1918-01-01"^^) } } GROUP BY ?amco ?gg_gemeente ?wkt #added line 2025-01-21 (to be more correct speedy) } bind(xsd:float(?occ_n)/xsd:float(?deceased_n) * 100 as ?occshare) bind(concat('reds,', (?occshare/ 100)) as ?wktColor) bind(concat(substr(str(?occshare), 0, 4),'%_', strafter(str(?gg_gemeente), 'gemeentenaam/')) as ?wktTooltip) } order by asc (?amco)

Share of known occupations

API

Variables