Forgot to mention that tutorial link for reference: http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t3
On Sun, Dec 9, 2012 at 12:11 PM, Donovan Cameron <sault....@gmail.com>wrote: > Thanks alex, that's definitely helpful. > I tried to install pyspatialite with easy_install and it tries to grab > "Best match: pyspatialite 3.0.1" which fails with a lot of errors... > > I can run through the tutorials from the spatialite page and this is the > initial output, telling me I am using spatialite 4: > SpatiaLite version ..: 4.0.0 Supported Extensions: > - 'VirtualShape' [direct Shapefile access] > - 'VirtualDbf' [direct DBF access] > - 'VirtualXL' [direct XLS access] > - 'VirtualText' [direct CSV/TXT access] > - 'VirtualNetwork' [Dijkstra shortest path] > - 'RTree' [Spatial Index - R*Tree] > - 'MbrCache' [Spatial Index - MBR cache] > - 'VirtualSpatialIndex' [R*Tree metahandler] > - 'VirtualFDO' [FDO-OGR interoperability] > - 'SpatiaLite' [Spatial SQL - OGC] > PROJ.4 version ......: Rel. 4.8.0, 6 March 2012 > GEOS version ........: 3.3.6-CAPI-1.7.6 > SQLite version ......: 3.7.12.1 > > I only installed QGIS from the GEO openSUSE repo. > I wonder if this is a dependency issue for the package maintainers? > > I have a freshly installed 12.2 KDE on a laptop and that also shows the > same output from above when creating a new sqlite db from spatialite. > > > > On Sun, Dec 9, 2012 at 12:00 PM, Alex Mandel > <tech_...@wildintellect.com>wrote: > >> On 12/09/2012 10:40 AM, Donovan Cameron wrote: >> > 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... >> > >> >> to solve the missing pyspatialite: >> easy_install pyspatialite >> OR >> pip install pyspatialite >> >> packages for above commands >> python-setuptools >> python-pip or python-distrubute >> >> Keep in mind that many python packages do not come in the distros but >> are platform independent and easy to install from the pypi python repo >> using setup tools or pip. >> >> This doesn't solve your original issue. What version of spatialite are >> you using. QGIS doesn't support the new 4.0 stuff yet... >> >> Thanks, >> Alex >> > >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user