sort _geoPoint delivers wrong results

[thomashenzjb]

Hi all,

Using Meilisearch v1.5.1 - I've got an index with around 16GB in size and 650.000 documents.

Running this query:

{
"q":"querystring",
"filter":"_geoRadius(50.937531, 6.960279, 5000)",
"attributesToRetrieve":["id","name","url","account_id","_geo","cats"],
"attributesToSearchOn":["name","type_name","brands","cats"],
"facets":["type_filter"],
"limit":10,
"page":1,
"sort": ["_geoPoint(50.937531, 6.960279):asc"]
}

results in a wrong geoPoint sort. It's not sorted :asc.

{
"hits": [
{
"name": "...",
"url": "...",
"cats": [...]
"id": 35114,
"account_id": 2575,
"_geo": {
"lat": 50.948035,
"lng": 6.956912
},
"_geoDistance": 1192
},
{
"name": "...",
"url": "...",
"cats": [...],
"id": 21,
"account_id": 14,
"_geo": {
"lat": 50.936075,
"lng": 6.95651
},
"_geoDistance": 310
},
{
"name": "...",
"url": "...",
"cats": [...],
"id": 2251,
"account_id": 102,
"_geo": {
"lat": 50.938764,
"lng": 6.945117
},
"_geoDistance": 1071
}
],
...

Do you have any idea what I should look for?

All _geo Objects are float.

Thanks a lot,
Thomas

[sanders41]

If you update the ranking rules to put sort first does it fix the problem? https://www.meilisearch.com/docs/reference/api/settings#update-ranking-rules

[thomashenzjb]

Thanks @sanders41 , that worked. Did not anticipate that this was necessary.

[skalra90]

@thomashenzjb @sanders41 I am experiencing the same problem but I did everything.

Here is my code:

const results = await global.meiliClient.index("airports").search("", {
                sort: [`_geoPoint(${topLatitude}, ${topLongitude}):asc`],
                showRankingScore: true,
                showRankingScoreDetails: true
            });

results contains all airports not sorted by distance.

Index details:
{
    "displayedAttributes": [
        "airport_id",
        "name",
        "alias",
        "city_name",
        "city_alias",
        "country_name",
        "iata",
        "country_code",
        "type",
        "capital",
        "_geo"
    ],
    "searchableAttributes": [
        "name",
        "alias",
        "city_name",
        "city_alias",
        "country_name",
        "iata",
        "country_code",
        "capital"
    ],
    "filterableAttributes": [
        "_geo",
        "country_code",
        "type"
    ],
    "sortableAttributes": [
        "_geo",
        "type"
    ],
    "rankingRules": [
        "sort",
        "words",
        "typo",
        "proximity",
        "attribute",
        "exactness"
    ],
    "stopWords": [],
    "nonSeparatorTokens": [],
    "separatorTokens": [],
    "dictionary": [],
    "synonyms": {},
    "distinctAttribute": "airport_id",
    "proximityPrecision": "byWord",
    "typoTolerance": {
        "enabled": true,
        "minWordSizeForTypos": {
            "oneTypo": 5,
            "twoTypos": 9
        },
        "disableOnWords": [],
        "disableOnAttributes": []
    },
    "faceting": {
        "maxValuesPerFacet": 100,
        "sortFacetValuesBy": {
            "*": "alpha"
        }
    },
    "pagination": {
        "maxTotalHits": 1000
    },
    "searchCutoffMs": null
}

Checked all documents and found no invalid entry:

function checkGeoData(documents) {
    const invalidEntries = [];

    documents.forEach((doc, index) => {
        // Check if _geo exists and has both lat and lng
        if (!doc._geo || typeof doc._geo.lat !== "number" || typeof doc._geo.lng !== "number") {
            invalidEntries.push({ index, doc });
        }
    });
    return invalidEntries;
}

First document always with airport_id 1:

{
  name: "Goroka Airport",
  alias: null,
  city_name: "Goroka",
  city_alias: "Goronka",
  country_name: "Papua New Guinea",
  iata: "GKA",
  country_code: "PG",
  capital: "Port Moresby",
  airport_id: 1,
  _geo: {
    lat: -6.08169,
    lng: 145.391998,
  },
  type: "medium_airport",
  _geoDistance: 8294109,
  _rankingScore: 1,
  _rankingScoreDetails: {
    "_geoPoint(29.61611, 76.98056):asc": {
      order: 0,
      value: null,
      distance: null,
    },
  },
}

topLatitude = 29.61611
topLongitude = 76.98056

Same is for _geoRadius, no matter how big radius I make it returns no results.

[curquiza]

Hello here

Sorry for the issue, we are releasing v1.8.1 right now that should fix the issue