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

Obe, Regina robe.dnd at cityofboston.gov
Wed Dec 17 04:22:00 PST 2008


That's the problem with the wiki or my inability to use it.  Try
stripping every where you see ?
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
lisek lichu
Sent: Wednesday, December 17, 2008 6:41 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] edges of road - sidewalk of road


Thanks,

I have my geom in table named segments. 
I added upgis_lineshift function to my database and after use 

SELECT upgis_lineshift(the_geom,10) As right_line from segments;

I get message like this:

ERROR:  column "st_startpoint" does not exist
LINE 1: SELECT  ST_Azimuth(ST_StartPoint?( $1 ), ST_EndPoint?( $1 ))

so I checked:

select AsText(ST_StartPoint(the_geom)) from segments;

and I get

              astext
---------------------------------
 POINT(-8.593025208 41.180818082)
 POINT(-8.594827652 41.187632944)
 POINT(-8.591823578 41.193090782)
 POINT(-8.611950874 41.190119708)
 POINT(-8.613796234 41.179203081)
 POINT(-8.602809906 41.180559684)
(6 rows)

so ST_StartPoint exists and works well.

I don't know what is goin on :P








-----------------------------------------
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/8652b498/attachment.html>


More information about the postgis-users mailing list