Changes

Jump to navigation Jump to search
Line 15: Line 15:     
* Code repository for lists, scripts and tools: https://github.com/openfoodfacts/eu-food-data
 
* Code repository for lists, scripts and tools: https://github.com/openfoodfacts/eu-food-data
 +
===For France===
 +
*Use of french Agriculture Ministry files (hosted at https://github.com/openfoodfacts/eu-food-data/blob/master/fr/urls-fr.txt) to extract list of certification (CE Approval number).
 +
*Definition of a common structure for the table, such as:
 +
**Type (name of category used by administration, ie name of the list)
 +
**Libelle autorisation/Approval description (for fish processing facilities)
 +
**Numero de departement/Department number
 +
**Numero agrement/Approval number
 +
**SIRET/Local Number
 +
**Processus/Process (for fish processing facilities)
 +
**Raison Sociale/Name
 +
**Adresse/Adress
 +
**Code Postal/Postal Code
 +
**Commune/Town
 +
**Espece/Species (for wild games or fish processing facilities)
 +
*Concatenation of file to obtain a list of all approved processes
 +
*Pivot table to create the list of all approved companies
 +
IMPORTANT NOTE: An approval number is unique.A company can have several approved processes, but they will all have the same approval number.
    
== Use of the food establishments list inside Open Food Facts ==
 
== Use of the food establishments list inside Open Food Facts ==

Navigation menu