GeoDistance Filter

[tsutomi]

A common filtering function provided by data storage systems (databases and search engines) uses the distance of geographic points to filter and sort results.

The repository model should provide a new IQueryFilter that provides the possibility to select the origin field, the point and a minimum/maximum distance, in a fashion that can be ported across multiple implementations of the repository.

• MongoFramework provides an extension function to translate into a native Mongo function - we might use this function or rather use the native FilterBuilder
• EntityFramework offers provider-specific functions for the case, but seems to depend from the NetTopologySuite in all cases, to have a GIS object model (1)
  • The SQL Server translator uses EF.Functions.Distance static method in a lambda expression
  • The Postgres translator uses the .Distance method of the parameter of a lambda expression to write the native SQL function(3)

(1) https://learn.microsoft.com/en-us/ef/core/modeling/spatial
(3) https://www.npgsql.org/efcore/mapping/nts.html?tabs=with-datasource