search

neilotoole / sq

sq data wrangler
https://sq.io
MIT License
2.14k stars 31 forks source link

Spatialite support #86

Open chapmanjacobd opened 3 years ago

chapmanjacobd commented 3 years ago 
# sq add test_api/test-data.sqlite
@test_data_sqlite  sqlite3  test-data.sqlite
# sq inspect
sq: failed to read @test_data_sqlite source metadata: no such module: VirtualSpatialIndex
neilotoole commented 3 years ago

@chapmanjacobd Do you have a (non-sensitive) sqlite db I could test against?

chapmanjacobd commented 3 years ago

either of these should work

https://github.com/dpmcmlxxvi/SpatiaLiteCpp/blob/master/examples/spatialite/test-2.3.sqlite

https://git.asi.ru/solutions/world-ai-and-data-challenge/trase/-/blob/fd8f090fb6f934890d4b5e95df4976c65f183292/aequilibrae/reference_files/spatialite.sqlite

chapmanjacobd commented 3 years ago

this might be helpful

https://github.com/malexer/spatialite/blob/master/spatialite/connection.py