[GRASS-user] SQLite connection - error

[Benjamin Ducke]

No, unfortunately you are right.
This is not an option for you.

There is some severe inefficiency in
the way v.in.ogr handles attribute and
geometry data during import, which makes
the whole process slow.

Unfortunately, no one has yet stepped forward
to re-design the logics (as far as I am
aware).

Ben

----- Espen Isaksen <espen.isaksen at gmail.com> wrote:
> 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
> >
> 



------
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.