[postgis-users] Create a geometry column from 2 colums of the same table

[Gregory S. Williamson]

Well, we use a different SRID (4326) but a sample bit of SQL (from a perl script -- forgive anh transcription errors as I have stripped out "\" symbols and may cause a typo. This sample is from postGIS 1.0, postgres 8.0.

First I create a column for the geometry:
SELECT * FROM AddGeometryColumn('public','mytable','req_pnts', 4326, 'POINT', 3);

And then I update it with:
UPDATE mytable SET req_pnts = GeomFromEWKT('SRID=4326;POINT(' || mytable.x || ' ' || mytable.y || ' ' || mytable.z || ')');

You'd need to substitute your SRID and pay attention to the actual x/y values; don't use the "z" coordinate if you don't need it; if you use a straight 2-D geometry change the last "3" in the AddGeometryColumn to a "2".

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Luca Penasa
Sent:	Sat 2/4/2006 4:35 AM
To:	PostGIS Users Discussion
Cc:	
Subject:	[postgis-users] Create a geometry column from 2 colums of the same table
I have 2 column into my table:

latitudine | longitudine
------------+-------------
    5104803 |     1663919
    5104548 |     1663044
        ......     |        ......   

and i want to create a unique geometry column (called the_geom):
POINT(5104803 1663919). The SRID is 26591 (Gauss-Boaga projection)..
any idea?
 
 
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Grande Offerta di Benvenuto Cassine di Pietra:
* 36 bottiglie di ottimo vino veneto direttamente a casa tua!
* 
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3923&d=4-2
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

!DSPAM:43e491a2320831270013900!