Geografic-Information-System/gui/wxpython/dbmgr/g.gui.dbmgr.html

<!-- meta page description: wxGUI Attribute Table Manager -->
<!-- meta page index: topic_gui|GUI -->
<h2>DESCRIPTION</h2>

The <b>Attribute Table Manager</b> is
a <em><a href="wxGUI.html">wxGUI</a></em> compoment to query, edit,
and manage attribute data for vector maps. The attribute table manager
can be launched by clicking on icon <img src="icons/table.png"
alt="icon"> in the toolbar. It's also available as a stand-alone
module <em>g.gui.dbmgr</em>.

<p>
<em>Attribute table manager</em> allows you to:

<ul>
  <li>browse attribute data of vector map, perform SQL select
  statements;</li>
  <li>modify attribute data, insert new records to attribute table,
  delete existing records;</li>
  <li>highlight selected items in the Map Display Window;</li>
  <li>extract selected items into a new vector map;</li>
  <li>modify attribute table - add, drop, rename columns;</li>
  <li>modify vector map DB connection settings - add, remove or
  modify layers.</li>
</ul>

<center>
<a href="dbmgr_frame.png"><img src="dbmgr_frame.png" alt="Attribute Table Manager" width="600" height="401"></a>
<br>
<i>Figure: Simple attribute filtering using Attribute Table Manager.</i>
</center>

<h3>SQL Builder</h3>

<center>
<a href="dbmgr_sql_builder.png"><img src="dbmgr_sql_builder.png" alt="Attribute Table Manager and SQL Builder" width="700" height="287"></a>
<br>
<i>Figure: Attribute filtering using Attribute Table Manager and SQL Builder.</i>
</center>

<h2>SEE ALSO</h2>

<em>
  <a href="wxGUI.html">wxGUI</a><br>
  <a href="wxGUI.components.html">wxGUI components</a>
</em>

<p>
<em>
<a href="db.columns.html">db.columns</a>,
<a href="db.connect.html">db.connect</a>,
<a href="db.describe.html">db.describe</a>,
<a href="db.drivers.html">db.drivers</a>,
<a href="db.execute.html">db.execute</a>,
<a href="db.select.html">db.select</a>,
<a href="db.tables.html">db.tables</a>
</em>

<p>
<em>
<a href="v.db.addcolumn.html">v.db.addcolumn</a>,
<a href="v.db.connect.html">v.db.connect</a>,
<a href="v.db.dropcolumn.html">v.db.dropcolumn</a>,
<a href="v.db.renamecolumn.html">v.db.renamecolumn</a>,
<a href="v.what.html">v.what</a>
</em>

<p>
See
also <a href="https://grasswiki.osgeo.org/wiki/WxGUI_Attribute_Table_Manager">wiki</a>
page
including <a href="https://grasswiki.osgeo.org/wiki/WxGUI_Attribute_Table_Manager#Video_tutorials">video
tutorials</a>.

<h2>AUTHORS</h2>

Martin Landa, <a href="http://www.fbk.eu">FBK-irst</a> (2007-2008),
Trento, Italy, and OSGeoREL at the Czech Technical
University in Prague, Czech Republic<br>
Michael Barton, Arizona State University, USA<br>
Jachym Cepicky