[postgis-users] Convert X/Y into geometry

[strk at refractions.net]

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