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

[Jeffrey Johnson]

Thanks, I thought mapserver assumed that if no host was specified. It
appears to work ... well no error, but doesn't display. I think I have
some projection issues to work out.

Thanks again,

Jeff


On 4/27/05, Mike Leahy <mgleahy at fes.uwaterloo.ca> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>