Re: [postgis-users] Topology Attributes

Hi Nicolas, Thanks for the detailed description that make the unclear clear... Now I feel ready to implement ... Your support is a great example for the strength of the open source community ... BR. Ofer On Tue, Feb 10, 2015 at 11:07 AM, Nicolas Ribot nicolas.ri...@gmail.com wrote: Hi

Re: [postgis-users] Topology Attributes

Hi Ofer, Some precisions regarding the query I sent: A topoGeometry objects stores the following information ( http://postgis.net/docs/manual-2.1/topogeometry.html): • topopology_id: id of the topology, as stored in the Topology metadata • layer_id : the id of the layer in the topology • id:

Re: [postgis-users] Topology Attributes

Hi, As usual with SQL, there must be several other ways to perform the same query. As the edge view stores 2 faces id per row (left and right), I duplicated the joins to join both left_face and right face against the original polygon table (p1 and p2 aliases) Nicolas On 8 February 2015 at

Re: [postgis-users] Topology Attributes

Hi, 1. I advanced ...and I used the topology.toTopoGeom() and now the relation is populated. 2. I try to understand the following join *pe.parcelle** p1 on (1, (p1.topo).id) *= (r1.layer_id, r1.topogeo_id) the second part of the join is clear -- comes from the relation table however the first

Re: [postgis-users] Topology Attributes

Hi Nicolas, 1. I used ST_CreateTopoGeo() to build the topology (not the topology.toTopoGeom() as you mentioned ) When I look at the relation table its empty ? should I use topology.toTopoGeom() instead, and it will populate it ? 2. can you explain what the parentheses (special the 1, ...)

[postgis-users] Topology Attributes

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

Re: [postgis-users] Topology Attributes

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

Re: [postgis-users] Topology Attributes

Thanks, I'm trying to figure out the process Ofer On Sun, Feb 8, 2015 at 4:58 PM, Richard Greenwood richard.greenw...@gmail.com wrote: I don't know if this will help but here is a link to a PDF http://www.greenwoodmap.com/presentations/WyGEO-Lander-2014.pdf of a presentation I did a while

Re: [postgis-users] Topology Attributes

I don't know if this will help but here is a link to a PDF http://www.greenwoodmap.com/presentations/WyGEO-Lander-2014.pdf of a presentation I did a while ago. Starting on page 14 I am trying to illustrate how attributes from a simple polygon source can be joined to edges in PostGIS topology .

Re: [postgis-users] Topology Attributes

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