distanceOnSphere

knight_tan · October 22, 2021, 6:31am

Just to confirm does distanceOnSphere return meters ?

I query two location with API even pretty near ( less then 100km on Google map measure ) but it return distance like 4671363 meter

meter

Alexander_Pavelko · October 22, 2021, 7:15am

Hello @knight_tan!
Welcome to our community and thank you for trying out Backendless.

Yes, distanceOnSphere returns a value in meters.
A more detailed description of this operator can be found here:
distanceOnSphere Operator

Regards,
Alexander

knight_tan · October 22, 2021, 7:31am

just to confirm the Point ( lot, lat ) should be in this format right?

getting some weird results when pretty close place also return huge distance point like the screen shot

Alexander_Pavelko · October 22, 2021, 8:00am

Yes, that’s right: POINT (longitude latitude)
Here’s a more detailed description: Point

Regards,
Alexander

knight_tan · October 22, 2021, 8:02am

any good way I can cross-reference the distance point I getting is correct?

Alexander_Pavelko · October 22, 2021, 8:54am

I just ran some tests for you and everything is working correctly:

Regards,
Alexander

knight_tan · October 22, 2021, 8:57am

hi Alex,
really appreciate it, can you share with me what’s service you use on top ( the mapping one )?

Alexander_Pavelko · October 22, 2021, 9:01am

Regards,
Alexander

knight_tan · October 22, 2021, 11:12am

solved my problem. really appreciated!

Alexander_Pavelko · October 22, 2021, 11:27am

I’m glad I could help you!
Thank you for contacting us.

Regards,
Alexander