3
<em>v.db.select</em> prints attributes of a vector map from one or several
4
user selected attribute table columns.
8
All examples are based on the North Carolina sample dataset.
10
<h3>Select and show entire table</h3>
12
<div class="code"><pre>
13
v.db.select map=roadsmajor
14
cat|MAJORRDS_|ROAD_NAME|MULTILANE|PROPYEAR|OBJECTID|SHAPE_LEN
15
1|1|NC-50|no|0|1|4825.369405
16
2|2|NC-50|no|0|2|14392.589058
17
3|3|NC-98|no|0|3|3212.981242
18
4|4|NC-50|no|0|4|13391.907552
22
<h3>Select and show single column from table</h3>
24
Note: multiple columns can be specified as comma separated list.
26
<div class="code"><pre>
27
v.db.select map=roadsmajor column=ROAD_NAME
36
<h3>Print region extent of selected vector features</h3>
38
<div class="code"><pre>
39
v.db.select -r map=roadsmajor where="ROAD_NAME = 'NC-98'"
46
<h3>Select empty vector features (no data entries)</h3>
48
<div class="code"><pre>
49
v.db.select geonames_wake where="ALTERNATEN IS NULL"
50
cat|GEONAMEID|NAME|ASCIINAME|ALTERNATEN|FEATURECLA|FEATURECOD|...
51
8|4498303|West Raleigh|West Raleigh||P|PPL|US||NC|338759|123|...
52
14|4459467|Cary|Cary||P|PPL|US||NC|103945|146|152|America/Iqaluit|...
53
31|4452808|Apex|Apex||P|PPL|US||NC|30873|167|134|America/Iqaluit|...
58
<h3>Select empty vector features (no data entries)</h3>
60
<div class="code"><pre>
61
v.db.select geonames_wake where="ALTERNATEN IS NOT NULL"
62
cat|GEONAMEID|NAME|ASCIINAME|ALTERNATEN|FEATURECLA|FEATURECOD|...
63
9|4487042|Raleigh|Raleigh|Raleigh,...
64
31299|4487056|Raleigh-Durham Airport|Raleigh-Durham Airport|...
71
<a href="db.select.html">db.select</a>
76
Radim Blazek, ITC-Irst, Trento, Italy<br>
77
Minimal region extent added by Martin Landa,
78
FBK-irst (formerly ITC-irst), Trento, Italy (2008/08)
80
<p><i>Last changed: $Date: 2014-11-28 15:41:54 +0100 (Fri, 28 Nov 2014) $</i>