Simon Willison’s Weblog

Spatial indexes

7th January 2003

Jeremy Zawodny demonstrates Spatial Indexes in MySQL 4.1. This clever new feature allows you to add data to a table in terms of geometric points, then run queries to find (for example) all points that occur inside a specified polygon. Weird and wonderful stuff.

Posted 7th January 2003 at 10:54 am · Follow me on Mastodon, Bluesky, Twitter or subscribe to my newsletter

More recent articles

Reverse engineering Codex CLI to get GPT-5-Codex-Mini to draw me a pelican - 9th November 2025
Video + notes on upgrading a Datasette plugin for the latest 1.0 alpha, with help from uv and OpenAI Codex CLI - 6th November 2025
Code research projects with async coding agents like Claude Code and Codex - 6th November 2025

This is Spatial indexes by Simon Willison, posted on 7th January 2003.

Next: Collaboration tools should be simple

Previous: Wiki hosts and ticket stubs

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe

Previously hosted at http://simon.incutio.com/archive/2003/01/07/spatialIndexes