Geospatial SQL queries in SQLite using TG, sqlite-tg and datasette-sqlite-tg

Geospatial SQL queries in SQLite using TG, sqlite-tg and datasette-sqlite-tg

Alex Garcia built sqlite-tg - a SQLite extension that uses the brand new TG geospatial library to provide a whole suite of custom SQL functions for working with geospatial data.

Here are my notes on trying out his initial alpha releases. The extension already provides tools for converting between GeoJSON, WKT and WKB, plus the all important tg_intersects() function for testing if a polygon or point overlap each other.

It's …

alex alexgarcia alpha brand data datasette extension functions geojson geospatial gis library notes releases sql sqlite sql queries