Changes

Jump to navigation Jump to search
no edit summary
Line 45: Line 45:  
*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
Line 98: Line 98:  
==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
Line 104: Line 104:  
*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
Line 124: Line 124:  
==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
Line 142: Line 142:  
==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

Navigation menu