<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [postgis-users] edges of road - sidewalk of road</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Look here<BR>
<BR>
<A HREF="http://postgis.refractions.net/support/wiki/index.php?plpgsqlfunctions">http://postgis.refractions.net/support/wiki/index.php?plpgsqlfunctions</A><BR>
<BR>
I think the upgis_lineshift function does what you want. <BR>
<BR>
So to create a parallel line to right of your center line do<BR>
<BR>
SELECT upgis_lineshift(line.the_geom,x) As right_line, upgis_lineshift(line.the_geom,-x) As left_line<BR>
FROM lines<BR>
<BR>
<BR>
Hope that helps,<BR>
Regina<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of lisek lichu<BR>
Sent: Tue 12/16/2008 6:34 PM<BR>
To: PostGIS<BR>
Subject: [postgis-users] edges of road - sidewalk of road<BR>
<BR>
Hello,<BR>
<BR>
I have a question.<BR>
Is there any possibility to create function or something to get geometry x<BR>
meters from another?<BR>
I want to do something like a sidewalk for road. so I just have linestring<BR>
in database as a center of roads and now i want to create something like two<BR>
parallel linestrings 10 meters from center of the road so it will by my edge<BR>
of road and beginning of sidewalk.<BR>
<BR>
Does anybody have an idea how to do that?<BR>
<BR>
Simon<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>