[postgis-users] Fixing linebreaks

Ben Madin lists at remoteinformation.com.au
Thu Aug 18 20:04:59 PDT 2011


G'day all,

I have 151 000 roads stored as multilinestrings (in EPSG 4326), and trying to find the start and end points I have discovered that nearly every one has approximately 5 - 15 mm separating the ends, so st_linemerge is not working for me.

I have considered st_snaptogrid, but am I missing something more simple...

cheers

Ben





More information about the postgis-users mailing list