Strange ST_DWithin behavior

[Paul Ramsey]

> On Jan 8, 2025, at 5:39 AM, Christian Pschierer <christian.pschierer at gmx.net> 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”.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250108/f1146d50/attachment.htm>