B4J Question GPS position archive procedure and search for the 'nearest' points

Daestrum said:

copilot said this - where mx,my is your location and x,y is the scooters location

B4X:

SELECT
    location_id,
    x,
    y,
    -- Calculate distance using Haversine formula
    6371 * ACOS(
        COS(RADIANS(mx)) * COS(RADIANS(x)) * COS(RADIANS(y) - RADIANS(my)) +
        SIN(RADIANS(mx)) * SIN(RADIANS(x))
    ) AS distance
FROM
    your_table
ORDER BY
    distance
LIMIT 10;

Click to expand...