[postgis-users] 3D topology nodes?

[Sandro Santilli]

On Tue, May 29, 2012 at 10:01:35PM -0400, John Morrison wrote:
> Hi;
> 
> Sorry if this is a dumb newbie question regarding support for 3D
> topology (as I am relatively new to both SQL and PostGIS).
> 
> I am running PostGIS 2.0.1SVN r9732 on FC16/x86_64.
> 
> When I try to add a 3D point to a topology via either ST_AddIsoNode or
> AddNode, I get an error of the form "Geometry has Z dimension, but
> column does not."  Adding 2D points seems to work fine.

There's no proper 3D topology support, but you do can equip your
primitives with a per-vertex Z value (2.5D) if you account for it
at topology creation time. See manual page entry for CreateTopology
on how to do that.

> pgadminIII gives a rather cryptic type of "geometry(1107456)" as the
> data type of the "geom" column of the "node" table of my topology.

That is annoying, I would expect something like "geometry(point)"
or "geometry(pointZ)" instead. Do types of other spatial tables
look fine in pgadminIII or is it a general issue with any geometry 
column ?

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'