Thanks Brent,

Happy Christmas / New Year to you as well!

On 23/12/2010, at 2:07 PM, pcr...@pcreso.com wrote:

> 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

Lines are roads, so they go every which way. 

> 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
> 
> For more complex shifting of features, probably overkill in your case, see
> http://postgis.refractions.net/documentation/manual-svn/ST_Affine.html

This might be what I am after, but I was thinking of somehow translating each 
segment parallel to it's current alignment and then rejoining with a nice 
smooth curve... kind of like a 1-sided buffer.

cheers

Ben





> --- 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

Reply via email to