Hey Ben... Seasons greetings!!
You have a couple of options: ST_Translate() is the simplest, but if your lines are horizontal you may want a Y shift as well? http://postgis.refractions.net/documentation/manual-svn/ST_Translate.html Having done this, I suggest you also use ST_reverse() to reflect the direction is now going the other way (unless it already is :-) http://postgis.refractions.net/documentation/manual-svn/ST_Reverse.html Cheers, Brent For more complex shifting of features, probably overkill in your case, see http://postgis.refractions.net/documentation/manual-svn/ST_Affine.html --- On Thu, 12/23/10, Ben Madin <li...@remoteinformation.com.au> wrote: From: Ben Madin <li...@remoteinformation.com.au> Subject: [postgis-users] Shifting linestrings left To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net> Date: Thursday, December 23, 2010, 3:13 PM G'day all, I have a problem where I am trying to show the route of livestock movements, but I am loosing information when the travel along the same road in different directions (ie in some cases they travel from a saleyard to a feedlot, then back to the saleyard after a period). The roads they travel along are single linestrings. Is there a way to 'shift' the linestring to the left - after all, that would be sensible side of the road to drive on... cheers Ben _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
