<div dir="ltr">Here's the CREATE TABLE from 3.4:<br><br>OGR2SQLITE: sqlite3_declare_vtab(CREATE TABLE "roadbed"("SOURCE_ID" FLOAT,"FEATURE_CODE" INTEGER_INT16,"SUB_FEATURE_CODE" INTEGER,"STATUS" VARCHAR(16),"SHAPE_Length" FLOAT,"SHAPE_Area" FLOAT,OGR_STYLE VARCHAR HIDDEN,"SHAPE" BLOB_MULTIPOLYGON_XY_2263, OGR_NATIVE_DATA VARCH<br>AR, OGR_NATIVE_MEDIA_TYPE VARCHAR))<br><div><br></div><div>In the 3.5+ versions, sqlite is angry about the INTEGER_INT16_BEGIN_DOMAIN_NAME_64526F6164626564_END_DOMAIN_NAME</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 28, 2023 at 9:18 AM Patrick Young <<a href="mailto:patrick.mckendree.young@gmail.com">patrick.mckendree.young@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>I'm playing around with the gdb dataset </div><div><br></div><div><a href="https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d" target="_blank">https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d</a> </div><div><br></div><div>and getting errors starting with gdal 3.5 when I try to use the sqlite dialect:</div><div><br></div><div>ogr2ogr -f GeoJSONSeq -sql "select shape from roadbed where source_id = 13350003311" -dialect sqlite /vsistdout/ NYC_DoITT_Planimetric_OpenData.gdb.zip</div><div><br>ERROR 6: Unsupported field type for range domain: esriFieldTypeDate<br>ERROR 1: Cannot create virtual table for layer 'roadbed' : CREATE VIRTUAL: invalid SQL statement : CREATE TABLE "roadbed"("SOURCE_ID" FLOAT,"FEATURE_CODE" 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 where source_id = 13350003311):<br>  no such table: roadbed<br></div><div><br></div><div>This command works in GDAL 3.4 (and also works with the ogr sql dialect); I was wanting to use the sqlite dialect so that i can use CASE statements.  Is this a bug or expected?</div><div><br></div><div>Thanks,</div><div>Patrick</div></div>
</blockquote></div>