Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
t.vect.db.select(1)	    GRASS GIS User's Manual	   t.vect.db.select(1)

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

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,...]]     [separa-
       tor=character]		  [layer=string]	     [where=sql_query]
       [t_where=sql_query]   [--help]  [--verbose]  [--quiet]  [--ui]

   Flags:
       --help
	   Print usage summary

       --verbose
	   Verbose module output

       --quiet
	   Quiet module	output

       --ui
	   Force launching GUI dialog

   Parameters:
       input=nameA [required]
	   Name	of the input space time	vector dataset

       columns=name[,name,...]
	   Name	of attribute column(s)

       separator=character
	   Field separator character between the output	columns
	   Special characters: pipe, comma, space, tab,	newline
	   Default: pipe

       layer=string
	   Layer number	or name
	   Vector features can have category values in different layers.  This
	   number determines which layer to use. When used with	direct OGR ac-
	   cess	this is	the layer name.
	   Default: 1

       where=sql_query
	   WHERE conditions of SQL statement without 'where' keyword
	   Example: income < 1000 and population >= 10000

       t_where=sql_query
	   WHERE conditions of SQL statement without 'where' keyword  used  in
	   the temporal	GIS framework
	   Example: start_time > '2001-01-01 12:30:00'

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

EXAMPLE
       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

SEE ALSO
	t.create, t.info

AUTHOR
       SA<paragraph>ren	Gebbert, ThA1/4nen Institute of	Climate-Smart Agricul-
       ture

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

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

       A(C) 2003-2020 GRASS Development	Team, GRASS GIS	7.8.4 Reference	Manual

GRASS 7.8.4						   t.vect.db.select(1)

NAME | KEYWORDS | SYNOPSIS | DESCRIPTION | EXAMPLE | SEE ALSO | AUTHOR | SOURCE CODE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=t.vect.db.select&sektion=1&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help