Remote Execution Third Example

example03.js

const degsToRads = (deg) => Math.PI / 180 * deg;
const haversine = (origin, dest) => Math.acos(
  Math.sin(degsToRads(origin.lat)) * Math.sin(degsToRads(dest.lat)) +
  Math.cos(degsToRads(origin.lat)) * Math.cos(degsToRads(dest.lat)) * Math.cos(degsToRads(dest.lng - origin.lng))
);
const notablePlaces = await query(`select * from notablePlaces`);
const relevantPlaces = notablePlaces
  .map((p) => ({
    name: p.name,
    img: p.img,
    desc: p.desc,
    distance: haversine({
      lat: p.lat,
      lng: p.lng,
    }, {
      lat: trip.destLat,
      lng: trip.destLng,
    }),
  }))
  .sort((a, b) => b.distance - a.distance)
  .slice(0, 4);