[gdal-dev] ogr2ogr sqlite dialect and fgb format

[Patrick Young]

Thanks Even!

On Mon, Jul 3, 2023, 3:11 AM Even Rouault <even.rouault at spatialys.com>
wrote:

> Hi Patrick,
>
> blocking error fixed per https://github.com/OSGeo/gdal/pull/8040
>
> and the one related to esriFieldTypeDate in
> https://github.com/OSGeo/gdal/pull/8039
>
> Even
>
> Le 28/06/2023 à 17:18, Patrick Young a écrit :
> > Hi,
> >
> > I'm playing around with the gdb dataset
> >
> > 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
>
> --
> http://www.spatialys.com
> My software is free, but my time generally not.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230707/efb8341c/attachment.htm>