[postgis-users] Transforming Linestring to Multipoint

Pavel Iacovlev iacovlev.pavel at gmail.com
Sun Sep 27 11:09:12 PDT 2009


pointn(
	geometryn(the_geom, 1),
	generate_series(1, numpoints(geometryn(the_geom, 1)))
)

On Sun, Sep 27, 2009 at 8:09 PM, Mehmet Sirin <m.sirin07 at googlemail.com> 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 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 not I thought of something like this: 1.appoint bbox of the linestring
> 2.divide the bbox area into a grid (lets say 32 boxes) 3.use
> line_interpolate_point function to get some intersections 4.save
> intersection as new multipoint ... ??
>
> ...you can say I'm a beginner in using postgis and stuff like that.
>
>
>
> i would appreciate your help!!
>
> Best regards
> Mehmet Sirin
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
http://iap.md, The future is open



More information about the postgis-users mailing list