<div dir="auto">Thanks Even!</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jul 3, 2023, 3:11 AM Even Rouault <<a href="mailto:even.rouault@spatialys.com">even.rouault@spatialys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Patrick,<br>
<br>
blocking error fixed per <a href="https://github.com/OSGeo/gdal/pull/8040" rel="noreferrer noreferrer" target="_blank">https://github.com/OSGeo/gdal/pull/8040</a><br>
<br>
and the one related to esriFieldTypeDate in <br>
<a href="https://github.com/OSGeo/gdal/pull/8039" rel="noreferrer noreferrer" target="_blank">https://github.com/OSGeo/gdal/pull/8039</a><br>
<br>
Even<br>
<br>
Le 28/06/2023 à 17:18, Patrick Young a écrit :<br>
> Hi,<br>
><br>
> I'm playing around with the gdb dataset<br>
><br>
> <a href="https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d" rel="noreferrer noreferrer" target="_blank">https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d</a><br>
><br>
> and getting errors starting with gdal 3.5 when I try to use the sqlite <br>
> dialect:<br>
><br>
> ogr2ogr -f GeoJSONSeq -sql "select shape from roadbed where source_id <br>
> = 13350003311" -dialect sqlite /vsistdout/ <br>
> NYC_DoITT_Planimetric_OpenData.gdb.zip<br>
><br>
> ERROR 6: Unsupported field type for range domain: esriFieldTypeDate<br>
> ERROR 1: Cannot create virtual table for layer 'roadbed' : CREATE <br>
> VIRTUAL: invalid SQL statement : CREATE TABLE "roadbed"("SOURCE_ID" <br>
> FLOAT,"FEATURE_CODE" <br>
> INTEGER_INT16_BEGIN_DOMAIN_NAME_64526F6164626564_END_DOMAIN_NAME,"SUB_FEATURE_CODE" <br>
> INTEGER,"STATUS" <br>
> VARCHAR(16)_BEGIN_DOMAIN_NAME_645374617475735F31_END_DOMAIN_NAME,"SHAPE_Length" <br>
> FLOAT,"SHAPE_Area" FLOAT,OGR_STYLE VARCHAR HIDDEN,"SHAPE" <br>
> BLOB_MULTIPOLYGON_XY_2263, OGR_NATIVE_DATA VARCHAR, <br>
> OGR_NATIVE_MEDIA_TYPE VARCHAR)<br>
> ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select shape from roadbed <br>
> where source_id = 13350003311):<br>
>   no such table: roadbed<br>
><br>
> This command works in GDAL 3.4 (and also works with the ogr sql <br>
> dialect); I was wanting to use the sqlite dialect so that i can use <br>
> CASE statements.  Is this a bug or expected?<br>
><br>
> Thanks,<br>
> Patrick<br>
><br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
> <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank" rel="noreferrer">gdal-dev@lists.osgeo.org</a><br>
> <a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
-- <br>
<a href="http://www.spatialys.com" rel="noreferrer noreferrer" target="_blank">http://www.spatialys.com</a><br>
My software is free, but my time generally not.<br>
<br>
</blockquote></div>