[GRASS-user] SQLite connection - error

[Benjamin Ducke]

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 grass-user at lists.osgeo.org
> 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.