GRASS Toolbox database modules

提供: OSGeo.JP Wiki
2009年8月18日 (火) 18:19時点におけるKayama (トーク | 投稿記録)による版

(差分) ←前の版 | 最新版 (差分) | 次の版→ (差分)
移動: 案内検索

GRASS Toolbox database modules

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>
<P>


<A NAME="264"></A>

Table 34: GRASS Toolbox: Database modules
Database management and analysis modules in the GRASS Toolbox
Module name Purpose
db.connect Sets general DB connection mapset
db.connect.schema Sets general DB connection mapset with a schema
v.db.reconnect.all Reconnect vector to a new database
db.login Set user/password for driver/database
db.in.ogr Imports attribute tables in various formats
v.db.addtable Create and add a new table to a vector
v.db.addcol Adds one or more columns to the attribute table connected to a given vector map
v.db.dropcol Drops a column from the attribute table connected to a given vector map
v.db.renamecol Renames a column in a attribute table connected to a given vector map
v.db.update_const Allows to assign a new constant value to a column
v.db.update_query Allows to assign a new constant value to a column only if the result of a query is TRUE
v.db.update_op Allows to assign a new value, result of operation on column(s), to a column in the attribute table connected to a given map
v.db.update_op_query Allows to assign a new value to a column, result of operation on column(s), only if the result of a query is TRUE
db.execute Execute any SQL statement
db.select Prints results of selection from database based on SQL
v.db.select Prints vector map attributes
v.db.select.where Prints vector map attributes with SQL
v.db.join Allows to join a table to a vector map table
v.db.univar Calculates univariate statistics on selected table column for a GRASS vector map

</DIV>

<P>

<P>