[postgis-users] Newbie question about making points...

[Gregory S. Williamson]

Jonathan,

Something along the lines of:

UPDATE tablename SET req_pnts = 
GeomFromEWKT('SRID=4326;POINT(' || x || ' ' || y || ' ' || z || ')');

where x, y and z are values for a 3d point; for a 2d I think you can just leave off the "z".

HTH,

Greg WIlliamson
DBA
GlobeXPlorer LLC


-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Jonathan Greenberg
Sent:	Mon 10/9/2006 11:26 PM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] Newbie question about making points...

So I have a postgres table with 5 fields, 2 of which are utm x and y
coordinates -- I would like to start working with this table as a set of
points, what are the steps I need to do to "convert" this to a "point"
coverage?

--j

-- 
Jonathan A. Greenberg, PhD
NRC Research Associate
NASA Ames Research Center
MS 242-4
Moffett Field, CA 94035-1000
Office: 650-604-5896
Cell: 415-794-5043
AIM: jgrn307
MSN: jgrn307 at hotmail.com


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


-------------------------------------------------------
Click link below if it is SPAM gsw at globexplorer.com
"https://mailscanner.globexplorer.com/dspam/dspam.cgi?signatureID=452b3b65221892117817174&user=gsw@globexplorer.com&retrain=spam&template=history&history_page=1"
!DSPAM:452b3b65221892117817174!
-------------------------------------------------------