[Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

[Donovan Cameron]

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_dev at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121209/b30fd3d2/attachment.html>