sqlite-tg

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