Difference between pages "User:Javichu/Temp 19" and "Food Traceability Codes/EU Food establishments"

From Open Food Facts wiki
< User:Javichu(Difference between pages)
Jump to navigation Jump to search
 
 
Line 1: Line 1:
<div style="color:red; font-size:xx-large; text-align:center">
+
A food establishment is a facility / an operation that stores, prepares, packages, serves, sells and/or provides food.
'''''Merging & updating: Frozen desserts'''''
 
</div>
 
  
= EN - FR =
+
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.
<pre>
 
< en:Frozen foods
 
en:Ice creams and sorbets
 
fr:Glaces et sorbets, glace et sorbet, sorbets et glaces
 
  
< en:Ice creams and sorbets
+
== Food establishments codes and sources ==
en:Ice creams
 
fr:Glaces
 
  
< en:Ice creams
+
Codes listed of food products labels includes:
fr:Bâtonnets, battonets, battonnets, eskimos
 
  
< fr:Bâtonnets
+
* EU agreements / food establishments codes : http://ec.europa.eu/food/food/biosafety/establishments/list_en.htm
fr:Bâtonnets à la vanille
+
* 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
  
< fr:Bâtonnets
+
== Aggregated list of food establishments ==
fr:Bâtonnets au chocolat
 
  
< en:Ice creams
+
* Code repository for lists, scripts and tools: https://github.com/openfoodfacts/eu-food-data
fr:Cônes
+
===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, ...
  
< en:Ice creams
+
===France===
fr:Crèmes glacées, crème glacée
+
*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
  
< fr:Crèmes glacées
+
== Use of the food establishments list inside Open Food Facts ==
fr:Glaces à la fraise
 
  
< fr:Crèmes glacées
+
* Display information on packager page (company name, street address, type of facility etc.)
fr:Glaces à la noix de coco, glaces au coco
+
* Geo-code addresses and display on http://cestemballepresdechezvous.fr
  
< fr:Crèmes glacées
+
[[fr:Projet:Etablissements alimentaires]]
fr:Glaces à la pistache
 
 
 
< fr:Crèmes glacées
 
fr:Glaces à la vanille
 
 
 
< fr:Crèmes glacées
 
fr:Glaces au café
 
 
 
< fr:Crèmes glacées
 
fr:Glaces au chocolat
 
 
 
< fr:Crèmes glacées
 
fr:Glaces au nougat
 
 
 
< fr:Crèmes glacées
 
fr:Glaces rhum-raisin, glaces au rhum et aux raisins
 
 
 
< en:Ice creams and sorbets
 
fr:Sorbets
 
 
 
< fr:Sorbets
 
fr:Sorbets à l’orange
 
 
 
< fr:Sorbets
 
fr:Sorbets à la fraise
 
 
 
< fr:Sorbets
 
fr:Sorbets à la framboise
 
 
 
< fr:Sorbets
 
fr:Sorbets à la mangue
 
 
 
< fr:Sorbets
 
fr:Sorbets à la mirabelle
 
 
 
< fr:Sorbets
 
fr:Sorbets à la poire
 
 
 
< fr:Sorbets
 
fr:Sorbets à la pomme
 
 
 
< fr:Sorbets
 
fr:Sorbets au citron
 
 
 
< fr:Sorbets
 
fr:Sorbets au citron vert
 
 
 
< fr:Sorbets
 
fr:Sorbets au fruit de la passion, sorbets aux fruits de la passion, sorbets passion, sorbets maracuja
 
</pre>
 
 
 
<pre>
 
< en:Frozen foods
 
fr:Cônes et batonnets surgelés
 
 
 
< en:Frozen foods
 
fr:Desserts et Bacs de glaces surgelés
 
</pre>
 
 
 
= Common =
 
== Top category ==
 
<pre>
 
< en:Frozen foods
 
< en:Desserts
 
en:Frozen desserts
 
es:Postres helados, Postres congelados
 
fr:Desserts glacés, Desserts surgelés
 
</pre>
 
 
 
== Classification by primary categories ==
 
<pre>
 
< en:Frozen desserts
 
de:Speiseeis und Sorbets
 
en:Ice creams and sorbets
 
es:Helados y sorbetes
 
fr:Glaces et sorbets, glace et sorbet, sorbets et glaces
 
 
 
< en:Ice creams and sorbets
 
de:Speiseeis
 
en:Ice creams
 
es:Helados
 
fr:Glaces
 
 
 
< en:Ice creams and sorbets
 
en:Plant-based ice creams, Non-dairy ice creams
 
es:Helados con leche vegetal, Helados con bebida vegetal, Helados vegetales
 
fr:
 
 
 
< en:Ice creams and sorbets
 
de:Sorbets
 
en:Sorbets
 
es:Sorbetes
 
fr:Sorbets
 
 
 
< en:Frozen desserts
 
en:Ice pops, Popsicle, Freeze pop, Ice lolly, Ice block, Icy pole, Freezer pop
 
es:Helados de hielo, Helados de agua, Polos de hielo, Polos de agua, Paletas de hielo, Paletas de agua
 
fr:Glaces à l'eau
 
 
 
< en:Frozen desserts
 
en:Frozen yogurts, Frozen yoghurts
 
es:Yogures helados, Yogures congelados
 
fr:Yaourts glacés
 
 
 
< en:Frozen desserts
 
en:Granizados
 
es:Granizados
 
fr:Granizados
 
</pre>
 
 
 
== Ice creams ==
 
<pre>
 
< en:Ice creams
 
en:Ice cream bars, Ice creams on a stick
 
es:Helados de palo, Polos de helado, Paletas de helado
 
fr:Bâtonnets, battonets, battonnets, eskimos
 
 
 
< en:Ice creams
 
en:Ice cream cones
 
es:Conos de helado
 
fr:Cônes
 
 
 
< en:Ice creams
 
en:Ice cream tubs
 
es:Tarrinas y bloques de helado, Tarrinas de helado, Bloques de helado
 
fr:Crèmes glacées, crème glacée
 
 
 
< en:Ice creams
 
en:Ice cream sandwiches
 
es:Sándwiches de helado
 
fr:Sandwiches à la crème glacée
 
</pre>
 
 
 
=== Ice cream bars ===
 
<pre>
 
< en:Ice cream bars
 
en:Vanilla ice cream bars, Vanilla ice creams on a stick
 
es:Helados de palo de vainilla, Polos de vainilla, Paletas de vainilla
 
fr:Bâtonnets à la vanille
 
 
 
< en:Ice cream bars
 
en:Chocolate ice cream bars, Chocolate ice creams on a stick
 
es:Helados de palo de chocolate, Polos de chocolate, Paletas de chocolate
 
fr:Bâtonnets au chocolat
 
</pre>
 
 
 
=== Ice cream tubs ===
 
<pre>
 
< en:Ice cream tubs
 
en:Strawberry ice cream tubs
 
es:Tarrinas y bloques de helado de fresa, Tarrinas de helado de fresa, Bloques de helado de fresa
 
fr:Glaces à la fraise
 
 
 
< en:Ice cream tubs
 
en:Coconut ice cream tubs
 
es:Tarrinas y bloques de helado de coco, Tarrinas de helado de coco, Bloques de helado de coco
 
fr:Glaces à la noix de coco, glaces au coco
 
 
 
< en:Ice cream tubs
 
en:Pistachio ice cream tubs
 
es:Tarrinas y bloques de helado de pistacho, Tarrinas de helado de pistacho, Bloques de helado de pistacho
 
fr:Glaces à la pistache
 
 
 
< en:Ice cream tubs
 
en:Vanilla ice cream tubs
 
es:Tarrinas y bloques de helado de vainilla, Tarrinas de helado de vainilla, Bloques de helado de vainilla
 
fr:Glaces à la vanille
 
 
 
< en:Ice cream tubs
 
en:Coffee ice cream tubs
 
es:Tarrinas y bloques de helado de café, Tarrinas de helado de café, Bloques de helado de café
 
fr:Glaces au café
 
 
 
< en:Ice cream tubs
 
en:Chocolate ice cream tubs
 
es:Tarrinas y bloques de helado de chocolate, Tarrinas de helado de chocolate, Bloques de helado de chocolate
 
fr:Glaces au chocolat
 
 
 
< en:Ice cream tubs
 
en:Nougat ice cream tubs
 
es:Tarrinas y bloques de helado de turrón, Tarrinas de helado de turrón, Bloques de helado de turrón
 
fr:Glaces au nougat
 
 
 
< en:Ice cream tubs
 
en:Rum and raisins ice cream tubs
 
es:Tarrinas y bloques de helado de ron con pasas, Tarrinas de helado de ron con pasas, Bloques de helado de ron con pasas
 
fr:Glaces rhum-raisin, glaces au rhum et aux raisins
 
</pre>
 
 
 
=== Ice cream cones ===
 
<pre>
 
</pre>
 
 
 
=== Ice cream sandwiches ===
 
<pre>
 
</pre>
 
 
 
== Sorbets ==
 
<pre>
 
< en:Sorbets
 
en:Orange sorbets
 
es:Sorbetes de naranja
 
fr:Sorbets à l’orange
 
 
 
< en:Sorbets
 
en:Strawberry sorbets
 
es:Sorbetes de fresa
 
fr:Sorbets à la fraise
 
 
 
< en:Sorbets
 
en:Raspberry sorbets
 
es:Sorbetes de frambuesa
 
fr:Sorbets à la framboise
 
 
 
< en:Sorbets
 
de:Mango Sorbets
 
en:Mango sorbets
 
es:Sorbetes de mango
 
fr:Sorbets à la mangue
 
 
 
< en:Sorbets
 
en:Plum sorbets
 
es:Sorbetes de ciruela
 
fr:Sorbets à la mirabelle
 
 
 
< en:Sorbets
 
en:Pear sorbets
 
es:Sorbetes de pera
 
fr:Sorbets à la poire
 
 
 
< en:Sorbets
 
en:Apple sorbets
 
es:Sorbetes de manzana
 
fr:Sorbets à la pomme
 
 
 
< en:Sorbets
 
en:Lemon sorbets
 
es:Sorbetes de limón
 
fr:Sorbets au citron
 
 
 
< en:Sorbets
 
en:Lime sorbets
 
es:Sorbetes de lima
 
fr:Sorbets au citron vert
 
 
 
< en:Sorbets
 
en:Passion fruit sorbets
 
es:Sorbetes de maracuyá, Sorbetes de fruta de la pasión
 
fr:Sorbets au fruit de la passion, sorbets aux fruits de la passion, sorbets passion, sorbets maracuja
 
 
 
< en:Sorbets
 
en:Multifruit sorbets
 
es:Sorbetes multifruta
 
fr:Sorbets multifruits
 
</pre>
 
 
 
== Plant-based ice creams ==
 
<pre>
 
< en:Plant-based ice creams
 
en:Plant-based ice cream bars, Plant-based ice creams on a stick
 
es:Helados de palo con leche vegetal, Polos con leche vegetal
 
fr:
 
 
 
< en:Plant-based ice creams
 
en:Plant-based ice cream cones
 
es:Conos de helado con leche vegetal
 
fr:
 
 
 
< en:Plant-based ice creams
 
en:Plant-based ice cream tubs
 
es:Tarrinas y bloques de helado con leche vegetal, Tarrinas de helado con leche vegetal, Bloques de helado con leche vegetal
 
fr:
 
</pre>
 
 
 
=== Plant-based ice creams bars ===
 
<pre>
 
< en:Plant-based ice creams bars
 
en:
 
es:Helados de palo de leche de soja con chocolate, Polos de leche de soja con chocolate
 
fr:
 
 
 
< en:Plant-based ice creams bars
 
en:
 
es:Helados de palo de leche de soja recubiertos con chocolate, Polos de leche de soja recubiertos con chocolate
 
fr:
 
 
 
< en:Plant-based ice creams bars
 
en:
 
es:Helados de palo de horchata, Polos de horchata
 
fr:
 
</pre>
 
 
 
=== Plant-based ice cream tubs ===
 
<pre>
 
< en:Plant-based ice cream tubs
 
en:
 
es:Tarrinas y bloques de helado de leche de arroz y vainilla, Tarrinas y bloques de helado de leche de arroz y vainilla
 
fr:
 
</pre>
 
 
 
=== Plant-based ice cream cones ===
 
<pre>
 
</pre>
 
 
 
== Frozen yogurts ==
 
<pre>
 
</pre>
 
 
 
== Granizados ==
 
<pre>
 
< en:Granizados
 
en:
 
es:Granizados de limón
 
fr:
 
 
 
< en:Granizados
 
en:
 
es:Granizados de horchata de chufa
 
fr:
 
 
 
< en:Granizados
 
en:
 
es:Granizados de café
 
fr:
 
 
 
< en:Granizados
 
en:
 
es:Granizados de turrón
 
fr:
 
 
 
< en:Granizados
 
en:
 
es:Granizados de mojito
 
fr:
 
</pre>
 
 
 
== ???? ==
 
<pre>
 
< en:Frozen foods
 
fr:Cônes et batonnets surgelés
 
 
 
< en:Frozen foods
 
fr:Desserts et Bacs de glaces surgelés
 
</pre>
 

Revision as of 16:36, 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

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

To do

Use of the food establishments list inside Open Food Facts

fr:Projet:Etablissements alimentaires