Share of CDDA sites in major ecosystems by IUCN NA categories

Data table via SPARQL Published 05 Mar 2018 Last modified 05 Mar 2018
32 min read

Download this dataset

Dataset preview

(Live Query)

major_ecosystem_type iucncat share sites site_area_total order
"Ecosystem type not available" "III" "0.06"^^<http://www.w3.org/2001/XMLSchema#decimal> "2034"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "IV" "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "621"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "Ia" "48.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "1697662"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "Ib" "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "13815"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "Not reported" "1.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "36730"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "V" "0.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "6614"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Ecosystem type not available" "VI" "49.52"^^<http://www.w3.org/2001/XMLSchema#decimal> "1724159"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481634.997111366"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#int>

Received 7 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-cdda-sites-in-2/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 schema: <http://reference.eionet.europa.eu/cdda/schema/>

SELECT 
?major_ecosystem_type
?iucncat
?share
?sites
?site_area_total
1 as ?order

{
  SELECT
    'Ecosystem type not available' as ?major_ecosystem_type

    bif:either(UCASE(?iucncat) in ('UA', 'NA', 'NOTREPORTED'), 'Not reported', 
          bif:either(UCASE(?iucncat) in ('NOTAPPLICABLE'), 'Not applicable',
          bif:either(UCASE(?iucncat) in ('NOTASSIGNED'), 'Not assigned',
          REPLACE(STR(?iucncat),'A','a')))) as ?iucncat #'IA' -> 'Ia'

    sum(?site_area) as ?sites
    ?site_area_total
    round((sum(?site_area)/xsd:double(?site_area_total))*10000)/100.0 as ?share

  WHERE {
    GRAPH <http://r.eionet.europa.eu/rdfdumps/cdda/cddasites.rdf.gz> 
    {
      ?sites schema:site_code ?site_code .
      ?sites schema:site_area ?site_area .
      ?sites schema:iucncat ?iucncat .
      OPTIONAL { ?sites schema:major_ecosystem_type ?major_ecosystem_type } .
      FILTER (!bound(?major_ecosystem_type)) .
      { 
        SELECT DISTINCT
          sum(xsd:double(?site_area)) as ?site_area_total
        WHERE {
        GRAPH <http://r.eionet.europa.eu/rdfdumps/cdda/cddasites.rdf.gz> 
          {
            ?sites schema:site_area ?site_area .
            OPTIONAL { ?sites schema:major_ecosystem_type ?major_ecosystem_type } .
            FILTER (!bound(?major_ecosystem_type)) .
          }  
        }
      }
    }
  }
}
ORDER BY ?order ?iucncat


Geographic coverage

Temporal coverage

Document Actions