other versions
- wheezy 6.4.2-2
- jessie 6.4.4-1
- testing 7.2.0-2
- unstable 7.2.0-2
- experimental 7.2.1-1~exp1
v.db.update(1grass) | Grass User's Manual | v.db.update(1grass) |
NAME¶
v.db.update - Allows to update a column in the attribute table connected to a vector map.KEYWORDS¶
vector, database, attribute tableSYNOPSIS¶
v.db.updateParameters:¶
- map=string
-
- layer=string
-
- column=string
-
- value=string
-
- qcolumn=string
-
- where=string
-
DESCRIPTION¶
v.db.update allows to assign a new value to a column in the attribute table connected to a given map. Alternatively, values can be copied from another column in the table.NOTES¶
v.db.update is just a front-end to db.execute to allow easier usage. For complex SQL UPDATE statements, db.execute should be used.EXAMPLES¶
In this example, selectively display lakes without (blue) and with NULL (red) are shown to find out which type is undefined. In the original map there are lakes missing FTYPE attribute which are wetlands along streams. These NULL attributes are replaced with the landuse type WETLAND:where="FTYPE IS NULL"
where="z_value <> 'N/A'"
SEE ALSO¶
db.execute, v.db.addcolumn, v.db.addtable, v.db.connect, v.db.droptable, v.db.join, v.db.selectAUTHOR¶
Moritz Lennert (mlennert@club.worldonline.be) Last changed: $Date: 2011-11-22 23:29:56 +0100 (Tue, 22 Nov 2011) $ Full index © 2003-2011 GRASS Development TeamGRASS 6.4.2 |