Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I try to use views with spatial column in spatialite. I can connect to spatialite database and load the layer without problems but when I try to view data in Attribute Table I can't get eny data; all rows and field show ERROR.

Data render well and information in point show correct data.

Has someone get the same error?. Is this a bug?

I get this results in different versions of qgis (osg4w in windows, master version in ubuntu 12.04 and qgis version included in osgeolive 6.0)

share|improve this question
Did you add into the view an integer column called "ROWID"?? – Micha Mar 23 '13 at 12:19

As I've got a similar problem with Geopackage spatial views I thought I'd share what I've seen elsewhere. Some people are reporting that if you select both the ROWID column and geometry column and alias both using " as " in the view SQL, but give them aliases that are exactly the same as the column names, then this fixes the problem in Spatialite. This however doesn't seem to fix it in Geopackage.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.