[postgis-users] Split linestring into two line

[Saurav Ranjit]

Hi Hugues,
Thanks for your reply.

This is what i am trying to do.[image: Inline image 1]

I have a single line string as shown in the figure above. I want to split
this line as shown in figure below.
[image: Inline image 2]
i need to split a single line into two line in postgis. I am not sure if
this can be done or not.
Hope you get my point.

Thanks again

Saurav





On Thu, Aug 8, 2013 at 2:55 PM, Hugues François
<hugues.francois at irstea.fr>wrote:

> **
> Hello,
>
> 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)
> => if you want to extract specific substrings from your original ones, the
> answer of Nicola seems to be the good one
> => 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.
>
> Did you make some tests with these functions on a sample of your data ?
>
> Hugues.
>
>  ------------------------------
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Saurav Ranjit
> *Sent:* Thursday, August 08, 2013 9:48 AM
> *To:* postgis-users at lists.osgeo.org
> *Subject:* [postgis-users] Split linestring into two line
>
>  hi
> i am new to the postgis. i would like to know if there is a way to split
> the linestring into two. what i am trying to get is: i have a map with
> single  line, now i want to show that single line into two separate line
> parallel to each other.
>
> Line string looks like this.
> "LINESTRING(120.5523267 13.7257305,120.5522595 13.7265231,120.552205
> 13.7270875)"
>
> can ST_split function be used for this purpose? Is yes how it is done?
>
> Thanks in advance
>
> Regards
>  Saurav Ranjit
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>


-- 
Saurav Ranjit
Master's Student in Engineering of Remote Sensing and Geographic
Information Systems (RSGIS)
School of Engineering and Technology (SET)
Asian Institute of Technology (AIT)
Thailand
Mobile: (+66) 800544946
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130808/e9f2db40/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 20010 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130808/e9f2db40/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 22661 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130808/e9f2db40/attachment-0001.png>