<div dir="auto">The table exists, the SQL emitted to create the virtual table is the issue from the looks of it.  The command works as is in gdal 3.4 FWIW</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 28, 2023, 9:29 AM Scott <<a href="mailto:public@postholer.com">public@postholer.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The last line says:<br>
    no such table: roadbed<br>
<br>
See if it exists in the gdb:<br>
<br>
ogrinfo dataset.gdb<br>
<br>
On 6/28/23 08:18, Patrick Young wrote:<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>
> <<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" INTEGER,"STATUS" VARCHAR(16)_BEGIN_DOMAIN_NAME_645374617475735F31_END_DOMAIN_NAME,"SHAPE_Length" FLOAT,"SHAPE_Area" FLOAT,OGR_STYLE VARCHAR HIDDEN,"SHAPE" BLOB_MULTIPOLYGON_XY_2263, OGR_NATIVE_DATA VARCHAR, 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 CASE <br>
> 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>
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>
</blockquote></div>