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