NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | These rows needs to get user_entered_x and user_entered_y or user_entered_mgrs populated. NAA has UPDATE queries.}}
==Case 4 Misc odd issues that needs to be corrected==
These errors may have been caused by
* user mistakes
* user updating DEFs with ''Replace'' action when Point1 of the polygon was referring to a single point
* what-ever.
=== Case 4A One/few points of a polygon are missing frompoint_guid and user_entered===
Run this query (''DistBear Check user_entered1'') to check if you have any points that falls under Case 2. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
"public".geopoint.longitude,
"public".geopoint.latitude,
"public".geopoint.coordrefsys,
"public".geopoint.distance,
"public".geopoint.bearing,
"public".geopoint.frompoint_guid,
"public".geopoint.userinputformat,
"public".geopoint.coordformat,
"public".geopoint.user_entered_x,
"public".geopoint.user_entered_y,
"public".geopoint.user_entered_mgrs
FROM
"public".geopoint
WHERE
("public".geopoint.user_entered_x IS NULL AND
"public".geopoint.user_entered_y IS NULL AND
("public".geopoint.distance IS NOT NULL or "public".geopoint.bearing is NOT NULL)
AND ("public".geopoint.frompoint_guid IS NULL or length("public".geopoint.frompoint_guid) = 0))
OR
("public".geopoint.user_entered_mgrs IS NULL AND
"public".geopoint.coordformat = 'MGRS' AND
("public".geopoint.distance IS NOT NULL or "public".geopoint.bearing is NOT NULL)
AND ("public".geopoint.frompoint_guid IS NULL or length("public".geopoint.frompoint_guid) = 0))
</pre>
{{Note | These rows needs 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 might be necessary to change to absolute coordinates for a few cases.}}
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]