Aquaculture production per country

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

Download this dataset

Dataset preview

(Live Query)

year country area obsValue
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "Inland waters" "2.59"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Algeria" "Inland waters" "0.76"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Armenia" "Inland waters" "15.17"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Inland waters" "34.39"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Azerbaijan" "Inland waters" "3.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belarus" "Inland waters" "49.91"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Inland waters" "8.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Inland waters" "86.34"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "Inland waters" "0.95"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "Inland waters" "425.35"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 2300 rows in 0.045 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/aquaculture-production-per-country-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 tableFile: <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/>

SELECT DISTINCT
xsd:integer(?year) as ?year
?country
?area
round(sum(xsd:double(?obsValue))/10.0)/100.0 as ?obsValue

WHERE {
  _:rec tableFile:iso2 ?iso2 .
  _:rec tableFile:speciesGroup ?speciesGroup .
  _:rec tableFile:species ?species .
  _:rec tableFile:group ?group .
  _:rec tableFile:area ?area .
  _:rec tableFile:environment ?environment .
  _:rec tableFile:unit ?unit .
  _:rec tableFile:year ?year .
  _:rec tableFile:obsValue ?obsValue .
  ?member skos:inScheme countries: .
  ?member skos:notation ?iso2 .
  ?member rdfs:label ?country .
  ?geoarea_uri skos:member ?member.
  ?geoarea_uri ?o countrygroups: .
  FILTER (xsd:integer(?year) >= 1990)
  #FILTER (xsd:integer(?year) = 2016)
}
GROUP BY xsd:integer(?year) ?area ?country
ORDER BY ?year ?area ?country


Related content

Visualisations produced

Temporal coverage

Document Actions
Filed under: