[postgis-users] Enter details into Geom column

[Peter]

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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>