[FWTools] ogr2ogr newbie question, MapInfo to SQLite conversion

[Richard Greenwood]

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
> SWEDEN

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

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com