v.db.droprow(1grass)

Usage

v.db.droprow

v.db.droprow --help

v.db.droprow input=name [layer=string] where=sql_query output=name [--overwrite] [--help] [--verbose] [--quiet] [--ui]

Keywords

vector, attribute table, database

Overview

v.db.droprow removes vector object(s) (point, line, area, face etc.) from a vector map through attribute selection in the table connected to the given vector map. It automatically checks the connection for the specified layer.

Notes

v.db.droprow is a front-end to v.extract (reverse selection) to allow easier usage. The existing database connection(s) can be verified with v.db.connect.

Examples

Dropping all vector points without elevation attribute (North Carolina data set):

g.region raster=elevation -p
v.random output=rand5k_elev n=5000
v.db.addtable map=rand5k_elev column="elevation double precision"
v.what.rast vect=rand5k_elev rast=elevation column=elevation
# verify absence of some elevation attributes ("number of NULL attributes"):
v.univar rand5k_elev type=point column=elevation
# Remove all vector points lacking elevation attribute
v.db.droprow rand5k_elev output=rand5k_elev_filt where="elevation IS NULL"
# verify:
v.univar rand5k_elev_filt type=point column=elevation

Source code

Available at: v.db.droprow source code (history)

Accessed: Monday Feb 24 17:51:45 2025

Releases

5 releases since Debian 9 (Stretch); the text changed 4 times.

9
10
11
12
13