[postgis-users] edges of road - sidewalk of road

[Obe, Regina]

Look here

http://postgis.refractions.net/support/wiki/index.php?plpgsqlfunctions

I think the upgis_lineshift function does what you want.  

So to create a parallel line to right of your center line do

SELECT upgis_lineshift(line.the_geom,x) As right_line, upgis_lineshift(line.the_geom,-x) As left_line 
FROM lines


Hope that helps,
Regina



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of lisek lichu
Sent: Tue 12/16/2008 6:34 PM
To: PostGIS
Subject: [postgis-users] edges of road - sidewalk of road
 
Hello,

I have a question.
Is there any possibility to create function or something to get geometry x
meters from another?
I want to do something like a sidewalk for road. so I just have linestring
in database as a center of roads and now i want to create something like two
parallel linestrings 10 meters from center of the road so it will by my edge
of road and beginning of sidewalk.

Does anybody have an idea how to do that?

Simon



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081217/c0aecc3a/attachment.html>