t.vect.db.select(1grass) | GRASS GIS User's Manual | t.vect.db.select(1grass) |
t.vect.db.select - Prints attributes of vector maps registered in a space time vector dataset.
temporal, attribute table, vector, database, select, time
t.vect.db.select
t.vect.db.select --help
t.vect.db.select input=name
[columns=name[,name,...]]
[separator=character] [layer=string]
[where=sql_query] [t_where=sql_query]
[--help] [--verbose] [--quiet] [--ui]
The module t.vect.db.select prints attributes of vector maps registered in a space time vector dataset.
The example is querying the shoreline space time dataset:
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
In the following example it print only DATE and SOURCE columns for
data before 1900-01-01.
t.vect.db.select input=shoreline column=DATE,SOURCE t_where="start_time < 1900" 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
t.create, t.info
Sören Gebbert, Thünen Institute of Climate-Smart Agriculture
Available at: t.vect.db.select source code (history)
Accessed: Sunday Jan 22 07:37:46 2023
Main index | Temporal index | Topics index | Keywords index | Graphical index | Full index
© 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
GRASS 8.2.1 |