2 ms·
Made my own map: brew install datasette sqlite-utils curl 'https://groundhog-day.com/api/v1/predictions?year=2023' | \ jq .predictions | \
by simonw 4y ago
Made my own map:
brew install datasette sqlite-utils
curl 'https://groundhog-day.com/api/v1/predictions?year=2023' | \
jq .predictions | \
sqlite-utils insert day.db groundhogs - --flatten
sqlite-utils convert day.db groundhogs \
groundhog_coordinates --multi 'return {
"latitude": value.split(",")[0],
"longitude": value.split(",")[1]
}'
datasette install datasette-cluster-map
datasette day.db
Screenshot of the map here: https://fedi.simonwillison.net/@simon/109796889732947452 https://fedi.simonwillison.net/@simon/109796889732947452
sqlite-utils docs here: https://sqlite-utils.datasette.io/en/stable/cli.html https://sqlite-utils.datasette.io/en/stable/cli.html
- deleted 4y ago[deleted]