[gdal-dev] SQLite Driver and non-spatial tables

Kyle Shannon kyle at pobox.com
Tue Nov 20 13:36:38 PST 2012


For the record, in case anyone is interested, it appears setting
SQLITE_LIST_ALL_TABLES=YES appears to allow me access to non-spatial
tables.  I didn't find any documentation on the format page though.

On Tue, Nov 13, 2012 at 1:44 PM, Kyle Shannon <kyle at pobox.com> wrote:

> I have a Spatialite enabled SQLite file with both spatial and non-spatial
> tables.  Since my database has a table called geometry_columns, all
> non-spatial tables are not loaded as layers.  If I don't have a
> geometry_columns OGR attempts to load geometry from all the tables, but
> still loads non-spatial tables.  Is that correct?  The behavior doesn't
> seem consistent in the two cases.  I just want to make sure I understand
> the driver's behavior.
>
> kss
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20121120/0f3af63e/attachment.html>


More information about the gdal-dev mailing list