<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'>Rob,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'>Duckdb and OGR Parquet connections are different. You should compare with gdal vector info /vsicurl/</span><span style='color:black'>github.com/iamgeodude/testgio/raw/main/area_types.parquet<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:black'>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<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:black'>What I had to use was:<br><br><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> connection "ADBC:/tmp/cds_pandas.parquet"<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> CONNECTIONOPTIONS<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> "PRELUDE_STATEMENTS" "ADBC_DRIVER=/opt/conda/envs/grid/lib/libduckdb.so"<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> "PRELUDE_STATEMENTS" "install httpfs" <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> "PRELUDE_STATEMENTS" "load httpfs" <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> "PRELUDE_STATEMENTS" "Set home_directory = '/tmp/'"<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'> END<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'>DATA "cds_pandas"<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'>Mike<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><div><div><p class=MsoNormal>-- <o:p></o:p></p></div><div><p class=MsoNormal>Michael Smith<o:p></o:p></p><p class=MsoNormal>RSGIS Center – ERDC CRREL NH<o:p></o:p></p></div></div><p class=MsoNormal>US Army Corps<span style='font-family:"Calibri",sans-serif'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-family:"Calibri",sans-serif;color:black'>From: </span></b><span style='font-family:"Calibri",sans-serif;color:black'>MapServer-users <mapserver-users-bounces@lists.osgeo.org> on behalf of Rob Dennett via MapServer-users <mapserver-users@lists.osgeo.org><br><b>Reply-To: </b>Rob Dennett <Rob.Dennett@twdb.texas.gov><br><b>Date: </b>Thursday, July 24, 2025 at 2:27 PM<br><b>To: </b>Scott <public@postholer.com>, MapServer Users <mapserver-users@lists.osgeo.org><br><b>Subject: </b>Re: [MapServer-users] Error advises checking logs, but I am not sure what logs it's referring to<o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='color:black'>I got an error trying to run that command:<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>ERROR 4: Only read-only mode is supported for /vsicurl<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>When I ran duckdb at the command line, I was able to run<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Select geometry from read_parquet("github.com/iamgeodude/testgio/raw/main/area_types.parquet")<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>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?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Thanks<o:p></o:p></span></p></div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><div id=divRplyFwdMsg><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'> Scott <public@postholer.com><br><b>Sent:</b> Thursday, July 24, 2025 10:48 AM<br><b>To:</b> Rob Dennett <Rob.Dennett@twdb.texas.gov>; MapServer Users <mapserver-users@lists.osgeo.org><br><b>Subject:</b> Re: [MapServer-users] Error advises checking logs, but I am not sure what logs it's referring to</span> <o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:11.0pt'>External: Beware of links/attachments.<br><br><br><br>Looking at the file, the layer name is plural, area_types and the<br>geometry column is 'geometry' not 'geom'.<br><br>Run the following from the command line and see what errors you get:<br><br>ogrinfo -sql "select geometry from area_types"<br>/vsicurl/https://github.com/iamgeodude/testgio/raw/main/area_types.parquet<br><br>On 7/24/25 08:12, Rob Dennett wrote:<br>> <a href="https://github.com/iamgeodude/testgio/raw/">https://github.com/iamgeodude/testgio/raw/</a><br>> > main/area_types.parquet<o:p></o:p></span></p></div></div><p class=MsoNormal>_______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users <o:p></o:p></p></div></body></html>