Hi Espen, the regular SQLite tables driver does not support geometry storage in SQLite databases. If you want to connect to a spatially enabled SQlite3 database, use v.in.ogr instead.
Cheers, Ben ----- Original Message ----- > Hi! > > I have tried to read the documentation and the mailing list for how to > connect to a SQLite database. So far I have done this: > > 1. db.connect driver=sqlite database='/home/espen/db.sqlite' > 2. Created a new vector map called test > 3. v.db.connect map=test table=GSHHS_f_L2 -o key=PK_UID > > However I get this warning: > > WARNING: SQLite driver: unable to parse decltype: POLYGON > WARNING: SQLite driver: unable to parse decltype: POLYGON > WARNING: SQLite driver: column 'Geometry', SQLite type 2 is not > supported > WARNING: SQLite driver: unable to parse decltype: POLYGON > WARNING: SQLite driver: unable to parse decltype: POLYGON > WARNING: SQLite driver: column 'Geometry', SQLite type 2 is not > supported The table <GSHHS_f_L2> is now part of vector map <test> and > may be deleted > or overwritten by GRASS modules > > And running v.info map=test show that the layer does not have any > objects > > +----------------------------------------------------------------------------+ > | Layer: test | > | Mapset: PERMANENT | > | Location: newLocation | > | Database: /home/espen/Dokumenter/grassdata | > | Title: | > | Map scale: 1:1 | > | Map format: native | > | Name of creator: espen | > | Organization: | > | Source date: Wed Jun 23 08:55:30 2010 | > |----------------------------------------------------------------------------| > | Type of Map: vector (level: 2) | > | | > | Number of points: 0 Number of areas: 0 | > | Number of lines: 0 Number of islands: 0 | > | Number of boundaries: 0 Number of faces: 0 | > | Number of centroids: 0 Number of kernels: 0 | > | | > | Map is 3D: No | > | Number of dblinks: 1 | > | | > | Projection: Lat/Lon | > | N: 0 S: 0 | > | E: 0 W: 0 | > | | > | Digitization threshold: 0 | > | Comments: | > | | > +----------------------------------------------------------------------------+ > > Could anybody explain to me what the warning means, and why I cannot > access the features? The only thing i can guess is that I can only use > version 1 of SQLite? However, I am not familiar with the different > versions of SQLite. > > Kind regards, > Espen Isaksen > _______________________________________________ grass-user mailing > list [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user ------ Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information. _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
