Re: Strange ST_DWithin behavior

Paul Ramsey <[email protected]>
Newsgroups gmane.comp.gis.postgis
Message-ID <[email protected]> 

> On Jan 8, 2025, at 5:39 AM, Christian Pschierer <[email protected]> wrote:
> 
> Option 2 would be to always segmentize large polygons, but that would have a negative impact on performance. 
> 

This would be better. Though not done blindly. More segmentized, even roughly will be better. It’ll help you when you visualize them, in particular, so you see what you’re getting. 

If you are evaluating what is “in” and “out” visually, you need to do what I did for my QGIS picture, which is look at the results of ST_Segmentize(geography(geometry)) on your flat map. Otherwise you are not seeing “reality”.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.