I created a sqlite/spatialite db from the spatialite_gui and started to import a bunch of shapefiles.
Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom as the name for the geometry field (type is set to auto...) Then in spatialite_gui I expanded each new table and built a spatial index. I can also right click each the_geom table and see a valid "Map Preview". But I can't open or load this .sqlite files into either spatialite_gis or qgis. So I think this could be a problem with my actual OS (openSUSE 12.2 x64 w/ KDE). QGIS loads the layers as tables, not vectors. spatialite_gis thrown an error: Missing or invalid Spatial Metadata tables: - spatial_ref_sys - geometry_columns Sorry, cowardly quitting ... But those tables are in the .sqlite db under the "Metadata" portion. >From the layer menu in QGIS, I can't create a layer in a sqlite db. It says that my layer is invalid and can't be created. Then I can't even see this sqlite database (that got created successfully, it's just the layer that failed creation) when navigating from the add vector window. But I can see it when trying to load from spatialite_gis but that throws the same error. I noticed in the DB Manager plugin, it says that pyspatialite is missing and that package isn't available for openSUSE in the open build service, unless it goes by a different name...
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
