<div dir="ltr">Hi Hugues,<div>Thanks for your reply.</div><div><br></div><div>This is what i am trying to do.<img src="cid:ii_1405d01c2b5a05e5" alt="Inline image 1" width="902" height="340"></div><div><br></div><div>I have a single line string as shown in the figure above. I want to split this line as shown in figure below.</div>
<div><img src="cid:ii_1405d03423a92355" alt="Inline image 2"><br></div><div>i need to split a single line into two line in postgis. I am not sure if this can be done or not.</div><div>Hope you get my point. </div><div><br>
</div><div>Thanks again</div><div><br></div><div>Saurav</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 8, 2013 at 2:55 PM, Hugues François <span dir="ltr"><<a href="mailto:hugues.francois@irstea.fr" target="_blank">hugues.francois@irstea.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div><font face="Arial"><span>Hello,</span></font></div>
<div><font face="Arial"><span></span></font> </div>
<div><font face="Arial"><span>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 face="Arial"><span>=> 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 face="Arial"><span>=> 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 face="Arial"><span></span></font> </div>
<div><font face="Arial"><span>Did you make some
tests with these functions on a sample of your data ?</span></font></div>
<div><font face="Arial"><span></span></font> </div>
<div><font face="Arial"><span>Hugues.</span></font></div><br>
<div dir="ltr" lang="fr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Saurav
Ranjit<br><b>Sent:</b> Thursday, August 08, 2013 9:48 AM<br><b>To:</b>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] Split
linestring into two line<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr"><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">hi </span><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"> </span><br style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">
<span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">i
am new to the postgis. i would like to know if there is a way to split
the </span><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">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-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"><br style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">Line
string looks like this. </span><br style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">"LINESTRING(120.5523267
13.7257305,120.5522595 13.7265231,120.552205 </span><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">13.7270875)"</span><br clear="all">
<div><br></div>
<div><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">can
ST_split function be used for this purpose? Is yes how it is
done?</span><br></div>
<div><span style="font-size:13px;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"><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>Saurav Ranjit</span></div>
<div><br></div></div></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div><span style="background-color:rgb(255,255,255)"><font color="#000000">Saurav Ranjit</font></span></div><div><span style="color:rgb(0,0,0)">Master's Student in Engineering of Remote Sensing and Geographic Information Systems (RSGIS)</span></div>
<div><span style="color:rgb(0,0,0)">School of Engineering and Technology (SET)</span></div><div><div><span style="background-color:rgb(255,255,255)"><font color="#000000">Asian Institute of Technology (AIT)</font></span></div>
<div><span style="color:rgb(0,0,0)">Thailand</span></div><div><span style="color:rgb(0,0,0)">Mobile: (+66) 800544946</span></div></div></div>
</div>