t.vect.db.select(1grass)

💅 t.vect.db.select — okay so here's the tea

bestie. if you've got a space time vector dataset (yes, the fancy temporal kind) and you just wanna see the attributes of the vector maps living inside it, this is the little icon you've been looking for. no cap.

Manual name (iykyk): t.vect.db.select(1grass) — she's a GRASS User's Manual girlie.

✨ KEYWORDS ✨

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

---

🌸 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 so you're not out here guessing 💖
• --verbose — verbose module output, aka she tells you everything 🗣️
• --quiet — quiet module output, aka she says nothing, main character silence 🫶
• --ui — force launches the GUI dialog, for the visual learners ✨

🦋 Parameters

• input=name [required, bestie, you must feed her this] — name of the input space time vector dataset
• columns=name[,name,...] — the name of the attribute column(s) you want
• separator=character — the field separator character that sits 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 have category values in different layers, and this number decides which layer gets used. When it's used with direct OGR access, this is the layer name. Default: 1
• where=sql_query — WHERE conditions of an SQL statement, without the 'where' keyword. 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. Example: start_time > '2001-01-01 12:30:00'

---

💖 DESCRIPTION 💖

So literally, the module t.vect.db.select prints attributes of vector maps registered in a space time vector dataset. that's it. that's the whole vibe. she looks inside the temporal dataset and hands you the attribute table. periodt. 👑

---

🌈 EXAMPLE 🌈

okay so the example here is querying the shoreline space time dataset. watch this:

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

ate. 🍓

and then, in the following example, she prints only the DATE and SOURCE columns, for data before 1900-01-01. narrowing it down, we love a filtered queen:

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

---

👀 SEE ALSO 👀

t.create, t.info

👑 AUTHOR 👑

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

💾 SOURCE CODE 💾

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

Latest change: Friday Feb 07 19:16:09 2025 in commit: a82a39f673b97fafcfce1604dc3e6015cb96487a

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

---

© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual

and that's the whole page bestie 💜 go forth and select your attributes, you absolute legend. this was GRASS 8.5.0, t.vect.db.select(1grass) — slay, no cap, bye 🧚✨