NAME
v.db.select - Prints vector map attributes.
KEYWORDS
vector, database, attribute table
SYNOPSIS
v.db.select
v.db.select help
v.db.select [-rcv] map=name layer=string [columns=name[,name,...]] [where=sql_query] [fs=character] [vs=character] [nv=string] [file=name] [--overwrite] [--verbose] [--quiet]
Flags:
- -r
- Print minimal region extent of selected vector features instead of attributes
- -c
- Do not include column names in output
- -v
- Vertical output (instead of horizontal)
- --overwrite
- Allow output files to overwrite existing files
- --verbose
- Verbose module output
- --quiet
- Quiet module output
Parameters:
- map=name
- Name of vector map
- Data source for direct OGR access
- layer=string
- Layer number or name
- A single vector map can be connected to multiple database tables. This number determines which table to use. Layer name for direct OGR access.
- Default: 1
- columns=name[,name,...]
- Name of attribute column(s)
- where=sql_query
- WHERE conditions of SQL statement without 'where' keyword
- Example: income < 1000 and inhab >= 10000
- fs=character
- Field separator
- Output field separator
- Default: |
- vs=character
- Field separator
- Output vertical record separator
- nv=string
- Null value indicator
- file=name
- Name for output file (if omitted or "-" output to stdout)
DESCRIPTION
v.db.select prints attributes of a vector map from one or several
user selected attribute table columns.
EXAMPLES
Select and show entire table:
v.db.select map=roads
cat|label
0|no data
1|interstate
2|primary highway, hard surface
3|secondary highway, hard surface
4|light-duty road, improved surface
5|unimproved road
v.db.select map=roads column=label
label
no data
interstate
primary highway, hard surface
secondary highway, hard surface
light-duty road, improved surface
unimproved road
v.db.select -r map=roads where="label ~ 'highway'"
n=4928063.398015
s=4914089.153930
w=589532.054964
e=609527.210215
SEE ALSO
db.select
AUTHOR
Radim Blazek, ITC-Irst, Trento, Italy
Minimal region extent added by Martin Landa,
FBK-irst (formerly ITC-irst), Trento, Italy (2008/08)
Last changed: $Date: 2008-08-23 13:40:40 -0700 (Sat, 23 Aug 2008) $
Main index - vector index - Full index
© 2003-2011 GRASS Development Team