Re: [postgis-users] Transforming Linestring to Multipoint

2009-09-27 Thread Mehmet Sirin
:D Okay, I think this is what I need! I never thought it would be that simple! thanks!! 2009/9/27 strk > 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

Re: [postgis-users] Transforming Linestring to Multipoint

2009-09-27 Thread strk
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

Re: [postgis-users] Transforming Linestring to Multipoint

2009-09-27 Thread Mehmet Sirin
> pointn( > geometryn(the_geom, 1), > generate_series(1, numpoints(geometryn(the_geom, 1))) > ) > Hi, that means if there is a Linestring, e.g. LINESTRING ( x1 y1, x2 y2, x3 y4 ) this function will Return 3 Points. But my itention was: If I have a LINESTRING ( x1 y1, x2 y2, x3 y4 ), I want to a

Re: [postgis-users] Transforming Linestring to Multipoint

2009-09-27 Thread Pavel Iacovlev
pointn( geometryn(the_geom, 1), generate_series(1, numpoints(geometryn(the_geom, 1))) ) On Sun, Sep 27, 2009 at 8:09 PM, Mehmet Sirin wrote: > Hi guys! > > I wonder if there is a simple or reasonable possibility to make a specific > amount of POINTS out of a LINESTRING or MULTILIN

[postgis-users] Transforming Linestring to Multipoint

2009-09-27 Thread Mehmet Sirin
Hi guys! I wonder if there is a simple or reasonable possibility to make a specific amount of POINTS out of a LINESTRING or MULTILINESTRING? I have some some Linestrings and now I want to transform these to a couple of Points. Is it possible, that means is there already an useable function? If