Difference between revisions of "Food Traceability Codes/EU Food establishments"

From Open Food Facts wiki
Jump to navigation Jump to search
(added Greek codes link)
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 ==

Revision as of 16:32, 4 August 2014

A food establishment is a facility / an operation that stores, prepares, packages, serves, sells and/or provides food.

The goal of this project is to establish a list of food establishments, to gather data about those establishments, to map food products to food establishments (using identifying codes and/or company names and street addresses), to use the data in the Open Food Facts applications and to enable other applications.

Food establishments codes and sources

Codes listed of food products labels includes:

Aggregated list of food establishments

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

fr:Projet:Etablissements alimentaires