[FWTools] ogr2ogr newbie question, MapInfo to SQLite conversion

Richard Greenwood richard.greenwood at gmail.com
Thu Feb 5 09:26:17 EST 2009

On Thu, Feb 5, 2009 at 6:06 AM, Per Åkesson <Per.Akesson at carmenta.com> wrote:
> As subject says, bare with a newbie question:
> I'm trying to convert a Mapinfo .TAB table to SQLite.
> I'm issuing the folwing command:
> ogr2ogr  -f "SQLite" test.SQLite mapinfotable.TAB
> but when inspecting the generated test.SQLite file in SQLite,
>        select * from GEOMETRY_COLUMNS;
> I get no geografic data. (Other attributes seemes to be there)
> Am I missing some command line switch ?
> All relevant MapInfo files exists (.MAP, .IND, .ID, .DAT)
> Thanks in advance
> -----------
> Per Åkesson
> Carmenta AB

Your query should return only one row. The GEOMETRY_COLUMNS table
simply lists the name of the column that holds the geometry for each
Would query the geometry for each object that you imported.

Richard Greenwood
richard.greenwood at gmail.com

More information about the FWTools mailing list