openfoodfacts / openfoodfacts-server

Open Food Facts database, API server and web interface - 🐪🦋 Perl, CSS and JS coders welcome 😊 For helping in Python, see Robotoff or taxonomy-editor
http://openfoodfacts.github.io/openfoodfacts-server/
GNU Affero General Public License v3.0
660 stars 389 forks source link

Wrong coordinates in italian packager-codes #10694

Open Telperion87 opened 3 months ago

Telperion87 commented 3 months ago

I've found wrong coordinates in a line within https://raw.githubusercontent.com/openfoodfacts/openfoodfacts-server/main/packager-codes/IT-merge-UTF-8.csv

the line

CE IT 09 39;GELATI STOCCHI S.R.L.;142820513;142820513;VIA GALVANI 7, AREZZO (AR);PP;9 - LATTE CRUDO E DERIVATI;45.4858803;9.200136199999974

should actually be something like

CE IT 09 39;GELATI STOCCHI S.R.L.;142820513;142820513;VIA GALVANI 7, AREZZO (AR);PP;9 - LATTE CRUDO E DERIVATI;43.46724622039064;11.848645025002435

[I know that for this kind of issues a pull request should be done, but it is still beyond my knowledge. If there's a better way to point out this kind of issues, just let me know]

McCio commented 3 weeks ago

The wrong coordinates come from the open data of the health ministry itself. My guess is that those coordinates comes from searching for the address on nominatim, without restricting the search by city: in OSM the address number 7 is not present for that street in Arezzo, while it is in Milan, so nominatim matches that better.