<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19412"></HEAD>
<BODY>
<DIV><FONT size=2 face=Arial><SPAN
class=588324907-08082013>Hello,</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=588324907-08082013></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=588324907-08082013>It is hard to give
you an answer if we don't know what exactly you are looking for and how you want
to proceed (i.e. especially what are your input data)</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=588324907-08082013>=> if you want to
extract specific substrings from your original ones, the answer of Nicola seems
to be the good one</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=588324907-08082013>=> if you want to
cut your linestring given another geometry, st_split may help you but we canno't
tell you it will be the result you are looking for since we don't have more
information about your data.</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=588324907-08082013></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=588324907-08082013>Did you make some
tests with these functions on a sample of your data ?</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=588324907-08082013></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=588324907-08082013>Hugues.</SPAN></FONT></DIV><BR>
<DIV dir=ltr lang=fr class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Saurav
Ranjit<BR><B>Sent:</B> Thursday, August 08, 2013 9:48 AM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Split
linestring into two line<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">hi </SPAN><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"> </SPAN><BR
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">i
am new to the postgis. i would like to know if there is a way to split
the </SPAN><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">linestring
into two. what i am trying to get is: i have a map with single </SPAN><FONT
face="Verdana, Geneva, Helvetica, Arial, sans-serif"> line, now i want to
show that single line into two </FONT><FONT
face="Verdana, Geneva, Helvetica, Arial, sans-serif">separate</FONT><FONT
face="Verdana, Geneva, Helvetica, Arial, sans-serif"> line parallel to each
other. </FONT><BR
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"><BR
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">Line
string looks like this. </SPAN><BR
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">"LINESTRING(120.5523267
13.7257305,120.5522595 13.7265231,120.552205 </SPAN><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">13.7270875)"</SPAN><BR
clear=all>
<DIV><BR></DIV>
<DIV><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px">can
ST_split function be used for this purpose? Is yes how it is
done?</SPAN><BR></DIV>
<DIV><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0); FONT-SIZE: 13px"><BR></SPAN></DIV>
<DIV><FONT face="Verdana, Geneva, Helvetica, Arial, sans-serif">Thanks in
advance</FONT></DIV>
<DIV><BR></DIV>Regards<BR>
<DIV dir=ltr>
<DIV><SPAN style="BACKGROUND-COLOR: rgb(255,255,255)">Saurav Ranjit</SPAN></DIV>
<DIV><BR></DIV></DIV></DIV></BODY></HTML>