Order documents by multiple geolocations

Elastic Stack Elasticsearch
1

I am new to Elasticsearch and I try to create an index for companies that come with multiple branches in the city.

Each of the branches it has it's own geolocation point.

My companies document looks like this:

{
    "company_name": "Company X",
    "branch": [
        {
            "address": {
                // ... other fields
                "location": "0.0000,1.1111"
            }
        }
    ]
}

The index have the following mapping:

{
  "companies": {
    "mappings": {
      "dynamic_templates": [
        {
          "ids": {
            "match": "id",
            "match_mapping_type": "long",
            "mapping": {
              "type": "long"
            }
          }
        },
        {
          "company_locations": {
            "match": "location",
            "match_mapping_type": "string",
            "mapping": {
              "type": "geo_point"
            }
          }
        }
      ],
      "properties": {
        "branch": {
          "properties": {
            "address": {
              "properties": {
                // ...
                "location": {
                  "type": "geo_point"
                },
                // ...
              }
            },
          }
        }
      }
    }
  }
}

Now, in the Elasticsearch I've indexed the following documents:

{
    "company_name": "Company #1",
    "branch": [
        {
            "address": {
                "location": "39.615,19.8948"
            }
        }
    ]
}

and

{
    "company_name": "Company #2",
    "branch": [
        {
            "address": {
                "location": "39.586,19.9028"
            }
        },
        {
            "address": {
                "location": "39.612,19.9134"
            }
        },
        {
            "address": {
                "location": "39.607,19.8946"
            }
        }
    ]
}

So what is my problem. If I try to run the following search query, unfortunately the company displayed first is the Company #2 although the geodistance query has the location data of the Company #1 :

GET companies/_search
{
  
  "fields": [
    "company_name", 
    "branch.address.location"
  ],
  "_source": false,
  "sort": [
    {
      "_geo_distance": {
        "branch.address.location": {
          "lon": 39.615,
          "lat": 19.8948
        },
        "order": "asc",
        "unit": "km"
      }
    }
  ]
}

Am I doing something wrong? Is there a way to sort the search results using this method?

Please keep in mind that if for example search with a geolocation that is more close to some of the geolocations of the "Comapny #2", in this case I need the Company #2 to be first.

Finally, if the setup I have isn't correct for what I need, if there's any other way to achieve that same result with different document structure please let me know. I am still in the begin of the project and It's simple to adapt to what is more appropriate.

Thank you in advance!

2

OK, It was me that I didn't pay close attention to what I did.

In the sorting I use the longitude value in the latitude field and the latitude value to the longitude field. Once I switched the values the query works as it is supposed to work :slight_smile:

3

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