[postgis-users] Convert X/Y into geometry

[Jeffrey Johnson]

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
>