[gdal-dev] ogr2ogr sqlite dialect and fgb format

[Patrick Young]

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 <public at 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 at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/gdal-dev
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230628/30b59209/attachment.htm>