Skip to main content

Datasette plugin that shows a cluster map for any data with latitude/longitude columns

Project description


A Datasette plugin that detects tables with latitude and longitude columns and then plots them on a map using Leaflet.markercluster.

Demo hosts a demo of this plugin running against several different tables.

Cluster map demo


Run pip install datasette-cluster-map to add this plugin to your Datasette virtual environment. Datasette will automatically include the plugin if it is installed in this way.

If you are deploying using the datasette publish command you can use the --install option:

datasette publish now mydb.db --install=datasette-cluster-map

If any of your tables have a latitude and longitude column, a map will be automatically displayed.

If you columns are called something else you can still get the map to display by using a custom SQL query to alias those columns to latitude and longitude, for example:

select *, "Capture Latitude" as latitude, "Capture Longitude" as longitude
from [USGS_WC_eartag_deployments_2009-2011]

How I deployed the demo

I deploy this demo using the latest master versions of both datasette and datasette-cluster-map like so:

datasette publish now --branch=master \
    --install= \
    --extra-options "--page_size=500" \
    --name="datasette-cluster-map-demo" \
    polar-bears.db sf-trees.db

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
datasette-cluster-map-0.4.tar.gz (4.2 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page