Closed this issue 5 years ago · 1 comments
FIXED!
had to change:
max(subq.lat) as lat, max(subq.lon) as lon,
to
mode() within group (order by subq.lat) as lat, mode() within group (order by subq.lon) as lon,