Timeline for PostGIS recursive query in order to find the longest connected subnetwork in my line network
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 20, 2018 at 18:32 | comment | added | geozelot | @JohnPowellakaBarça thx! now that you mention it, remember this? actually a close call for a duplicate, and guess how that turned out for my upvote balance... | |
| Jun 20, 2018 at 13:49 | comment | added | John Powell | Good answer, and the Cluster trick is good, though recursive queries are worth learning in their own right, imho. I have come to the conclusion that the harder the question/answer, the less upvotes it gets. Must go and answer a question about ST_Length :D. | |
| Jun 19, 2018 at 14:25 | comment | added | obchardon |
Great, I was indeed looking for ST_ClusterDBSCAN it work like a charm and is much much faster than any other solution.
|
|
| Jun 19, 2018 at 12:46 | vote | accept | obchardon | ||
| Jun 19, 2018 at 11:43 | history | answered | geozelot | CC BY-SA 4.0 |