[postgis-users] Problem with geodata storage

[Emilio Ponce]

Ok, that works :)

Thank you



2007/10/22, Matthew Perry <perrygeo at gmail.com>:
> 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."
>


-- 
Emilio