Timeline for Can QGIS Read Spatialite Views?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 12, 2012 at 22:53 | vote | accept | Bryan Goodrich | ||
| May 9, 2012 at 6:25 | history | edited | underdark | CC BY-SA 3.0 |
added 499 characters in body
|
| May 9, 2012 at 1:55 | comment | added | Nathan W |
Use SELECT * FROM views_geometry_columns; to see what is needed to be inserted. More info at gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/…
|
|
| May 9, 2012 at 1:53 | comment | added | Nathan W | example: INSERT INTO VIEWS_GEOMETRY_COLUMNS VALUES ('Towns_v1', 'Geometry', 'POINT', 2, 32632, 0); | |
| May 9, 2012 at 1:53 | comment | added | Nathan W | There is a special table for handling geometry based views. Use the following syntax INSERT INTO VIEWS_GEOMETRY_COLUMNS VALUES ('{TABLE NAME}', '{GEOM COLUMN NAME}', '{GEOM TYPE}', 2, {SRID}, 0); | |
| May 9, 2012 at 1:35 | comment | added | Bryan Goodrich | That seems to be the issue. I created the view and checked the meta tables. Obviously, the geometry from the view isn't listed. How do I register the view's geometry? I tried the RecoverGeometryColumn but it's telling me the table doesn't exist. I thought I was on a 2.4 version, but apparently I'm working with the Spatialite 3.0 beta. Maybe I'm implementing the command wrong? Maybe it doesn't work on views? (It better!); for clarity, my command was SELECT RecoverGeometryColumn('tblName', 'SHAPE', 2226, 'POINT', 2); | |
| May 8, 2012 at 21:47 | history | answered | underdark | CC BY-SA 3.0 |