Global Annual Production by continent

Data table via SPARQL Last modified 19 Sep 2018

Download this dataset

Dataset preview

(Live Query)

year geoarea obsValue
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Oceania" "75.79"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Asia" "22101.12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Africa" "105.11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Americas" "823.22"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "EU28" "1003.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "EEA39" "1191.21"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Oceania" "75.42"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Asia" "25253.92"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Africa" "117.52"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Americas" "870.32"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 144 rows in 0.095 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/global-annual-production-by-continent-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
xsd:integer(?year) as ?year
?geoarea
round(sum(xsd:double(?obsValue))/10.0)/100.0 as ?obsValue

WHERE {
 _:rec tableFile:country ?country .
 _:rec tableFile:continent ?continent .
 _: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)
}
ORDER BY xsd:integer(?year)


Related content

Geographic coverage

Temporal coverage

Document Actions
Filed under: