Line 83: |
Line 83: |
| *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) |
Line 89: |
Line 103: |
| *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 |
Line 95: |
Line 148: |
| **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== |
| + | |
| | | |
− | ==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
| |
| | | |
| ==Inspiration== | | ==Inspiration== |