How about the example here?
Z and M should be supported.
https://postgis.net/docs/manual-1.5/ST_Line_Substring.html
--The below example simulates a while loop in
--SQL using PostgreSQL generate_series() to cut all
--linestrings in a table to 100 unit segments
-- of which no segment is longer
I tried to use st_segmentize but found that the m coordinate gets corrupted.
Get BlueMail for Android
On Feb 15, 2020, 12:50 PM, at 12:50 PM, Phil Bartie
wrote:
>Would ST_Segmentize() do what you are after?
> Run it after the simplify.
>
>https://postgis.net/docs/ST_Segmentize
>
>Might need
Douglas-Peucker simplification doesn't split segments, it only creates
longer ones. So not sure what behaviour you are seeing with it?
Can you post an example?
On Sat, Feb 15, 2020, 10:44 AM Alexander Gataric wrote:
> I mean if a line is one mile long and is simplified into five 1000 foot
>
Would ST_Segmentize() do what you are after?
Run it after the simplify.
https://postgis.net/docs/ST_Segmentize
Might need to use in conjunction with ST_Union()
On Sat, 15 Feb 2020 at 18:44, Alexander Gataric wrote:
> I mean if a line is one mile long and is simplified into five 1000 foot
I mean if a line is one mile long and is simplified into five 1000 foot
segments, I want the longest segment to be 500 feet instead of 1000 feet.
Get BlueMail for Android
On Feb 15, 2020, 11:47 AM, at 11:47 AM, Martin Davis wrote:
>You mean you want to keep simplifying until there are no
You mean you want to keep simplifying until there are no segments of length
greater than the maximum? (Presumably excluding input segments already
longer?)
On Fri, Feb 14, 2020, 1:57 PM Alexander Gataric wrote:
> Is there a way to modify st_simplify to have a maximum segment length? I
> want
Is there a way to modify st_simplify to have a maximum segment length? I want
to be able to limit it to 500 feet.
Get BlueMail for Android
On Feb 14, 2020, 1:13 PM, at 1:13 PM, Regina Obe wrote:
>gdal_translate does not have a PostGIS raster writer (or at least not
>last time I checked).