<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="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 11 (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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I found a work around to the problem –
posting here in case someone else runs into the problem<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I changed the initial select * to separate
the attributes and cast them as real<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Example: Select cast(LAT2 as real), cast(lon2
as real), cast(confidence as real), cast(intensity as real), date_time from (<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I don’t know where in the overall package
the attributes were converted to integer but this method at least lets the SQL
code work<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>GetField as string does not work in this
case but that does not really surprise me since the resulting data does not
come from a table rather it is processed data.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It just means we have to be very careful
of the fieldIndex alignment<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bruce<o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
gdal-dev-bounces@lists.osgeo.org [mailto:gdal-dev-bounces@lists.osgeo.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Clay, Bruce<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, November 04, 2009
12:25 PM<br>
<b><span style='font-weight:bold'>To:</span></b> gdal-dev@lists.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> [gdal-dev] SQL results
truncated</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>It seems like I encountered this problem before but I can not
find any information about it now.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If I run a SQ script like the following<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Select * from<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> (Select MIN_LAT - (round((MIN_LAT - LATITUDE) /
(MAX_LAT - MIN_LAT) * 1728.497600)) * 0.000579 LAT2,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> MAX_LON -
(round((LONGITUDE - MAX_LON) / (MIN_LON - MAX_LON) * 1814.921600)) * 0.000551
LON2,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
Round(sum(TRACK_SIZE) / 1.000000) CONFIDENCE,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> max(B_TEMP)
Intensity,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
min(TO_CHAR(DATE_TIME, 'MM-DD-YYYY HH24:MI:SS')) DATE_TIME <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> FROM<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> WACDS.MODIS_ACTIVE_FIRE
WHERE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> LATITUDE
BETWEEN MIN_LAT AND MAX_LAT AND<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
LONGITUDE BETWEEN MIN_LON AND MAX_LON AND<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
DATE_TIME BETWEEN TO_DATE('03/01/2007 00:00:00' , 'MM-DD-YYYY HH24:MI:SS') AND<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
TO_DATE('04/30/2007 23:59:59' , 'MM-DD-YYYY HH24:MI:SS') AND<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
CONFIDENCE > 1.000000<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> GROUP BY<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> round((MIN_LAT -
LATITUDE) / (MAX_LAT - MIN_LAT) * 1728.497600),<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> round((LONGITUDE
- MAX_LON) / (MIN_LON - MAX_LON) * 1814.921600))<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> where <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> (CONFIDENCE * 1.000000) > 1.000000<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ORDER BY DATE_TIME<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>From sqlPal I get LAT2 and LON2 data back as doubles<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If I run it through OGR ExecuteSql the LAT2 and LON2 data
comes back as integers and can not be used to plot the data<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'>OGRFieldDefn
*fieldDef = featureDef->GetFieldDefn(fieldIndex);<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span Courier><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>if</span></span></font><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'> (fieldDef !=
NULL)<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'>{<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'>
fieldType = fieldDef->GetType();<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal><font size=2 face="Courier New"><span Courier><span
style='font-size:10.0pt;font-family:"Courier New"'>}<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal><font size=2 face="Courier New"><span Courier><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
</span>
<p class=MsoNormal><font size=2 face="Courier New"><span Courier><span
style='font-size:10.0pt;font-family:"Courier New"'>Returns type integer<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And both<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>const</span></font> <font color=blue><span
style='color:blue'>char</span></font> *latStr = (<font color=blue><span
style='color:blue'>char</span></font> *)feature->GetFieldAsString(<font
color="#a31515"><span style='color:#A31515'>"LAT2"</span></font>);<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>double</span></font> latitude =
feature->GetFieldAsDouble(<font color="#a31515"><span style='color:#A31515'>"LAT2"</span></font>);<o:p></o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
</span>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
Courier><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
</span>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>return(only the whole portion of what I see in sqlPal.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Does anyone see / know what might be going wrong?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Bruce<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
<pre>
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.</pre>
<pre>
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.</pre>