Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

QGIS not opening SQLIte file generated by FME #15510

Closed
qgib opened this issue Aug 15, 2012 · 3 comments

Comments

@qgib
Copy link
Contributor

commented Aug 15, 2012

Author Name: Jonathan Moules (Jonathan Moules)
Original Redmine Issue: 6196
Affected QGIS version: 1.8.0


I have a SpatiaLite file I created in FME. It looks valid in SQLiteStudio, but when I try and "connect" to it in QGIS 1.8.0.1 I get:

"Failure exploring tables from: C:/2 Temp Data/temp_test.sl3

no such column: type"

I've tried this with two different datasets so far, both give this error; I've attached one of the SQLite files (contains OS Meridian data).


@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Aug 15, 2012

Author Name: Even Rouault (@rouault)


This file is not a Spatialite DB, but a SQLite DB with a table organization and geometries in FGF (FDO Geometry Format : http://trac.osgeo.org/fdo/wiki/FDORfc16 ). You can open it through OGR - that handles it well - with the "Open Vector Layer" menu item.

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Aug 15, 2012

Author Name: Jonathan Moules (Jonathan Moules)


Ah, that makes sense. Didn't realise there was a difference, but FME does say "SQLite Spatial (FDO)" under the writer.

You may wish to make the SpatiaLite reader capable of determining this itself and informing the user (the difference between the filetypes isn't something I guess users should be able to determine themselves after all). If so, change this ticket to "feature", otherwise, please close it.
Thanks.

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Aug 16, 2012

Author Name: Giovanni Manghi (@gioman)


  • resolution was changed from to invalid
  • status_id was changed from Open to Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.