<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=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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">
<div class="WordSection1">
<p class="MsoNormal">Hello List,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I'm making this post so that others may avoid the pain that I just went through. We finaly have a working install of MapServer 6.2.1 compiled with GDAL 1.9 on 64 Bit Linux Red Hat 6 Enterprise displaying and querying data from ArcSDE 10.0.
At first the data displayed fine with a patch to the mapsde.c file from Steve Lime, thanks Steve. The problem we struggled with for weeks was querying SDE. After a lot of internet searching and sleepless nights I came across the blurb of code below that
was the game changer. We added this to the mods that Steve made to the mapsde.c file and presto. Anyway if anyone want to know more you can contact me through the list or at my email below.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Steve, I owe you a beer.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif"">void msSDELayerFreeItemInfo(layerObj *layer)<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif"">{<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif"">#ifdef USE_SDE<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> msSDELayerInfo *sde = NULL;<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> int i;<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> if (!msSDELayerIsOpen(layer)) {<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> msSetError( MS_SDEERR,<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> "SDE layer has not been opened.",<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> "msSDELayerFreeItemInfo()");<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> }<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> sde = layer->layerinfo;<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> if (sde != NULL && sde->basedefs) {<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> SE_table_free_descriptions(sde->basedefs);<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> sde->basedefs = NULL;<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> }<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> if (sde != NULL && sde->joindefs) {<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> SE_table_free_descriptions(sde->joindefs);<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> sde->joindefs = NULL;<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> }<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> if (layer->iteminfo) {<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-family:"Calibri","sans-serif""> :<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial Black","sans-serif"">Eric Weisbender</span><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial Black","sans-serif"">Western Area Power Administration<br>
Corporate Service Office<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial Black","sans-serif"">U.S. Dept. of Energy</span><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial Black","sans-serif"">office: (720) 962-7280<br>
email: </span><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="mailto:weisbend@wapa.gov"><span style="font-family:"Arial Black","sans-serif";color:windowtext">weisbend@wapa.gov</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>