Share of CDDA sites in major ecosystems by IUCN categories

Data table via SPARQL Published 29 Sep 2016 Last modified 04 Jun 2018
33 min read

Download this dataset

Dataset preview

(Live Query)

major_ecosystem_type iucncat share sites_area site_area_total order
"Marine ecosystem" "II" "1.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "481380.90002441406"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "III" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "109.10768372751772"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "IV" "40.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.714140183768159E7"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "Ia" "0.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "32355.5129404068"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "Ib" "1.37"^^<http://www.w3.org/2001/XMLSchema#decimal> "582479.4374328852"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "Not applicable" "0.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "45835.34389305115"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "Not assigned" "4.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "2102651.444782257"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "Not reported" "12.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "5423093.2545662895"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "V" "5.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "2450677.0253925323"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Marine ecosystem" "VI" "33.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4208603536969423E7"^^<http://www.w3.org/2001/XMLSchema#double> "42468587.40136658" "0"^^<http://www.w3.org/2001/XMLSchema#int>

Received 30 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-cdda-sites-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 schema: <http://reference.eionet.europa.eu/cdda/schema/>
#tech debt, rework it so the filter on iso3 is applied once only
#
#the filter is not working as such
#FILTER (?iso3 NOT IN ('GRL','SJM','ATF', 'BLM', 'GLP','GUF','MAF','MTQ','MYT','REU','SPM','PYF'))

SELECT 
?major_ecosystem_type
?iucncat

sum(?share) as ?share
sum(?sites_area) as ?sites_area
sql:GROUP_CONCAT_DISTINCT(?site_area_total,' ') as ?site_area_total
0 as ?order
  {
  SELECT
    bif:either(UCASE(?major_ecosystem_type) = 'T', 'Terrestrial ecosystem',
             bif:either(?major_ecosystem_type = 'MT', 'Mixed marine and terrestrial ecosystem',
             bif:either(?major_ecosystem_type = 'M', 'Marine ecosystem',
             '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'

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

  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 .
      ?sites schema:iso3 ?iso3 .
      FILTER (?iso3 != 'GRL' && ?iso3 != 'SJM' && ?iso3 != 'ATF' && ?iso3 != 'BLM' && ?iso3 != 'GLP' && ?iso3 != 'GUF' && ?iso3 != 'MAF' && ?iso3 != 'MTQ' && ?iso3 != 'MYT' && ?iso3 != 'REU' && ?iso3 != 'SPM' && ?iso3 != 'PYF')
      ?sites schema:major_ecosystem_type ?major_ecosystem_type .
      {     
        SELECT DISTINCT
          sum(xsd:double(?site_area)) as ?site_area_total
          bif:UCASE(?major_ecosystem_type) as ?major_ecosystem_type
        WHERE {
        GRAPH <http://r.eionet.europa.eu/rdfdumps/cdda/cddasites.rdf.gz> 
          {
            ?sites schema:site_area ?site_area .
            ?sites schema:major_ecosystem_type ?major_ecosystem_type .
            ?sites schema:iso3 ?iso3 .
            FILTER (?iso3 != 'GRL' && ?iso3 != 'SJM' && ?iso3 != 'ATF' && ?iso3 != 'BLM' && ?iso3 != 'GLP' && ?iso3 != 'GUF' && ?iso3 != 'MAF' && ?iso3 != 'MTQ' && ?iso3 != 'MYT' && ?iso3 != 'REU' && ?iso3 != 'SPM' && ?iso3 != 'PYF')
            
          }  
        }
        GROUP BY bif:UCASE(?major_ecosystem_type) ?site_area_total
      }
    }
  }
  GROUP BY UCASE(?iucncat) UCASE(?major_ecosystem_type) ?site_area_total
}
ORDER BY  ?major_ecosystem_type ?order ?iucncat


Geographic coverage

Temporal coverage

Document Actions