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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of Saurav Ranjit Sent: Thursday, August 08, 2013 9:48 AM To: [email protected] 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 [email protected] 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 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
