[postgis-users] Split linestring into two line

[Hugues François]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130808/65e260bf/attachment.html>