[postgis-users] Split / Divide linestring into parts / segments ?

[Paragon Corporation]

Grant,
We have an example something like this in the docs. Look at the example that
cuts a linestring into 100 unit length segments.  In your case if your SRID
is in meters you should be able to change the 100 to 30.
 
http://www.postgis.org/documentation/manual-svn/ST_Line_Substring.html
 
Not quite sure its what you are looking for but sounds like it . 
Hope that helps,
Regina

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Grant
Masan
Sent: Tuesday, October 13, 2009 1:39 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Split / Divide linestring into parts / segments ?


Hi all, 

I am having this kind of problem that I have one linestring("door") and then
I am searching how many linestrings has intersect the linestring("door").
I am getting the intersections thats not a problem. What I need is to split
/ divide this "door" linestring to segments or parts or what ever...
So my goal is to devide "door" into 30 different parts (like if door is
30meters then I need thirty 1meter pieces). Then I can calculate how many
linestrings are intersecting door
and in what part of door.

                                linestring "door"

<----1------><-----2-----><------3------><-------5-----><-----6-------> and
so on ...

Hope you guys undestood my need and somebody can help me little bit !

Thanks mates

Br.
Grant
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091013/3afd37d9/attachment.html>