[postgis-users] Mapserver ? (was Convert X/Y into geometry)

[Mike Leahy]

Jeff,

I think you need the host in your connection:

'user=postgres dbname=paleo host=localhost'

Mike


Quoting Jeffrey Johnson <ortelius at gmail.com>:

> Ok, It looks like that worked, but now when trying to draw this using
> mapserver using the following layer def, I get this error
> 
> LAYER
>                NAME localities2
>                 CONNECTIONTYPE postgis
>                 CONNECTION "user=postgres dbname=paleo"
>                 DATA "localities_geom FROM localities"
>                 STATUS DEFAULT
>                 TYPE POINT
>                 CLASS
>                         SYMBOL 'circle'
>                         COLOR 0 0 0
>                         MINSIZE 5
>                 END
>         END
> 
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'localities2'.
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
> connect string 'user=postgres dbname=paleo'.
> Error reported was 'could not connect to server: `4o@ˆÌU@% Is the
> server running locally and accepting connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"? '.
> 
> I start psql with -U postgres -d paleo, no problem. Mapserver and
> postgis are on the same box, and I started postgis with the -i option.
> 
> Anything else I did wrong?
> 
> Thanks,
> 
> Jeff
> 
> On 4/27/05, Jeffrey Johnson <ortelius at gmail.com> wrote:
> > I assume you mean like this
> > 
> > update localities set localities_geom=SetSRID(MakePoint(UTM_NORTHING,
> > UTM_EASTING), 26711);
> > 
> > Where localities_geom is the point geometry field and 26711 is the
> > SRID (NAD27 UTMZ11N)
> > 
> > Seems to work, I'll see what mapserver has to say.
> > 
> > Thanks,
> > 
> > Jeff
> > 
> > 
> > On 4/27/05, strk at refractions.net <strk at refractions.net> wrote:
> > > On Wed, Apr 27, 2005 at 02:03:15PM -0700, Jeffrey Johnson wrote:
> > > > Hi all,
> > > >
> > > > What is the easiest/quickest way to convert a set of x,y points in an
> > > > existing table into geometry for PostGIS. I have a table LOCALITIES
> > > > with UTM_NORTHING and UTM_EASTING fields, and I want to prepare this
> > > > table for display via mapserver. Not sure how to go about doind this.
> > >
> > > SetSRID(MakePoint(UTM_NORTHING, UTM_EASTING), <SRID>) from LOCALITIES;
> > >
> > > --strk;
> > >
> > >
> > > >
> > > > Thanks in advance,
> > > >
> > > > Jeff
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users at postgis.refractions.net
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
> >
> 




----------------------------------------
This mail sent through www.mywaterloo.ca