NEST Elasticsearch Query

Elastic Stack Elasticsearch
1

Hi, I would like to replicate this query using .NET Core 3.1, Nest 7.10.0 and Elasticsearch 7.9.3

SELECT name, lat, lon, (6371 * acos(cos(radians(41.671958)) * cos(radians(lat)) * cos(radians(lon) - radians(-3.685049)) + sin(radians(41.671958)) * sin(radians(lat))))
AS distance
FROM table
HAVING distance < 70
ORDER BY distance;

name, lat and lon are fields from the db.

https://www.pabloblanco.es/sql-obtener-coordenadas-en-radio-de-accion/

Thanks!

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.