Much Thanks, First I will try to understand the join that you did and then try to implement it...
Ofer On Sun, Feb 8, 2015 at 12:44 PM, Nicolas Ribot <nicolas.ri...@gmail.com> wrote: > Hi, > > When you build the topology, for instance with topology.toTopoGeom(), you > get back a TopoGeometry object for each polygon added to the topology. > This TopoGeometry is used to keep a link between your polygon object and > all the topological elements composing it. > The "relation" table inside the topo schema holding the topology contains > the identifier of the topoGeometry object and the identifiers of topo > elements composing the polygon. > > To get the right and left original polygons from the topology, you make a > join between edge, relation and pg table: > (topo_grass is the topo schema, parcelle is the polygon table with a topo > column containing the TopoGeometry object corresponding to the polygon): > > select e.edge_id, e.left_face, e.right_face, > p1.id as left_id, p2.id as right_id > from topo_grass.edge e > join topo_grass.relation r1 on r1.element_id = e.left_face > join pe.parcelle p1 on (1, (p1.topo).id) = (r1.layer_id, r1.topogeo_id) > join topo_grass.relation r2 on r2.element_id = e.right_face > join pe.parcelle p2 on (1, (p2.topo).id) = (r2.layer_id, r2.topogeo_id); > > Nicolas > > > > On 8 February 2015 at 10:29, Ofer Zilberstein <zilberstein.o...@gmail.com> > wrote: > >> >> Hi, >> >> When you build topology from set of connected polygons, the original >> polygon attributes are not part of the topology model. The model creates >> MBR face for each original polygon. >> >> The edges hold the left & right faces. >> >> How or what is the right way to add to the edges the right and left >> original polygons ? >> >> -- >> >> *Ofer Zilberstein* >> >> Mobile: 972-544886873 >> >> Skype: ofer.zilberstein >> >> Mail: zilberstein.o...@gmail.com >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- *Ofer Zilberstein* Mobile: 972-544886873 Skype: ofer.zilberstein Mail: zilberstein.o...@gmail.com
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users