Re: [postgis-users] number all houses on branch roads first

2016-07-15 Thread 積丹尼 Dan Jacobson
Thanks fellows. In fact I am convinced that I have stumbled upon a new traversal of binary trees, http://jidanni.org/geo/house_numbering/taizhong/dongshi/zaokeng.html useful for numbering irregular communities, campgrounds, cemeteries... ___

Re: [postgis-users] number all houses on branch roads first

2016-07-13 Thread Rémi Cura
Would be much easier to send your graph to python networkx If you have plpython, this is immediate (line 368) I found it painful to

Re: [postgis-users] number all houses on branch roads first

2016-07-12 Thread Stephen Woodbridge
Sounds like you want a "graph" based on the road network topology like what is used in pgRouting. Then given the graph do a depth first traversal of the topology, labeling the edges as you go. If you build the graph topology (not the postgis topology), the you can probably write a recursive