Hi all,
I have change client and I have no more problems.
Thank you for all.
This is a great mailing list.
Best regards,
a
P.S. the client is http://sqliteadmin.orbmu2k.de/
-
Andrea Borruso
email: [EMAIL PROTECTED]
blog:
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
This must be a problem with your SQLite client.
I used the sqlite3 console gui and did on your database:
ALTER TABLE output ADD COLUMN newcolumn VARCHAR;
ogrinfo was still working afterwards.
Le Wednesday 29 October 2008 19:52:41 iomeneandrei, vous avez écrit :
d a column to this sqlite db
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
Hi Frank,
thank you very much.
Frank Warmerdam-2 wrote:
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.
The file I have attache
I can read output2.sqlite with ogrinfo:
INFO: Open of `output2.sqlite'
using driver `SQLite' successful.
Layer name: output
Geometry: Point
Feature Count: 2
Extent: (13.00, 38.00) - (13.50, 39.00)
Layer SRS WKT:
GEOGCS[WGS 84,
DATUM[WGS_1984,
SPHEROID[WGS
Yes, see http://www.sqlite.org/lang_altertable.html
You need SQLite 3.1.3
Le Wednesday 29 October 2008 23:44:37 Even Rouault, vous avez écrit :
I can read output2.sqlite with ogrinfo:
INFO: Open of `output2.sqlite'
using driver `SQLite' successful.
Layer name: output
Geometry: Point
Hi Even,
Even Rouault wrote:
Yes, see http://www.sqlite.org/lang_altertable.html
You need SQLite 3.1.3
to build my sqlite spatial db I use ogr2ogr utility I have in the lates
fwtools for windows.
The same for ogrinfo. Whit this I have:
FAILURE:
Unable to open datasource `C:\output2.sqlite