Re: [gdal-dev] SQLite driver hit and miss with spatial index

Frederik Ramm wrote > Hi, > >while what I wrote in the previous post is still interesting and a > bit strange, I have meanwhile upgraded to GDAL 2 packages from the > ubuntugis-unstable repository for Xenial, and now the behaviour is as I > would expect it: The ogr2ogr -spat command *with*

Re: [gdal-dev] SQLite driver hit and miss with spatial index

Hi, while what I wrote in the previous post is still interesting and a bit strange, I have meanwhile upgraded to GDAL 2 packages from the ubuntugis-unstable repository for Xenial, and now the behaviour is as I would expect it: The ogr2ogr -spat command *with* indexes takes practically no time

Re: [gdal-dev] SQLite driver?

Yes, it had a small image attached. But never mind, I ended up finding that the crash resulted from the fact that some other gdal.dll without sqlite driver managed to get in the way. The bad new was that, once this solved, I got another crash latter but there is nothing in it that I can

Re: [gdal-dev] SQLite driver?

On 2016-09-14 6:55 PM, Joaquim Luis wrote: FWIW, my reply with an attached image is waiting for approval. Joaquim, I checked in the mailman backend and I don't see a message being held. But for sure always always when using mailing lists never try attaching things, for example if you need

Re: [gdal-dev] SQLite driver?

FWIW, my reply with an attached image is waiting for approval. I haven't done serious Windows coding since the NT days, but I found this. Sounds like this will do it and then you can load the dump in visual >studio and get the stack track, yes? Anyone who actually uses windows +

Re: [gdal-dev] SQLite driver?

I haven't done serious Windows coding since the NT days, but I found this. Sounds like this will do it and then you can load the dump in visual studio and get the stack track, yes? Anyone who actually uses windows + visualstudio want to comment? -kurt

Re: [gdal-dev] SQLite driver?

Yes, but (that I know) we don't get long stack traces in VS. Exception thrown at 0x7FFF88F87788 in osmcoastline.exe: Microsoft C++ exception: gdalcpp::gdal_error at memory location 0x00CD6E33E090. Unhandled exception at 0x7FFF88F87788 in osmcoastline.exe: Microsoft C++ exception:

Re: [gdal-dev] SQLite driver?

A stack trace would give others a chance to possibly spot what the crash is. On Wed, Sep 14, 2016 at 11:31 AM, Joaquim Luis wrote: > OK, clean & rebuilt (as I (thought) did before) and I can see the SQLite > driver now. > However, the osmcoastline still crashes. Unfortunately,

Re: [gdal-dev] SQLite driver?

OK, clean & rebuilt (as I (thought) did before) and I can see the SQLite driver now. However, the osmcoastline still crashes. Unfortunately, it's too damn C++ for me to debugg. Le mercredi 14 septembre 2016 19:43:22, Joaquim Luis a écrit : Sorry, my bad. When I thought I was using

Re: [gdal-dev] SQLite driver?

Le mercredi 14 septembre 2016 19:43:22, Joaquim Luis a écrit : > Sorry, my bad. When I thought I was using gisinternals I was actually > using my build. Gisinternals does show the SQLite driver. > > But one of my points still holds. If the Walker shows me that sqlite3.dll > is a dependency than

Re: [gdal-dev] SQLite driver?

Sorry, my bad. When I thought I was using gisinternals I was actually using my build. Gisinternals does show the SQLite driver. But one of my points still holds. If the Walker shows me that sqlite3.dll is a dependency than why the SQLite driver is not available? Hmm, several (weird)

Re: [gdal-dev] SQLite driver?

Hmm, several (weird) things. 1. I'm using GnuWin ports for unix commands. And: - this works gdalinfo --formats | sort - this not (output is empty) ogfinfo --formats | sort Same thing for 'grep' 2. To check I'm using gisinternals and same thing as my build.

Re: [gdal-dev] SQLite driver?

ogrinfo --formats | grep -i lite SQLite -vector- (rw+v): SQLite / Spatialite On Wed, Sep 14, 2016 at 9:32 AM, Joaquim Luis wrote: > > Sorry Even that you are bombed with so many questions. > > I have (re)build GDAL with sqlite and can confirm with The (Dependency) > Walker that

Re: [gdal-dev] SQLite driver and drop table problem

Le vendredi 14 juin 2013 20:18:19, Piotr Tracz a écrit : Hello, I think there might be a bug in OGRSQLiteDataSource::ExecuteSQL but before I make bug ticket, I want to be sure I'm not missing anything. When one try to execute SQL command DROP TABLE xxx, error In ExecuteSQL():

Re: [gdal-dev] SQLite driver and drop table problem

W dniu 2013-06-14 20:58, Even Rouault pisze: http://svn.osgeo.org/gdal/trunk/autotest/ogr/data/poly_spatialite.sqlite and then do : ogrinfo poly_spatialite.sqlite -sql drop table poly ? This works for me with SQLITE 3.6.22 and 3.7.13. Yes it works. False alarm. Error was a reason of some

Re: [gdal-dev] SQLite Driver and non-spatial tables

For the record, in case anyone is interested, it appears setting SQLITE_LIST_ALL_TABLES=YES appears to allow me access to non-spatial tables. I didn't find any documentation on the format page though. On Tue, Nov 13, 2012 at 1:44 PM, Kyle Shannon k...@pobox.com wrote: I have a Spatialite