<div dir="ltr"><div>(switching to devel list)</div>What would you think of 2 functions :<div><br></div><div>GetRelatedPuntal(Lineal)<br>GetRelatedLineal (Puntal)</div><div><br></div><div>This function would allow, when having a lineal, to get puntal sharing a node;</div>
<div>and when having a puntal, to get part of a lineal sharing node with it.</div><div><br></div><div>precise signature being : </div><div><br></div><div>SET OF id_topogeom GetRelatedLineal( a_puntal_topogeom_name, a_puntal_topogeom_layer_id )<br>
</div><div><br></div><div>same for puntal </div><div><br></div><div><div>Cheers,</div></div><div>Rémi-C</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/10/22 Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Sandro,<div><br></div><div>I'll surely do things the way you suggest, I realize it is what makes the most sense for me.<br>
<br></div><div>Thanks for the quick answer !</div><div><br></div><div>Cheers,</div>
<div><br></div><div>Rémi-C</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">2013/10/22 Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>On Tue, Oct 22, 2013 at 01:51:53PM +0200, Rémi Cura wrote:<br>
> Hey dear List,<br>
> (and hey Sandro ;-) )<br>
><br>
> somebody knows if there is a mechanism to make explicit link between 2<br>
> topogeoms of different type (lineal and puntal)?.<br>
> For instance in a road network with topogeom "road" and topogeom<br>
> "road_intersection", I would like to link the "road_intersection" to all<br>
> incoming/outcoming "road".<br>
><br>
> I was thinking of using classical relations (foregin key etc), but maybe<br>
> there is something I don't understand.<br>
><br>
> I'm going to do this a lot so I would appreciate suggestions making it<br>
> compatible with current postgis_topology functionning.<br>
<br>
</div></div>The TopoGeometry type was created mostly to let people deal with them<br>
the way they used to deal with Geometry objects, so you can use classical<br>
relations.<br>
<br>
BUT if you get down one level you can use GetNodeEdges against a node associated<br>
with a "road_intersection" value to obtain a list of edge identifiers, and then<br>
go back up to find linear TopoGeometry objects whose definition include those<br>
edge identifiers. Those relations are already there, it's only your choice to<br>
use them.<br>
<br>
--strk;<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>