v.db.select(1grass) | GRASS GIS User's Manual | v.db.select(1grass) |
v.db.select - Prints vector map attributes.
vector, attribute table, database, SQL
v.db.select
v.db.select --help
v.db.select [-rcvf] map=name
[layer=string] [columns=name[,name,...]]
[where=sql_query] [group=string]
[separator=character]
[vertical_separator=character]
[null_value=string] [file=name]
[--overwrite] [--help] [--verbose] [--quiet]
[--ui]
v.db.select prints attributes of a vector map from one or several user selected attribute table columns.
All examples are based on the North Carolina sample dataset.
v.db.select map=roadsmajor cat|MAJORRDS_|ROAD_NAME|MULTILANE|PROPYEAR|OBJECTID|SHAPE_LEN 1|1|NC-50|no|0|1|4825.369405 2|2|NC-50|no|0|2|14392.589058 3|3|NC-98|no|0|3|3212.981242 4|4|NC-50|no|0|4|13391.907552 ...
Note: multiple columns can be specified as comma separated list.
v.db.select map=roadsmajor column=ROAD_NAME NC-50 NC-50 NC-98 NC-50 NC-98 ...
v.db.select -r map=roadsmajor where="ROAD_NAME = ’NC-98’" n=248425.389891 s=245640.640081 w=635906.517653 e=661979.801880
v.db.select geonames_wake where="ALTERNATEN IS NULL" cat|GEONAMEID|NAME|ASCIINAME|ALTERNATEN|FEATURECLA|FEATURECOD|... 8|4498303|West Raleigh|West Raleigh||P|PPL|US||NC|338759|123|... 14|4459467|Cary|Cary||P|PPL|US||NC|103945|146|152|America/Iqaluit|... 31|4452808|Apex|Apex||P|PPL|US||NC|30873|167|134|America/Iqaluit|... ...
v.db.select geonames_wake where="ALTERNATEN IS NOT NULL" cat|GEONAMEID|NAME|ASCIINAME|ALTERNATEN|FEATURECLA|FEATURECOD|... 9|4487042|Raleigh|Raleigh|Raleigh,... 31299|4487056|Raleigh-Durham Airport|Raleigh-Durham Airport|... ...
v.db.select map=roadsmajor columns=ROAD_NAME group=ROAD_NAME ROAD_NAME I-40 I-440 I-540 NC-231 NC-39 NC-42 ...
It is also possible to combine with where option
v.db.select map=roadsmajor columns=ROAD_NAME,MULTILANE group=ROAD_NAME where=’ROAD_NAME is not null’ ROAD_NAME|MULTILANE I-40|yes I-440|yes I-540|yes NC-231|no NC-39|no NC-42|no NC-50|no NC-54|no NC-55|no NC-96|no NC-97|no NC-98|no US-1| US-401|no US-64|yes US-70|yes
It can also use more columns in group option
v.db.select map=roadsmajor columns=ROAD_NAME,MULTILANE group=ROAD_NAME,MULTILANE where=’ROAD_NAME is not null’ ROAD_NAME|MULTILANE I-40|yes I-440|yes I-540|yes NC-231|no NC-39|no NC-42|no NC-50|no NC-54|no NC-55|no NC-96|no NC-97|no NC-98|no US-1| US-1|yes US-401|no US-401|yes US-64|yes US-70|yes
db.select
Radim Blazek, ITC-Irst, Trento, Italy
Minimal region extent added by Martin Landa, FBK-irst (formerly ITC-irst),
Trento, Italy (2008/08)
Group option added by Luca Delucchi, Fondazione Edmund Mach, Trento, Italy
(2015/12)
Available at: v.db.select source code (history)
Main index | Vector index | Topics index | Keywords index | Graphical index | Full index
© 2003-2020 GRASS Development Team, GRASS GIS 7.8.5 Reference Manual
GRASS 7.8.5 |