<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Here is a link to a small test database<br class=""><div class=""><br class=""></div><div class=""><a href="https://www.dropbox.com/s/vwu4q7ud3e3sv2y/binary_blob.sqlite.zip?dl=0" class="">https://www.dropbox.com/s/vwu4q7ud3e3sv2y/binary_blob.sqlite.zip?dl=0</a></div><div class=""><br class=""></div><div class="">The problem seems to come up when the BLOB is a bit bigger. I couldn’t reproduce it with a smaller dataset. </div><div class=""><br class=""></div><div class="">For the db I get with ogrinfo GDAL 2.1.0</div><div class=""><br class=""></div><div class=""><div class="">INFO: Open of `/home/christian/Desktop/binary_blob.sqlite'</div><div class=""> using driver `SQLite' successful.</div><div class="">1: timeseries</div><div class=""><br class=""></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 24 Oct. 2016, at 7:17 pm, jratike80 <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" class="">jukka.rahkonen@maanmittauslaitos.fi</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Please put a test db somewhere or describe how to create such a database. I<br class="">made a quick test by importing some XML file with spatialite-gui 1.8.0-dev.<br class="">it creates a table as<br class=""><br class="">CREATE TABLE "xml" (<br class="">"pk_uid" INTEGER PRIMARY KEY AUTOINCREMENT,<br class="">"xml_document" BLOB NOT NULL<br class="">,"file_name" TEXT NOT NULL<br class="">,"schema_uri" TEXT<br class="">,"parse_errors" TEXT<br class="">,"validate_errors" TEXT);<br class=""><br class="">Test with ogrinfo of GDAL 2.2.0dev does not list table "xml".<br class=""><br class="">ogrinfo blob.sqlite<br class="">INFO: Open of `blob.sqlite'<br class=""> using driver `SQLite' successful.<br class="">1: layer_1 (Point)<br class=""><br class="">-Jukka Rahkonen-<br class=""><br class=""><br class=""><br class="">--<br class="">View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292228.html" class="">http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292228.html</a><br class="">Sent from the GDAL - Dev mailing list archive at <a href="http://Nabble.com" class="">Nabble.com</a>.<br class="">_______________________________________________<br class="">gdal-dev mailing list<br class=""><a href="mailto:gdal-dev@lists.osgeo.org" class="">gdal-dev@lists.osgeo.org</a><br class="">http://lists.osgeo.org/mailman/listinfo/gdal-dev</div></div></blockquote></div><br class=""></div></body></html>