next
previous
items

Data table via SPARQL

Pesticide sales peragainst utilised agricultural area, by country

Data table via SPARQL Published 17 Oct 2016 Last modified 28 Nov 2016

Download this dataset

Dataset preview

(Live Query)

date ugeo aei_fm_salpest09 ef_kvaareg ratio
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "3097436"^^<http://www.w3.org/2001/XMLSchema#decimal> "2726890"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.14"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "6330367"^^<http://www.w3.org/2001/XMLSchema#decimal> "1307900"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.84"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "1196270"^^<http://www.w3.org/2001/XMLSchema#decimal> "4650940"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.26"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "2006445"^^<http://www.w3.org/2001/XMLSchema#decimal> "1571200"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.28"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "109330"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Czech Republic" "6188583"^^<http://www.w3.org/2001/XMLSchema#decimal> "3491470"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "4204970"^^<http://www.w3.org/2001/XMLSchema#decimal> "2619340"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.61"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Estonia" "567368"^^<http://www.w3.org/2001/XMLSchema#decimal> "957510"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.59"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Finland" "3273822"^^<http://www.w3.org/2001/XMLSchema#decimal> "2282400"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.43"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "France" "66659493"^^<http://www.w3.org/2001/XMLSchema#decimal> "27739430"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.4"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 30 rows in 0.001 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/pesticide-sales-peragainst-utilised-agricultural/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 sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX infotype: <http://rdfdata.eionet.europa.eu/eurostat/dic/infotype#>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX strucpro: <http://dd.eionet.europa.eu/vocabulary/eurostat/strucpro/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
PREFIX indic_ef: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ef/>
PREFIX legtype: <http://dd.eionet.europa.eu/vocabulary/eurostat/legtype/>
PREFIX agrarea: <http://dd.eionet.europa.eu/vocabulary/eurostat/agrarea/>

SELECT
year(?date) as ?date
?ugeo
sum(?aei_fm_salpest09) as ?aei_fm_salpest09
sum(?ef_kvaareg) as ?ef_kvaareg 
round(sum(?aei_fm_salpest09)/sum(?ef_kvaareg)*100.0)/100.0 as ?ratio

WHERE {{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_kvaareg.rdf.gz>
  {
    _:ef_kvaareg sdmx-dimension:timePeriod ?date .
    _:ef_kvaareg property:legtype legtype:TOTAL .
    _:ef_kvaareg property:indic_ef indic_ef:AGRAREA_HA .
    _:ef_kvaareg sdmx-dimension:refArea ?geo .
    _:ef_kvaareg property:agrarea agrarea:TOTAL .
    _:ef_kvaareg sdmx-measure:obsValue ?ef_kvaareg .
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aei_fm_salpest09.rdf.gz>
  {
    _:aei_fm_salpest09 sdmx-dimension:timePeriod ?date . 
    _:aei_fm_salpest09 sdmx-dimension:refArea ?geo . 
    _:aei_fm_salpest09 sdmx-attribute:unitMeasure ?unit . 
    _:aei_fm_salpest09 property:pesticid ?pesticid . 
    _:aei_fm_salpest09 sdmx-measure:obsValue ?aei_fm_salpest09 .
  }
 }
 FILTER (year(?date) = 2013)
 ?geo skos:exactMatch ?eeauri .
 ?eeauri skos:inScheme common_countries: .
 ?eeauri rdfs:label ?ugeo .
}
GROUP BY ?ugeo ?date
ORDER BY ?ugeo ?date


Permalinks

Document Actions