[postgis-users] Problem with geodata storage

[Burgholzer,Robert]

Emilio,
That is the default storage now, binary.  If you want the text
representation, select AsTExt(calles_geom);

Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
rwburgholzer at deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
Web-Based Water Supply Planning Demo:
http://soulswimmer.dynalias.net/models/wsdemo/demo_hsi.php

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Emilio Ponce
Sent: Monday, October 22, 2007 12:10 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Problem with geodata storage

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 |
01020000000200000000000000005807410000000070AD0D410000000020540741000000
0050B10D41
(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