look at
st_scalehttp://www.postgis.org/documentation/manual-1.4.1SVN/ST_Scale.html or
maybe
st_transscalehttp://www.postgis.org/documentation/manual-1.4.1SVN/ST_TransScale.html
/Nicklas
2009-09-08 Daniel Grum wrote:
Hy,
>
>I want to make a new line from a given line -->both geometry types are
>MULTININESTRING
>
>Every step the new line should be "x meters" shorter than the original.
>
>I get the length of the line, f.e. 5000 meters (length(the_geom)) and
>after the step the new Line should be only 4000 meters.
>
>I have a idea but it isn't ready:
>
>UPDATE table
>SET the_geom = (SELECT MakeLine(StartPoint(line.the_geom),
>EndPoint(line_merge(line.the_geom)))
> FROM public.table line
> ORDER BY line.gid);
>
>But in if I do so I have no chance to say that the new line has to be
>100meters shorter than the original line.
>
>Are there any ideas how I can solve this problem?
>
>Thanks,
>--Daniel
>_______________________________________________
>postgis-users mailing list
>[email protected]
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
