On Thu, Jun 24, 2010 at 10:35 AM, Espen Isaksen <[email protected]> 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 <[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 > _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
