NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
=== Case 1A===
Run this query (''DistBear Missing FromPoint Point1'') to check if you have any points that falls under Case 1A. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
"public".geopoint.user_entered_x,
"public".geopoint.user_entered_y,
"public".geopoint.user_entered_mgrs,
"public".geopoint.coordrefsys,
"public".geopoint.userinputformat,
=== Case 1B===
Run this query (''DistBear Missing FromPoint Point2'') to check if you have any points that falls under Case 1A1B. This query is '''NOT''' tested with MGRS.
<pre>
SELECT
"public".geopoint.user_entered_x,
"public".geopoint.user_entered_y,
"public".geopoint.user_entered_mgrs,
"public".geopoint.pointno,
"public".geopoint.userinputformat,
==Case 2 Coordinates entered with 5.x and upgraded to 6.0==
These records have been entered into the database with 5.x and upgraded to 6.0 by the upgrade functionality provided by Novetta. But the upgrade funtionality does '''not''' set geopoint.user_entered_x and geopoint.user_entered_y or user_entered_mgrs for records with '''Bearing and Distance''' as userinputformat. This causes problems with 6.0. 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.coordformat,"public".geopoint.userinputformat,"public".geopoint.user_entered_x,"public".geopoint.user_entered_y,"public".geopoint.user_entered_mgrsFROM"public".geopointWHERE(("public".geopoint.user_entered_x IS NULL ORlength("public".geopoint.user_entered_x) = 0 OR"public".geopoint.user_entered_y IS NULL ORlength("public".geopoint.user_entered_y) = 0 ) and("public".geopoint.distance IS NOT NULL or "public".geopoint.bearing is NOT NULL)AND ("public".geopoint.frompoint_guid IS NOT NULL))OR(("public".geopoint.user_entered_mgrs IS NULL ORlength("public".geopoint.user_entered_mgrs) = 0) 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 NOT NULL))ORDER BY"public".geopoint.userinputformat ASC</pre> {{Note | These rows needs to get user_entered_x and user_entered_y or user_entered_mgrs populated. NAA has UPDATE queries.}}
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]