Changes

Check coordinates distance and bearing

762 bytes added, 12:42, 13 March 2016

Created page with "Fist run this query to see if there is any coordinates that use '''Distance and bearing'''. <pre> SELECT geopoint.coordrefsys, geopoint.coordformat, geopoint.userinputformat,..."

Fist run this query to see if there is any coordinates that use '''Distance and bearing'''.
<pre>
SELECT
geopoint.coordrefsys,
geopoint.coordformat,
geopoint.userinputformat,
Count(geopoint.geopoint_guid)
FROM
geopoint
GROUP BY
geopoint.coordrefsys,
geopoint.coordformat,
geopoint.userinputformat
ORDER BY
geopoint.coordrefsys ASC,
geopoint.coordformat ASC,
geopoint.userinputformat ASC
</pre>

If there are any with userinputformat '''Bearing and Distance''' then you MUST update them.
<pre>
UPDATE geopoint
SET
user_entered_x = longitude,
user_entered_y = latitude

WHERE
bearing IS NOT NULL AND
distance IS NOT NULL AND
user_entered_x IS NULL AND
user_entered_y IS NULL
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits