Re: [gdal-dev] ogr2ogr sqlite dialect and fgb format

There may be a way to address the underlying issue, I don't know what it is. In lieu of that, here's a work around in 2 steps in 3.7. Create a gpkg: ogr2ogr -sql "select * from roadbed where source_id = 13350003311" tmp.gpkg /vsizip/NYC_DoITT_Planimetric_OpenData.gdb.zip Then do it with -dia

[gdal-dev] Converting VPF vector set into shapefile (under Windows environment)

Dear all, I would like to convert a VPF vector set ( OGDI driver ) into shapefile format. My environment is as follow: - windows 10 - GDAL environment installed with QGIS 3.26.0 : *GDAL 3.5.0, released 2022/05/10* - the OGDI driver is ava

Re: [gdal-dev] ogr2ogr sqlite dialect and fgb format

Here's the CREATE TABLE from 3.4: 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_DA

Re: [gdal-dev] ogr2ogr sqlite dialect and fgb format

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 wrote: > The last line says: > no such table: roadbed > > See if it exists in the gdb: > > ogrinfo dataset.gdb > > On

Re: [gdal-dev] ogr2ogr sqlite dialect and fgb format

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

[gdal-dev] ogr2ogr sqlite dialect and fgb format

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 sqlit