Tag Info

New answers tagged

0

This worked: CREATE TABLE coastalsegments AS (SELECT ST_Line_Substring(the_geom, 1000.00*n/length, CASE WHEN 1000.00*(n+1) < length THEN 1000.00*(n+1)/length ELSE 1 END) As the_geom FROM (SELECT ST_LineMerge(coastal_shoreline.geom) AS the_geom, ST_Length(coastal_shoreline.geom) As length FROM coastal_shoreline) ) AS t CROSS JOIN ...


0

Use ST_Line_Interpolate_Point union them first to create a single complete without gaps line .



Top 50 recent answers are included