label |
bookmark |
query |
List of species with Natura 2000 codes and EUNIS links |
http://semantic.eea.europa.eu/sparqlbookmarks/-3637185103296548007 |
PREFIX e:
PREFIX dwc:
SELECT ?n2000code ?name ?authority?eunisurl WHERE {
?eunisurl e:sameSynonymN2000 ?n2000code ;
e:binomialName ?name;
dwc:scientificNameAuthorship ?authority
} ORDER BY ?n2000code |
Vocabularies in the database |
http://semantic.eea.europa.eu/sparqlbookmarks/2889283866111318528 |
PREFIX rdfs:
PREFIX skos:
SELECT DISTINCT ?vocabulary STR(?label) AS ?title
WHERE {
?vocabulary a skos:ConceptScheme .
{ ?vocabulary rdfs:label ?label }
UNION
{ ?vocabulary skos:prefLabel ?label}
FILTER(LANG(?label) = 'en' || LANG(?label) = '' )
} ORDER BY ?label |
List of Indicator Specifications |
http://semantic.eea.europa.eu/sparqlbookmarks/7431098683120358771 |
PREFIX dcterms:
PREFIX rdfs:
PREFIX s:
SELECT DISTINCT * WHERE {
_:bookmark a s:Specification ;
s:id ?id;
s:dpsir ?dpsir;
s:typology ?typology;
dcterms:title ?title
} |
Area of European countries (FAO) |
http://semantic.eea.europa.eu/sparqlbookmarks/4192399402114854625 |
PREFIX fao:
SELECT * WHERE {
[] a fao:self_governing ;
fao:isInGroup fao:Europe;
fao:codeISO2 ?code;
fao:nameShort ?name;
fao:landAreaTotal ?landarea;
fao:countryAreaTotal ?totalarea.
FILTER(LANG(?name) = 'en')
} ORDER BY ?code |
EEA themes queried as a SKOS vocabulary |
http://semantic.eea.europa.eu/sparqlbookmarks/-1896528077057874440 |
PREFIX skos:
SELECT * WHERE {
?theme skos:inScheme ;
skos:prefLabel ?label
} ORDER BY ?label |
Referenced datasets from indicator specifications |
http://semantic.eea.europa.eu/sparqlbookmarks/-2279484858719720842 |
PREFIX rdfs:
PREFIX cr:
PREFIX s:
PREFIX ed:
PREFIX d:
PREFIX dct:
SELECT DISTINCT sql:sample(?items) AS ?url ?title ?dataseturl sql:sample(?obligations) AS ?obligation
WHERE {
?specification s:relatedItems ?items .
?items a ?type .
OPTIONAL {?items ed:dataset_url ?dataseturl }
OPTIONAL {?items dct:title ?title }
OPTIONAL {?items d:reportingObligations ?obligations }
FILTER(?type IN ( , ))
} ORDER BY ?title |
Natura 2000 sites |
http://semantic.eea.europa.eu/sparqlbookmarks/6199112345960261408 |
SELECT ?code ?name ?SDF WHERE {
?site ?name .
?site ?code .
?site ?SDF .
} |
SENSE II specifications (9 items) |
http://semantic.eea.europa.eu/sparqlbookmarks/1457704810160049751 |
PREFIX dcterms:
PREFIX rdfs:
PREFIX s:
SELECT DISTINCT * WHERE {
?bookmark a s:Specification ;
s:codes ?subject;
s:dpsir ?dpsir;
s:typology ?typology;
dcterms:title ?title
FILTER(?subject IN ('CSI001','CSI002','CSI003','CSI008','CSI010', 'CSI011','CSI018','CSI029','CSI033'))
} limit 100 |
Species that are valid in EUNIS, but invalid in ITIS |
http://semantic.eea.europa.eu/sparqlbookmarks/4001076049521143419 |
PREFIX e:
PREFIX itis:
PREFIX dwc:
SELECT ?eunisname ?eunisauthor ?itisname ?itisauthor WHERE {
?eunisurl e:validName 1;
e:sameSynonym ?itisurl;
e:binomialName ?eunisname;
dwc:scientificNameAuthorship ?eunisauthor.
?itisurl itis:nameUsage "invalid";
itis:completename ?itisname;
itis:hasAuthor _:auurl.
_:auurl itis:taxonAuthor ?itisauthor
} |
Country memberships (EU, EUN22, EEA, EIONET) |
http://semantic.eea.europa.eu/sparqlbookmarks/-4537076113860538368 |
PREFIX rdfs:
PREFIX eea:
SELECT DISTINCT ?code ?countryname ?publishingCode
IF(bound(?eumember),'Yes','') AS ?eu
IF(bound(?eeamember),'Yes','') AS ?eea
IF(bound(?eionetmember),'Yes','') AS ?eionet
IF(bound(?eun22member),'Yes','') AS ?eun22
WHERE {
?ucountry a eea:Country ;
eea:code ?code;
eea:publishingCode ?publishingCode;
rdfs:label ?countryname
OPTIONAL { skos:member ?ucountry, ?eumember }
OPTIONAL { skos:member ?ucountry, ?eun22member }
OPTIONAL { skos:member ?ucountry, ?eeamember }
OPTIONAL { skos:member ?ucountry, ?eionetmember }
} ORDER BY ?code |
EEA member countries |
http://semantic.eea.europa.eu/sparqlbookmarks/7279832685263796754 |
PREFIX skos:
PREFIX rdfs:
PREFIX eea:
SELECT ?code ?countryname ?publishingCode WHERE {
?ucountry a eea:Country ;
eea:code ?code;
eea:publishingCode ?publishingCode;
rdfs:label ?countryname.
skos:member ?ucountry
} ORDER BY ?code |
Languages used by EEA member countries |
http://semantic.eea.europa.eu/sparqlbookmarks/5276366884876196697 |
PREFIX skos:
PREFIX rdfs:
PREFIX l:
PREFIX eea:
SELECT ?code ?countrycode ?languagename ?countryname WHERE {
?language a l:Language ;
l:officialOf ?ucountry;
eea:code ?code;
rdfs:label ?languagename.
?ucountry eea:code ?countrycode;
rdfs:label ?countryname.
skos:member ?ucountry
} ORDER BY ?code |
Long-range Transboundary Air Pollution (LRTAP) National totals per pollutant (9333 records) |
http://semantic.eea.europa.eu/sparqlbookmarks/8526082216353463375 |
PREFIX rdfs:
PREFIX lrtap:
PREFIX eea:
PREFIX skos:
SELECT ?country ?year ?pollutant ?pollutantcode ?emissions ?unit "National total" AS ?sector ?notation
WHERE {
GRAPH {
?subj a lrtap:Emission;
lrtap:forCountry ?countryUri;
lrtap:forSector ;
lrtap:forPollutant ?pollutantUri;
lrtap:year ?year;
lrtap:emissions ?emissions;
lrtap:unit ?unit.
OPTIONAL { ?subj lrtap:notation ?hasNotation .
?hasNotation rdfs:label ?notation }
}
?countryUri rdfs:label ?country .
skos:member ?countryUri .
?pollutantUri rdfs:label ?pollutant;
skos:notation ?pollutantcode
} ORDER BY ?country ?sector ?year |
All EEA datasets |
http://semantic.eea.europa.eu/sparqlbookmarks/-4808651405979017634 |
PREFIX a:
PREFIX dcterms:
SELECT DISTINCT ?subj ?issued ?title ?description WHERE {
?subj a a:Data ;
dcterms:title ?title ;
dcterms:description ?description;
dcterms:issued ?issued.
} ORDER BY ?effective |
Codelist for bio-geographical regions, Europe 2011 |
http://semantic.eea.europa.eu/sparqlbookmarks/5626811883626411719 |
PREFIX rdfs:
PREFIX eea:
SELECT ?Code ?Name
(if(?is_marine,'Marine Region','Bio-geographical Region') AS ?Region) ?Code_used_until_2012
FROM
WHERE {
?region a eea:BiogeographicalRegion ;
eea:code ?Code;
eea:art17Code ?Code_used_until_2012;
eea:isMarine ?is_marine;
rdfs:label ?Name.
} ORDER BY ?Region ?Code |
Air pollution for NH3, NMVOC, SOX and NOX per country per year (EEA) |
http://semantic.eea.europa.eu/sparqlbookmarks/-4506678806623749703 |
PREFIX qb:
PREFIX estat:
PREFIX measure:
PREFIX dimension:
PREFIX attribute:
PREFIX dataset:
PREFIX rdfs:
PREFIX skos:
SELECT ?country ?year ?pollutant ?value
WHERE {
?obs qb:dataSet dataset:env_air_emis;
dimension:freq ;
estat:unit ;
estat:airsect ;
estat:geo ?ucountry;
estat:ai ?upollutant;
dimension:timePeriod ?year;
measure:obsValue ?value.
?ucountry rdfs:label ?country.
?upollutant rdfs:label ?pollutant.
} ORDER BY ?country ?year |
Electricity generated from renewable sources (1990-) (Eurostat nrg_ind_333a) |
http://semantic.eea.europa.eu/sparqlbookmarks/-8011263055660014139 |
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX geo:
PREFIX dataset:
PREFIX skos:
SELECT ?country ?iso2 ?percentage ?year
WHERE {
?obsrec qb:dataSet dataset:nrg_ind_333a ;
sdmx-dimension:timePeriod ?year;
sdmx-dimension:freq ;
estat:unit ;
estat:geo ?ucountry;
sdmx-measure:obsValue ?percentage.
?ucountry rdfs:label ?country;
skos:notation ?iso2.
} ORDER BY ?country ?year |
Area of European countries in 2009 (Eurostat) |
http://semantic.eea.europa.eu/sparqlbookmarks/-5277434325430085422 |
PREFIX owl:
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX geo:
PREFIX dataset:
SELECT ?ucountry
sql:sample(?totalarea) AS ?totalarea
sql:sample(?landarea) AS ?landarea
sql:sample(?country) AS ?country
WHERE {
?areaobs qb:dataSet dataset:demo_r_d3area ;
sdmx-dimension:timePeriod "2009-01-01"^^xsd:date;
sdmx-dimension:freq ;
estat:unit ;
estat:geo ?ucountry
{ ?areaobs estat:landuse ;
sdmx-measure:obsValue ?totalarea
} UNION {
?areaobs estat:landuse ;
sdmx-measure:obsValue ?landarea
}
OPTIONAL { ?ucountry rdfs:label ?country }
?eeacountry owl:sameAs ?ucountry
} GROUP BY ?ucountry ORDER BY ?ucountry |
Energy consumption per country in thousand tonnes of oil equivalent 1999- (Eurostat ten00095) |
http://semantic.eea.europa.eu/sparqlbookmarks/-4626061118178514952 |
# ten00095 (Final energy consumption per country in thousand tonnes of oil equivalent 1999-)
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX geo:
PREFIX dataset:
PREFIX skos:
PREFIX eont:
SELECT ?country ?iso2 ?year ?obsvalue AS ?toe
WHERE {
?obsrec qb:dataSet dataset:ten00095 ;
sdmx-dimension:timePeriod ?year;
sdmx-dimension:freq ;
estat:product ;
estat:geo ?ucountry;
sdmx-measure:obsValue ?obsvalue.
?ucountry rdfs:label ?country;
skos:notation ?iso2.
} ORDER BY ?country ?year |
Eurostat datasets related to environment |
http://semantic.eea.europa.eu/sparqlbookmarks/6377596960698554404 |
PREFIX rdfs:
PREFIX dctype:
PREFIX void:
PREFIX dcterms:
PREFIX estattoc:
PREFIX skos:
PREFIX otoc:
PREFIX cr:
SELECT ?title ?code ?values ?datastart ?dataend ?dataset
WHERE {
?dataset a void:Dataset ;
dcterms:creator estattoc:Eurostat;
rdfs:label ?title;
cr:tag "environment";
skos:notation ?code;
otoc:dataStart ?datastart;
otoc:dataEnd ?dataend;
void:entities ?values.
} ORDER BY ?title |
GDP per capita per country for the years 1949-2011 (Eurostat) |
http://semantic.eea.europa.eu/sparqlbookmarks/912716897883996198 |
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX dataset:
SELECT STR(?country) AS ?country ?year ?gdp
WHERE {
?obs qb:dataSet dataset:nama_aux_gph ;
sdmx-dimension:timePeriod ?year;
sdmx-dimension:freq ;
estat:geo ?ucountry;
estat:unit ;
estat:indic_na ;
sdmx-measure:obsValue ?gdp.
?ucountry rdfs:label ?country.
} ORDER BY DESC(?year) ?country |
Water use per capita and NUTS2 in 2007 (Eurostat demo_r_pjangroup and env_n2_wu) |
http://semantic.eea.europa.eu/sparqlbookmarks/-4181441865268706038 |
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-measure:
PREFIX sdmx-dimension:
PREFIX skos:
PREFIX g:
PREFIX dataset:
SELECT ?nuts2code ?nuts2
?population
?wateruse
xsd:decimal(?wateruse)*1000000/SUM(xsd:decimal(?population)) AS ?percapita
WHERE {
GRAPH dataset:demo_r_pjangroup.rdf.gz {
?observation qb:dataSet dataset:demo_r_pjangroup ;
sdmx-dimension:timePeriod "2007-01-01"^^xsd:date;
estat:age ;
estat:sex ;
estat:geo ?ugeo;
sdmx-measure:obsValue ?population.
}
GRAPH dataset:env_n2_wu.rdf.gz {
?wuregion qb:dataSet dataset:env_n2_wu ;
estat:geo ?ugeo;
estat:cons ;
sdmx-dimension:timePeriod "2007-01-01"^^xsd:date;
sdmx-measure:obsValue ?wateruse.
}
?ugeo rdfs:label ?nuts2;
skos:notation ?nuts2code
} ORDER BY DESC(?percapita)
LIMIT 25 |
GDP vs. GHG per capita per country from 1990-2010 (Eurostat) |
http://semantic.eea.europa.eu/sparqlbookmarks/8398759721491149450 |
PREFIX skos:
PREFIX qb:
PREFIX e:
PREFIX code:
PREFIX measure:
PREFIX dimension:
PREFIX rdfs:
PREFIX dataset:
SELECT ?country ?iso2
?year
xsd:double(?gdp) AS ?gdppercapita
1000.0 * xsd:double(?ghgtotal) / xsd:double(?population) AS ?ghgpercapita
?population
?ghgtotal
WHERE {
GRAPH {
?popobs qb:dataSet dataset:demo_pjanbroad ;
dimension:timePeriod ?year;
dimension:freq code:freq-A;
e:age ;
e:sex ;
e:geo ?ucountry;
measure:obsValue ?population.
}
GRAPH {
?ghgobs qb:dataSet dataset:env_air_gge ;
e:geo ?ucountry;
dimension:timePeriod ?year;
e:airsect ;
measure:obsValue ?ghgtotal.
}
GRAPH {
?gdpobs qb:dataSet dataset:nama_aux_gph ;
dimension:timePeriod ?year;
dimension:freq code:freq-A;
e:geo ?ucountry;
e:unit ;
e:indic_na ;
measure:obsValue ?gdp.
}
GRAPH {
?ucountry skos:prefLabel ?country;
skos:notation ?iso2.
}
} ORDER BY ?country ?year |
Percentage of wastewater treatment in regions of Europe (1990-) (Eurostat env_watq4) |
http://semantic.eea.europa.eu/sparqlbookmarks/5398259541246397332 |
# Caution: The average is not weighted with population size in each country.
PREFIX owl:
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX geo:
PREFIX dataset:
PREFIX skos:
SELECT ?region AVG(xsd:int(?percentage)) AS ?percentage ?year ?source
WHERE {
GRAPH dataset:env_watq4.rdf.gz {
?obsrec qb:dataSet dataset:env_watq4 ;
sdmx-dimension:timePeriod ?year;
sdmx-dimension:freq ;
estat:src ?usource;
estat:unit ;
estat:geo ?ucountry;
sdmx-measure:obsValue ?percentage.
}
?eeacountry owl:sameAs ?ucountry.
?uregion skos:inScheme ;
skos:member ?eeacountry;
skos:prefLabel ?region.
?ucountry rdfs:label ?country.
?usource rdfs:label ?source.
FILTER(?year >= "1990-01-01"^^xsd:date)
} GROUP BY ?region ?year ?source ORDER BY ?region ?year ?source |
Comparison of FAO and Eurostat GDP for EEA members |
http://semantic.eea.europa.eu/sparqlbookmarks/-7146413543025253899 |
PREFIX skos:
PREFIX owl:
PREFIX rdfs:
PREFIX fao:
PREFIX qb:
PREFIX p:
PREFIX dimension:
PREFIX measure:
SELECT ?code ?countryname
bif:sprintf("%.1f",?faogdp) AS ?faoGDP
bif:sprintf("%.1f",xsd:float(?estatgdp) * 1.395871) AS ?estatGDP
bif:sprintf('%.2f',?faogdp / xsd:float(?estatgdp) / 0.01395871) AS ?differencePercentage
?faogdpyear
WHERE {
skos:member ?ucountry.
?ucountry a skos:Concept ;
skos:notation ?code;
rdfs:label ?countryname;
owl:sameAs ?faourl;
owl:sameAs ?estaturl.
?faourl fao:GDPTotalInCurrentPrices ?faogdp;
fao:GDPYear ?faogdpyear.
?obs qb:dataSet ;
p:geo ?estaturl;
p:indic_na ;
dimension:timePeriod ?year;
p:unit ;
measure:obsValue ?estatgdp.
FILTER(?year = "2009-01-01"^^xsd:date)
} ORDER BY ?code |
GHG per capita 1990-2009 (Eurostat env_air_gge) |
http://semantic.eea.europa.eu/sparqlbookmarks/-6468351171283079891 |
PREFIX qb:
PREFIX e:
PREFIX code:
PREFIX measure:
PREFIX dimension:
PREFIX rdfs:
PREFIX dataset:
PREFIX eont:
SELECT ?country
bif:left(STR(?year),4) AS ?year
1000.0 * xsd:int(?ghgtotal) / xsd:decimal(?population) AS ?ghgpercapita
?population
xsd:int(?ghgtotal) AS ?ghgtotal
WHERE {
GRAPH {
?popobs qb:dataSet dataset:demo_pjanbroad ;
dimension:timePeriod ?year;
dimension:freq code:freq-A;
e:age ;
e:sex ;
e:geo ?ucountry;
measure:obsValue ?population.
}
GRAPH {
?ghgobs qb:dataSet dataset:env_air_gge ;
e:geo ?ucountry;
dimension:timePeriod ?year;
e:airsect ;
measure:obsValue ?ghgtotal.
}
GRAPH {
?ucountry rdfs:label ?country.
}
} ORDER BY ?country ?year |
Swedish counties from Länsstyrelsen combined with population statistics from Eurostat |
http://semantic.eea.europa.eu/sparqlbookmarks/-3049153028536253036 |
PREFIX rdfs:
PREFIX v:
PREFIX dbo:
PREFIX cube:
PREFIX p:
PREFIX dimension:
PREFIX measure:
SELECT ?len ?name ?population ?sex
WHERE {
?len a v:County ;
v:code ?code;
rdfs:label ?name;
owl:sameAs ?ld.
?ds p:geo ?ld.
?ds cube:dataSet ;
dimension:timePeriod "2011-01-01"^^xsd:date;
measure:obsValue ?population;
p:age ;
p:sex ?usex.
?usex rdfs:label ?sex FILTER(LANG(?sex) = 'en')
} ORDER BY ?name ?sex |
EU country populations in 2011 (Eurostat) |
http://semantic.eea.europa.eu/sparqlbookmarks/5971358899151821186 |
# Note: the GRAPH clause makes it much faster
PREFIX owl:
PREFIX skos:
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX c:
PREFIX dataset:
SELECT ?ucountry ?country ?population
WHERE {
GRAPH dataset:demo_pjanbroad.rdf.gz {
?popobs qb:dataSet dataset:demo_pjanbroad ;
sdmx-dimension:timePeriod "2011-01-01"^^xsd:date;
sdmx-dimension:freq ;
estat:age ;
estat:sex ;
estat:geo ?ucountry;
sdmx-measure:obsValue ?population.
}
?eeacountry owl:sameAs ?ucountry .
c:EU27 skos:member ?eeacountry .
?eeacountry rdfs:label ?country.
} ORDER BY ?country |
Percentage of wastewater treatment in Central region of Europe (1980-) (Eurostat env_watq4) |
http://semantic.eea.europa.eu/sparqlbookmarks/-859863030625221999 |
PREFIX owl:
PREFIX rdfs:
PREFIX qb:
PREFIX estat:
PREFIX sdmx-dimension:
PREFIX sdmx-measure:
PREFIX geo:
PREFIX dataset:
PREFIX skos:
SELECT ?country ?percentage ?year ?source
WHERE {
GRAPH dataset:env_watq4.rdf.gz {
?obsrec qb:dataSet dataset:env_watq4 ;
sdmx-dimension:timePeriod ?year;
sdmx-dimension:freq ;
estat:src ?usource;
estat:unit ;
estat:geo ?ucountry;
sdmx-measure:obsValue ?percentage.
}
?eeacountry owl:sameAs ?ucountry .
skos:member ?eeacountry.
?ucountry rdfs:label ?country.
?usource rdfs:label ?source.
FILTER(?year >= "1980-01-01"^^xsd:date)
} ORDER BY ?country ?year ?source |
List of Climate-adapt case studies |
http://semantic.eea.europa.eu/sparqlbookmarks/5697338927318524417 |
PREFIX foaf:
PREFIX dcterms:
PREFIX ca:
SELECT ?title sql:group_concat(?country,', ') AS ?countries ?description ?website
WHERE {
GRAPH {
?project a ca:Measure ;
dcterms:title ?title;
dcterms:description ?description;
foaf:page ?website;
dcterms:spatial ?ucountry
}
?ucountry rdfs:label ?country
} |
Relative natural gas prices (Eurostat datasets ten00118 and prc_hicp_aind) |
http://semantic.eea.europa.eu/sparqlbookmarks/4909081381588765377 |
PREFIX qb:
PREFIX sdmx-measure:
PREFIX sdmx-dimension:
PREFIX sdmx-attribute:
PREFIX property:
PREFIX data:
SELECT ?date ?geo (?gasprice * 100 / ?index AS ?relindex)
WHERE {
# Gas prices by type of user - MSHH = Medium sized households
GRAPH data:ten00118.rdf.gz {
_:ten00118 qb:dataSet data:ten00118 .
_:ten00118 sdmx-dimension:freq .
_:ten00118 sdmx-dimension:timePeriod ?date .
_:ten00118 property:indic_en .
_:ten00118 property:geo _:geo .
_:ten00118 property:unit .
_:ten00118 sdmx-measure:obsValue ?gasprice .
}
# Harmonised indexes of consumer prices - CP00 = all items
GRAPH data:prc_hicp_aind.rdf.gz {
_:prc_hicp_aind qb:dataSet data:prc_hicp_aind.
_:prc_hicp_aind sdmx-dimension:freq .
_:prc_hicp_aind sdmx-dimension:timePeriod ?date.
_:prc_hicp_aind property:infotype .
_:prc_hicp_aind property:geo _:geo .
_:prc_hicp_aind property:coicop .
_:prc_hicp_aind sdmx-measure:obsValue ?index .
}
_:geo skos:notation ?geo .
} |
Comparison between WHO and Eurostat populations |
http://semantic.eea.europa.eu/sparqlbookmarks/-1044098601592653620 |
#DEFINE input:same-as "yes"
PREFIX owl:
PREFIX rdfs:
PREFIX qb:
PREFIX measure:
PREFIX who:
PREFIX dimension:
PREFIX dataset:
PREFIX estat:
SELECT ?country ?time
(xsd:int(?whopop) AS ?whopop)
(xsd:int(?estatpop)/1000 AS ?estatpop)
WHERE {
GRAPH {
?bookmark qb:dataSet ;
who:country ?wcountry;
dimension:timePeriod ?time;
measure:obsValue ?whopop .
}
?wcountry owl:sameAs ?ucountry.
GRAPH {
?popobs qb:dataSet dataset:demo_pjanbroad ;
dimension:timePeriod ?time;
dimension:freq ;
estat:age ;
estat:sex ;
estat:geo ?ucountry;
measure:obsValue ?estatpop.
}
?ucountry rdfs:label ?country. FILTER(LANG(?country) = '')
} |
EEA published products for Intranet MPS integration |
http://semantic.eea.europa.eu/sparqlbookmarks/489534846925181018 |
PREFIX cr:
PREFIX amp:
PREFIX r:
PREFIX dc:
PREFIX bibo:
SELECT DISTINCT *
WHERE {
?subject a amp:Output .
?subject a ?type FILTER( !?type IN ( amp:Output, bibo:Webpage, cr:File ) )
OPTIONAL { ?subject dc:created ?created }
OPTIONAL { ?subject dc:modified ?modified }
OPTIONAL { ?subject dc:issued ?published }
OPTIONAL { ?subject dc:title ?title }
OPTIONAL { ?subject dc:description ?description }
OPTIONAL { ?subject amp:managementPlan ?MPScode }
OPTIONAL { ?subject r:serial_title ?serial_title }
OPTIONAL { ?subject r:isbn ?isbn }
OPTIONAL { ?subject r:order_id ?catalogue_number }
OPTIONAL { ?subject r:id ?id }
} |
NUTS regions level 0 to 2 |
http://semantic.eea.europa.eu/sparqlbookmarks/-827861145687036979 |
PREFIX e:
SELECT ?nuts ?nutscode ?level ?name ?enddate
WHERE {
?nuts a e:NUTSRegion ;
e:code ?nutscode;
e:level ?level;
e:name ?name
OPTIONAL {?nuts e:enddate ?enddate }
FILTER(?level < 3)
} |
Homicides per million (Eurostat crim_gen and WHO WHS9_86 datasets) |
http://semantic.eea.europa.eu/sparqlbookmarks/-2082223201218876477 |
PREFIX owl:
PREFIX qb:
PREFIX sdmx-measure:
PREFIX sdmx-dimension:
PREFIX sdmx-attribute:
PREFIX skos:
PREFIX property:
PREFIX wproperty:
SELECT ?country ?date (?homicide * 1000 / ?population AS ?Homicides)
WHERE {
GRAPH {
_:crim_gen qb:dataSet .
_:crim_gen sdmx-dimension:freq .
_:crim_gen property:crim .
_:crim_gen property:unit .
_:crim_gen property:geo ?geo .
_:crim_gen sdmx-dimension:timePeriod ?date .
_:crim_gen sdmx-measure:obsValue ?homicide
}
?ucountry owl:sameAs ?geo
GRAPH {
_:WHS9_86 qb:dataSet .
_:WHS9_86 sdmx-dimension:freq .
_:WHS9_86 sdmx-dimension:timePeriod ?date .
_:WHS9_86 sdmx-dimension:refArea ?ucountry .
_:WHS9_86 sdmx-measure:obsValue ?population
FILTER((?ucountry != && ?population < 400000)
|| (?ucountry = && ?population < 500) )
}
?ucountry rdfs:label ?country
} ORDER BY ?date ?country |
Homicides per million (Eurostat crim_gen and demo_pjanbroad supplemented with WHO WHS9_86 datasets) |
http://semantic.eea.europa.eu/sparqlbookmarks/-1769057037362946420 |
PREFIX owl:
PREFIX qb:
PREFIX sdmx-measure:
PREFIX sdmx-dimension:
PREFIX sdmx-attribute:
PREFIX skos:
PREFIX property:
PREFIX wproperty:
PREFIX code:
PREFIX c:
SELECT ?country ?date
(xsd:int(if( bound(?epopulation),
?homicide * 1000000 / ?epopulation,
?homicide * 1000 / ?wpopulation)) AS ?Homicides)
WHERE {
GRAPH {
_:crim_gen qb:dataSet .
_:crim_gen sdmx-dimension:freq code:freq-A .
_:crim_gen property:crim .
_:crim_gen property:unit .
_:crim_gen property:geo ?geo .
_:crim_gen sdmx-dimension:timePeriod ?date .
_:crim_gen sdmx-measure:obsValue ?homicide
}
FILTER(!?geo IN (,
))
?geo rdfs:label ?country
OPTIONAL {
?ucountry owl:sameAs ?geo
GRAPH {
_:WHS9_86 qb:dataSet .
_:WHS9_86 sdmx-dimension:freq code:freq-A .
_:WHS9_86 sdmx-dimension:timePeriod ?date .
_:WHS9_86 sdmx-dimension:refArea ?ucountry .
_:WHS9_86 sdmx-measure:obsValue ?wpopulation
FILTER((?ucountry != c:ISL && ?wpopulation < 400000)
|| (?ucountry = c:ISL && ?wpopulation < 500) )
}
}
OPTIONAL {
GRAPH {
_:demo_pjanbroad qb:dataSet .
_:demo_pjanbroad sdmx-dimension:freq code:freq-A .
_:demo_pjanbroad property:age .
_:demo_pjanbroad property:sex .
_:demo_pjanbroad sdmx-dimension:timePeriod ?date .
_:demo_pjanbroad property:geo ?geo .
_:demo_pjanbroad sdmx-measure:obsValue ?epopulation
}
}
FILTER(BOUND(?wpopulation) || BOUND(?epopulation))
} ORDER BY ?date ?country |