<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=560212112-17122008><FONT face=Arial
color=#0000ff size=2>That's the problem with the wiki or my inability to use
it. Try stripping every where you see ?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=560212112-17122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=560212112-17122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>lisek
lichu<BR><B>Sent:</B> Wednesday, December 17, 2008 6:41 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] edges of road - sidewalk
of road<BR></FONT><BR></DIV>
<DIV></DIV>Thanks,<BR><BR>I have my geom in table named segments. <BR>I added
upgis_lineshift function to my database and after use <BR><BR><SPAN
style="FONT-FAMILY: courier new,monospace">SELECT upgis_lineshift(the_geom,10)
As right_line from segments;</SPAN><BR><BR>I get message like this:<BR><BR><SPAN
style="FONT-FAMILY: courier new,monospace">ERROR: column "st_startpoint"
does not exist</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace">LINE 1: SELECT
ST_Azimuth(ST_StartPoint?( $1 ), ST_EndPoint?( $1 ))</SPAN><BR><BR>so I
checked:<BR><BR><SPAN style="FONT-FAMILY: courier new,monospace">select
AsText(ST_StartPoint(the_geom)) from segments;</SPAN><BR><BR>and I
get<BR><BR><SPAN
style="FONT-FAMILY: courier new,monospace">
astext</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace">---------------------------------</SPAN><BR
style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.593025208
41.180818082)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.594827652
41.187632944)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.591823578
41.193090782)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.611950874
41.190119708)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.613796234
41.179203081)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace"> POINT(-8.602809906
41.180559684)</SPAN><BR style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: courier new,monospace">(6 rows)</SPAN><BR><BR>so
ST_StartPoint exists and works well.<BR><BR>I don't know what is goin on
:P<BR><BR><BR><BR><BR><BR></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>