Id just be updating the existing database column using makepoint and concatnate from the lat and long columns.
Peter James Smith wrote:
Dear all, Would appreciate some help. I have created an existing database (with PostGIS extension) and it has a table called CLEANEDCAMDENGPS which is populated with approx 600,000 rows. There are 20 or so columns in the table, two of which are Latitude and Longitude (WGS84). I would now like to create a Geom column with points in, the values of which should be taken from the latitude and longitude column. Could someone provide me with sample code as to how to do this please? I had a go with the below, but don't really know what I'm doing... neither of the statements work... --CREATE THE COLUMN-- SELECT AddGeometryColumn('CAMDENGPS', 'GPS_POINTS', 'geom', 4326, 'POINT', 2) --POPULATE THE COLUMN-- INSERT INTO CLEANEDCAMDENGPS (GPS_POINTS) VALUES ( ST_GEOMFROMTEXT('POINT((SELECT LONGITUDE FROM CLEANEDCAMDENGPS) (SELECT LATITUDE FROM CLEANEDCAMDENGPS))', 4326, 'Point')); Thank you James _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users