Point ID Length: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into | This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into | ||
<pre> | <pre> | ||
SELECT | SELECT | ||
Count(geopoint_guid), | Count(geopoint_guid), | ||
length(pointlocal_id) | length(trim(pointlocal_id)) | ||
FROM | FROM | ||
geopoint | geopoint | ||
GROUP BY | GROUP BY | ||
length(pointlocal_id) | length(trim(pointlocal_id)) | ||
ORDER by length(pointlocal_id) | ORDER by length(trim(pointlocal_id)) | ||
</pre> | </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:NoPublic]] | ||
[[Category:SQL Queries]] | [[Category:SQL Queries]] | ||
Revision as of 19:31, 12 February 2014
This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into
SELECT Count(geopoint_guid), length(trim(pointlocal_id)) FROM geopoint GROUP BY length(trim(pointlocal_id)) ORDER by length(trim(pointlocal_id))
This query checks the Point ID with length 2
SELECT DISTINCT trim(pointlocal_id) FROM geopoint where length(trim(pointlocal_id) )= 2 ORDER by pointlocal_id