.TH t.vect.db.select 1grass "" "GRASS 7.8.5" "GRASS GIS User's Manual"
.SH NAME
\fI\fBt.vect.db.select\fR\fR  \- Prints attributes of vector maps registered in a space time vector dataset.
.SH KEYWORDS
temporal, attribute table, vector, database, select, time
.SH SYNOPSIS
\fBt.vect.db.select\fR
.br
\fBt.vect.db.select \-\-help\fR
.br
\fBt.vect.db.select\fR \fBinput\fR=\fIname\fR  [\fBcolumns\fR=\fIname\fR[,\fIname\fR,...]]   [\fBseparator\fR=\fIcharacter\fR]   [\fBlayer\fR=\fIstring\fR]   [\fBwhere\fR=\fIsql_query\fR]   [\fBt_where\fR=\fIsql_query\fR]   [\-\-\fBhelp\fR]  [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR]  [\-\-\fBui\fR]
.SS Flags:
.IP "\fB\-\-help\fR" 4m
.br
Print usage summary
.IP "\fB\-\-verbose\fR" 4m
.br
Verbose module output
.IP "\fB\-\-quiet\fR" 4m
.br
Quiet module output
.IP "\fB\-\-ui\fR" 4m
.br
Force launching GUI dialog
.SS Parameters:
.IP "\fBinput\fR=\fIname\fR \fB[required]\fR" 4m
.br
Name of the input space time vector dataset
.IP "\fBcolumns\fR=\fIname[,\fIname\fR,...]\fR" 4m
.br
Name of attribute column(s)
.IP "\fBseparator\fR=\fIcharacter\fR" 4m
.br
Field separator character between the output columns
.br
Special characters: pipe, comma, space, tab, newline
.br
Default: \fIpipe\fR
.IP "\fBlayer\fR=\fIstring\fR" 4m
.br
Layer number or name
.br
Vector features can have category values in different layers. This number determines which layer to use. When used with direct OGR access this is the layer name.
.br
Default: \fI1\fR
.IP "\fBwhere\fR=\fIsql_query\fR" 4m
.br
WHERE conditions of SQL statement without \(cqwhere\(cq keyword
.br
Example: income < 1000 and population >= 10000
.IP "\fBt_where\fR=\fIsql_query\fR" 4m
.br
WHERE conditions of SQL statement without \(cqwhere\(cq keyword used in the temporal GIS framework
.br
Example: start_time > \(cq2001\-01\-01 12:30:00\(cq
.SH DESCRIPTION
The module \fIt.vect.db.select\fR prints attributes of vector maps
registered in a space time vector dataset.
.SH EXAMPLE
The example is querying the \fIshoreline\fR space time dataset:
.br
.nf
\fC
t.vect.db.select input=shoreline
start_time|end_time|cat|DESCR|SOURCE|DATE
1849|1873|1|T\-736|NOAA/USGS|01/01/1858
1849|1873|2|T\-657|NOAA/USGS|01/01/1857
1849|1873|3|T\-381(2)|NOAA/USGS|01/01/1852
1849|1873|4|T\-381(1)|NOAA/USGS|01/01/1852
1849|1873|5|T\-381(1)|NOAA/USGS|01/01/1852
\&...
2009||44|2009 USDA NAIP|2009\-07\-11|VA, SAND, Wet / Dry
2009||45|2009 USDA NAIP|2009\-07\-11|Carolina Beach, SAND, Wet / Dry
2009||46|2009 USDA NAIP|2009\-07\-11|Carolina Beach, REVETMENT\-ROCK, Hard Structure
2009||47|2009 USDA NAIP|2009\-07\-11|Fort Fisher, REVETMENT\-ROCK, Hard Structure
\fR
.fi
In the following example it print only DATE and SOURCE columns for data
before 1900\-01\-01.
.br
.nf
\fC
t.vect.db.select input=shoreline column=DATE,SOURCE t_where=\(dqstart_time < 1900\(dq
start_time|end_time|DATE|SOURCE
1849|1873|01/01/1858|NOAA/USGS
1849|1873|01/01/1857|NOAA/USGS
1849|1873|01/01/1852|NOAA/USGS
1849|1873|01/01/1852|NOAA/USGS
\&...
1849|1873|01/01/1860|NOAA/USGS
1849|1873|01/01/1860|NOAA/USGS
1849|1873|01/01/1873|Coastal Carolina University
1849|1873|01/01/1873|Coastal Carolina University
1849|1873|01/01/1873|Coastal Carolina University
\fR
.fi
.SH SEE ALSO
\fI
t.create,
t.info
\fR
.SH AUTHOR
Sören Gebbert, Thünen Institute of Climate\-Smart Agriculture
.SH SOURCE CODE
.PP
Available at: t.vect.db.select source code (history)
.PP
Main index |
Temporal index |
Topics index |
Keywords index |
Graphical index |
Full index
.PP
© 2003\-2020
GRASS Development Team,
GRASS GIS 7.8.5 Reference Manual