ElasticSearch filtering with geo distance

Question

I'm attempting to filter data with both geo distance and fields like 'has_cctv' or 'has_instant_bookings'.

{
  "query" : {
    "filtered" : {
      "filter" : {
        "geo_distance": {
          "distance": 10000,
          "lat_lng": {
            "lat": "51.5073509",
            "lon": "-0.1277583"
          }
        }
      }
    }
  }
}

I've tried many combinations of filtering using terms but can't seem to get past errors. For example:

{
  "query" : {
    "filtered" : {
      "filter" : {
        "terms": [
          {"term": {"has_cctv": 1}}
        ],
        "geo_distance": {
          "distance": 10000,
          "lat_lng": {
            "lat": "51.5073509",
            "lon": "-0.1277583"
          }
        }
      }
    }
  }
}

This gives me '[terms] filter does not support [has_cctv] within lookup element'. Could this be a problem with my query, or a problem with the way the data is stored?

Bharvi Dixit · Accepted Answer · 2015-01-09 18:34:28Z

2

Here goes the correct query:

POST _search
{
   "query": {
      "filtered": {
         "query": {
            "term": {
               "has_cctv": {
                  "value": 1
               }
            }
         },
         "filter": {
            "geo_distance": {
               "distance": 10000,
               "lat_lng": {
                  "lat": "51.5073509",
                  "lon": "-0.1277583"
               }
            }
         }
      }
   }
}

Just make sure that lat_lng is stored as geo_point

Thanks Bharvi

answered Jan 9, 2015 at 18:34

Bharvi Dixit

691 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bharvi Dixit Over a year ago

I had written query for a single term matching. If you have multiple conditions you can write down a bool query like : "query": { "bool": { "must": [ { "term": { "has_cctv": { "value": 1 } } } ],"must": [ {"term": { "has_instant_bookings": { "value": 1 } }} ] } }

Alex Garrett Over a year ago

Your comment underneath this post solved it, thank you so much! You might want to update the original answer for anyone else who's having a similar issue can see the answer a little clearer.

Andrei Stefan · Accepted Answer · 2015-01-09 18:32:34Z

2

Or you could use an and filter and group the two filters together. And a comparison between bool filter and and/or/not filters: http://www.elasticsearch.org/blog/all-about-elasticsearch-filter-bitsets/

{
  "query": {
    "filtered": {
      "filter": {
        "and": {
          "filters": [
            {
              "term": {
                "has_cctv": "1"
              }
            },
            {
              "geo_distance": {
                "distance": 10000,
                "lat_lng": {
                  "lat": "51.5073509",
                  "lon": "-0.1277583"
                }
              }
            }
          ]
        }
      }
    }
  }
}

answered Jan 9, 2015 at 18:32

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

1 Comment

eugene Over a year ago

the sort by distance feature is lost if you lose this , it seems.

dadoonet · Accepted Answer · 2015-01-09 18:21:42Z

1

Two errors.

As you have more than one filter, you need to add a bool filter and put each filter in a must clause. Then you don't need a terms filter here but a term filter.

answered Jan 9, 2015 at 18:21

dadoonet

14.6k3 gold badges46 silver badges51 bronze badges

Collectives™ on Stack Overflow

ElasticSearch filtering with geo distance

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related