<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<br>I have very nice results with sqlite+GRASS.<br><br>First, use an sqlite administrator software to make things easier.<br><br> <br>> 1) My initial impression is that I need a separate database for each layer<br>> (i.e., one for highways, a separate one for streams & rivers, etc.). Is this<br>> correct?<br><br>One database for each LOCATION, one table for each vector.<br><br>One way of working is that You can put rivers, highways, power lines, etc. in the same "layer" and put a column in the table that describe what kind of object it is. You can play with CAT number too, like rivers is cat number x and highways is cat number y.<br>Then for example:<br>Displaying the vector you say: x=blue y=black.<br>In the sql you say: SELECT * FROM table WHERE description="river"<br><br><br>Try no to think as the obsolete shapefile style gis.<br><br><br>> 2) Do I manually create the databases and specify table schema within each<br>> location's dbf/ directory?<br><br>Just create the table and connect the LOCATION to it. "db.connect".<br>Any new vector or command tha creates a vector, creates also a new table in the sql database.<br><br><br>> 3) If I want to write SELECT statments that JOIN tables in different<br>> layers, then I need to open one database and attach the others. Is this done<br>> within GRASS?<br><br>I have never tried joining tables in different databases.<br><br>> I'm sure that I'll have more questions as I learn how to use SQLite with<br>> vector attributes. The soils data in particular, has a couple of dozen<br>> tables associated with it.<br><br>I am a <span id="result_box" class="short_text"><span style="background-color: rgb(255, 255, 255);" title="agrônomo engenheiro">agronomist engineer an I have made soil maps and soil use maps with grass, just ask if you have more questions.</span></span><br><br><br>Pablo Torres Carreira<br>Brazil.<br><br><br><br> <br /><hr />A vida na frente do computador ficou mais simples: Chegou Windows 7! <a href='http://www.microsoft.com/brasil/windows7/default.html?WT.mc_id=1539' target='_new'>Clique e Conheça</a></body>
</html>