[Gdal-dev] SQLite problem

[Frank Warmerdam]

iomeneandrei wrote:
> Hi all,
> I have created a sqlite spatial db with ogr2ogr, starting from a simple
> shapefile.
> 
> I'm able to read the proper info of this sqlite db with ogrinfo.
> 
> If I add a column to this sqlite db inside the table where I have the
> WKT_GEOMETRY, ogrinfo is no more able to read properly this db.
> 
> Is it possible to add a column to  a sqlite spatial db without destroy the
> spatial component?
> 
> I'm using SQLite Manager 0.3.15 for firefox to edit the db.
> 
> I'm attaching the original sqlite file: 
> http://www.nabble.com/file/p20233548/output1.sqlite output1.sqlite 

Andrea,

The file you referenced seems to work fine with my (trunk) ogrinfo.  Can you
provide an example that ogrinfo can't read?  Generally, adding new columns to
a spatial table should not cause problems for OGR.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent