GRASS Toolbox database modules
提供: OSGeo.JP Wiki
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>
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>