Annual aquaculture production by environment

Data table via SPARQL Last modified 19 Sep 2018

Download this dataset

Dataset preview

(Live Query)

year geoarea area obsValue
"1993" "Africa" "Inland waters" "79.88"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993" "Africa" "Marine areas" "25.23"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994" "Africa" "Inland waters" "84.69"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994" "Africa" "Marine areas" "32.84"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995" "Africa" "Inland waters" "102.61"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995" "Africa" "Marine areas" "47.82"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996" "Africa" "Inland waters" "126.47"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996" "Africa" "Marine areas" "55.66"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997" "Africa" "Inland waters" "129.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997" "Africa" "Marine areas" "45.97"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 288 rows in 0.064 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/annual-aquaculture-production-by-environment-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/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT DISTINCT
?year 
?geoarea
?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:continent ?geoarea .
    FILTER (?geoarea != 'Europe')
    _:rec tableFile:obsValue ?obsValue .
  } UNION {
    ?member skos:inScheme countries: .
    ?member skos:notation ?iso2 .
    ?geoarea_uri skos:member ?member.
    ?geoarea_uri ?o countrygroups: .
    ?geoarea_uri skos:notation ?geoarea .
    _:rec tableFile:obsValue ?obsValue .
    FILTER (?geoarea_uri in (countrygroups:EU28 ))
  } UNION {
     { SELECT 'EEA39' as ?geoarea {} } .
     ?member skos:inScheme countries: .
     ?member skos:notation ?iso2 .
     ?geoarea_uri skos:member ?member.
     ?geoarea_uri ?o countrygroups: .
     _:rec tableFile:obsValue ?obsValue .
     FILTER (?geoarea_uri in (countrygroups:EEA33) || 
             ?member in (countries:AL, countries:BA, countries:MK, 
             countries:ME, countries:RS, countries:XK, countries:CS))
  }
  FILTER (xsd:integer(?year) > 1992)
}

GROUP BY ?geoarea ?year ?area 
ORDER BY ?geoarea xsd:integer(?year) ?area


Related content

Geographic coverage

Temporal coverage

Document Actions
Filed under: