[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