Marine aquaculture production relative to coastline length - total

Data table via SPARQL Last modified 06 Sep 2018
32 min read

Download this dataset

Dataset preview

(Live Query)

year country group wri_coastline obsValue FishStatUnpivot
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "TOTAL" "649"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "TOTAL" "457"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.93"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "TOTAL" "5663"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "TOTAL" "671"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.56"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "TOTAL" "5316"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.88"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "France" "TOTAL" "7330"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "128.06"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "TOTAL" "3624"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.26"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "TOTAL" "15147"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.94"^^<http://www.w3.org/2001/XMLSchema#decimal> "120.29"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Iceland" "TOTAL" "8506"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.06"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.49"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Ireland" "TOTAL" "6437"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.47"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 20 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/marine-aquaculture-production-relative-total-1/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 FishStatUnpivot: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot2018.tsv#>
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
xsd:integer(?year) as ?year
?country
'TOTAL' as ?group
?wri_coastline
round((sum(coalesce(xsd:double(?FishStatUnpivot),0))/?wri_coastline)*100)/100.0 as ?obsValue

round(sum(coalesce(xsd:double(?FishStatUnpivot),0))/10.0)/100.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 (xsd:integer(?year) = 2016)
    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 xsd:integer(?year) ?country ?environment


Related content

Temporal coverage

Document Actions