Geolocation functions

Is there a way in Cockroachdb to make geolocation based queries ?

For instance, we store origin/destination entries with their respective longitude/latitude and we need to be able to get to the rows for which origin->(some longitude/latitude point as param)->destination has a distance below a certain value (param too).

ElasticSearch lets us create Groovy queries that can achieve the intended result
MongoDB has a $where that allows us to pass a javascript function to find the result
PostgreSQL has https://www.postgresql.org/docs/8.3/static/earthdistance.html

How can we achieve this with CockroachDB ?

Hi @somatt! CockroachDB does not currently support geospatial queries or indexes but it’s on our radar. Please chime in on https://github.com/cockroachdb/cockroach/issues/19313 with your use case!