Does anyone have experience in dealing with spatial data in their database? I have an application that uses maps and also a large set of latitude/longitude data stored in an SQLite database that needs to be queried in an offline capacity. I need to query a given location and radius to find out which latitude/longitude are closest.
Currently exploring whether to try and put together a formula to query SQLite data or load and query the data in C#. The preferred method would be for database but it seems like a difficult task using SQLite.
There seems to be no other Xamarin components I can find that would allow me to make use of spatial database tables (CosmosDB is unfortunately not an option I can use).
Any suggestions would be appreciated.