[GRASS-user] SQLite connection - error

[Espen Isaksen]

Thanks Achim and Ben for your quick answers! I never even thought
about that(a bit embarrassing really :-) )

I suppose that means I am back to the horribly slow import through
v.in.ogr. Practically impossible for me to import a 100 mb shapefile.
If anybody has suggestions for good performance, please go ahead and
tell me.

Espen



2010/6/24 Achim Kisseler <achim.kisseler at jupiter.uni-freiburg.de>:
> This is because SQLite is not SpatiaLite (SQLite with spatial extension).
>
> GRASS does not support SpatiaLite as far as I know.
>
> If you just want to use the Data from Spatiallite, you can export the tables
> as shape-files or csv and import these to GRASS.
>
> Hope it helps a bit,
> Achim
>
> Espen Isaksen schrieb:
>>
>> 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
>>
>
>