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
