<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18294" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009>Grant,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009><A
href="http://www.postgis.org/documentation/manual-svn/ST_Line_Substring.html">http://www.postgis.org/documentation/manual-svn/ST_Line_Substring.html</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009>Not quite sure its what you are looking for but sounds
like it . </SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009>Hope that helps,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=896324618-13102009>Regina</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Grant
Masan<BR><B>Sent:</B> Tuesday, October 13, 2009 1:39 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Split /
Divide linestring into parts / segments ?<BR></FONT><BR></DIV>
<DIV></DIV>Hi all,
<DIV><BR></DIV>
<DIV>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").</DIV>
<DIV>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...</DIV>
<DIV>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</DIV>
<DIV>and in what part of door.</DIV>
<DIV><BR></DIV>
<DIV>
linestring "door"</DIV>
<DIV><BR></DIV>
<DIV><----1------><-----2-----><------3------><-------5-----><-----6------->
and so on ...</DIV>
<DIV><BR></DIV>
<DIV>Hope you guys undestood my need and somebody can help me little bit !</DIV>
<DIV><BR></DIV>
<DIV>Thanks mates</DIV>
<DIV><BR></DIV>
<DIV>Br.</DIV>
<DIV>Grant</DIV></BODY></HTML>