1db.univar(1)                  Grass User's Manual                 db.univar(1)
2
3
4

NAME

6       db.univar  - Calculates univariate statistics on selected table column.
7

KEYWORDS

9       database, statistics, attribute table
10

SYNOPSIS

12       db.univar
13       db.univar --help
14       db.univar [-eg] table=name column=name  [database=name]   [driver=name]
15       [where=sql_query]   [percentile=float[,float,...]]   [--help]   [--ver‐
16       bose]  [--quiet]  [--ui]
17
18   Flags:
19       -e
20           Extended statistics (quartiles and 90th percentile)
21
22       -g
23           Print stats in shell script style
24
25       --help
26           Print usage summary
27
28       --verbose
29           Verbose module output
30
31       --quiet
32           Quiet module output
33
34       --ui
35           Force launching GUI dialog
36
37   Parameters:
38       table=name [required]
39           Name of attribute table
40
41       column=name [required]
42           Name  of attribute column on which to calculate statistics (must be
43           numeric)
44
45       database=name
46           Name of database
47
48       driver=name
49           Name of database driver
50           Options: dbf, odbc, ogr, sqlite, pg
51
52       where=sql_query
53           WHERE conditions of SQL statement without ’where’ keyword
54           Example: income < 1000 and population >= 10000
55
56       percentile=float[,float,...]
57           Percentile to calculate (requires extended statistics flag)
58           Options: 0-100
59           Default: 90
60

DESCRIPTION

62       db.univar calculates basic univariate statistics for numeric attributes
63       in a data table. It will calculate minimum, maximum, range, mean, stan‐
64       dard deviation, variance, coefficient of variation, quartiles,  median,
65       and  90th percentile.  It uses db.select to create list values for sta‐
66       tistical calculations.  NOTES If the database and driver are not speci‐
67       fied, the default values set in db.connect will be used.
68

EXAMPLE

70       In  this  example,  random  points  are  sampled from the elevation map
71       (North Carolina sample dataset) and univariate statistics performed:
72       g.region raster=elevation -p
73       v.random output=samples n=100
74       v.db.addtable samples column="heights double precision"
75       v.what.rast samples raster=elevation column=heights
76       v.db.select samples
77       db.univar samples column=heights
78

SEE ALSO

80        v.db.univar, r.univar, v.univar, db.select, d.vect.thematic
81

AUTHOR

83       Michael Barton, Arizona State University
84
85       and authors of r.univar.sh
86
87       Last changed: $Date: 2016-11-14 00:05:32 +0100 (Mon, 14 Nov 2016) $
88

SOURCE CODE

90       Available at: db.univar source code (history)
91
92       Main index | Database index | Topics index | Keywords index | Graphical
93       index | Full index
94
95       © 2003-2019 GRASS Development Team, GRASS GIS 7.6.0 Reference Manual
96
97
98
99GRASS 7.6.0                                                       db.univar(1)
Impressum