Hi all,<br>
I had, with your help, added 500 columns of rain data from 500 corresponding rasters, t0 my vector map of 8 watersheds.<br>
<br>
Now i want to add another 500 columns to the same vector map, but from
different 100 rasters, namely derived reference ET maps i have created.<br>
<br>
My qna are:<br>
1. Should i use the same table but first connect to a different empty 'layer' first using v.db.connect?<br>
<br>
2. If i do the above, will i be able to extract individual layers of the table in openoffice calc or Excel?<br>
<br>
3. i was going to just copy my vector map and then delete the original
500 rain columns from the table, and then add the 500 ET columns- but i
was not able to do it. i tried commands like<br>
<span style="color: rgb(51, 102, 255);"> echo "DELETE COLUMN 'Rain1' FROM watershed8c" | db.execute</span><br>
<br>
and <br>
<span style="color: rgb(51, 51, 255);">echo "DELETE FROM watershed8c COLUMN LIKE 'rain'" | db.execute</span><br>
but they did'nt work.<br><br>
How do i delete say all columns that start with the text 'rain' from a table?<br>
<br>
thanks much,<br>
vishal<br>
<br>
<br>
<br><div><span class="gmail_quote">On 6/28/06, <b class="gmail_sendername">Hamish</b> <<a href="mailto:hamish_nospam@yahoo.com">hamish_nospam@yahoo.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Vishal Mehta wrote:<br><br>> 2. My rasters are large, covering south asia (60E-100E, 5N-45N; 0.5<br>> degree resolution). My vectors are very small (covering small part of<br>> south-west India). Perhaps this effects the processing time..should i
<br>> mask the rasters and then do the adding of columns?<br><br><br>add in a step after MASK creation:<br><br>g.region zoom=MASK res=0.5 -a<br><br><br>leave out the g.mlist sep=space, it uses the whole word!<br>`g.mlist pat='*'` is enough.
<br><br><br><br>Hamish<br><br>ps - new mailing list address: grassuser at <a href="http://grass.itc.it">grass.itc.it</a><br></blockquote></div><br>