t.vect.db.select(1)

💖 t.vect.db.select — the GRASS GIS user's manual, but make it make sense 💖

okay bestie, welcome to t.vect.db.select(1), straight outta the GRASS GIS User's Manual. this one's a lil temporal queen. let's go 🦋

---

✨ NAME ✨

t.vect.db.select — prints the attributes of vector maps that are registered inside a space time vector dataset. yes. that's the whole job. she's focused, she's employed, she slays 💅

---

🎀 KEYWORDS 🎀

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

(iykyk — if u were searching for those words, you found her 🌸)

---

🌈 SYNOPSIS 🌈

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]

🫶 Flags:

• --help — prints the usage summary. the "what do i even type" button.
• --verbose — verbose module output. she talks more.
• --quiet — quiet module output. she talks less.
• --ui — forces the GUI dialog to launch. clicking instead of typing, valid and iconic.

🍓 Parameters:

• input=name [required] — the name of the input space time vector dataset. yes it's required, no you cannot skip her, she's the main character of this command 👑
• columns=name[,name,...] — the name(s) of the attribute column(s) you want.
• separator=character — the field separator character that goes between your output columns.
  • Special characters you can use: pipe, comma, space, tab, newline.
  • Default: pipe
• layer=string — layer number or name.
  • Vector features can hold category values in different layers, so this number decides which layer gets used. When you're rolling with direct OGR access, this is the layer name instead.
  • Default: 1
• where=sql_query — WHERE conditions of an SQL statement, and you do not type the word 'where' yourself, she handles that.
  • Example: income < 1000 and population >= 10000
• t_where=sql_query — WHERE conditions of an SQL statement without the 'where' keyword, but this one is used in the temporal GIS framework specifically.
  • Example: start_time > '2001-01-01 12:30:00'

---

💜 DESCRIPTION 💜

So. The module t.vect.db.select prints attributes of vector maps that are registered in a space time vector dataset. That's it, that's her whole personality, and honestly? she ate. 🔥

---

🌟 EXAMPLE 🌟

This first 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 next example she prints only the DATE and SOURCE columns, for data from 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

look at that output. filtered, formatted, pristine. no cap 💅✨

---

🌸 SEE ALSO 🌸

• t.create
• t.info

go say hi to her friends, they're all in the temporal family 🧚

---

👑 AUTHOR 👑

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

---

⭐ SOURCE CODE ⭐

Available at: t.vect.db.select source code (history)

Accessed: Saturday Jan 17 05:41:54 2026

Main index | Temporal index | Topics index | Keywords index | Graphical index | Full index

---

© 2003-2025 GRASS Development Team, GRASS GIS 8.4.2 Reference Manual

and that's the whole page bestie!! this was t.vect.db.select(1) from GRASS 8.4.2, accessed Saturday Jan 17 05:41:54 2026, brought to you by the GRASS Development Team (© 2003-2025) 💖 go query something temporal, you deserve it 🦋✨