Thank you! This seems to be an interesting solution to the problem especially because it involves changing the driver from DBF to SQLITE. I ended up using 'v.rast.stats', which adds columns for extended statistics and uploads values all at once. The only thing is: data are recorded as part of the same layer (i.e., Layer 1). So, I cheated!<div>
<br></div><div>However, I started trying your method. I created a new mapset to use sqlite and copied some vector maps from a mapset where default driver is DBF. I defined SQLITE as the new driver in the new mapset using 'db.connect' </div>
<div>(driver=sqlite, database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db', no flags checked). Then I wanted to use 'v.db.connect' for a vector map but I cannot select table name etc. I also tried just using 'v.db.connect' but I still cannot see anything under Table. So. I am confused about how to define a new driver in a mapset.</div>
<div><br></div><div>Thank you again,</div><div><br></div><div>Bulent<br><br><div class="gmail_quote">On Tue, Jan 3, 2012 at 9:13 PM, Micha Silver <span dir="ltr"><<a href="mailto:micha@arava.co.il" target="_blank">micha@arava.co.il</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div style="direction:ltr" bgcolor="#ffffff" text="#000000"><div>
On 01/03/2012 04:50 PM, Bulent Arikan wrote:
<blockquote type="cite">Dear List,
<div><br>
</div>
<div>I rasterized a centroid and ran 'r.univar', whose extended
stats are saved as a text file. Then, I ran 'v.db.addtable' to
create a second layer in the attribute table of the centroid and
I had columns added in this second layer using 'v.db.addcol'. I
want GRASS to upload values from the text file but I am not sure
how to perform this task. </div>
<div><br>
</div>
<div>Is there a shorter way of creating a second layer and
uploading values from the text file or what should I do next so
that the columns in the second layer will be populated using the
text file I have?</div>
<div><br>
</div>
</blockquote>
<br></div>
I'm not sure about a shorter way, but here's an option:<br>
First setup your mapset to save attributes to sqlite. <br>
> v.db.connect centroid driver=sqlite database=.... <br>
<br>
Now add the columns which will accept r.univar values to the sqlite
table:<br>
> v.db.addcol centroid col="n double, null_cells double, cells
double, min double, max double, range double, mean double,
mean_of_abs double, stddev double, variance double, coeff_var
double, sum double"<br>
<br>
Run r.univar on your raster, putting results into a text file<br>
> r.univar your_rast -g > univar.txt<br>
<br>
Now do this loop to update values for the centroid:<br>
> while read l; do \<br>
col=`echo $l | cut -d= -f1`; val=`echo $l | cut -d= -f2`; \<br>
sqlite3 sqlite.db "UPDATE centroid SET ${col}=${val} ;"; \<br>
> done < univar.txt<br>
<br>
Assuming you want to run this for several centroids/areas, you'll
probably want to add a WHERE clause to the UPDATE statement so as to
put values for only one certain row (centroid).<br>
<br>
HTH, Micha<br>
<br>
<br>
<blockquote type="cite"><div>
<div>Thank you for your time.<br clear="all">
<div><br>
</div>
<div>GRASS 6.5 svn on Snow Leopard</div>
<div><br>
</div>
<div><br>
</div>
-- <br>
BÜLENT<br>
</div>
<br></div>
This mail was received via Mail-SeCure System.<br>
<pre><fieldset></fieldset>
_______________________________________________
grass-user mailing list
<a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre><span><font color="#888888">
</font></span></blockquote><span><font color="#888888">
<p><br>
</p>
<br>
<pre cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a href="http://www.surfaces.co.il" target="_blank">http://www.surfaces.co.il</a></pre>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>BÜLENT ARIKAN, PhD<div>Senior Research Fellow</div><div>Research Center for Anatolian Civilizations<br>Koç University<br>İstiklal Caddesi No: 181 Merkez Han</div>
<div>Beyoğlu - ISTANBUL</div><div>TURKEY<br>34433</div><div><a href="tel:%28%2B%2090%29%20212-393-6036" value="+902123936036" target="_blank">(+ 90) 212-393-6036</a></div><br>
</div>