NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
OR
geopoint.userenteredcoord LIKE '%.|%'
</pre>
The Locale fix tool and Area Recalculation tool have problems handling userenteredcoord with many decimals. This query checks for more than 13 decimals of the X value and regional settings comma as decimal symbol.
<pre>
SELECT
geopoint.longitude,
geopoint.latitude,
userenteredcoord,
length(geopoint.userenteredcoord)
FROM
geopoint
where
INSTR(userenteredcoord, '|') - INSTR(userenteredcoord, ',') > 15 AND
userenteredcoord NOT LIKE '%.%'
</pre>
This query checks for more than 13 decimals of the X value and regional settings dot as decimal symbol.
<pre>
SELECT
geopoint.longitude,
geopoint.latitude,
userenteredcoord,
length(geopoint.userenteredcoord)
FROM
geopoint
where
INSTR(userenteredcoord, '|') - INSTR(userenteredcoord, '.') > 15 AND
userenteredcoord NOT LIKE '%,%'
</pre>
{{NavBox Upgrade}}
