>I have already loaded a table that contains X, Y and Z values. AT the time of >loading it was thought we did not need a spatial component to this table. >Now we realize that we do have a need but do not want to reload the 190 >million records again and create the point features on load. >Is it possible to create the point geometry in the existing table....if so, >how? >Thanks in advance. >Tony Appel
Assume the X,Y,Z are in three fields in a "tablename" table. SELECT AddGeometryColumn( 'public','tablename','geom', <epsg>, 'POINT', 3 ); update public.tablename set geom = ST_MakePoint(X::double,Y::double,Z::double); epsg is a integer value of your SRS (epsg code) Regards, -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
