[postgis-users] Problem with geodata storage

[Matthew Perry]

Emilio,

 The geometry is encoded in a binary format. In order to get the
textual representation of the geometry use select AsText(the_geom)
from ....

- matt

On 10/22/07, Emilio Ponce <yosoycore at gmail.com> wrote:
> Hi everyone, here Emilio from Barcelona,
>
> I've found a problem with my postgresql+postgis under ubuntu. When I
> tried to store a geometry worked well, but when I tried to get this
> data with a select I found this strange numbers:
>
> testgis=# select * from calles_geom;
>
>  id |  name   |                                        geom
> ----+---------+------------------------------------------------------------------------------------
>   1 | Jeff Rd |
> 01020000000200000000000000005807410000000070AD0D4100000000205407410000000050B10D41
> (1 fila)
>
>
> I've done this to store the data:
>
> CREATE TABLE CALLES_GEOM(
>         ID int4,
>         NAME varchar(25)
> );
>
> SELECT AddGeometryColumn('calles_db','calles_geom','geom','-1', 'LINESTRING',2);
>
> BEGIN;
> INSERT INTO CALLES_GEOM(ID,GEOM,NAME) VALUES (1,
> GeometryFromText('LINESTRING(191232 243118,191108 243242)',-1),'Jeff
> Rd');
> END;
>
>
> Then,anyone know why the geom column is not 'LINESTRING(191232
> 243118,191108 243242)'?
>
> Thanks!
>
>
> --
> Emilio
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Matthew T. Perry
http://www.perrygeo.net

"Never ascribe to malice, that which can be adequately explained by
incompetence."