[MapServer-users] Error advises checking logs, but I am not sure what logs it's referring to

[Michael Smith]

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-bounces at lists.osgeo.org> on behalf of Rob Dennett via MapServer-users <mapserver-users at lists.osgeo.org>
Reply-To: Rob Dennett <Rob.Dennett at twdb.texas.gov>
Date: Thursday, July 24, 2025 at 2:27 PM
To: Scott <public at postholer.com>, MapServer Users <mapserver-users at 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 <public at postholer.com>
Sent: Thursday, July 24, 2025 10:48 AM
To: Rob Dennett <Rob.Dennett at twdb.texas.gov>; MapServer Users <mapserver-users at 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 at lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20250724/d688a896/attachment-0001.htm>