next
previous
items

Data table via SPARQL

Marine aquaculture production relative to coastline length - total

Data table via SPARQL Published 06 Sep 2018 Last modified 24 Jun 2020
32 min read

Download this dataset

Dataset preview

(Live Query)

year country group wri_coastline obsValue FishStatUnpivot
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "TOTAL" "649"^^<http://www.w3.org/2001/XMLSchema#int> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.83"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "TOTAL" "457"^^<http://www.w3.org/2001/XMLSchema#int> "7.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.29"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "TOTAL" "5663"^^<http://www.w3.org/2001/XMLSchema#int> "2.25"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.76"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "TOTAL" "671"^^<http://www.w3.org/2001/XMLSchema#int> "10.73"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "TOTAL" "5316"^^<http://www.w3.org/2001/XMLSchema#int> "2.97"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "France" "TOTAL" "7330"^^<http://www.w3.org/2001/XMLSchema#int> "17.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "127.92"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "TOTAL" "3624"^^<http://www.w3.org/2001/XMLSchema#int> "4.67"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.94"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "TOTAL" "15147"^^<http://www.w3.org/2001/XMLSchema#int> "8.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "122.45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Iceland" "TOTAL" "8506"^^<http://www.w3.org/2001/XMLSchema#int> "0.06"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.51"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Ireland" "TOTAL" "6437"^^<http://www.w3.org/2001/XMLSchema#int> "6.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "44.74"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 20 rows in 0.001 seconds.


https://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/FishStatUnpivot2019.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) = 2017)
    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


Permalinks

Geographic coverage

Temporal coverage

Tags

Document Actions