Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

after st_union() PgSQL returns a note:

NOTE:  TopologyException: side location conflict at 226.001 39.5158

And in the results there are two rows with empty geometry and other rows are ok.
What causes that problem? How to solve it?

share|improve this question
add comment

2 Answers 2

up vote 9 down vote accepted

I've found the problem. It was a self intersecting polygon. I used ST_IsValidReason to find it.

share|improve this answer
add comment

Googling found this related post: http://lists.refractions.net/pipermail/jts-devel/2009-March/002939.html

So it seems your features may be suffering from rounding errors, and it may be solvable by cleaning up the geometry a bit.

It might be worth creating a minimum reproducible case, and post a message on the postgis mailing list.

share|improve this answer
    
Thank you for pointing the post, it was very useful. –  Pablo May 2 '11 at 18:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.