elasticsearch/docs/reference/query-languages/esql/_snippets/functions/examples/st_geohex.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Example

FROM airports
| EVAL geohex = ST_GEOHEX(location, 1)
| STATS
    count = COUNT(geohex),
    centroid = ST_CENTROID_AGG(location)
      BY geohex
| WHERE count >= 10
| EVAL geohexString = TO_STRING(geohex)
| KEEP count, centroid, geohexString
| SORT count DESC, geohexString ASC

count:long	centroid:geo_point	geohexString:keyword
22	POINT (7.250850197689777 48.21363834643059)	811fbfffff
18	POINT (-80.64959161449224 40.04119813675061)	812abfffff
17	POINT (-0.7606179875266903 52.86413913565304)	81197fffff
13	POINT (22.53157936179867 41.98255742864254)	811effffff
13	POINT (78.30096947387435 26.073904778951636)	813dbfffff
12	POINT (-76.39781514415517 45.16300531569868)	812bbfffff
12	POINT (-100.30120467301458 20.114154297625646)	8149bfffff
11	POINT (18.037187419831753 48.66540593306788)	811e3fffff
11	POINT (-83.42379064553164 33.18388901439241)	8144ffffff
11	POINT (-99.4237939513881 27.100012352774765)	8148bfffff
10	POINT (128.01009018346667 35.8699960866943)	8130ffffff