Datasette plugin that adds a custom SQL function for shortest haversine distances between a point and a path
Project description
datasette-haversine-point-path
Datasette plugin that adds a custom SQL function for shortest haversine distances between a point and a path on a sphere
Install this plugin in the same environment as Datasette to enable the haversine_point_path()
SQL function.
datasette install datasette-haversine-point-path
The plugin is built on top of the haversine library.
haversine_point_path() to calculate distances
select haversine_point_path(lat1, lon1, lat2, lon2, lat3, lon3);
This will return the distance in kilometers between the path defined by (lat1, lon1)
, (lat2, lon2)
, and the point defined by (lat3, lon3)
.
Demo
No demo yet
Custom units
By default haversine_point_path()
returns results in km. You can pass an optional third argument to get results in a different unit:
ft
for feetm
for metersin
for inchesmi
for milesnmi
for nautical mileskm
for kilometers (the default)
select haversine_point_path(lat1, lon1, lat2, lon2, 'mi');
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for datasette-haversine-point-path-0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4ca3cbeebfa9d3284e977753986ac3419ed0c69101a3baf0a2dbf66b196441d9 |
|
MD5 | d7529aa4f32c57e623d6152f049dfc4f |
|
BLAKE2b-256 | 68b8afd612ec7cd0bc01534efb30c373fb07d005b1787fc5b95e64a2e11a52a8 |
Hashes for datasette_haversine_point_path-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 05fc3445876afdbb45dd29595e4ac0fc9dfe3251c4e0f6a4bc549edd63626d1e |
|
MD5 | bf2e8551eca6f16f2d4d7c97209368e3 |
|
BLAKE2b-256 | 8d2b72886a26ffd4538f3ae2fac781212e82ac7eecf0c546941ecdecb836cbc0 |