[postgis-users] Adding Spatial Index to Existing Table

[Gregory S. Williamson]

If you single quote something PostgreSQL will interpet it as a string ... since they are lower case anyway, try not quoting them at all, of double quote them if you need to preserve case:
UPDATE locations SET point_geom = SetSRID(makepoint(longitude,latitude), 4326);

Or:
UPDATE locations SET point_geom = SetSRID(makepoint("longitude","latitude"), 4326);

G

-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Adam
Sent:	Fri 12/29/2006 8:57 PM
To:	PostGIS Users Discussion
Cc:	
Subject:	Re: [postgis-users] Adding Spatial Index to Existing Table

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



-------------------------------------------------------
Click link below if it is SPAM gsw at globexplorer.com
"https://mailscanner.globexplorer.com/dspam/dspam.cgi?signatureID=4595f117132351789821027&user=gsw@globexplorer.com&retrain=spam&template=history&history_page=1"
!DSPAM:4595f117132351789821027!
-------------------------------------------------------