Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-08-31 Thread Rahkonen Jukka
Hi, When the SQLite dialect is used, a temporary SQLite database is created. OBJECTID is a feature identifier (FID) and I guess that the FID gets converted into a primary key with the SQLite defaults. So maybe you can find the OBJECTID from ROWID. I made a simple test and at least this command

Re: [gdal-dev] multidim arraySpecs/GetView

2023-08-31 Thread Michael Sumner
Excellent, thanks so much, confirmed it's working. Cheers, Mike On Fri, Sep 1, 2023 at 6:14 AM Even Rouault wrote: > Michael, > > Hi, hoping to check my syntax ... or expectations ... I'm expecting this > to subset by step the 20x20 array in this netcdf, but getting no change in > python MultiD

Re: [gdal-dev] Universal raster to rgba?

2023-08-31 Thread Michael Katz via gdal-dev
Hi Javier, thanks for the detailed breakdown. I had a sense of some of those cases but didn't know all. Still, I think there is a use case, like for users of my program, where they have a file that covers a certain region, and they prefer to see *something* rather than nothing. I imagine a func

[gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-08-31 Thread andy
Hi, if I run ogr2ogr -f CSV /vsistdout/ data.gdb -sql " SELECT OBJECTID from table_EDF_IS limit 1" I have OBJECTID, "1" Instead, if I run ogr2ogr -f CSV /vsistdout/ data.gdb -dialect sqlite -sql " SELECT OBJECTID from table_EDF_IS limit 1" I have this error ERROR 1: In ExecuteSQL(): sq

Re: [gdal-dev] multidim arraySpecs/GetView

2023-08-31 Thread Even Rouault
Michael, Hi, hoping to check my syntax ... or expectations ... I'm expecting this to subset by step the 20x20 array in this netcdf, but getting no change in python MultiDimTranslate or at command line: ds = gdal.OpenEx('gdrivers/data/netcdf/byte_no_cf.nc ', gdal.OF_MUL

Re: [gdal-dev] Universal raster to rgba?

2023-08-31 Thread Javier Jimenez Shaw
Hi Michael. First of all: I do not know a magic function to convert to RGB(A) >From my experience exactly with this situation, it is never possible to make everybody happy. I detected several issues: - Missing metadata. Many images do not specify the "meaning" of each band. If you have 3 bands as