prefix class: prefix cshape: prefix country: prefix geo: prefix id: prefix property: prefix rdf: prefix xsd: select ?shape ?shapeColor ?shapeLabel ?shapeLabel1 { { select (min(?studies) as ?min) (max(?studies) as ?max) { { select ?country (count(?study) as ?studies) { ?study property:country ?country. } } } } { select ?country (count(distinct ?study) as ?studies) (count(distinct ?paper) as ?papers) (count(distinct ?effect) as ?effects) { ?paper property:study ?study. ?study property:country ?country; property:reportsEffect ?effect. } } service { [ a cshape:CountrySlice; geo:hasGeometry/geo:asWKT ?shape; cshape:gwEnd ?end; cshape:isoAlpha3 ?iso; cshape:isoName ?name ]. filter(?end = "2016-06-30"^^xsd:date) } filter(iri(concat(str(country:),str(?iso))) = ?country) #bind(concat('jet,',xsd:double(?studies - ?min)/(?max - ?min)) as ?shapeColor) bind(concat('jet,',xsd:double(if(?studies > 2.0e2, 2.0e2, ?studies))/2.0e2) as ?shapeColor) bind(strdt(concat( '

',str(?name),'

', '

Number of papers: ',replace(str(?papers),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

Number of studies: ',replace(str(?studies),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

Number of effects: ',replace(str(?effects),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

' ),rdf:HTML) as ?shapeLabel) } #limit 100

Documentation

Triply