As per your workaround suggestion,
Are these intended to work? The returned datasource is None. Removing the
`/vsimem` preamble returns the disk-backed geopackage datasource as expected.
tree_canopy_mem_ds = ogr.Open('/vsimem/Users/jrmeyer3/Downloads/features.gpkg')
tree_canopy_mem_ds =
ogr.GetDriverByName("GPKG").Open('/vsimem/Users/jrmeyer3/Downloads/features.gpkg')
From: Even Rouault <even.roua...@spatialys.com>
Date: Monday, August 21, 2023 at 6:22 PM
To: "Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC]"
<jesse.r.me...@nasa.gov>, "gdal-dev@lists.osgeo.org" <gdal-dev@lists.osgeo.org>
Subject: [EXTERNAL] Re: [gdal-dev] Is SQLITE dialect supported on Memory OGR
datasets?
CAUTION: This email originated from outside of NASA. Please take care when
clicking links or opening attachments. Use the "Report Message" button to
report suspicious messages to the NASA SOC.
Jesse,
No it wasn't. Fix in https://github.com/OSGeo/gdal/pull/8247
Potential workaround: use a in-memory SQLite or GeoPackage with a /vsimem/
filename
Even
Le 21/08/2023 à 21:30, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND
APPLICATIONS INC] via gdal-dev a écrit :
Hi,
This works:
tc_lyr = execute_SQL(tree_canopy_mem_ds, "select * from trees",
spatialFilter=c_geo)
However, this:
tc_lyr = execute_SQL(tree_canopy_mem_ds, "select * from trees",
spatialFilter=c_geo, dialect="SQLITE")
Returns:
In Initialize(): sqlite3_step(SELECT _rowid_, * FROM 'trees' LIMIT 1): SQL
logic error
Where execute_SQL = ogr.DataSource.ExecuteSQL
Which is naturally a surprise given that I’m not explicitly asking for the
rowid, nor to limit the number of returned rows.
The docs claim that the SQLite dialect can be used with any OGR datasource, so
I did expect this to work. The input datasource is GeoPackage, which is based
on SQLite, so I assume my install is built with SQLite, though I’d welcome
advice on how to explicitly demonstrate this.
My GDAL version install is 3.6.4, on OSX 13.5.
Thanks,
Jesse
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com<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
