[postgis-users] Adding Spatial Index to Existing Table

[Brad Ediger]

If your lat/longs are WGS84, you should be able to say:

UPDATE table SET location = SetSRID(MakePoint(Long,Lat), 4326);

That should update all points in one statement, and set the proper SRID.

Brad

On Dec 29, 2006, at 1:08 PM, Adam wrote:

> This is my first try at adding spatial to my table.  Currently I  
> have a 'Lat' and 'Long' columns that have my Latitiude and Longitude.
>
> Do I need to add another column named 'Location' and insert each  
> rows 'Lat' and 'Long' into the corresponding 'Location' row by  
> doing:  "INSERT INTO table ( Location ) VALUES ( GeometryFromText 
> ('Point xx.xxx yy.yyyy', 4326) )" ?  This will assume WGS 84 datum.
>
> Is this right?
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061229/a49caa57/attachment.html>