NoPublic, bureaucrat, administrator
4,913
edits
Changes
→Case 4 Miscellaneous odd issues that needs to be corrected
{{Warning | New(?) variation of Case 1 which we are currently investigating. We need better knowledge on how did the problem occurred before fixing a few records.}}
==Case 4 Miscellaneous odd issues that needs need to be corrected==
These errors may have been caused by
* user mistakes
'' How to see if Case 4A exists: It is not possible to open Geospatial tab in the Summary window and the DEF looks like this ''
</div>
Run this query (''DistBear Check user_entered2'') to check if you have any points that falls fall under Case 4A. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
</pre>
{{Note | These rows needs need to get user_entered_x and user_entered_y or user_entered_mgrs '''and''' frompoint_guid populated. NAA has UPDATE queries which may be applied to some of the above records but there it might be necessary to change to absolute coordinates for a few cases.}}
=== Case 4B Distance = 0===
To have Distance = 0 may cause calculation errors. Run this query (''DistBear Check dist 0'') to check if you have any points that falls fall under Case 4B. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
</pre>
{{Note | These rows needs need to be investigated manually but most likely both distance and bearing should be deleted. Most like likely they also have length(frompoint_guid) <nowiki>= 0</nowiki> too. NAA has UPDATE queries.}}
=== Case 4C length(frompoint_guid) = 0===
'' Difference between length = 0 and NULL''
</div>
These records are likely to be the same as found for Case 4B and could be orphans as well be orphans. Run this query (''DistBear Check length FromPointGUID'') to check if you have any points that falls fall under Case 4C. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
</pre>
{{Note | These rows needs need to be investigated manually. NAA has UPDATE queries.}}
=== Case 4D One of Distance / Bearing is null===
Run this query (''DistBear Check bear dist NULL'') to check if you have any points that falls fall under Case 4D. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
</pre>
{{Note | These rows needs need to be investigated and updated manually. }}
==Case 5 Calculated MGRS contains spaces ==
