Marine aquaculture production relative to coastline length - total

Data table via SPARQL Published 01 Mar 2018 Last modified 01 Mar 2018
32 min read
This is an old version, kept for reference only.

Go to latest version

Download this dataset

Dataset preview

(Live Query)

year country group wri_coastline obsValue FishStatUnpivot
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "TOTAL" "649"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.58"^^<http://www.w3.org/2001/XMLSchema#decimal> "1028"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "TOTAL" "457"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "3373"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "TOTAL" "5663"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10740"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "TOTAL" "671"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "5396"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "TOTAL" "5316"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.65"^^<http://www.w3.org/2001/XMLSchema#decimal> "14090"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "France" "TOTAL" "7330"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "156940"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "TOTAL" "3624"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "10955"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "TOTAL" "15147"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "103164"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Iceland" "TOTAL" "8506"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "214"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Ireland" "TOTAL" "6437"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "38728"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 20 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/marine-aquaculture-production-relative-total/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 skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX FishStatUnpivot: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot.csv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
PREFIX wri_coastline: <http://semantic.eea.europa.eu/project/CSI033/wri_coastline.tsv#>

select
?year
?country
'TOTAL' as ?group
?wri_coastline
round((sum(coalesce(?FishStatUnpivot,0))/?wri_coastline)*100)/100.0 as ?obsValue
sum(coalesce(?FishStatUnpivot,0)) as ?FishStatUnpivot

{{
  SELECT DISTINCT
    ?year
    ?country
    ?iso2
    ?group
    ?FishStatUnpivot
    ?wri_coastline
  WHERE {
    _:FishStatUnpivot FishStatUnpivot:country ?country .
    _:FishStatUnpivot FishStatUnpivot:iso2 ?iso2 .
    _:FishStatUnpivot FishStatUnpivot:group ?group .
    _:FishStatUnpivot FishStatUnpivot:environment ?environment .
    _:FishStatUnpivot FishStatUnpivot:year ?year .
    _:FishStatUnpivot FishStatUnpivot:obsValue ?FishStatUnpivot .
    FILTER (?group IN ('PISCES', 'MOLLUSCA'))

    FILTER (?environment = 'Marine')
    FILTER (?year = 2015)
    OPTIONAL { ?member skos:notation ?iso2 }.
    OPTIONAL { ?member rdfs:label ?country } .

    _:wri_coastline wri_coastline:geo ?iso2 .
    _:wri_coastline wri_coastline:obsValue ?wri_coastline .
  }
}}
ORDER BY ?year ?country ?environment


Related content

Temporal coverage

Document Actions