[Qgis-developer] Incompatibilities between QGIS Spatialite and
Spatialite (CLI and GIS) created files
nsicad at gmail.com
Wed Aug 11 20:53:26 EDT 2010
File created using CLI (command line interface) in Spatialite could
not be opened in QGIS 1.5 and (QGIS 1.4) in Windows 7 and XP. And vice
versa i.e. spatialite created in QGIS 1.5 could not be opened as well
Please note that Spatialite test database could not open property in
QGIS 1.4 and QGIS 1.5. You can open the file but it will not render
the geometry polygon.
I am trying to create a Spatialite file from a Shapefile.
Steps In QGIS 1.5
1. Load Shapefile
2. Save Shapefile to Spatialite - Spatialite file successful created.
3. Remove Shapefile from Qgis.
4. Open Spatialte file that was created in QGIS - It is rendered
5. OK, no problem
Steps in Spatialite CLI using Spatialite 2.4
1. Create a Spatialite database
3. Initalise the database (.read init_spatialite-2.4.sql ASCII)
2. Load Shapeflle (.loadshp)
3. Inspect tables (.tables)
4. Close command line
Now, the problems.
In QGIS - Problem in opening Spatialite file created by Spatialite CLI in QGIS.
It ask you for layers to open. You can select any tables, yet it will
not render the polygons. You can see the attributes though.
In Spatialite-GIS - Problem in opening QGIS created spatialite file.
"Missing or invalid Spatial Metadata tables
I examined theSpatialite file created in QGIS 1.5 using Spatialite
CLI, the 2 metadata tables are present.
What causes these incompatibilities and any solution to the problem?
Problem in Geoserver with Spatialite.
More information about the Qgis-developer