search

emka / openstreetbugs

OpenStreetBugs (deprecated)
http://wiki.openstreetmap.org/wiki/OpenStreetBugs
GNU General Public License v3.0
17 stars 5 forks source link

precisions of coordinates are insufficient for areas over 100 degree. #14

Closed nazotoko closed 14 years ago

nazotoko commented 15 years ago

A user in Japan reported me that bug markers always shift about 50 meters west or east after submitting it. It does not depend on Browsers. From a sources, create-database.sql, OSB deals longitudes and latitudes as float value. Obviously, significant figures of them are small for areas of which longitude is over 100 degrees. The significant figure of float type is 6 digits, which means that the minimum unit of latitude is 0.001 degrees (about 100 m) in areas over 100 degree. It is useless to point a map feature. Could you increase precisions of latitude and longitude on database, to double type or int(10) type?

emka commented 14 years ago

changed lat&lon to double

nazotoko commented 14 years ago

Thank you. I have checked that it works correct.