Please disregard last email. That will NEVER work with a .fgb file. I
tested with a .gpkg on the command line.
Apologies,
Scott
On 9/22/25 11:29, Scott via MapServer-dev wrote:
Greetings,
My understanding is CONNECTIONTYPE OGR uses GDAL directly. Assuming
this, I'm trying to access the sqlite/spatialite dialect in the SQL
query below. Any option for setting dialect?
I've also tried an "<OGRVRTDataSource..." string in CONNECTION with
dialect="sqlite", no luck.
Yes, my libgdal is built with sqlite/spatialite.
The following runs without error, no errors/warnings in the log file.
All other layers render, but this layer does not. If I remove the DATA/
query line it will render. Query runs fine with gdal ogr* command at the
command line (with -dialect sqlite)
Any suggestions?
CONNECTIONTYPE OGR
CONNECTION "/path/to/data.fgb"
DATA "select
geom
,st_area(geom) as area
from table"
CONNECTIONOPTIONS
"VERIFY_BUFFERS" "NO"
END
PROCESSING "CLOSE_CONNECTION=DEFER"
Thank you!
Scott
--
www.postholer.com
_______________________________________________
MapServer-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-dev
_______________________________________________
MapServer-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-dev
