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

[Moritz Lennert]

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>

Moritz