Skip to content

Topic: attribute table

Tool Description
db.columns List all columns for a given table.
db.connect Prints/sets general DB connection for current mapset.
db.copy Copy a table. Either 'from_table' (optionally with 'where') can be used or 'select' option, but not 'from_table' and 'select' at the same time.
db.createdb Creates an empty database.
db.databases Lists all databases for a given driver and location.
db.dropcolumn Drops a column from selected attribute table.
db.dropdb Removes an existing database.
db.droptable Drops an attribute table.
db.execute Executes any SQL statement. For SELECT statements use 'db.select'.
db.select Selects data from attribute table. Performs SQL query statement(s).
db.tables Lists all tables for a given database.
db.test Test database driver, database must exist and set by db.connect.
t.vect.db.select Prints attributes of vector maps registered in a space time vector dataset.
v.db.addcolumn Adds one or more columns to the attribute table connected to a given vector map.
v.db.addtable Creates and connects a new attribute table to a given layer of an existing vector map.
v.db.connect Prints/sets DB connection for a vector map to attribute table.
v.db.dropcolumn Drops a column from the attribute table connected to a given vector map.
v.db.droprow Removes a vector feature from a vector map through attribute selection.
v.db.droptable Removes existing attribute table of a vector map.
v.db.join Joins a database table to a vector map table.
v.db.reconnect.all Reconnects attribute tables for all vector maps from the current mapset to a new database.
v.db.renamecolumn Renames a column in the attribute table connected to a given vector map.
v.db.select Prints vector map attributes.
v.db.update Updates a column in the attribute table connected to a vector map.
v.to.db Populates attribute values from vector features.
v.vect.stats Count points in areas, calculate statistics from point attributes.

See also the corresponding keyword for additional references:

attribute table

  • db.columns - List all columns for a given table.
  • db.connect - Prints/sets general DB connection for current mapset.
  • db.copy - Copy a table. Either 'from_table' (optionally with 'where') can be used or 'select' option, but not 'from_table' and 'select' at the same time.
  • db.createdb - Creates an empty database.
  • db.databases - Lists all databases for a given driver and location.
  • db.describe - Describes a table in detail.
  • db.dropcolumn - Drops a column from selected attribute table.
  • db.dropdb - Removes an existing database.
  • db.droptable - Drops an attribute table.
  • db.execute - Executes any SQL statement. For SELECT statements use 'db.select'.
  • db.in.ogr - Imports attribute tables in various formats.
  • db.join - Joins a database table to another database table.
  • db.out.ogr - Exports attribute tables into various formats.
  • db.select - Selects data from attribute table. Performs SQL query statement(s).
  • db.tables - Lists all tables for a given database.
  • db.test - Test database driver, database must exist and set by db.connect.
  • db.univar - Calculates univariate statistics on selected table column.
  • g.gui.dbmgr - wxGUI Attribute Table Manager
  • t.vect.db.select - Prints attributes of vector maps registered in a space time vector dataset.
  • v.area.stats - Populates attribute values from vector features.
  • v.class - Classifies attribute data, e.g. for thematic mapping
  • v.db.addcolumn - Adds one or more columns to the attribute table connected to a given vector map.
  • v.db.addtable - Creates and connects a new attribute table to a given layer of an existing vector map.
  • v.db.connect - Prints/sets DB connection for a vector map to attribute table.
  • v.db.dropcolumn - Drops a column from the attribute table connected to a given vector map.
  • v.db.droprow - Removes a vector feature from a vector map through attribute selection.
  • v.db.droptable - Removes existing attribute table of a vector map.
  • v.db.join - Joins a database table to a vector map table.
  • v.db.pyupdate - Updates a column in a vector attribute table using Python code
  • v.db.reconnect.all - Reconnects attribute tables for all vector maps from the current mapset to a new database.
  • v.db.renamecolumn - Renames a column in the attribute table connected to a given vector map.
  • v.db.select - Prints vector map attributes.
  • v.db.univar - Calculates univariate statistics on selected table column for a GRASS vector map.
  • v.db.update - Updates a column in the attribute table connected to a vector map.
  • v.distance - Finds the nearest element in vector map 'to' for elements in vector map 'from'.
  • v.strds.stats - Calculates univariate statistics from given space-time raster datasets based on a vector map
  • v.to.db - Populates attribute values from vector features.
  • v.univar - Calculates univariate statistics of vector map features. Variance and standard deviation is calculated only for points if specified.
  • v.vect.stats - Count points in areas, calculate statistics from point attributes.
  • v.vect.stats.multi - Computes isochrones from collection point in a sewershed
  • v.what.rast - Uploads raster values at positions of vector points to the table.
  • v.what.rast.label - Uploads raster values and labels to vector point layer
  • v.what.rast.multi - Uploads values of multiple rasters at positions of vector points to the table.
  • v.what.rast3 - Uploads 3D raster values at positions of vector points to the table.
  • v.what.strds - Uploads space time raster dataset values at positions of vector points to the table.
  • v.what.strds.timestamp - Uploads space time raster dataset values to the attribute table at positions of vector points in space and time.
  • v.what.vect - Uploads vector values at positions of vector points to the table.