Hi,
Simplest way would be to read definition of ST_DWithin and use index
lookups for smaller box, but rechecks for bigger. Don't ST_Simplify, it's
just wasting cycles.
select ... where geom && ST_Expand(other_geom, 100) and _ST_DWithin(geom,
other_geom, 110)
It will exit loop in ST_DWithin faste
hi all,
I use postgis to query nearby points to a linestring using st_dwithin()
however, in my usecase, the linestrings are too detailed and I do not
need very exact results. I would like function like:
st_dwithin(g1,g2, 100, 110) which:
return true if distance is less than 100
return false if di
