PostgreSQL: Z-coordinate (3D) not supported and misrepresented in AutoCAD Map3D

[Mike Toews]

Currently, Z-coordinate (3D) geometries are not supported. However, this is highly desirable.

Also, AutoCAD Map3D 2011 can add PostGIS layers with Z-coordinates, but they are misrepresented. For example, a four-sided polygon:

create table test3(gid serial primary key, name text);
select addgeometrycolumn('public','test3','geometry',26910,'POLYGON',3);
insert into test3(geometry, name) values('SRID=26910;POLYGON((514452.882612015 6252255.92843785 10.1,514477.777417923 6252277.50262608 11.2,514489.882524277 6252263.32205739 12.3,514464.987722183 6252241.74786916 13.3,514452.882612015 6252255.92843785 10.1))', 'A 3D Rectangle')

This appears as a triangle, with the individual XYZ coordinates appearing in different X and Y values in AutoCAD 3D.

[brentrobinson]

The coordinate misrepresentation problem was fixed by revisions 5458 and 5469. Official 3D support is still to do.