[postgis-users] Adding Spatial Index to Existing Table

Brad Ediger brad at bradediger.com
Fri Dec 29 21:03:10 PST 2006


Don't put quotes around longitude and latitude. They are column names.

On Dec 29, 2006, at 10:57 PM, Adam wrote:

> I tried: UPDATE locations SET point_geom = SetSRID(makepoint 
> ('longitude','latitude'), 4326);
> but got this error:
> ERROR:  invalid input syntax for type double precision: "longitude"
> Could the problem be that my "longitude" column is type "Character  
> Varying"?
> ----- Original Message -----
> From: Brad Ediger
> To: PostGIS Users Discussion
> Sent: Friday, December 29, 2006 1:18 PM
> Subject: Re: [postgis-users] Adding Spatial Index to Existing Table
>
> 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
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> 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/313a239b/attachment.html>


More information about the postgis-users mailing list