[postgis-users] 3D data became 2d auf insertion?

Simon Schneider Kallas at gmx.de
Tue Jan 22 07:53:32 PST 2008


Hi,

I have the following table...

_________________________________________
create table objects
(
   name varchar(15) not null primary key,
   parent varchar(15),
   type varchar(15) not null
);
select addgeometrycolumn('objects','geom',-1,'POLYGON',3);
_________________________________________


... in which I insert the following row:

_________________________________________
insert into objects(name, type, geom3d) values('Main2', 'building', 
GeomFromEWKT('POLYGON((0 0 0, 50 0 0, 50 50 0, 0 50 0, 0 0 50, 50 0 50, 
50 50 50, 0 50 50, 0 0 0))'));
_________________________________________


After querying the data of this table I get:

_________________________________________
"Main2";"POLYGON((0 0,50 0,50 50,0 50,0 0,50 0,50 50,0 50,0 0))"
_________________________________________


And now I'm wondering where did my z-vals go? Can anybody explain to me 
what's happened here?


Thx,
Simon



More information about the postgis-users mailing list