Share via

geo_geohash_neighbors()

  • Artículo

Calcula vecinos geohash.

Obtenga más información sobre geohash.

Syntax

geo_geohash_neighbors(geohash)

Obtenga más información sobre las convenciones de sintaxis.

Parámetros

Nombre Tipo Requerido Descripción
geohash string ✔️ Valor geohash tal y como se calculó geo_point_to_geohash(). La cadena geohash debe tener entre 1 y 18 caracteres.

Devoluciones

Matriz de vecinos geohash. Si geohash no es válido, la consulta genera un resultado nulo.

Ejemplos

En el ejemplo siguiente se calculan los vecinos de Geohash.

Ejecución de la consulta

print neighbors = geo_geohash_neighbors('sunny')

Salida

Vecinos
["sunnt","sunpj","sunnx","sunpn","sunnv","sunpp","sunnz","sunnw"]

En el ejemplo siguiente se calcula una matriz de entrada Geohash con sus vecinos.

Ejecución de la consulta

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

Salida

celdas
["sunny","sunnt","sunpj","sunnx","sunpn","sunnv","sunpp","sunnz","sunnw"]

En el ejemplo siguiente se calcula la colección de geometrías GeoJSON de polígonos Geohash.

Ejecución de la consulta

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"))

Salida

geojson
{"type": "Feature","geometry": {"type": "GeometryCollection","geometries": [
{"type":"Polygon","coordinates":[[[[42.451171875,23.6865234375],[42.4951171875,23.6865234375],[42.4951171875,23.73046875],[42.451171875,23.73046875],[42.451171875,23.6865234375]]]},
{"type":"Polygon","coordinates":[[[[42.4072265625,23.642578125],[42.451171875,23.642578125],[42.4511711875,23.6865234375],[42.4072265625,23.6865234375],[42.4072265625,23.642578125]]]},
{"type":"Polygon","coordinates":[[[[42.4072265625,23.73046875],[42.451171875,23.73046875],[42.451171875,23.7744140625],[42.4072265625,23.7744140625],[42.4072265625,23.73046875]]]},
{"type":"Polygon","coordinates":[[[[42.4951171875,23.642578125],[42.5390625,23.642578125],[42.5390625,23.6865234375],[42.4951171875,23.6865234375],[42.4951171875,23.642578125]]]},
{"type":"Polygon","coordinates":[[[[[42.451171875,23.73046875],[42.4951171875,23.73046875],[42.4951171875,23.7744140625],[42.451171875,23.7744140625],[42.45117171875,23.73046875]},
{"type":"Polygon","coordinates":[[[[42.4072265625,23.6865234375],[42.451171875,23.6865234375],[42.451171875,23.73046875],[42.4072265625,23.73046875],[42.4072265625,23.6865234375]]]},
{"type":"Polygon","coordinates":[[[[42.4951171875,23.73046875],[42.5390625,23.73046875],[42.5390625,23.7744140625],[42.4951171875,23.7744140625],[42.4951171875,23.73046875]]},
{"type":"Polygon","coordinates":[[[[42.4951171875,23.6865234375],[42.5390625,23.6865234375],[42.5390625,23.73046875],[42.4951171875,23.73046875],[42.4951171875,23.6865234375]]]},
{"type":"Polygon","coordinates":[[[[42.451171875,23.642578125],[42.4951171875,23.642578125],[42.49511771875,23.6865234375],[42.451171875,23.6865234375],[42.451171875,23.642578125]]]}]},
"properties": {"name": "polygons"}}

En el ejemplo siguiente se calculan uniones de polígono que representan Geohash y sus vecinos.

Ejecución de la consulta

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)

Salida

polygon
{"type":"Polygon","coordinates":[[[42.4072265625,23.642578125],[42.451171875,23.642578125],[42.4951171875,23.642578125],[42.5390625,23.642578125],[42.5390625,23.686523437500004],[42.5390625,23.730468750000004],[42.5390625,23.7744140625],[42.4951171875,23.7744140625],[42.451171875,23.7744140625],[42.407226562499993,23.7744140625],[42.4072265625,23.73046875],[42.4072265625,23.6865234375],[42.4072265625,23.642578125]]]}

En el ejemplo siguiente se devuelve true debido a la entrada de token Geohash no válida.

Ejecución de la consulta

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

Salida

no válido
1