<br><br><div class="gmail_quote">2012/2/28 Anzel, Phil - NRCS, Fort Collins, CO <span dir="ltr"><<a href="mailto:Phil.Anzel@ftc.usda.gov">Phil.Anzel@ftc.usda.gov</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi, Tamas,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I believe there is at least one bug in the OGR code: the SRID is not properly retrieved from the underlying Sql Server 2008 database or its value is ignored,
and therefore zero records are returned.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p></div></div></blockquote><div><br></div><div>Probably the geometry_columns metadata table contains incorrect srid for the NAV_STATE entry.</div>
<div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I also note that all columns are returned. That is unfortunate, as that could potentially represent quite a bit of network traffic,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"></span></p></div></div></blockquote><div><br></div><div>This is a subject of improvement in the mapserver ogr driver. OGR is now capable to limit the fields by using <span style="background-color:rgb(255,255,255);font-size:14px">OGR_L_SetIgnoredFields, but it hasn't been utilized yet. We should also modify the OGR mssql driver to rely on </span><span style="background-color:rgb(255,255,255);font-size:14px">OGRFieldDefn::IsIgnored just like for the sqlite driver. </span><span style="background-color:rgb(255,255,255);font-size:14px">Added 2 tickets to implement this addition:</span></div>
<div><a href="http://trac.osgeo.org/mapserver/ticket/4217">http://trac.osgeo.org/mapserver/ticket/4217</a>
</div><div><a href="http://trac.osgeo.org/gdal/ticket/4534">http://trac.osgeo.org/gdal/ticket/4534</a>
</div><div><br></div><div>Best regards,</div><div><br></div><div>Tamas</div><div><br></div><div> </div></div>