[postgis-users] Changing Column data type from WKB to LATLON

George Silva georger.silva at gmail.com
Mon Jul 14 13:22:11 PDT 2014

Evan, the internal geometry storage format cannot be changed.

You can query your database to get the "human" values with ST_AsText and
other functions for printing. This depends a lot on what you need to do.

On Mon, Jul 14, 2014 at 5:06 PM, Evan Phillippi <ev_phil at rocketmail.com>

> Hello,
> I am attempting to store some gps coordinates that i collected for a
> geospatial db in precision ag.  I created a table with a geometry column
> called "Coordinates"  using the command "Coordinates" geometry(Point,4326).
>  I then populated the column using the
> command ST_SetSRID(ST_MakePoint(-89.53580,44.12101), 4326));
> This populates the coordinate table with a string in WKB.  Is there a way
> I can covert the output values of the entire column from WKB to the raw
> lat,lon values.  I have tried the alter table command    ALTER TABLE
> "Customers"ALTER COLUMN "Coordinates" TYPE geometry(St_AsLatLonText),
> 4326));  but with no luck.
> Im relatively new to sql and postgres,  I would certainly appreciate any
> help.
> Thanks!
> Evan
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

George R. C. Silva
SIGMA Consultoria
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140714/36467122/attachment.html>

More information about the postgis-users mailing list