[postgis-users] hierarchical topology and attributes at different levels

[Sandro Santilli]

On Fri, Oct 19, 2012 at 11:56:18AM -0500, William Kyngesburye wrote:

> Can the attributes of child layers be seen from a layer? 

Sure, given enough neurons to build the appropriate SQL query...
(TopoGeomeometry management still has rough edges)

It would be something like this:

 SELECT * FROM child_features c, parent_features s
 WHERE id(c.topogeom) = GetTopoGeomElements(s.topogeom)[2];

Fixing the syntax is left as an excercise to the reader

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net