geo_geohash_neighbors()

Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Calculates Geohash neighbors.

Read more about geohash.

geo_geohash_neighbors(geohash)

Learn more about syntax conventions.

An array of Geohash neighbors. If the Geohash is invalid, the query produces a null result.

The following example calculates Geohash neighbors.

print neighbors = geo_geohash_neighbors('sunny')

Output

The following example calculates an array of input Geohash with its neighbors.

let geohash = 'sunny';
print cells = array_concat(pack_array(geohash), geo_geohash_neighbors(geohash))

Output

The following example calculates Geohash polygons GeoJSON geometry collection.

let geohash = 'sunny';
print cells = array_concat(pack_array(geohash), geo_geohash_neighbors(geohash))
| mv-expand cells to typeof(string)
| project polygons = geo_geohash_to_polygon(cells)
| summarize arr = make_list(polygons)
| project geojson = bag_pack("type", "Feature","geometry", bag_pack("type", "GeometryCollection", "geometries", arr), "properties", bag_pack("name", "polygons"))

Output

The following example calculates polygon unions that represent Geohash and its neighbors.

let h3cell = 'sunny';
print cells = array_concat(pack_array(h3cell), geo_geohash_neighbors(h3cell))
| mv-expand cells to typeof(string)
| project polygons = geo_geohash_to_polygon(cells)
| summarize arr = make_list(polygons)
| project polygon = geo_union_polygons_array(arr)

Output

The following example returns true because of the invalid Geohash token input.

print invalid = isnull(geo_geohash_neighbors('a'))

Output