Marine aquaculture production relative to coastline length

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

Download this dataset

Dataset preview

(Live Query)

year country group wri_coastline obsValue FishStatUnpivot
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "PISCES" "671"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.05"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "PISCES" "5316"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "France" "MOLLUSCA" "7330"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "208.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "France" "PISCES" "7330"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.29"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "PISCES" "3624"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "MOLLUSCA" "3624"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.33"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "PISCES" "15147"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "MOLLUSCA" "15147"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.69"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Iceland" "PISCES" "8506"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.32"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.72"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Ireland" "PISCES" "6437"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.65"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 871 rows in 0.042 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/marine-aquaculture-production-relative-to-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 wri_coastline: <http://semantic.eea.europa.eu/project/CSI033/wri_coastline.tsv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

select
xsd:integer(?year) as ?year
?country
?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)
    FILTER (xsd:integer(?year) >= 1990)

    ?member skos:inScheme countries: .
    ?member skos:notation ?iso2 .
    ?geoarea_uri skos:member ?member.
    ?geoarea_uri ?o countrygroups: .
    FILTER (?geoarea_uri in (countrygroups:EEA33))

    _: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
Filed under: