Thanks Even!
On Mon, Jul 3, 2023, 3:11 AM Even Rouault
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 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
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
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,
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
>
>
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
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