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-07-18 15:45:25 发布