How can I find the location that are within the certain range from my input location?

Question

I have a mapping like below:

{
"my_locations": {
  "aliases": {

  },
  "mappings": {
    "_doc": {
      "properties": {
          "location": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
        },

I know that if the field type of location is "geo_point" then I can use following geo distance query.

GET /my_locations/_search
{
    "query": {
        "bool" : {
            "must" : {
                "match_all" : {}
            },
            "filter" : {
                "geo_distance" : {
                    "distance" : "200km",
                    "location" : {
                        "lat" : 40,
                        "lon" : -70
                    }
                }
            }
        }
    }
}

I read that I cannot change the field type for location from text to geo_point(from elastic search documentation and stackoverflow) and I already have many data. So how can I find the location that are within the certain range from my input location?

You need to reindex your data in order to change the type of your location field to geo_point — Val
– Val, Commented Aug 7, 2018 at 7:01
No, you simply need to create another index with the right data type and then reindex will copy your current index into the new one. Then you'll be able to run your query on the new index. elastic.co/guide/en/elasticsearch/reference/current/… — Val
– Val, Commented Aug 7, 2018 at 7:04

Val · Accepted Answer · 2018-08-07 07:07:01Z

1

First, you need to create a new index with the correct data type

PUT my_locations_2
{
  "mappings": {
    "_doc": {
      "properties": {
          "location": {
            "type": "geo_point"
          }
      }
   }
}

Then you can use the reindex API in order to copy the data from the old index to the new one:

POST _reindex
{
  "source": {
    "index": "my_locations"
  },
  "dest": {
    "index": "my_locations_2"
  }
}

answered Aug 7, 2018 at 7:07

Val

218k14 gold badges377 silver badges384 bronze badges

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

3 Comments

S S Over a year ago

I will try it many thankx. I could not understand the documentation. So your suggested helped me understand some basic

S S Over a year ago

I have some issue. When I store the location using text I have location": "40.124,-70.254" like this but with geo_point I have to store "location" : { "lat" : 40, "lon" : -70 }

Val Over a year ago

you don't need to change your data, you can also store it as text as you can see here: elastic.co/guide/en/elasticsearch/reference/current/…

Collectives™ on Stack Overflow

How can I find the location that are within the certain range from my input location?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related