[postgis-users] Ring Self-intersection problem

[Sandro Santilli]

On Sat, Nov 26, 2011 at 09:35:47AM +0200, ahmet temiz wrote:

> Could you give me an idea to solve  this problem ?
> 
> "Ring Self-intersection at or near point 39.0002 37.8181"

Try passing the geoms under st_buffer() with a distance of 0.
Alternatively, if you can, use ST_MakeValid() found in PostGIS-2.0.

If you feel adventurous you could build a standard topology and
clean from there. See:
http://strk.keybit.net/blog/2011/11/21/topology-cleaning-with-postgis/

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html