GRASS GIS manual: db.join

NAME

db.join - Joins a database table to another database table.

KEYWORDS

SYNOPSIS

db.join

db.join --help

db.join table=name column=name [database=name] [driver=name] other_table=name other_column=name [subset_columns=name[,name,...]] [--help] [--verbose] [--quiet] [--ui]

Flags:

--help: Print usage summary
--verbose: Verbose module output
--quiet: Quiet module output
--ui: Force launching GUI dialog

Parameters:

table=name [required]: Table to which to join other table
column=name [required]: Identifier column (e.g.: cat) in the table to be used for join
database=name: Name of database
driver=name: Name of database driver; Options: dbf, odbc, ogr, sqlite, pg
other_table=name [required]: Other table name
other_column=name [required]: Identifier column (e.g.: id) in the other table used for join
subset_columns=name[,name,...]: Subset of columns from the other table

DESCRIPTION
NOTES
EXAMPLES
SEE ALSO
AUTHOR

DESCRIPTION

db.join joins the content of one attribute table into another attribute table through common attributes.

NOTES

db.join is a front-end to db.execute to allow easier usage. The attribute table must be stored in a SQL database (SQLite, PostgreSQL, MySQL, ODBC, ...). The DBF backend is not supported. Tables can be imported with db.in.ogr.

EXAMPLES

# join soils_legend into mysoils attribute table
db.join mysoils col=label otable=soils_legend ocol=shortname

# verification of join
db.select mysoils
cat|label|id|shortname|longname
1|Aab|||
2|Ba|2|Ba|Barnum silt loam
3|Bb|3|Bb|Barnum silt loam, channeled
4|BcB|4|BcB|Boneek silt loam, 2 to 6
5|BcC|5|BcC|Boneek silt loam, 6 to 9
...

AUTHOR

Markus Neteler

Last changed: $Date: 2016-03-09 11:08:11 +0100 (Wed, 09 Mar 2016) $

SOURCE CODE

Available at: db.join source code (history)