<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap:break-word"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">It is a spatialite database.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">The data field is the SQLITE_BLOB that should not be recognised as geometry. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div> <br> <div id="bloop_sign_1477309692772182016" class="bloop_sign"></div> <br><p class="airmail_on">On 24 October 2016 at 10:42:21 pm, jratike80 (<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>How did you create the database? It is a spatial db for Spatialite as well<br>because it contains also field GEOMETRY which is registered in<br>geometry_columns.<br><br>DLL of the "timeseries" table is<br>CREATE TABLE 'timeseries' ( ogc_fid INTEGER PRIMARY KEY, 'data' BLOB, 'end'<br>VARCHAR, 'start' VARCHAR, 'station_id' INTEGER, 'timestep' INTEGER, 'type'<br>VARCHAR, "GEOMETRY" GEOMETRY)<br><br>Ogrinfo -al -so finds these attributes:<br><br>FID Column = ogc_fid<br>Geometry Column 1 = data<br>Geometry Column 2 = GEOMETRY<br>end: String (0.0)<br>start: String (0.0)<br>station_id: Integer (0.0)<br>timestep: Integer (0.0)<br>type: String (0.0)<br><br>If I drop column "GEOMETRY" with spatialite-gui which also removes the line<br>from geometry_columns the table is not more a spatial table for GDAL<br><br>ogrinfo binary_blob.sqlite -al -so<br>INFO: Open of `binary_blob.sqlite'<br> using driver `SQLite' successful.<br><br>Is your aim to have both the geometry and some blob fields? Is the problem<br>in here:<br>Geometry Column 1 = data<br>Geometry Column 2 = GEOMETRY<br><br>So, field "data" is somehow reported to be a geometry even it is not<br>registered in the geometry_columns. That does feel a bit odd.<br><br><br><br><br>--<br>View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292285.html">http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292285.html</a><br>Sent from the GDAL - Dev mailing list archive at Nabble.com.<br>_______________________________________________<br>gdal-dev mailing list<br><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></div></div></span></blockquote></body></html>