[postgis-users] side location conflict in GeomUnion function

[Paul Ramsey]

Have you checked that all your geometries are valid first?

select * from geomtable where not isvalid(the_geom);

invalid geometries are the #1 cause of topology failures.
Paul

Hisaji Ono wrote:

> Hello.
> 
>  I've got following error message in creating geometry unions using
> postgis-cvs.
> 
> # select GeomUnion(the_geom)  from kagawa group by  y2000;
> 
> NOTICE:  TopologyException: jpnboundary=# select GeomUnion(the_geom)  from
> kagawa where gid <> 883 group by
>  y2000;
> NOTICE:  TopologyException: side location conflict (133.949,34.2926)
> NOTICE:  TopologyException: side location conflict (133.949,34.2926)
> ERROR:  GEOS union() threw an error!
> ERROR:  GEOS union() threw an error!(133.949,34.2926)
> NOTICE:  TopologyException: side location conflict (133.949,34.2926)
> ERROR:  GEOS union() threw an error!
> ERROR:  GEOS union() threw an error!
> 
>  Could you tell me how to detect a record including this geometry which
> caused this error and how to remedy this geometry?
> 
>  Regards.
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_