删除每行列中重复的 GPS 坐标 [英] Delete duplicates GPS coordinates in column in each row
问题描述
我有一列带有 gps 坐标，每一行都有一组地理多边形坐标.大多数线路都有重复的 gps 坐标(一列中的经度和纬度完全重合).
I have a column with gps coordinates, in each row a set of geo-polygon coordinates. Most lines have duplicate gps coordinates (complete coincidence of longitude and latitude in one column).
示例:
多多边形23.453411011874813 41.7424539513234423.453972640029299 41.7421420839074123.453977029220994 41.74182773909023323.454523642352295 41.74151586901252323.441100249526403 41.74120399633372423.441661846243466 41.74089212105391823.456223434003668 41.7405802431731723.441661846243466 41.740892121053918
MULTIPOLYGON 23.453411011874813 41.74245395132344 23.453972640029299 41.74214208390741 23.453977029220994 41.741827739090233 23.454523642352295 41.741515869012523 23.441100249526403 41.741203996333724 23.441661846243466 41.740892121053918 23.456223434003668 41.74058024317317 23.441661846243466 41.740892121053918
我需要删除重复的坐标(粗体)
I need to remove duplicate coordinates (bold)
我使用的是 teradata 16.20.32.17
I'm using teradata 16.20.32.17
谢谢！
推荐答案
看看 SimplifyPreserveTopology，它并不是完全删除重复项，但可能接近您想要的:
Have a look at SimplifyPreserveTopology, it's not exactly removing duplicates, but probably close to what you want:
通过删除落入某个范围内的点来简化几何图形指定的距离容差.
Simplifies a geometry by removing points that would fall within a specified distance tolerance.
简化总是返回一个有效的几何.简化的几何形状需要更少的存储空间和地理空间操作期间的空间操作更少.最后对简化几何的操作通常执行得更快.较小公差值导致几何更接近输入几何，但会移除更少的顶点.较大的公差值将消除更多的顶点，但生成的简化几何体会更少类似于原始输入.
The simplification always returns a valid geometry. Simplified geometries require less storage space and fewer spatial operations during geospatial manipulations. Consequently operations on simplified geometries generally perform faster. Smaller tolerance values result in a geometry closer to the input geometry, but will remove fewer vertices. Larger tolerance values will remove more vertices, but the resulting simplified geometry will be less similar to the original input.
这篇关于删除每行列中重复的 GPS 坐标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
