Changes

*Update list with other official lists, such as derogatory approvals, ...

*Update list with other official lists, such as derogatory approvals, ...

===France===

===France (DONE) ===

*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 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

*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

===United Kingdom===

===United Kingdom (DONE) ===

To-do list:

To-do list:

*find a way to manage the data available there http://www.food.gov.uk/enforcement/sectorrules

*find a way to manage the data available there http://www.food.gov.uk/enforcement/sectorrules

==Faroe Islands==

==Faroe Islands==

==Finland==

==Finland==

==France==

==France (DONE) ==

*I just build a script that takes all the french agreement info from Agriculture Ministry and concatenate them in one file. Next step is to do the same for UK. The step after that is to cleverly agregate the duplicates (some companies have several health agreements under the same agreement number)

*I just build a script that takes all the french agreement info from Agriculture Ministry and concatenate them in one file. Next step is to do the same for UK. The step after that is to cleverly agregate the duplicates (some companies have several health agreements under the same agreement number)

https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/FR-script.py

https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/FR-script.py

*If nominatim limits queries, you can use data files from wikipedia for lat/lng for each zipcode https://www.data.gouv.fr/fr/datasets/listes-des-communes-geolocalisees-par-regions-departements-circonscriptions-nd/

*If nominatim limits queries, you can use data files from wikipedia for lat/lng for each zipcode https://www.data.gouv.fr/fr/datasets/listes-des-communes-geolocalisees-par-regions-departements-circonscriptions-nd/

==Germany==

==Germany (DONE) ==

*@vince has performed a first extraction based on file in https://github.com/openfoodfacts/eu-food-data/tree/master/de with the help of the following script

*@vince has performed a first extraction based on file in https://github.com/openfoodfacts/eu-food-data/tree/master/de with the help of the following script

     cat export.csv | awk -F';' '{print "\"" $4 "\"; Deutschland"}' | sed "1d" | sort -u | iconv -f ISO-8859-15 -t UTF-8 > to_geocode.csv

     cat export.csv | awk -F';' '{print "\"" $4 "\"; Deutschland"}' | sed "1d" | sort -u | iconv -f ISO-8859-15 -t UTF-8 > to_geocode.csv

==Monaco==

==Monaco==

==Montenegro==

==Montenegro==

==Netherlands==

==Netherlands (DONE) ==

*Data from NWA (Netherlands Food & Consumer Product Safety Authority)

*Data from NWA (Netherlands Food & Consumer Product Safety Authority)

**English (PDF): https://english-acc.nvwa.nl/documents/document/approved-establishments1/animal-byproducts

**English (PDF): https://english-acc.nvwa.nl/documents/document/approved-establishments1/animal-byproducts

==Switzerland==

==Switzerland==

==Ukraine==

==Ukraine==

==United Kingdom==

==United Kingdom (DONE) ==

*As UK is divided in 4 regions (Ireland, England, Wales and Scotland) and because they have different file format, we use a 3-file script

*As UK is divided in 4 regions (Ireland, England, Wales and Scotland) and because they have different file format, we use a 3-file script