New answers tagged spatialite
Additional to the SpatiaLite Cookbook's workflow I found a good solution for for this problem here.
You can add the view as you add a normal spatialite table, if the view has field of unique integers. In the add dialog, to the right of the view name is an ID field drop down, select your unique integer field there. You could also enter your SQL statement in DB Manager's SQL window, and add the layer from there. You'll still need a unique integer field in ...
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) ...
I would create a view in spatialite which is composed of the geography from the "trees" table, and the (linked) attributes from the other tables. THen display that view in QGIS, and you'll get the values rather than the common keys. Suppose, for example, that you have a table of trees, with geometry, primary key, and an key column "attrib1_id" and another ...
Whenever you use an aggregate function with a GROUP BY clause and multiple results are available for the aggregate function, the last of the values is the one that's returned. That's why you're getting "wheat" for the pk_uid 168. What you can do to get the actual Max() value for the correct landuse is use a sorted subquery, and do the GROUP BY in the outer ...
pyspatialite is a Python interface to the SQLite/SpatiaLite databases, as psycopg2 for PostgreSQL and has nothing to do with QGIS. They are Python modules which settled in the site-packages folder of your Python installation You install it as any other Python module (easy_install, pip). I don't use OpenSuse but you can look at Spatialite and Python on ...
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 ...
You can use our free converter for changing OSM into a routable network, that splits at all intersections. This means OSM ways are changed into multiple links. Input is OSM XML files, output is for instance SHP. Find it at www.routeware.dk, download section.
If you're familiar with SQL, probably the easiest way is to use the capabilities of the underlying SQLite database to "mount" one database onto another (or perhaps both source databases onto a new target database. The SQLite SQL command for this is ATTACH. Conceptually, you'd then SELECT / UPDATE from the source database table(s) into the target table. The ...
Top 50 recent answers are included