NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
This query shows the different combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' used in the database.
# Verify that all combinations are correct, if not they need to be corrected.
LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) <> 2
and coordformat = 'Degrees:Decimal Minutes'
</pre>
This query identifies coordinates where distance and bearing has been migrated from Legacy as extra information
<pre>
SELECT
geopoint_guid,
longitude,
latitude,
bearing,
distance,
frompoint_guid,
coordrefsys,
userinputformat,
coordformat,
poly.enumvalue
FROM
geopoint
INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN imsmaenum AS poly ON geospatialinfo.shapeenum_guid = poly.imsmaenum_guid
WHERE
(distance IS NOT NULL AND
bearing IS NOT NULL) AND
(frompoint_guid IS NULL OR length(frompoint_guid) = 0 )
ORDER BY
geopoint.geospatialinfo_guid ASC,
pointno ASC
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]