6,724
edits
Changes
Jump to navigation
Jump to search
Line 83:
Line 83: + + + + + + + + + + + + + + Line 89:
Line 103: − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 95:
Line 148: + + + − ==DE== − *@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 − ==NL== − *Data from NWA (Netherlands Food & Consumer Product Safety Authority) − **English (PDF): https://english-acc.nvwa.nl/documents/document/approved-establishments1/animal-byproducts − *A nice map with all the companies with approval from Netherlands under the EU regulation: http://www.alteconomics.fr/Leaflet
Food Traceability Codes/EU Food establishments (view source)
Revision as of 10:40, 8 December 2016
, 10:40, 8 December 2016no edit summary
*https://opencorporates.com/
*https://opencorporates.com/
==Albania==
==Andorra==
==Austria==
==Belarus==
==Belgium==
==Bosnia and Herzegovina==
==Bulgaria==
==Croatia==
==Cyprus==
==Czech Republic==
==Denmark==
==Estonia==
==Faroe Islands==
==Finland==
==France==
==France==
*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)
*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/
==UK==
==Germany==
*@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
==Gibraltar==
==Greece==
==Hungary==
==Iceland==
==Ireland==
==Isle of Man==
==Italy==
==Kosovo==
==Latvia==
==Liechtenstein==
==Lithuania==
==Luxembourg==
==Macedonia==
==Malta==
==Moldova==
==Monaco==
==Montenegro==
==Netherlands==
*Data from NWA (Netherlands Food & Consumer Product Safety Authority)
**English (PDF): https://english-acc.nvwa.nl/documents/document/approved-establishments1/animal-byproducts
*A nice map with all the companies with approval from Netherlands under the EU regulation: http://www.alteconomics.fr/Leaflet
==Norway==
==Poland==
==Portugal==
==Romania==
@lucaa is doing it
==Russia==
==San Marino==
==Serbia==
==Slovakia==
==Slovenia==
==Spain==
==Sweden==
==Switzerland==
==Ukraine==
==United Kingdom==
*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
**https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/UK-urls.txt => all UK urls
**https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/UK-urls.txt => all UK urls
**https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/UK-script.py => the script itself
**https://github.com/openfoodfacts/eu-food-data/blob/master/scripts/UK-script.py => the script itself
*Source: Food Standards Agency - http://www.food.gov.uk/business-industry/meat/audit
*Source: Food Standards Agency - http://www.food.gov.uk/business-industry/meat/audit
==Vatican city==
==Yugoslavia==
==Inspiration==
==Inspiration==