- 👋 Hi, I’m @Ooblek, software developer and occasional cocoa addict
- ⌨️ I also have a Codepen. Check it out :D
🖥️
Rejecting your reality and substituting it with my own
Pinned Loading
-
-
-
-
-
A query to get the distance between ...
A query to get the distance between a resource and all the others (A -> Everything else) Provided the Lat and Long. (IN KM) 1SELECT a.id b.id, /*WHERE A IS THE OBJECT SELECTED AND B REPRESENTS ALL THE OTHER OBJECTS IN THE TABLE*/
2b.name, b.location_lat,
3b.location_long,
4111.111 * /* 111.111 Meters per degree Lat and 111 111*cos(Let) Meters per degree Long.*/
5DEGREES(ACOS(LEAST(1.0, COS(RADIANS(a.location_lat))
-
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.


