New answers tagged sqlite
My nose was right! It was a multiple path issue in OSX. I had multiple installs of ogr and gdal conflicting despite them not being on my path as defined by .bash_profile but this: http://stackoverflow.com/a/8841666/2062470 sorted me out.
Since GDAL/OGR 1.10, the SQLite "dialect" can be used as an alternate SQL dialect to the OGR SQL dialect. This assumes that GDAL/OGR is built with support for SQLite (>= 3.6), and preferably with Spatialite support too to benefit from spatial functions. Source: http://www.gdal.org/ogr/ogr_sql_sqlite.html So you need to build GDAL (>= 1.10) ...
You can add the data from the database with Add vector layer ... in QGIS 2.0.1. But be patient, it is a lot of data. The Qspatialite plugin is unfortunately not able to deal with the data, nor the Add Spatialite layer dialogue.
The sqlite file from NE is in FDO-OGR format, not the native spatialite geometry. If you're willing to do some manual labor, here's a way to convert to a spatialite db: First make a new, empty spatialite database (I call it "nev.sqlite"), then in a separate terminal session open the original natural_earth_vector.sqlite with spatialite. (I used the newer ...
Top 50 recent answers are included