<font size="2">Thanks Eric and everyone else,<br>
Using your tip I managed to do the job in OpenOffice Calc. But in the
last few days with a friend's help i am moving over to postgresql as my
database driver, since i got the impression from this list that its
better.<br>
<br>
now i do need help figuring out how to use vector and database tabl,es in GRASS.<br>
So far I have 2 tables in my database. One is my masterfile, a table
called 'stations ' that looks like this: WMoID, city, lat, long<br>
<br>
420710,AMRITSAR,
31.63,74.86<br>
421010,PATIALA,30.33,76.46<br>
421310,HISSAR,29.16,75.73<br>
421820,DELHI,28.58,77.20<br>
<br>
and i prepared a table called 'data', which looks like this (i'm copying from openoffice thats why it looks a bot strange):</font><br>
<br>
<DEFANGED_meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title><DEFANGED_meta name="GENERATOR" content="OpenOffice.org 1.9.129 (Linux)">
<!-- <DEFANGED_STYLE>
<!--
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Nimbus Sans L"; font-size:x-small }
-->
--> </DEFANGED_STYLE>
<table border="1" cellspacing="0" cols="256" frame="void" rules="groups">
<colgroup><col width="49"><col width="86"><col width="36"><col width="30"><col width="40"><col width="40"><col width="40"><col width="40"><col width="58"><col width="46"><col width="43"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86">
<col width="86"><col width="86"><col width="86"><col width="86"></colgroup>
<tbody>
<tr>
<td align="left" height="18" width="49">WMOID,N,10,0</td>
<td align="left" width="86">CITY,C,50</td>
<td align="left" width="36">YEAR,N,5,0</td>
<td align="left" width="30">YDAY,N,4,0</td>
<td align="left" width="40">TMAX,N,10,2</td>
<td align="left" width="40">TMIN,N,10,2</td>
<td align="left" width="40">TDAY,N,10,2</td>
<td align="left" width="40">RAIN,N,10,2</td>
<td align="left" width="58">VPD,N,10,2</td>
<td align="left" width="46">SRAD,N,10,2</td>
<td align="left" width="43">DAYLEN,N,10,0</td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
<td align="left" width="86"><br></td>
</tr>
<tr>
<td align="right" height="18">427240</td>
<td align="left">Agartala</td>
<td align="right">1995</td>
<td align="right">1</td>
<td align="right">26</td>
<td align="right">8.5</td>
<td align="right">21.19</td>
<td align="right">0</td>
<td align="right">1112.83</td>
<td align="right">341.2</td>
<td align="right">37998</td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
</tr>
<tr>
<td align="right" height="18">427240</td>
<td align="left">Agartala</td>
<td align="right">1995</td>
<td align="right">2</td>
<td align="right">24</td>
<td align="right">7.39</td>
<td align="right">19.43</td>
<td align="right">0</td>
<td align="right">1082.93</td>
<td align="right">339.33</td>
<td align="right">38019</td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
</tr>
<tr>
<td align="right" height="18">427240</td>
<td align="left">Agartala</td>
<td align="right">1995</td>
<td align="right">3</td>
<td align="right">22.72</td>
<td align="right">4.89</td>
<td align="right">17.82</td>
<td align="right">0</td>
<td align="right">1097.42</td>
<td align="right">360.24</td>
<td align="right">38041</td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
</tr>
<tr>
<td align="right" height="18">427240</td>
<td align="left">Agartala</td>
<td align="right">1995</td>
<td align="right">4</td>
<td align="right">24</td>
<td align="right">4</td>
<td align="right">18.5</td>
<td align="right">0</td>
<td align="right">1084.58</td>
<td align="right">377.3</td>
<td align="right">38065</td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
</tr>
<tr>
<td align="right" height="18">427240</td>
<td align="left">Agartala</td>
<td align="right">1995</td>
<td align="right">5</td>
<td align="right">25.11</td>
<td align="right">5.22</td>
<td align="right">19.64</td>
<td align="right">0</td>
<td align="right">1155.05</td>
<td align="right">374.59</td>
<td align="right">38091</td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
<td align="left"><br></td>
</tr>
</tbody>
</table>
<br>
f<font size="2"><font size="2">or each station.<br>
<br>
What i want to do, and dont know how to (i looked at the GRASS online
help which is just not enough for someone new to databases):<br>
1. I want to use the 'stations' table to bring in as a vector map. When i had the 'stati<br>
<br>
ons' as a csv file, i used v.in.ascii. i dont know what to use when its in a table in a pg database.<br>
<br>
2. I also want to link the 'stations' to the 'data' table. i did this
using v.db.connect and it seemed to work. But i dont know how its
linking. When i had used v.in.ascii on a csv file, i had defined the
WMOID as cat; and then in ' v.db.connect i had WMOID in the 'data' file
be the key. But then it did'nt like it at all when i tried a SQL query-
it seemed to not like having WMOID as the key, because it had
duplicates. But how else can i link the 2 tables?<br>
<br>
3. My final goal is to be able to write a script, where i can have
every day's data from a particular column, become a vector map. To do
this would i need my intial points vector file to be a 3d vector file?<br>
<br>
any help would be great!<br>
thanks,<br>
vishal<br>
</font><br>
</font><div><font size="2"><span class="gmail_quote">On 3/17/06, <b class="gmail_sendername">Patton, Eric</b> <<a href="mailto:epatton@nrcan.gc.ca" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
epatton@nrcan.gc.ca</a>> wrote:</span></font><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><font size="2">Vishal,<br>
<br>
If you open your dbf in OpenOffice Calc, you are able to edit the data types
<br>
for each column. Here's an example from one of my dbf's:<br>
<br>
CAT,N,11,0 CLASS_CODE,N</font><font size="2">,20,6
NEW_CLASS,C,50 Length,N,20,2<br>
9 1 Rock Shores 961.07<br>
178 1 Rock Shores 661.39<br>
494 1 Rock Shores 768.71<br>
508 1 Rock Shores 543.68<br>
511 1 Rock Shores
989.52<br>
<br>
The columns aren't going to line up nice in this email, but you get the<br>
idea. Under the first column heading, 'CAT', there is an 'N' following it<br>
signifying that this is a number, that 11 digit maximum is acceptable, and
<br>
that 0 decimals are allowed. db.columns in Grass would report that this is<br>
an INTEGER datatype. You can edit these values to accept larger integer<br>
values. If you want floating point datatype for this column, change the
<br>
final zero to match whatever the desired precision of your data.<br>
<br>
The fourth column of data in my example corresponds to the Length column,<br>
and is floating point data as you can see. If I wanted more decimal places,
<br>
I would chage the 2 to 6, say. The Length column could also be made into an<br>
integer column simply by changing the ending '2' to a 0.<br>
<br>
<br>
Hope this helps,<br>
<br>
~ Eric.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
-----Original Message-----
<br>
From: <a href="mailto:owner-GRASSLIST@baylor.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">owner-GRASSLIST@baylor.edu</a><br>
To: David Finlayson<br>
Cc: Stefan Istvan; GRASS Users list<br>
Sent: 3/17/2006 3:00 AM<br>
Subject: [GRASSLIST:199] Re: trouble using v.in.ascii
<br>
<br>
Hi all,<br>
<br>
ok i was able to get the points vector file done- silly syntax mistake<br>
on my part-sorry.<br>
But i could use some input on my attempts to connect my data dbf file to<br>
the vector points file as layer 2.
<br>
<br>
What i did is, that i prepared a dbf file in Windows, then brought it<br>
into my /dbf folder in Linux/Grass. Now this file is recognized when i<br>
do db.describe(below):<br>
<br>
GRASS 6.0.1 (ncdc):~/Desktop/NCDC >
db.describe -c Data<br>
ncols:11<br>
Column 1: WMOID<br>
Column 2: CITY<br>
Column 3: YEAR<br>
Column 4: YDAY<br>
Column 5: TMAX<br>
Column 6: TMIN<br>
Column 7: TDAY<br>
Column 8: RAIN<br>
Column 9: VPD<br>
Column 10: SRAD<br>
Column 11: DAYLEN
<br>
<br>
BUT, the column 'WMOID' which i want to use as key, has suddenly become<br>
float (it was integer when i made it in windows), and in fact all<br>
numeric columns are assigned double precision now when they were not
<br>
originally. How do i rectify this, since to identify a key tolink my<br>
vector points to this data file, the key column should be integer?<br>
<br>
I dont know postgresql, mysql etc, therefore i'm trying things this<br>
way..<br>
<br>
thanks,<br>
vishal<br>
<br>
<br>
On 3/17/06, David Finlayson < <a href="mailto:david.p.finlayson@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">david.p.finlayson@gmail.com</a><br>
<mailto:<a href="mailto:david.p.finlayson@gmail.com" target="_blank"DEFANGED_Onclick="return top.js.OpenExtLink(window,event,this)">david.p.finlayson@gmail.com
</a>> > wrote:<br>
<br>
Breezy also has the "flip" command (search synaptic) for converting<br>
line endings.<br>
<br>
-David<br>
<br>
On 3/16/06, Stefan Istvan < <a href="mailto:stefi@geohidroterv.hu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stefi@geohidroterv.hu
</a><br>
<mailto:<a href="mailto:stefi@geohidroterv.hu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stefi@geohidroterv.hu</a>> > wrote:<br>
> On Fri, 2006-03-17 at 11:30 +0530, Vishal Mehta wrote:<br>
> > Hi all,<br>
> ><br>
> > I'm trying to bring in a comma separated text file as a point vector
<br>
> > file in GRASS using v.in.ascii , before i try to link it to a large<br>
> > 33Mb dbf data file.<br>
> ><br>
> > The csv file looks like this with 39 rows and i removed the header<br>
> > because grass60 (on Ubuntu breezy) does not have the skip option in
<br>
> > the v.in.ascii command: the columns are WMOID, cityname, Latitude<br>
and<br>
> > Longitude. I want to use the WMOID as 'cat' in order to link my dbf<br>
> > data later.<br>
> ><br>
> > 420710,AMRITSAR,
31.63,74.86<br>
> > 421010,PATIALA,30.33,76.46<br>
> > 421310,HISSAR,29.16,75.73<br>
> > 421820,DELHI,28.58,77.20<br>
> > 423390,JODHPUR,26.30,73.01<br>
> > 423480,JAIPUR,26.81,75.80<br>
> > 423690,LUCKNOW,
26.75,80.88<br>
> > 424100,GAUHATI,26.10,91.58<br>
> ><br>
> > I Tried the following command and got the error:<br>
> ><br>
> > cat reformat/STATIONS2.dat | v.in.ascii output=stations2 fs=','<br>
> > columns='cat int, name(varchar(30), y double, x double' x=4 y=3<br>
cat=1<br>
> > WARNING: DOS text format found, attempting import anyway<br>
> > Maximum input row length: 39<br>
> > Maximum number of columns: 4
<br>
> > Minimum number of columns: 4<br>
> > column: 1 type: integer<br>
> > column: 2 type: string length: 18<br>
> > column: 3 type: double<br>
> > column: 4 type: double<br>
> > DBMI-DBF driver error:
<br>
> > SQL parser error in statement:<br>
> > create table stations2 ( cat int, name(varchar(30), x double, y<br>
> > double )<br>
> > Error in db_execute_immediate()<br>
> ><br>
> > ERROR: Cannot create table: create table stations2 ( cat int,
<br>
> > name(varchar(30), x double, y double )<br>
> ><br>
> > I also get the same error with<br>
> ><br>
> > v.in.ascii input=reformat/STATIONS.csv output=gstations fs=','<br>
skip=1<br>
> > columns='cat int, label(varchar(30), y double, x double' x=4 y=3
<br>
cat=1<br>
> ><br>
> There is an additional "(" sign in your columns definition. You should<br>
> write columns='cat int, label varchar(30), y double, x double'.<br>
> The other problem maybe that your file is in MSDOS format, but it
<br>
could<br>
> be that it doesn't bother Grass. Try to use dos2unix command to<br>
convert<br>
> it to unix format.<br>
><br>
> Regards,<br>
> Istvan<br>
><br>
><br>
<br>
<br>
--<br>
David Finlayson<br>
<br>
<br>
<br>
</font>
</blockquote></div><br>