I have a GeoPackage and I want to select the geometry as text from the SQLite command-line client. Here's what I've done:
- Load SpatiaLite with
.load /path/to/mod_spatialite.dylib(I'm on a Mac)
- Run the following query:
sqlite> select astext(geom) from boundary;
There aren't any errors, but the client prints a blank newline as the result.
Am I doing something wrong, or can anyone think of other diagnostics?
I'm new to SpatiaLite/GeoPackage.
The layer loads fine in QGIS! The geometry looks fine. It's one big multipolygon.