[postgis-users] Transforming Linestring to Multipoint

[Mehmet Sirin]

:D Okay, I think this is what I need! I never thought it would be that
simple!

thanks!!

2009/9/27 strk <strk at keybit.net>

> On Sun, Sep 27, 2009 at 10:47:40PM +0200, Mehmet Sirin wrote:
>
> > so:  transforming LINESTRING ( x1 y1, x2 y2, x3 y4 ) to LINESTRING ( x1
> y1,
> > x2 y2, x3 y4, x4 y4, x5 y5, ... ) but it is the same line!
> > Why doing all this stuff? I just want to find out the center of that
> > linestring^^
>
> How about this:
>
>  SELECT ST_Line_Interpolate_Point(line, 0.5);
>
>
> http://postgis.refractions.net/documentation/manual-svn/ST_Line_Interpolate_Point.html
>
> --strk;
>
>
> --
>
>  Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
>  http://foo.keybit.net/~strk/services.html<http://foo.keybit.net/%7Estrk/services.html> /\  Keep it simple!
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090927/1ae1b28a/attachment.html>