Hello achim<div>1- I converted from raster to vector (r.to.vect)</div><div><div>r.to.vect -v input=teste01_LULC@Regional output=vector01 feature=area </div><div>Extracting areas...</div><div>Building topology for vector map <vector01>...</div>
<div>Registering primitives...</div><div>833 primitives registered</div><div>4624 vertices registered</div><div>Building areas...</div><div>334 areas built</div><div>163 isles built</div><div>Attaching islands...</div><div>
Attaching centroids...</div><div>Number of nodes: 662</div><div>Number of primitives: 833</div><div>Number of points: 0</div><div>Number of lines: 0</div><div>Number of boundaries: 499</div><div>Number of centroids: 334</div>
<div>Number of areas: 334</div><div>Number of isles: 163</div><div>r.to.vect complete.</div></div><div><br></div><div>2- When I select a designated area i get this:</div><div><div>East: 629238.662505</div><div>North: 9331859.599043</div>
<div>Map: vector01 </div><div>Mapset: Regional</div><div>Type: Area</div><div>Sq Meters: 1132124355.009</div><div>Hectares: 113212.436</div><div>Acres: 279754.021</div><div>Sq Miles: 437.1157</div><div>Layer: 1</div><div>
Category: 5</div><div>Driver: dbf</div><div>Database: C:\DWEISdata/Brazil/Regional/dbf/</div><div>Table: vector01</div><div>Key column: cat</div><div>cat : 5</div><div>label : </div><div>(CAT IS the value of my previous raster)</div>
<div><br></div><div>3- When i do:</div><div>v.db.connect map=vector01@Regional table=vector01 driver=sqlite</div><div>I get the following error:</div><div>ERROR: Use -o to overwrite existing link for layer <1></div>
<div>THis will mean that it will overwrite existing table right?</div><div><br></div><div>I tried with -o and I got the error:</div><div><div>DBMI-SQLite driver error:</div><div>Unable to open database: unable to open database file</div>
<div>Unable to open database <$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/> by driver <sqlite></div><div>Unable open database <$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/> by driver <sqlite></div><div>ERROR: Table <vector01> does not exist in database <$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/></div>
</div><div>So I'm not able to do what you suggest</div><div><br></div><div>Any other suggestion?</div><br><div class="gmail_quote">2010/11/16 Achim Kisseler <span dir="ltr"><<a href="mailto:ak7@jupiter.uni-freiburg.de">ak7@jupiter.uni-freiburg.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br>
<br>
you should not loose the information, because the table you create consists of a column "cat" by default containing the cats.<br>
<br>
Does this do the job?<br>
<br>
Achim<br>
<br>
Am 16.11.2010 09:46, schrieb Luisa Peña:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hi Achim<br>
Well, the thing is, if I add a table to my vector, I will loose all the<br>
information that is already available in my vector (since it's a<br>
conversion from a Classification raster I have a cat value for each<br>
area). Right?<br>
<br>
2010/11/15 Achim Kisseler <<a href="mailto:ak7@jupiter.uni-freiburg.de" target="_blank">ak7@jupiter.uni-freiburg.de</a><br></div>
<mailto:<a href="mailto:ak7@jupiter.uni-freiburg.de" target="_blank">ak7@jupiter.uni-freiburg.de</a>>><div class="im"><br>
<br>
<br>
<br>
Am 15.11.2010 16:41, schrieb Luisa Peña:<br>
<br>
In this email,<br>
<a href="http://lists.osgeo.org/pipermail/grass-user/2010-November/058644.html" target="_blank">http://lists.osgeo.org/pipermail/grass-user/2010-November/058644.html</a>,<br>
you suggested me to use sqlite as database. I'm willing to try<br>
that. How<br>
can I do that with a vector created from r.to.vect with categories<br>
values in cat column<br>
<br>
<br>
Hi Luisa,<br>
<br>
first create an sqlite-database, second take the vector file and add<br>
an table to it<br>
(<a href="http://grass.osgeo.org/gdp/html_grass64/v.db.addtable.html" target="_blank">http://grass.osgeo.org/gdp/html_grass64/v.db.addtable.html</a>:<br>
--%<--<br>
DESCRIPTION<br>
v.db.addtable creates and adds a new attribute table to a given<br>
vector map. It links the table to the specified layer of the vector<br>
map. If the vector map is not yet linked to any table, new a<br>
database link is established based on the MAPSET database settings<br>
(see db.connect).<br>
--%<--).<br>
Is that what you are looking for?<br>
<br>
Regards,<br>
Achim<br>
<br>
<br>
</div></blockquote>
</blockquote></div><br></div>