On 03/08/16 23:04, Johannes Radinger wrote:
Hi all,

the database is the original sqlite database the ships with the the NC
grass7 location (nc_spm_08_grass7). I want to import a single table (e.g
'streams') from that NC grass7 database (source, sqlite) into my new
location (target) using db.in.ogr. As far as I understand, for the
module db.in.ogr the database scheme of the target location should not
be of relevance?! Interestingly, the database scheme (either sqlite, dbf
etc) of the source db/table is not explicitly specified in db.in.ogr?!

Well, it is specified implicitely in the input= parameter, and ogr automagically identifies the file type on its own.

The issue is not really with file type. In your original message you had this error:

db.in.ogr
input=/media/grassgis_data/GRASS_locations/nc_spm_08_grass7/PERMANENT/sqlite/sqlite.db
db_table=streams output=my_test
ERROR: Unable to open data source <streams>
ERROR: Input table <streams> not found or not readable

So, apparently there is no table streams in the sqlite.db you give in the input parameter. So I suggest to run

v.db.connect -p streams@PERMANENT to see which table this map is connected to.

You can also run

db.tables -p driver=sqlite database=/media/grassgis_data/GRASS_locations/nc_spm_08_grass7/PERMANENT/sqlite/sqlite.db

to see which tables are in that database.

Moritz
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to