mailto:postgis-users-boun...@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
ok i found it :)
http://www.freemapload.de/article.php?id=17930&group=gmane.comp.gis.postgis
there is the same function but without bugs and it works. I checked already.
It is fine
thanks a lot
Simon
___
postgis-users mailing list
postgis-users@postgis.
er 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 me
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 ),
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 l
