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