[GRASS-user] SQLite connection - error

Markus Metz markus.metz.giswork at googlemail.com
Thu Jun 24 07:12:43 EDT 2010


On Thu, Jun 24, 2010 at 10:35 AM, Espen Isaksen <espen.isaksen at gmail.com> wrote:
> 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.

You could try grass 7, see [1]

Really big shapefiles like GADM v1 (gadm1.shp is 913 MB) will take at
least 1 hour, though.

Alternatively, get v.in.gshhs from grass-addons [2], get the original
GSHHS data [3] and import those with v.in.gshhs

Markus M

[1] http://grass.osgeo.org/wiki/GRASS_7_ideas_collection#Radim.27s_TODO_list
[2] http://grass.osgeo.org/wiki/GRASS_AddOns#v.in.gshhs
[3] ftp://ftp.soest.hawaii.edu/pwessel/gshhs/gshhs_2.0.tbz

>
>
>
> 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
>>>
>>
>>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>


More information about the grass-user mailing list