NoPublic, bureaucrat, administrator
4,913
edits
Changes
no edit summary
These queries are for databases that have been '''upgraded''' to 6.0 and for which distance and bearing was '''not''' fixed during the upgrade process. This '''[[Check coordinates distance and bearing | page]]''' contains checks to be run '''before and after''' upgrade to 6.0.
{{Warning | The [[:File:DistBearing.zip|queries ]] are SELECT queries that will help you identify if the database has any Distance and bearing issues. UPDATE queries that correct the problem is then needed to correct the database. A tool (e.g. Google Earth Pro) that could calculate longitude/latitude and/or distance/bearing between points might also be needed.}}
==Which database columns should have values / How it should look like==