[postgis-users] topology, joining attributes

[Sandro Santilli]

On Wed, Jul 23, 2014 at 10:49:47AM +0200, Rémi Cura wrote:

> Your querry could look like this:
> 
> SELECT my_topogeom, f.face_id
> FROM my_table AS mt
> INNER JOIN relation AS r ON (((mt.mytopogeom).id ,
> (mt.mytopogeom).layer_id)) = (r.topogeo_id, r.layer_id  )
> INNER JOIN face AS f ON (r.element_id = f.face_id)

See also http://postgis.net/docs/GetTopoGeomElements.html
.. if you want to have more isolation from the "relation" table
(not necessarely a good idea, in terms of speed)

--strk;