1

I have exported file with no geometry, values from attribute tables, to SQLite. I manage to open it in SQLite.

But when I want to import to another QGIS project or even the same project I get an error message. "failure getting table metadata. Is path/file.sqlite really a Spatial Lite database?"

what could be wrong here?

1 Answer 1

2

An SQLite file is not (always) a SpatialLite database file. SpatialLite database files have extra metadata tables for spatial data.

If you create a SQLite file using, for example, the sqlite3 command line SQL processor, or Python's sqlite3 module, you won't get a SpatialLite database.

QGIS might be able to read the plain SQLite file as non-spatial database tables, but I can't see a native way of doing it so the solution is either going to be via ODBC or converting your plain SQLite to a SpatialLite database or another format, eg GeoPackage, which is still SQLite compatible.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.