If you want 2 separate, parallel lines, from one input line, st_offsetCurve may help: http://postgis.net/docs/manual-2.0/ST_OffsetCurve.html
Nicolas On 8 August 2013 09:55, 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 > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
