[postgis-users] Closing polylines

[Nicolas Ribot]

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 <gws293 at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users