Total aquaculture production of finfish, shellfish and aquatic plants
Data table via SPARQL
Published 06 Oct 2016
Last modified 03 May 2017
This is an old version, kept for reference only.
Go to latest version
Go to latest version
Download this dataset
Dataset preview
(Live Query)
Received 184 rows in 0.007 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/total-aquaculture-production-of-finfish/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.
http://semantic.eea.europa.eu/sparql
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX tableFile: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot.csv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
SELECT
?year
?geoarea
?environment
?group
round(sum(?obsValue)/100)/10.0 as ?obsValue
{{
SELECT DISTINCT
?year
?geoarea
bif:either(?group != 'PISCES', '',
bif:either(?environment = 'Brackishwater', 'Marine', ?environment) ) as ?environment
?group
sum(?obsValue) 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 .
{
?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: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 (?year > 1992)
FILTER (?group IN ('MOLLUSCA', 'PISCES', 'PLANTAE AQUATICAE'))
}
}}
ORDER BY ?year ?geoarea ?environment ?group
Related content
Visualisations produced
Permalinks
- Permalink to this version
- 5790f35f97994f588b6e5edf36b58dca
- Permalink to latest version
- 7TDW8MN0O4
Geographic coverage
Temporal coverage
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/total-aquaculture-production-of-finfish or scan the QR code.
PDF generated on 20 Jun 2019, 11:52 AM
Document Actions
Share with others