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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

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.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/pesticide-sales-peragainst-utilised-agricultural/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        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