Data quality checks before upgrading to V6.0

From IMSMA Wiki
Revision as of 16:21, 6 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search

Invalid / space coordinates

It was not possible to upgrade to V5.08.04 if there are invalid coordinates in the database. Please run this SQL query anyhow because importing may overrun application rules. If you get any rows here, you have more SQL queries that will identify which object has the invalid coordinates in “Invalid_coordinates_ver2.doc” on PI.

MGRS coordinates

In V5.xxx it was possible to enter MGRS with wrong format. The query checks for coordinates written 4qfj12345678

Coordinates display rules

Length of Point ID