|
|
行1: |
行1: |
− | <H2>
| + | --[[利用者:Sanak|Sanak]] 2009年10月5日 (月) 14:41 (UTC)このページは削除予定です。 |
− | GRASS Toolbox database modules
| + | |
− | </H2>
| + | |
− | | + | |
− | <P>
| + | |
− | This Section lists all graphical dialogs in the GRASS Toolbox to manage,
| + | |
− | connect and work with internal and external databases. Working with spatial
| + | |
− | external databases is enabled via OGR and not covered by these modules.
| + | |
− | | + | |
− | <P>
| + | |
− | <BR><P></P>
| + | |
− | <DIV ALIGN="CENTER">
| + | |
− | <DIV ALIGN="CENTER">
| + | |
− | | + | |
− | </DIV>
| + | |
− | <P>
| + | |
− | <BR>
| + | |
− | <A NAME="264"></A>
| + | |
− | <TABLE CELLPADDING=3 BORDER="1">
| + | |
− | <CAPTION><STRONG>Table 34:</STRONG>
| + | |
− | GRASS Toolbox: Database modules</CAPTION>
| + | |
− | <TR><TD ALIGN="CENTER" COLSPAN=2><SPAN><SPAN CLASS="textbf">Database management and analysis modules in the GRASS
| + | |
− | Toolbox</SPAN></SPAN></TD>
| + | |
− | </TR>
| + | |
− | <TR><TH ALIGN="LEFT" VALIGN="TOP" WIDTH=113><SPAN CLASS="textbf">Module name</SPAN></TH>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340><SPAN CLASS="textbf">Purpose</SPAN></TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.connect</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Sets general DB connection mapset</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.connect.schema</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Sets general DB connection mapset with a schema</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.reconnect.all</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Reconnect vector to a new database</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.login</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Set user/password for driver/database</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.in.ogr</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Imports attribute tables in various formats</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.addtable</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Create and add a new table to a vector</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.addcol</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Adds one or more columns to the attribute table
| + | |
− | connected to a given vector map</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.dropcol</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Drops a column from the attribute table connected to
| + | |
− | a given vector map</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.renamecol</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Renames a column in a attribute table connected to
| + | |
− | a given vector map</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.update_const</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Allows to assign a new constant value to a
| + | |
− | column</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.update_query</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Allows to assign a new constant value to a
| + | |
− | column only if the result of a query is TRUE</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.update_op</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Allows to assign a new value, result of operation
| + | |
− | on column(s), to a column in the attribute table connected to a given map</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.update_op_query</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Allows to assign a new value to a column,
| + | |
− | result of operation on column(s), only if the result of a query is TRUE</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.execute</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Execute any SQL statement</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>db.select</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Prints results of selection from database based on SQL</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.select</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Prints vector map attributes</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.select.where</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Prints vector map attributes with SQL</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.join</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Allows to join a table to a vector map table</TD>
| + | |
− | </TR>
| + | |
− | <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=113>v.db.univar</TD>
| + | |
− | <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=340>Calculates univariate statistics on selected table
| + | |
− | column for a GRASS vector map</TD>
| + | |
− | </TR>
| + | |
− | </TABLE>
| + | |
− | </DIV>
| + | |
− | <BR>
| + | |
− | | + | |
− | <P>
| + | |
− | | + | |
− | <P>
| + | |