Changes

Point ID Length

188 bytes added, 20:31, 12 February 2014

no edit summary

This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into.

<pre>

SELECT

Count(geopoint_guid),

length(trim(pointlocal_id))

FROM

geopoint

GROUP BY

length(trim(pointlocal_id))ORDER by length(trim(pointlocal_id))

</pre>

This query checks the Point ID with length 2

<pre>

SELECT DISTINCT

trim(pointlocal_id)

FROM

geopoint

where length(trim(pointlocal_id) )= 2

ORDER by pointlocal_id

</pre>

[[Category:NoPublic]]

[[Category:SQL Queries]]

6,632

edits