[Qgis-user] Loading SpatiaLite databases

[Mike Leahy]

Hi Giuseppe,

That did work - although I also figured out that I was missing the step where I 
need to run the init_spatialite script for the SpatiaLite db - that step seems 
to fall pretty late in tutorial on the SpatiaLite project page, and I missed 
it initially.

Thanks,
Mike

On Sunday, August 01, 2010 06:29:34 Giuseppe Sucameli wrote:
> Hi Mike,
> 
> you have a sqlite db with not spatialite support enabled.
> You can load that db by the "Add Vector Layer".
> 
> Cheers.
> 
> On Sun, Aug 1, 2010 at 12:43 AM, Mike Leahy 
<mgleahy at alumni.uwaterloo.ca>wrote:
> > Hello list,
> > 
> > I'm having trouble opening an spatialite database that I created by
> > importing
> > a shapefile.  When I try to open the db, I get a message saying:
> > 
> > "Failure while connecting to:
> > /path/to/filename.sqlite
> > 
> > seems to be a valid SQLite DB, but not a SpatiaLite's one..."
> > 
> > I've found a couple references to this error in my searches online, but
> > nothing conclusive yet.
> > 
> > I created the file by opening the db with 'spatialite
> > /path/to/filename.db',
> > then used the .loadshp command to import a shapefile into the database.
> > 
> >  The
> > 
> > data appear to be fine, and I can query it and the geometries all seem to
> > work
> > (e.g., "select area(Geometry) from tablename;" produces the expected
> > output).
> > 
> > I also have the same problem if I use the OGR conversion utility in QGIS
> > to convert a shapefile to SQLite - though I'm guessing in this case it's
> > because
> > OGR isn't creating an actual SpatiaLite file.
> > 
> > I'm doing this using QGIS 1.5 on 64-bit Ubuntu.  Here's the version
> > information from spatialite:
> > 
> > SpatiaLite version ..: 2.4.0    Supported Extensions:
> >        - 'VirtualShape'        [direct Shapefile access]
> >        - 'VirtualDbf'          [direct DBF access]
> >        - 'VirtualText'         [direct CSV/TXT access]
> >        - 'VirtualNetwork'      [Dijkstra shortest path]
> >        - 'RTree'               [Spatial Index - R*Tree]
> >        - 'MbrCache'            [Spatial Index - MBR cache]
> >        - 'VirtualFDO'          [FDO-OGR interoperability]
> >        - 'SpatiaLite'          [Spatial SQL - OGC]
> > 
> > PROJ.4 version ......: Rel. 4.7.1, 23 September 2009
> > GEOS version ........: 3.2.2-CAPI-1.6.2
> > SQLite version ......: 3.6.22
> > 
> > Is there something incompatible here, or am I doing something wrong in
> > the creation of the SpatiaLite DB?
> > 
> > Regards,
> > Mike
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user