Rob,
Duckdb and OGR Parquet connections are different. You should compare with gdal
vector info /vsicurl/github.com/iamgeodude/testgio/raw/main/area_types.parquet
If you want to do a duckdb connection with OGR, you need to do a ADBC
connection and add various preclude_statements under connection options to use
libduckdb
What I had to use was:
connection "ADBC:/tmp/cds_pandas.parquet"
CONNECTIONOPTIONS
"PRELUDE_STATEMENTS"
"ADBC_DRIVER=/opt/conda/envs/grid/lib/libduckdb.so"
"PRELUDE_STATEMENTS" "install httpfs"
"PRELUDE_STATEMENTS" "load httpfs"
"PRELUDE_STATEMENTS" "Set home_directory = '/tmp/'"
END
DATA "cds_pandas"
Mike
--
Michael Smith
RSGIS Center – ERDC CRREL NH
US Army Corps
From: MapServer-users <mapserver-users-boun...@lists.osgeo.org> on behalf of
Rob Dennett via MapServer-users <mapserver-users@lists.osgeo.org>
Reply-To: Rob Dennett <rob.denn...@twdb.texas.gov>
Date: Thursday, July 24, 2025 at 2:27 PM
To: Scott <pub...@postholer.com>, MapServer Users
<mapserver-users@lists.osgeo.org>
Subject: Re: [MapServer-users] Error advises checking logs, but I am not sure
what logs it's referring to
I got an error trying to run that command:
ERROR 4: Only read-only mode is supported for /vsicurl
When I ran duckdb at the command line, I was able to run
Select geometry from
read_parquet("github.com/iamgeodude/testgio/raw/main/area_types.parquet")
Just fine. Updating the code from geom to geometry in the .map file yields the
same error. Are the logs mentioned referring to the error_log I am looking at,
or something else?
Thanks
From: Scott <pub...@postholer.com>
Sent: Thursday, July 24, 2025 10:48 AM
To: Rob Dennett <rob.denn...@twdb.texas.gov>; MapServer Users
<mapserver-users@lists.osgeo.org>
Subject: Re: [MapServer-users] Error advises checking logs, but I am not sure
what logs it's referring to
External: Beware of links/attachments.
Looking at the file, the layer name is plural, area_types and the
geometry column is 'geometry' not 'geom'.
Run the following from the command line and see what errors you get:
ogrinfo -sql "select geometry from area_types"
/vsicurl/https://github.com/iamgeodude/testgio/raw/main/area_types.parquet
On 7/24/25 08:12, Rob Dennett wrote:
> https://github.com/iamgeodude/testgio/raw/
> > main/area_types.parquet
_______________________________________________ MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
