[postgis-users] Topology Postgis 2.0

[Sandro Santilli]

On Mon, Sep 24, 2012 at 08:34:46PM -0700, ps.tiara wrote:
> I have checked with
> select * from topology.topology where name = <toponame>
> 
> 
> but I mean the value of Z didn't appear in the Face table is when
> SELECT ST_AsEWKT (mbr)
> FROM <toponame>. Face
> 
> "SRID = 32749; POLYGON ((436431.259423056 9227300.43051331,436431.259423056
> 9227300.43051344,436431.259423165 9227300.43051344,436431.259423165
> 9227300.43051331,436431.259423056 9227300.43051331))"
> 
> there is no value of Z, whereas in the Node table  Z exists.
> did I miss a step?

The 'mbr' is only the Minimum Bounding Rectangle, not the full face.
That value is 2d only (seemed to be enough for a 2.5 system).

Try GetFaceGeometry if you want to the full surface.

--strk;