Thanks Even! On Mon, Jul 3, 2023, 3:11 AM Even Rouault <even.roua...@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@lists.osgeo.org > > https://lists.osgeo.org/mailman/listinfo/gdal-dev > > -- > http://www.spatialys.com > My software is free, but my time generally not. > >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev