NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Rewrite| This page in under re-write/construction.<br/>There are three 5 different cases; the cases are a mix of what needs to be checked '''before''' upgrade, '''after''' upgrade and for countries that have used 6.0.}}There are five different cases of found issues with Distance and Bearing
# migrated data that may not have FromPointGUID set
# upgraded data from version 5 that will not have user_entered coordinates
# a few cases where one point of a polygon where missing FromPointGUID and/or user_entered coordinates
# distance = 0 and length(frompoint_guid)=0
# wrong format of MGRS (ICR-368)NAA has found all four cases case 1-4 in Sri Lankaand have select + update queries for them.
Case 2 First run this query to see if there is any coordinates that use '''Distance and bearing''' and do not have user_entered coordinates.
