[GRASS-user] Import sqlite table using db.in.ogr

Moritz Lennert mlennert at club.worldonline.be
Wed Aug 3 06:52:37 PDT 2016

On 03/08/16 12:35, Johannes Radinger wrote:
> Hi,
> I am trying to import a sqlite table to my current mapset database
> (sqlite). In a further step I want to join the imported table to an
> already existing attribute table in my mapset-specific sqlite database.
> However I get an error that when I want to import the table. Here an
> example where I want to import the "streams" table from the PERMANENT
> mapset of the NC location (GRASS7):
> 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

Are you sure that the database used is sqlite ?

I get:

v.db.connect -p streams
Vector map <streams> is connected by:
layer <1/streams> table <streams> in database 
</data/GRASS/DATA7/nc_spm_08/PERMANENT/dbf/> through driver <dbf> with 
key <cat>


More information about the grass-user mailing list