[postgis-users] Re: Blank PostGIS Layer in MapServer

2008-12-17 Thread Ben Madin
G'day all,A quick cross posting - I reply to myself - (thanks to Venkat for the suggestion, albeit not successful)I am having generally excellent results with MapServer 5.2, but I am having a problem with a postgis line layer not displaying, and no suggestion that it shouldn't from the logs.This wa

Re: [postgis-users] pgrouting

2008-12-17 Thread searchelite
Pedro Doria Meunier wrote: > > Daniel's solution was completely adequate. > Remember that your vehicle location might not (surely not) be precisely > over a > vertex or line segment. This is the "real life" scenario. > > What you must do is create a line segment from the vehicle's location to

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Dylan Beaudette
On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood wrote: > On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam wrote: > >>> However, I am troubled that the Ubuntu proj distribution does not seem >>> to include the grid ship files. >> >> >> I have learned that the DebianGIS packagers are unwilling

Re: [postgis-users] Confusing Distance

2008-12-17 Thread Paul Ramsey
Yeah, north polar stereographic, not an optimal choice for Brazil :) P On Wed, Dec 17, 2008 at 12:53 PM, David William Bitner wrote: > How did you chose to use 32661? You should use an SRID that uses a > projection that works well for the area that you are working in. > > On Wed, Dec 17, 2008 a

Re: [postgis-users] Confusing Distance

2008-12-17 Thread David William Bitner
How did you chose to use 32661? You should use an SRID that uses a projection that works well for the area that you are working in. On Wed, Dec 17, 2008 at 2:34 PM, sub3 wrote: > > Hi, > I was trying to calculate the distance (in NM) from two points. I've found > a method using distance_sphero

[postgis-users] Confusing Distance

2008-12-17 Thread sub3
Hi, I was trying to calculate the distance (in NM) from two points. I've found a method using distance_spheroid, but I am curious why my original method didn't work correctly: select distance ( transform( GeomFromText('Point(-76.29145663 -45.9229366415 )', 4269), 32661), transform( GeomFromT

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Richard Greenwood
On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam wrote: >> However, I am troubled that the Ubuntu proj distribution does not seem >> to include the grid ship files. > > > I have learned that the DebianGIS packagers are unwilling to distribute the > grid shift component until there is a licensing

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Frank Warmerdam
Richard Greenwood wrote: However, I am troubled that the Ubuntu proj distribution does not seem to include the grid ship files. Richard, I have learned that the DebianGIS packagers are unwilling to distribute the grid shift component until there is a licensing statement available for the grid

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

2008-12-17 Thread Kevin Neufeld
Hi Regina, According to the wiki notes: "You can suppress linking to old-style references and URIs by preceding the word with a '!', e.g. NotLinkedAsWikiName, http://not.linked.to/"; I did this here (seems to work): http://postgis.refractions.net/support/wiki/index.php?ComputeMultiCentroid -

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Richard Greenwood
On Tue, Dec 16, 2008 at 9:57 PM, Richard Greenwood wrote: > On Mon, Dec 8, 2008 at 6:08 PM, Dylan Beaudette > wrote: >>> Richard Greenwood wrote: >>> The files in http://svn.osgeo.org/metacrs/proj/trunk/proj/nad/ are >>> ASCII. In the nad directory, you need to do: >>> ./configure >>> make >

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

2008-12-17 Thread lisek lichu
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.

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

2008-12-17 Thread Obe, Regina
That's the problem with the wiki or my inability to use it. Try stripping every where you see ? From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of lisek lichu Sent: Wednesday, December 17, 2

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

2008-12-17 Thread lisek lichu
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 ),