Changes

Jump to navigation Jump to search
Line 18: Line 18:  
* French EMB codes: http://agriculture.gouv.fr/liste-des-etablissements-agrees-ce
 
* 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
 
* Greek GR codes: http://www.efet.gr/portal/page/portal/efetnew/enterprises/facilities
 +
* Spanish RGSEAA codes: http://rgsa-web-aesan.msssi.es/rgsa/formulario_ue_js.jsp
 
* other countries packaging codes
 
* other countries packaging codes
   Line 45: Line 46:  
*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 83: Line 84:  
*Infogreffe
 
*Infogreffe
 
*https://opencorporates.com/
 
*https://opencorporates.com/
 +
 +
 +
{| class="wikitable"
 +
! Country
 +
! Owner
 +
! Source format
 +
! Status
 +
! Output
 +
! Deployed ?
 +
! Remarks
 +
|-
 +
| Austria
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Belgium
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Bulgaria
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Croatia
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Cyprus
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|Czech Republic
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|Denmark
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Estonia
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Finland
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| France
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Germany
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Greece
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Hungary
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Ireland
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Italy
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Latvia
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|Lithuania
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Luxembourg
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Malta
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Netherlands
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Poland
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Portugal
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Romania
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Slovakia
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Slovenia
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
| Spain
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
    
==Albania==
 
==Albania==
 +
 
==Andorra==
 
==Andorra==
 
==Austria==
 
==Austria==
Line 98: Line 320:  
==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 326:  
*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 114: Line 336:  
==Isle of Man==
 
==Isle of Man==
 
==Italy==
 
==Italy==
 +
Geocoded version by Tacite : https://openfoodfacts.slack.com/archives/C02LB7AV0/p1494497561131004 <br/>
 +
Source (no geocoding) is at http://www.salute.gov.it/consultazioneStabilimenti/ConsultazioneStabilimentiServlet?ACTION=gestioneSingoloPaese&naz=CL <br/>
 +
Note: There is an alternative version with more than 6500 codes available that includes artisan raw milk codes that we're not likely to see on OFF for now. In an effort to get a working version with geocoding quickly, I didn't use it.
 +
 
==Kosovo==
 
==Kosovo==
 
==Latvia==
 
==Latvia==
Line 124: Line 350:  
==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 (site): https://english.nvwa.nl/topics/approved-establishments
*A nice map with all the companies with approval from Netherlands under the EU regulation: http://www.alteconomics.fr/Leaflet
+
* EU
 +
**English EU: https://webgate.ec.europa.eu/tracesnt/directory/publication/establishment/index#!/search?classificationSectionChapter=food&countryCode=NL&sort=classificationSection.translation
 +
 
 
==Norway==
 
==Norway==
 
==Poland==
 
==Poland==
Line 136: Line 364:  
==San Marino==
 
==San Marino==
 
==Serbia==
 
==Serbia==
 +
https://openfoodfacts.slack.com/files/bojackhorseman/F59PY4CR1/version1.csv
 +
 
==Slovakia==
 
==Slovakia==
 
==Slovenia==
 
==Slovenia==
Line 142: Line 372:  
==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
3,393

edits

Navigation menu