79791696

Date: 2025-10-16 00:41:45
Score: 1.5
Natty:
Report link

Are h3id values unique? Then do

SELECT h3s.h3id, ANY_VALUE(h3s.geog) as geog 
...
GROUP BY h3s.h3id

See also a blog post on this topic https://mentin.medium.com/howto-group-by-geography-column-5638ea1306a1

Reasons:
  • Blacklisted phrase (0.5): medium.com
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • High reputation (-1):
Posted by: Michael Entin