1t.vect.db.select(1)         GRASS GIS User's Manual        t.vect.db.select(1)
2
3
4

NAME

6       t.vect.db.select   -  Prints  attributes of vector maps registered in a
7       space time vector dataset.
8

KEYWORDS

10       temporal, attribute table, vector, database, select, time
11

SYNOPSIS

13       t.vect.db.select
14       t.vect.db.select --help
15       t.vect.db.select   input=name    [columns=name[,name,...]]     [separa‐
16       tor=character]             [layer=string]             [where=sql_query]
17       [t_where=sql_query]   [--help]  [--verbose]  [--quiet]  [--ui]
18
19   Flags:
20       --help
21           Print usage summary
22
23       --verbose
24           Verbose module output
25
26       --quiet
27           Quiet module output
28
29       --ui
30           Force launching GUI dialog
31
32   Parameters:
33       input=name [required]
34           Name of the input space time vector dataset
35
36       columns=name[,name,...]
37           Name of attribute column(s)
38
39       separator=character
40           Field separator character between the output columns
41           Special characters: pipe, comma, space, tab, newline
42           Default: pipe
43
44       layer=string
45           Layer number or name
46           Vector features can have category values in different layers.  This
47           number determines which layer to use. When used with direct OGR ac‐
48           cess this is the layer name.
49           Default: 1
50
51       where=sql_query
52           WHERE conditions of SQL statement without ’where’ keyword
53           Example: income < 1000 and population >= 10000
54
55       t_where=sql_query
56           WHERE conditions of SQL statement without ’where’ keyword  used  in
57           the temporal GIS framework
58           Example: start_time > ’2001-01-01 12:30:00’
59

DESCRIPTION

61       The module t.vect.db.select prints attributes of vector maps registered
62       in a space time vector dataset.
63

EXAMPLE

65       The example is querying the shoreline space time dataset:
66       t.vect.db.select input=shoreline
67       start_time|end_time|cat|DESCR|SOURCE|DATE
68       1849|1873|1|T-736|NOAA/USGS|01/01/1858
69       1849|1873|2|T-657|NOAA/USGS|01/01/1857
70       1849|1873|3|T-381(2)|NOAA/USGS|01/01/1852
71       1849|1873|4|T-381(1)|NOAA/USGS|01/01/1852
72       1849|1873|5|T-381(1)|NOAA/USGS|01/01/1852
73       ...
74       2009||44|2009 USDA NAIP|2009-07-11|VA, SAND, Wet / Dry
75       2009||45|2009 USDA NAIP|2009-07-11|Carolina Beach, SAND, Wet / Dry
76       2009||46|2009 USDA NAIP|2009-07-11|Carolina Beach, REVETMENT-ROCK, Hard Structure
77       2009||47|2009 USDA NAIP|2009-07-11|Fort Fisher, REVETMENT-ROCK, Hard Structure
78       In the following example it print only DATE and SOURCE columns for data
79       before 1900-01-01.
80       t.vect.db.select input=shoreline column=DATE,SOURCE t_where="start_time < 1900"
81       start_time|end_time|DATE|SOURCE
82       1849|1873|01/01/1858|NOAA/USGS
83       1849|1873|01/01/1857|NOAA/USGS
84       1849|1873|01/01/1852|NOAA/USGS
85       1849|1873|01/01/1852|NOAA/USGS
86       ...
87       1849|1873|01/01/1860|NOAA/USGS
88       1849|1873|01/01/1860|NOAA/USGS
89       1849|1873|01/01/1873|Coastal Carolina University
90       1849|1873|01/01/1873|Coastal Carolina University
91       1849|1873|01/01/1873|Coastal Carolina University
92

SEE ALSO

94        t.create, t.info
95

AUTHOR

97       Sören Gebbert, Thünen Institute of Climate-Smart Agriculture
98

SOURCE CODE

100       Available at: t.vect.db.select source code (history)
101
102       Accessed: Saturday Jan 21 20:41:06 2023
103
104       Main index | Temporal index | Topics index | Keywords index | Graphical
105       index | Full index
106
107       © 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
108
109
110
111GRASS 8.2.1                                                t.vect.db.select(1)