[GRASS-user] SQLite connection - error

[Espen Isaksen]

My understading from this page is that it is not possible to compile
OGR with Grass write support?

http://gdal.org/ogr/ogr_formats.html

Am I wrong? This might indicate that write support is possible:

http://grass.osgeo.org/wiki/Compile_and_install_GDAL-GRASS_plugin

Espen



2010/6/24 Benjamin Ducke <benjamin.ducke at oxfordarch.co.uk>:
> You could try compiling GDAL with GRASS support and
> using ogr2ogr directly to convert from the external
> format to GRASS.
>
> Ben
>
>
> ----- Original Message -----
>> 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
>> >>
>> >
>> >
>> _______________________________________________ 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.
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>