Hi,
will do.
I run into another problem. The update statement for multiple geometry
fails.
ERROR 1: In SetFeature(): sqlite3_prepare(UPDATE 'timeseries' SET "data" =
?"GEOMETRY" = ?,"end" = ?,"start" = ?,"station_id" = ?,"timestep" =
?,"type" = ?,"s" = ? WHERE "ogc_fid" = 1):
near ""GEOMETRY"": syntax error
Looks like a comma is missing. Looking at the code my guess is
gdal/gdal/ogr/ogrsf_frmts/sqlite/ogrsqlitetablelayer.cpp line 2640 misses a
if( bNeedComma )
osCommand += ",";
On 24 October 2016 at 11:00:34 pm, jratike80 (
[email protected]) wrote:
Hi,
It does smell like a bug. Could you repeat my test and take care to have the
additional BLOB field created after the geometry field? For me this
workaround seems to work and there is only one geometry left and "data"
field is reported as "binary" type.
FID Column = ogc_fid
Geometry Column = geometry
end: String (0.0)
start: String (0.0)
station_id: Integer (0.0)
timestep: Integer (0.0)
type: String (0.0)
data: Binary (0.0)
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292293.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
