[postgis-users] topology, joining attributes
Sandro Santilli
strk at keybit.net
Wed Jul 23 09:10:09 PDT 2014
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;
More information about the postgis-users
mailing list