WITH SplitLines AS (
SELECT
"osm_id", "code", "fclass", "width", "name",
ST_AsText(ST_MakeLine(ST_PointN("geom", generate_series(1, ST_NPoints("geom") - 1)),
ST_PointN("geom", generate_series(2, ST_NPoints("geom"))))) AS geom
FROM "public"."lineriver3"
)
SELECT * FROM SplitLines;
怎么把geom里面的MutipleLinestring转linestring
最新推荐文章于 2024-12-30 10:11:51 发布
本文介绍了如何使用SQL查询从lineriver3表中提取osm_id,code,fclass等字段以及生成由几何点组成的Linestring(geom),并展示了ST_AsText,ST_MakeLine和ST_PointN函数的运用。
471

被折叠的 条评论
为什么被折叠?



