Recently I have started using PostGIS topology extension, but I have some difficulties in understanding how the structure works:
One of the key points is the use of "layer"s: as of what I understand, features attributes should be stored in a table out of the topology's schema (the one named
topo_actualname) and registered as a layer of that topology with
However, is there a simple way to join the attributes (stored in the layer table) with the respective features (elements in the
Now, what I do is:
SELECT whatever FROM layer_tb l JOIN topo_topologyname.edge_data e ON (l.topo).id=edge_id;
But I guess the whole
layer concept is rather useless if I have to know both the topology schema name and the layer name to get the information I want.
In fact I think I understood that the
topo column on the layer has enough information to know where the respective topology is, and moreover the
topology schema stores a reference to each layer table for each topology.
Is there a short/simple/proper way to join information together? I was looking for something in the topology extension functions, but couldn't find anything useful.