|
NAMEv.db.select - Prints vector map attributes.KEYWORDSvector, attribute table, database, SQLSYNOPSISv.db.selectv.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] Flags:
Parameters:
DESCRIPTIONv.db.select prints attributes of a vector map from one or several user selected attribute table columns.EXAMPLESAll examples are based on the North Carolina sample dataset.Select and show entire tablev.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 ... Select and show single column from tableNote: 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 ... Print region extent of selected vector featuresv.db.select -r map=roadsmajor where="ROAD_NAME = ’NC-98’" n=248425.389891 s=245640.640081 w=635906.517653 e=661979.801880 Select empty vector features (no data entries)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|... ... Select not empty vector features (no data entries)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|... ... Select features with distinct road namesv.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|yesIt 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 SEE ALSOdb.selectAUTHORSRadim Blazek, ITC-Irst, Trento, ItalyMinimal 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) SOURCE CODEAvailable at: v.db.select source code (history)Main index | Vector index | Topics index | Keywords index | Graphical index | Full index © 2003-2021 GRASS Development Team, GRASS GIS 7.8.6 Reference Manual
Visit the GSP FreeBSD Man Page Interface. |