Is there some way in PostGIS to interpolate missing M coordinates in a geometry like this?
select ST_MakeLine(ARRAY[ ST_MakePointM (0, 1, 10), ST_MakePoint (0, 2), ST_MakePoint (0, 3), ST_MakePointM (0, 4, 40)])Where the expected result would be:
LINESTRING M (0 1 10, 0 2 20, 0 3 30, 0 4 40)
I found ST_AddMeasure, but that overrides existing values. I want to interpolate any missing values along the line. Some values are possibly already there (at least start and end).
أكثر...
select ST_MakeLine(ARRAY[ ST_MakePointM (0, 1, 10), ST_MakePoint (0, 2), ST_MakePoint (0, 3), ST_MakePointM (0, 4, 40)])Where the expected result would be:
LINESTRING M (0 1 10, 0 2 20, 0 3 30, 0 4 40)
I found ST_AddMeasure, but that overrides existing values. I want to interpolate any missing values along the line. Some values are possibly already there (at least start and end).
أكثر...