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
On Wed, Jun 28, 2023, 9:29 AM Scott <pub...@postholer.com> wrote: > The last line says: > no such table: roadbed > > See if it exists in the gdb: > > ogrinfo dataset.gdb > > On 6/28/23 08:18, Patrick Young wrote: > > Hi, > > > > I'm playing around with the gdb dataset > > > > https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d > > <https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d > > > > > > and getting errors starting with gdal 3.5 when I try to use the sqlite > > dialect: > > > > ogr2ogr -f GeoJSONSeq -sql "select shape from roadbed where source_id = > > 13350003311" -dialect sqlite /vsistdout/ > > NYC_DoITT_Planimetric_OpenData.gdb.zip > > > > ERROR 6: Unsupported field type for range domain: esriFieldTypeDate > > 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) > > ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select shape from roadbed > > where source_id = 13350003311): > > no such table: roadbed > > > > 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? > > > > Thanks, > > Patrick > > > > _______________________________________________ > > gdal-dev mailing list > > gdal-dev@lists.osgeo.org > > https://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev