1v.db.droprow(1)             GRASS GIS User's Manual            v.db.droprow(1)
2
3
4

NAME

6       v.db.droprow   -  Removes  a  vector  feature from a vector map through
7       attribute selection.
8

KEYWORDS

10       vector, attribute table, database
11

SYNOPSIS

13       v.db.droprow
14       v.db.droprow --help
15       v.db.droprow input=name   [layer=string]   where=sql_query  output=name
16       [--overwrite]  [--help]  [--verbose]  [--quiet]  [--ui]
17
18   Flags:
19       --overwrite
20           Allow output files to overwrite existing files
21
22       --help
23           Print usage summary
24
25       --verbose
26           Verbose module output
27
28       --quiet
29           Quiet module output
30
31       --ui
32           Force launching GUI dialog
33
34   Parameters:
35       input=name [required]
36           Name of input vector map
37           Or data source for direct OGR access
38
39       layer=string
40           Layer number or name
41           Vector  features can have category values in different layers. This
42           number determines which layer to use. When  used  with  direct  OGR
43           access this is the layer name.
44           Default: 1
45
46       where=sql_query [required]
47           WHERE conditions of SQL statement without ’where’ keyword
48           Example: income < 1000 and population >= 10000
49
50       output=name [required]
51           Name for output vector map
52

DESCRIPTION

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

NOTES

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

EXAMPLES

65       Dropping all vector points without elevation attribute (North  Carolina
66       data set):
67       g.region raster=elevation -p
68       v.random output=rand5k_elev n=5000
69       v.db.addtable map=rand5k_elev column="elevation double precision"
70       v.what.rast vect=rand5k_elev rast=elevation column=elevation
71       # verify absence of some elevation attributes ("number of NULL attributes"):
72       v.univar rand5k_elev type=point column=elevation
73       # Remove all vector points lacking elevation attribute
74       v.db.droprow rand5k_elev output=rand5k_elev_filt where="elevation IS NULL"
75       # verify:
76       v.univar rand5k_elev_filt type=point column=elevation
77

SEE ALSO

79        db.droptable, db.execute, v.db.addcolumn, v.db.addtable, v.db.connect,
80       v.db.dropcolumn, v.db.droptable, v.db.select, v.db.update
81

AUTHOR

83       Markus Neteler
84

SOURCE CODE

86       Available at: v.db.droprow source code (history)
87
88       Main index | Vector index | Topics index | Keywords index  |  Graphical
89       index | Full index
90
91       © 2003-2020 GRASS Development Team, GRASS GIS 7.8.5 Reference Manual
92
93
94
95GRASS 7.8.5                                                    v.db.droprow(1)