Work-in-progress geospatial SQLite extension around tg. Not ready yet, but feel free to play with it!
Once stabilized, will be a part of sqlite-ecosystem.
.load ./tg0
select tg_point_wkt(1, 2);
-- 'POINT(1 2)'tg and therefore sqlite-tg support WKT, WKB, and GeoJSON. Most functions will accept any of these formats, and you can convert between them with tg_to_geojson(), tg_to_wkb(), and tg_to_wkt().
select tg_to_geojson('POINT(1 2)');
-- '{"type":"Point","coordinates":[1,2]}'
select tg_to_wkb('POINT(1 2)');
-- X'0101000000000000000000f03f0000000000000040'
select tg_to_wkt('{"type":"Point","coordinates":[1,2]}');
-- 'POINT(1 2)'See docs.md for a full API reference.
| Language | Install | |
|---|---|---|
| Python | pip install sqlite-tg |
 |
| Datasette | datasette install datasette-sqlite-tg |
 |
| sqlite-utils | sqlite-utils install sqlite-utils-sqlite-tg |
 |
| Node.js | npm install sqlite-tg |
 |
| Deno | deno.land/x/sqlite_tg |
 |
| Ruby | gem install sqlite-tg |
 |
| Github Release |  |