<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">Yes, I would leave it to driver owners to capitalize on CONNECTIONOPTIONS (and DATAOPTIONS - good idea!).</p>
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;" dir="ltr">
<br>
</div>
--Steve<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Even Rouault <even.rouault@spatialys.com><br>
<b>Sent:</b> Friday, August 23, 2019 8:55 AM<br>
<b>To:</b> Lime, Steve D (MNIT) <steve.lime@state.mn.us><br>
<b>Cc:</b> mapserver-dev@lists.osgeo.org <mapserver-dev@lists.osgeo.org><br>
<b>Subject:</b> Re: [mapserver-dev] OPENOPTION (was Re: Dropping support for GDAL < 2 ?)</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">This message may be from an external email source.<br>
Do not select links or open attachments unless verified. Report all suspicious emails to Minnesota IT Services Security Operations Center.<br>
<br>
<br>
<br>
On vendredi 23 août 2019 13:30:56 CEST Lime, Steve D (MNIT) wrote:<br>
> Would CONNECTIONOPTIONS be more generic? I could see that being useful for<br>
> other drivers where key:value pairs are used as part of the configuration.<br>
<br>
Yes, I agree that the mechanism could potentially be used for other connection<br>
types.<br>
<br>
For completness, you'd probably also want a DATAOPTIONS to pass options<br>
specific to the DATA keyword. I've always found the syntax for PostGIS data to<br>
be a bit awkward.<br>
<br>
So instead of<br>
<br>
DATA "the_geom from (select * from polygon3d order by id) as foo using<br>
srid=27700 using unique id"<br>
<br>
you could have<br>
<br>
DATA "select * from polygon3d order by id"<br>
DATAOPTIONS<br>
"geometry_column" "the_geom"<br>
"srid" "27700"<br>
"unique_column" "id"<br>
END<br>
<br>
But this is just food for thought, and we probably don't want to break<br>
existing PostGIS DATA syntax.<br>
My scope for now would be just CONNECTIONOPTIONS and implementation for GDAL<br>
and OGR connections.<br>
<br>
><br>
><br>
> For 8.0 a broader conversion of the syntax for layer->processing and<br>
> outputformat->formatoptions could be implemented. For the latter you'd get:<br>
><br>
><br>
> OUTPUTFORMAT<br>
> NAME "kayml"<br>
> DRIVER "TEMPLATE"<br>
> MIMETYPE "application/vnd.google-earth.kml+xml"<br>
> OPTIONS<br>
> "FILE" "myTemplate.kml"<br>
> "ATTACHMENT" "queryResults.kml"<br>
> END<br>
> END<br>
><br>
> In this case you could ensure backwards compatibility by adding recognizing<br>
> FORMATOPTION as a shortcut.<br>
><br>
> Perhaps a new PROCESSINGOPTIONS block should be added and PROCESSING is<br>
> handled as a shortcut for backwards compatability.<br>
<br>
Makes sense<br>
<br>
Even<br>
<br>
--<br>
Spatialys - Geospatial professional services<br>
<a href="https://gcc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spatialys.com&data=02%7C01%7Csteve.lime%40state.mn.us%7C020baaa6275a47f47b2c08d727d184a8%7Ceb14b04624c445198f26b89c2159828c%7C0%7C1%7C637021653136627039&sdata=odW%2FufcJzUm5CzN8KXSsMs6i1uax8W5cstQGGFuT31c%3D&reserved=0" id="LPlnk728321" class="OWAAutoLink" previewremoved="true">https://gcc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spatialys.com&data=02%7C01%7Csteve.lime%40state.mn.us%7C020baaa6275a47f47b2c08d727d184a8%7Ceb14b04624c445198f26b89c2159828c%7C0%7C1%7C637021653136627039&sdata=odW%2FufcJzUm5CzN8KXSsMs6i1uax8W5cstQGGFuT31c%3D&reserved=0</a><br>
</div>
</span></font></div>
</div>
</div>
</body>
</html>