Geospatial SQL queries in SQLite using TG, sqlite-tg and datasette-sqlite-tg: https://til.simonwillison.net/sqlite/sqlite-tg
@alexgarciaxyz built a SQLite extension that exposes functionality from the new TG library by @tidwall as custom SQL functions, and it's really cool!
Geospatial SQL queries in SQLite using TG, sqlite-tg and datasette-sqlite-tg
TG is an exciting new project in the world of open source geospatial libraries. It's a single C file (an amalgamation, similar to that provided by SQLite) which implements the subset of geospatial operations that I most frequently find myself needing:



