Datasette plugin that adds a custom SQL function for haversine distances
Project description
datasette-haversine
Datasette plugin that adds a custom SQL function for haversine distances
Install this plugin in the same environment as Datasette to enable the haversine()
SQL function.
$ pip install datasette-haversine
The plugin is built on top of the haversine library.
haversine() to calculate distances
select haversine(lat1, lon1, lat2, lon2);
This will return the distance in kilometers between the point defined by (lat1, lon1)
and the point defined by (lat2, lon2)
.
Custom units
By default haversine()
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(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 Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for datasette_haversine-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2496d53a3c99b15a75fdb5df3d6cd32c692c2e61b9fd58a26c4e4ca4c921ac44 |
|
MD5 | 87420a5929cf6a368905c15b78e4fed0 |
|
BLAKE2b-256 | 1a5c0dd7c88dc0e6cbaa1a1bfe6bfbc878e5b311d1402ec1bea43ad673d5b741 |