C#使用弹性搜索计算大地距离（嵌套2）

Question

我正在实现一个程序，能够接收10个最近的对象。作为数据库，我使用弹性搜索，我的模型看起来像这样。

[Nest.ElasticsearchType(Name = "eventelastic", IdProperty = "Id")]
public class EventElastic:BaseElastic
{
    [Nest.String]
    public string EventName { get; set; }
    [Nest.Date]
    public DateTime CreateTime { get; set; }
    [Nest.String]
    public string Country { get; set; }
    [Nest.String]
    public string City { get; set; }
    [Nest.String]
    public string Place { get; set; }
    [Nest.Boolean]
    public bool IsPrivate { get; set; }
    [Nest.Boolean]
    public bool IsSponsored { get; set; }
    [Nest.String]
    public string ImageWeb { get; set; }
    [Nest.Number]
    public int MaxPersons { get; set; }
    [Nest.GeoPoint]
    public LocationModel Location { get; set; }


}

[Nest.ElasticsearchType(Name = "location", IdProperty = "Id")]
public class LocationModel
{
    public LocationModel(double lon, double lat)
    {
        Lon = lon;
        Lat = lat;
    }

    public double Lon { get; set; }

    public double Lat { get; set; }
}

我创建了一个这样的索引

connection.CreateIndex("index", s => s.Mappings(f => f.Map<EventElastic>(m => m.AutoMap().Properties(p=> p.GeoPoint(g => g.Name(n => n.Location))))));

我会插入像这样的新文档

var response = connection.IndexAsync<EventElastic>(model, idx => idx.Index("index"));
            response.ContinueWith(t =>
            {
                if (!t.Result.IsValid)
                {
                    log.Error(t.Result.ServerError.Error.Reason);
                }
            });

该模型的所有值都已设置，并且可以正常工作。

但是现在我想得到10公里范围内最近的10个。我这样质疑这个

var geoResult = connection.Search<EventElastic>(s => s.From(0).Size(10)
            .Query(query => query.Bool(b => b.Filter(filter => filter
                    .GeoDistance(geo => geo
                        .Field(f => f.Location) //<- this 
                        .Distance("10km").Location(lon, lat)
                        .DistanceType(GeoDistanceType.SloppyArc)
                        ))
                )
            )
        );

但是它不返回任何文档，但是如果我将距离值设置为10000km，它将返回文档。

我在模型中使用的数据是：LAT:47.4595248 LON:9.6385962

我在搜索中使用的位置：LAT:47.4640298 LON:9.6389685

那些地方相距100米。有人能帮我找到代码中的错误吗？是否有可能得到从elasticsearch服务器计算的距离？

顺便说一句：我正在设置默认索引

var settings = new ConnectionSettings(pool).DefaultIndex("index");

编辑我发现了错误：

var geoResult = connection.Search<EventElastic>(s => s.From(0).Size(10)
        .Query(query => query.Bool(b => b.Filter(filter => filter
                .GeoDistance(geo => geo
                    .Field(f => f.Location) 
                    .Distance("10km").Location(lat, lon) //wrong parameter
                    .DistanceType(GeoDistanceType.SloppyArc)
                    ))
            )
        )
    );

我必须改变lat和lon的位置。

但是我没有得到计算的距离，有人知道我如何得到距离吗？

最好的问候

Answer 1

您可以将距离添加到文档中，并在查询中使用sctipt字段来更新此值。

var geoResult = client.Search<EventElastic>(s => s.From(0).Size(10)
    .ScriptFields(sf => sf
        .ScriptField("distance", descriptor => descriptor
            .Inline("doc[\u0027location\u0027].distanceInKm(lat,lon)")
            .Lang("groovy")
            .Params(f => f.Add("lat", lat).Add("lon", lon))))
    .Query(query => query.Bool(b => b.Filter(filter => filter
        .GeoDistance(geo => geo
            .Field(f => f.Location)
            .Distance("10km").Location(lat, lon)
            .DistanceType(GeoDistanceType.SloppyArc)
        ))
        )
    )
    .Sort(sort => sort
        .GeoDistance(g => g
            .Field(f => f.Location)
            .Order(SortOrder.Ascending)
            .PinTo(new GeoLocation(1.5, 1))
            .DistanceType(GeoDistanceType.SloppyArc)))
    );


public class EventElastic
{
    ..
    public double Distance {get;set;}
}

elasticsearch的响应：

{
   "took": 3,
   "timed_out": false,
   "_shards": {
      "total": 5,
      "successful": 5,
      "failed": 0
   },
   "hits": {
      "total": 2,
      "max_score": null,
      "hits": [
         {
            "_index": "my_index",
            "_type": "data",
            "_id": "1",
            "_score": null,
            "fields": {
               "distance": [
                  55.65975203179589
               ]
            },
            "sort": [
               55659.66677843493
            ]
         },
         {
            "_index": "my_index",
            "_type": "data",
            "_id": "2",
            "_score": null,
            "fields": {
               "distance": [
                  124.45896068602408
               ]
            },
            "sort": [
               124411.81715215484
            ]
         }
      ]
   }
}

希望能有帮助。