[GRASSweb-list]markus: web/grass51/tutorial attrib_storage.html,1.10,1.11 examples.html,1.9,1.10 index.html,1.4,1.5
grass at intevation.de
grass at intevation.de
Sun Jan 26 07:07:22 EST 2003
Author: markus
Update of /grassrepository/web/grass51/tutorial
In directory doto:/tmp/cvs-serv19237
Modified Files:
attrib_storage.html examples.html index.html
Log Message:
added quick guide table
Index: attrib_storage.html
===================================================================
RCS file: /grassrepository/web/grass51/tutorial/attrib_storage.html,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- attrib_storage.html 24 Jan 2003 15:08:32 -0000 1.10
+++ attrib_storage.html 26 Jan 2003 12:07:20 -0000 1.11
@@ -273,10 +273,10 @@
to_table=markveggy
</div></pre>
-<li> Next add an entry in the GRASS 5.1 'DB' file:
+<li> Next add an entry in the GRASS 5.1 'dbln' file:
<div class="code"><pre>
-# map field table ID database DBMIdriver
-markveggy.shp 1 markveggy VEGCNP_ID grass51test odbc
+# field table ID database DBMIdriver
+1 markveggy VEGCNP_ID grass51test odbc
</div></pre>
<li>
@@ -330,10 +330,10 @@
</div></pre>
<p>
Let's assume that PostgreSQL runs on machine 'pgserver'.
-Add entry in the GRASS 5.1 'DB' file in the mapset directory:
+Add entry in the GRASS 5.1 'dbln' file in the vector map directory:
<div class="code"><pre>
-# map field table ID database DBMIdriver
-markveggy.shp 1 markveggy VEGCNP_ID host=pgserver,dbname=grass51test,user=neteler pg
+#field table ID database DBMIdriver
+1 markveggy VEGCNP_ID host=pgserver,dbname=grass51test,user=neteler pg
</div></pre>
Connect GRASS 5.1 to the table:
Index: examples.html
===================================================================
RCS file: /grassrepository/web/grass51/tutorial/examples.html,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- examples.html 24 Jan 2003 15:08:32 -0000 1.9
+++ examples.html 26 Jan 2003 12:07:20 -0000 1.10
@@ -65,11 +65,11 @@
</ul>
<hr>
+<a name="toc"></a>
<ol>
<li><a href="#convert">Convert from/to GRASS 5.0 vector maps</a>
<li><a href="#geometry">Geometry storage in various formats</a>
<li><a href="#attributes">Attribute storage in (external) databases</a>
-<li><a href="#geometry">Geometry stored in external database</a>
<li><a href="#v.extract">Example: Extract vector data from map to new map
with SQL statements (PostGRASS)</a>
<li><a href="#ogr_export">Example: Vector map export data using OGR</a>
@@ -89,6 +89,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="convert"></a>
Convert from/to GRASS 5.0 vector maps
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
<b>
@@ -118,6 +119,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="geometry"></a>
Geometry storage in various formats
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
There are various possibilities to store vector geometry in GRASS 5.1:
@@ -137,6 +139,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="attributes"></a>
Attribute storage in (external) databases
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
There are various possibilities to store attributes in GRASS 5.1:
@@ -156,6 +159,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="v.extract"></a>
Example: Extract vector data from map to new map with SQL statements
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
<div class="code"><pre>
@@ -188,6 +192,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="ogr_export"></a>
Example: Vector map export data using OGR
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
#Export of GRASS 5.1 vector map to SHAPE format (generates /tmp/testogr.shp
@@ -208,6 +213,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="SQL_queries"></a>
Example: SQL queries
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
@@ -248,6 +254,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="shape_conversion"></a>
Example: Conversion of SHAPE map to GRASS 5.1 vector map
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
WARNING: don't try this at home. Still pretty unstable.
@@ -298,6 +305,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="map_from_points"></a>
Example: Generating a vector map from a point data table
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
Assume you have a CSV (comma separated values) file and want to generate a
@@ -357,6 +365,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="db_copy"></a>
Example: Copying a database table from one DBMS to another within GRASS 5.1
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
Here we copy a DBF file from current directory into a PostgreSQL database
@@ -383,6 +392,7 @@
<tr><td align="left" bgcolor="#B0F0B0"><font color="#00000"><big><b>
<a name="postgismapserver"></a>
Example: Writing the GRASS 5.0 Spearfish 'streams' map into PostGIS for MapServer
+<DIV ALIGN=right><a href="#toc">[UP]</a></DIV>
</b></big></font></td></tr></table>
In this example we want to take the Spearfish 'streams' vector map and write
Index: index.html
===================================================================
RCS file: /grassrepository/web/grass51/tutorial/index.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- index.html 21 Jan 2003 17:50:04 -0000 1.4
+++ index.html 26 Jan 2003 12:07:20 -0000 1.5
@@ -33,7 +33,7 @@
<ol>
<li><a href="demo.html">A demo tour through GRASS 5.1</a>
-<li>Vector data management in GRASS 5.1:
+<li>Vector data management in GRASS 5.1
<ul>
<li><a href="geom_storage.html">Geometry management, optionally with connections to DBMS</a>
<li><a href="attrib_storage.html">Attribute management with connections to DBMS</a>
@@ -41,8 +41,80 @@
<li><a href="examples.html">Examples how to use the GRASS 5.1 vector engine</a>
</ol>
+<h3>Tutorial Quick Guide</h3>
+
+The table does not completely refer to all examples. Please check also the
+individual tables of contents.
+<center>
+<table border=2>
+<tr>
+<td></td>
+<td colspan="7">
+<i>Formats/RDBMS</i>
+</td>
+</tr>
+<tr>
+ <td> </td>
+ <td><b>Native</b></td>
+ <td><b>SHAPE</b></td>
+ <td><b>PostGIS</b></td>
+ <td><b>DBF</b></td>
+ <td><b>mySQL</b></td>
+ <td><b>PostgreSQL</b></td>
+ <td><b>ODBC</b></td>
+</tr>
+<tr>
+ <td><b>Geometry</b></td>
+ <td>default format<br>
+ 2D/3D vectors<br>
+ topology<br>
+ <a href="geom_storage.html#native">Def.</a> /
+ <a href="examples.html#convert">Ex.</a></td>
+ <td>.shp<br>
+ import/export<br>
+ pseudotopology<br>
+ <a href="geom_storage.html#SHAPE">Def.</a> /
+ <a href="examples.html#shape_conversion">Ex.1</a> / <a href="examples.html#ogr_export">Ex.2</a> </td>
+ <td>needs PostgreSQL <br>
+ pseudotopology<br>
+ <a href="geom_storage.html#PostGRASS">Def.</a> /
+ <a href="examples.html#postgismapserver">Ex.</a></td>
+ <td align="center"> - </td>
+ <td align="center"> - </td>
+ <td>with PostGIS<br>
+ <i>see there</i></td>
+ <td align="center"> - </td>
+</tr>
+<tr>
+ <td><b>Attributes</b></td>
+ <td align="center"> - </td>
+ <td>with DBF<br>
+ <i>see there</i></td>
+ <td>with PostgreSQL <br>
+ <i>see there</i></td>
+ <td>all COLUMN types <br>
+ <a href="attrib_storage.html#DBF">Def.</a> /
+ <a href="examples.html#db_copy">Ex.</a></td>
+ <td>all COLUMN types (?) <br>
+ <a href="attrib_storage.html#mySQL">Def.</a></td>
+ <td>all COLUMN types (?) <br>
+ <a href="attrib_storage.html#PostgreSQL">Def.</a> /
+ <a href="examples.html#db_copy">Ex.</a></td>
+ <td>links to various RDBMS <br>
+ <a href="attrib_storage.html#ODBC">Def.</a> </td>
+</tr>
+<tr>
+<td> </td>
+<td colspan="7">
+<i>Def.: Definition, Ex. Example</i>
+</td>
+</tr>
+
+</table>
+</center>
+
<hr>
-Bibliography:<p>
+<h3>Bibliography:</h3>
R. Blazek, M. Neteler, and R. Micarelli, 2002. The new GRASS 5.1 vector
architecture. In <i>Open Source GIS - GRASS users conference 2002, Trento,
@@ -50,7 +122,7 @@
<a target="top" href="http://www.ing.unitn.it/~grass/conferences/GRASS2002/proceedings/proceedings/pdfs/Blazek_Radim.pdf">http://www.ing.unitn.it/~grass/conferences/GRASS2002/proceedings/proceedings/pdfs/Blazek_Radim.pdf</a>
<p>
-<b>Further Links:</b>
+<h3>Related:</h3>
<ul>
<li><a href=index.html>GRASS 5.1 main page</a></li>
More information about the grass-web
mailing list