[postgis-users] snapping all close-by lines in a set of 500, 000

[Greg Polanski]

Thank you. Nicolas! Your explanations and sql example help a lot.

Greg



________________________________
 From: Nicolas Ribot <nicolas.ribot at gmail.com>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net> 
Sent: Monday, June 18, 2012 4:31 PM
Subject: Re: [postgis-users] snapping all close-by lines in a set of 500, 000
 

I find useful to explode a linestring into its points to be able to identify pseudo-parallel lines: st_distance is not enough as perpendicular, touching lines will return 0 for the distance though they are not close to each other at each location.
If all linestring points are within a given distance to a line, then chances are good these 2 lines are aligned.

...
Nicolas 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120618/1562937c/attachment.html>