[postgis-users] Split linestring into two line

[Hugues François]

Hi,
 
In this case, last answer from Nicolas is the good one !
 
St_OffsetCurve returns "an offset line at a given distance and side from an input line"

Give it a try !

Regards,

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 10:27 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Split linestring into two line


Hi Hugues, 
Thanks for your reply.

This is what i am trying to do.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.
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