<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:x="urn:schemas-microsoft-com:office:excel" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" 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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</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:blue;
text-decoration:underline;}
span.EmailStyle17
{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>
<!--[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=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi wang,<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
think you can do that very easily, if you have a monitoring system setup which
feeds the data into sql2000, you can easily make it to append to a postgres
database. I would suggest you using a postgres database since it has postgis
which can store spatial data and mapserver can use it. You need 2 tables <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'>Location Table with following fields
(minimum), Example Shown below<o:p></o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=256
style='width:192.0pt;margin-left:-1.0pt;border-collapse:collapse'>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>unid<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Locid<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>X_Coord<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Y_Coord<o:p></o:p></span></font></b></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1234.56<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>6543.12<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2345.65<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>7654.23<o:p></o:p></span></font></p>
</td>
</tr>
</table>
<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'><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'>Monitoring_Table<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>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=335
style='width:251.0pt;margin-left:-1.0pt;border-collapse:collapse'>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>uid<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Locid<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>date_time<o:p></o:p></span></font></b></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Parameter<o:p></o:p></span></font></b></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Result<o:p></o:p></span></font></b></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Temperature<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>35<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Humidity<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>10<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>3<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>radiation<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>10<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>4<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Temperature<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>36<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>5<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Humidity<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>11<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>6<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X1<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>radiation<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num>
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>11<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A7+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>7<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Temperature<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E2+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>36<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A8+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>8<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Humidity<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E3+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>11<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A9+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>9<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39083">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>radiation<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E4+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>11<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A10+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>10<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Temperature<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E5+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>37<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A11+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>11<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Humidity<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E6+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>12<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num
x:fmla="=A12+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>12<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>X2<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num="39114">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2/1/2007<o:p></o:p></span></font></p>
</td>
<td width=79 nowrap height=17 valign=bottom style='width:59.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>radiation<o:p></o:p></span></font></p>
</td>
<td width=64 nowrap height=17 valign=bottom style='width:48.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt' x:num x:fmla="=E7+1">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>12<o:p></o:p></span></font></p>
</td>
</tr>
</table>
<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'>Then you can make a query which is
approximately going to look like this<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'>SELECT <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'> Location
Table.*,<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'> Monitoring_Table.*<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'> setsrid(makepoint(Location
Table."X_Coord", Location Table."Y_Coord"), xxxx ) AS
the_geom<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'>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'> Monitoring_Table<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'> RIGHT OUTER JOIN Monitoring_Table ON
(Monitoring_Table.locid = Location Table.locid)<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 style='text-indent:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>This will create the geometry
field required for the map file and also put all the data required for you to
display. On the map, its going to show as single point for each location, but
using as use query_float interface in ka-map to show as a the results as a table.
You add modules to ka-map to make it as map. This is in my todo list for
sometime time now, for my projects. I am assuming you have proper X, Y
co-ordinates. <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'> -
kumar<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'>
ka-map-users-bounces@lists.maptools.org
[mailto:ka-map-users-bounces@lists.maptools.org] <b><span style='font-weight:
bold'>On Behalf Of </span></b>stin wang<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, June 27, 2007
8:45 PM<br>
<b><span style='font-weight:bold'>To:</span></b>
ka-map-users@lists.maptools.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> [ka-Map-users] how to use
mssql database</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=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hello, lister<br>
<br>
I'm fresh to mapserver. I want to do something described as blow; anyone can
give me some idea about how to do is welcome.<br>
<br>
I'm do some researches in greenhouse, which means i put some sensors in the
greenhouse, used to monitor some environment parameter ,such as temperature ,
humidity, carbon dioxide concentration and radiation. There are several green
houses, so I want to build a webgis so I can check data visually. The data
gathered in greenhouse is send to mssql2000 database server. So my question is
how to show the data in sql2000 in a ka-map interface. <br>
<br>
I have already built a test ka-map, and add a new map to hold my greenhouse
point data. Is there any idea that can allow me to just click one point
then popup a gage and show a curve describe the variation in a fixed time
series. And future more, maybe I can do some interpolations using kriging
method?? I don't know, maybe you get give me some cues.<br clear=all>
<br>
-- <br>
----------------------------------------------<br>
Tie Wang<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">TianJin</st1:PlaceName> <st1:PlaceName
w:st="on">Climate</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1:PlaceType></st1:place><br>
<st1:City w:st="on"><st1:place w:st="on">TianJin</st1:place></st1:City>
Meterological Bureau<br>
<st1:City w:st="on">Tianjin</st1:City>, 300074, <st1:country-region w:st="on"><st1:place
w:st="on">China</st1:place></st1:country-region> <br>
Email: <a href="mailto:stin.wang@gmail.com">stin.wang@gmail.com</a><br>
<a href="mailto:wangtie@orsi.ouc.edu.cn">wangtie@orsi.ouc.edu.cn</a><br>
<br>
---------------------------------------------- <o:p></o:p></span></font></p>
</div>
</body>
</html>