All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 30 rows in 0.001 seconds.
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.
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
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/pesticide-sales-peragainst-utilised-agricultural or scan the QR code.
PDF generated on 27 Nov 2024, 03:32 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others