Area of European countries in 2009 (Eurostat)

Data table via SPARQL Published 16 Apr 2012 Last modified 21 May 2019

Download this dataset

Dataset preview

(Live Query)

ucountry totalarea landarea country

Received 0 rows in 0.073 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/area-of-european-countries-in/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://semantic.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX estat: <http://eurostat.linked-statistics.org/property#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX g: <http://eurostat.linked-statistics.org/ontologies/geographic.rdf#>
PREFIX geo: <http://eurostat.linked-statistics.org/dic/geo#>
PREFIX dataset: <http://eurostat.linked-statistics.org/data/>

SELECT ?ucountry
         sql:sample(?totalarea) AS ?totalarea
         sql:sample(?landarea) AS ?landarea
         sql:sample(?country) AS ?country
FROM <http://eurostat.linked-statistics.org/data/demo_r_d3area.rdf>
FROM <http://eurostat.linked-statistics.org/dic/geo.rdf>
FROM <http://rdfdata.eionet.europa.eu/eurostatdic/eurostat-countrygroups.rdf>
WHERE {
  ?areaobs qb:dataSet dataset:demo_r_d3area ;
        sdmx-dimension:timePeriod "2009-01-01"^^xsd:date;
        sdmx-dimension:freq <http://purl.org/linked-data/sdmx/2009/code#freq-A>;
        estat:unit <http://eurostat.linked-statistics.org/dic/unit#KM2>;
        estat:geo ?ucountry
 { ?areaobs  estat:landuse <http://eurostat.linked-statistics.org/dic/landuse#TOTAL>;
        sdmx-measure:obsValue ?totalarea
 } UNION {
 ?areaobs  estat:landuse <http://eurostat.linked-statistics.org/dic/landuse#L0008>;
        sdmx-measure:obsValue ?landarea
 }
FILTER( bif:length(str(?ucountry)) = 48)
# ?ucountry <http://rdfdata.eionet.europa.eu/estat/ontology/memberOf> geo:EU27 
  OPTIONAL { ?ucountry     rdfs:label ?country. FILTER(LANG(?country) = '' ||LANG(?country) = 'en')}

} GROUP BY ?ucountry ORDER BY ?ucountry


Document Actions