Difference between pages "Food Traceability Codes/EU Food establishments" and "Translations - Presentations"

From Open Food Facts wiki
(Difference between pages)
Jump to navigation Jump to search
 
 
Line 1: Line 1:
A food establishment is a facility / an operation that stores, prepares, packages, serves, sells and/or provides food.
+
<< Back to [[Translations]]
 +
<br>
 +
Draft at https://lite6.framapad.org/p/OFF_Presentations<br>
 +
* [[Translations - Presentations - English]]
 +
* [[Translations - Presentations - French]]
 +
* [[Translations - Presentations - Greek]]
  
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.
+
[[Category:Translations]]
 
 
== Food establishments codes and sources ==
 
 
 
Codes listed of food products labels includes:
 
 
 
* EU agreements / food establishments codes : http://ec.europa.eu/food/food/biosafety/establishments/list_en.htm
 
* French EMB codes: http://agriculture.gouv.fr/liste-des-etablissements-agrees-ce
 
* Greek GR codes: http://www.efet.gr/portal/page/portal/efetnew/enterprises/facilities
 
* other countries packaging codes
 
 
 
== Aggregated list of food establishments ==
 
 
 
* Code repository for lists, scripts and tools: https://github.com/openfoodfacts/eu-food-data
 
===How to process official lists===
 
*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.
 
*Update list with other official lists, such as derogatory approvals, ...
 
 
 
===France===
 
*Complete list of approved processes (as of July 2014): https://raw.githubusercontent.com/pmainguet/eu-food-data/master/fr/140802_Liste_Certif_EMB_CE_MinAgri
 
*Complete list of approved companies (as of July 2014): https://raw.githubusercontent.com/pmainguet/eu-food-data/master/fr/140802_Liste_EMB_CE_MinAgri.csv
 
====To do====
 
*Add derogatory approvals, see http://agriculture.gouv.fr/liste-des-etablissements
 
*Search for EMB list approvals
 
 
 
== Use of the food establishments list inside Open Food Facts ==
 
 
 
* Display information on packager page (company name, street address, type of facility etc.)
 
* Geo-code addresses and display on http://cestemballepresdechezvous.fr
 
 
 
[[fr:Projet:Etablissements alimentaires]]
 

Revision as of 08:45, 9 May 2015