Hi George, Glad I could help. I also learned a lot with this case. The "with recursive" queries are really powerful to process data. You could also use a plpgsql function to achieve the same result. It offers a great amount of control to process data.
Regarding the SQL code I use, I'm wondering if using "distinct on" geometry could lead to problems. AFAIK it uses bboxes and not geom themselves to compare records. Not sure, though, if 2 contours can share the same bbox. Nicolas. Le 19 mai 2012 à 09:25, georgew <gws...@hotmail.com> a écrit : > Hi Nicolas, this is it! it works beautifully. I even tried it with the full > set of contours and it all makes sense. > The truth is for me your help has been more than a solution, it has also > been a great tutorial on Postgis, I hope others will find it as useful. > Thanks a lot for your continuing help. > George > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Closing-polylines-tp4971098p4994271.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
