Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- const result = await pool
- .request()
- .input("longtitude", sql.Float, 31.769317)
- .input("latitude", sql.Float, 35.201113)
- .input("distance", sql.Float, 40000)
- .execute("GetPlacesAtDistance");
- console.log(result.recordset[0].Location.points);
- const mappedResult = result.recordset.map(record => ({
- Id: record.Id,
- Name: record.Name,
- Location: {
- lng: record.Location.points[0].y,
- lat: record.Location.points[0].x
- }
- }));
- res.json(mappedResult);
- } catch (err) {
- console.log(err);
- res.status(500);
- res.send();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement