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

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

Example

FROM airports
| EVAL geotile = ST_GEOTILE(location, 2)
| STATS
    count = COUNT(geotile),
    centroid = ST_CENTROID_AGG(location)
      BY geotile
| EVAL geotileString = TO_STRING(geotile)
| SORT count DESC, geotileString ASC
| KEEP count, centroid, geotileString

count:long	centroid:geo_point	geotileString:keyword
286	POINT (39.31202001609169 35.149993664386415)	2/2/1
197	POINT (-55.387361375756825 31.952955322292855)	2/1/1
136	POINT (-110.97162496141048 36.87185255084734)	2/0/1
106	POINT (119.35907618669827 25.46263281488791)	2/3/1
67	POINT (-58.031108492373754 -22.624166105151065)	2/1/2
46	POINT (142.95455511274707 -20.581492295427978)	2/3/2
34	POINT (31.38476753634784 -14.64374022804858)	2/2/2
8	POINT (-160.0723083713092 -19.124013530672528)	2/0/2
6	POINT (23.95813101902604 70.17537698848173)	2/2/0
3	POINT (-133.4001641627401 72.06833167467266)	2/0/0
2	POINT (-68.47209956031293 66.77569948369637)	2/1/0