Merger of BNV-D data (2008 to 2019) and enrichment
Description
Merging (in Table R) data published on https://www.data.gouv.fr/fr/datasets/ventes-de-pesticides-par-departement/, and joining two other sources of information associated with MAs:
— uses: https://www.data.gouv.fr/fr/datasets/usages-des-produits-phytosanitaires/
— information on the “Biocontrol” status of the product, from document DGAL/SDQSPV/2020-784 published on 18/12/2020 at https://agriculture.gouv.fr/quest-ce-que-le-biocontrole
All the initial files (.csv transformed into.txt), the R code used to merge data and different output files are collected in a zip.
[enter image description here](http://www.open-source-biology.com/biocontrole_all.png “enter image title here”)
NB:
1) “YASCUB” for {year,AMM,Substance_active,Classification,Usage,Statut_“BioConttrol”}, substances not on the DGAL/SDQSPV list being coded NA.
2) The file of biocontrol products shall be cleaned from the duplicates generated by the marketing authorisations leading to several trade names.
3) The BNVD_BioC_DY3 table and the output file BNVD_BioC_DY3.txt contain the fields {Code_Region,Region,Dept,Code_Dept,Anne,Usage,Classification,Type_BioC,Quantite_substance)}
Resources
| Name |
Format |
Description |
Link |
|
57 |
|
https://www.data.gouv.fr/api/1/datasets/r/d6a40f0e-328d-4f2e-af86-b42875ee3d5a |
Tags
- biocontrole
- usage
- phytosnitaire
- bnv-d
- classification