.TH v.db.univar 1grass "" "GRASS 6.4.4" "Grass User's Manual" .SH NAME \fI\fBv.db.univar\fR\fR - Calculates univariate statistics on selected table column for a GRASS vector map. .SH KEYWORDS vector, statistics .SH SYNOPSIS \fBv.db.univar\fR .br \fBv.db.univar help\fR .br \fBv.db.univar\fR [\-\fBe\fR] \fBtable\fR=\fIstring\fR \fBcolumn\fR=\fIstring\fR [\fBdatabase\fR=\fIstring\fR] [\fBdriver\fR=\fIstring\fR] [\fBwhere\fR=\fIstring\fR] [\-\-\fBverbose\fR] [\-\-\fBquiet\fR] .SS Flags: .IP "\fB\-e\fR" 4m .br Extended statistics (quartiles and 90th percentile) .IP "\fB\-\-verbose\fR" 4m .br Verbose module output .IP "\fB\-\-quiet\fR" 4m .br Quiet module output .PP .SS Parameters: .IP "\fBtable\fR=\fIstring\fR" 4m .br Name of data table .IP "\fBcolumn\fR=\fIstring\fR" 4m .br Column on which to calculate statistics (must be numeric) .IP "\fBdatabase\fR=\fIstring\fR" 4m .br Database/directory for table .IP "\fBdriver\fR=\fIstring\fR" 4m .br Database driver .IP "\fBwhere\fR=\fIstring\fR" 4m .br WHERE conditions of SQL statement without 'where' keyword .PP .SH DESCRIPTION \fIv.db.univar\fR calculates basic univariate statistics for numeric attributes in a data table. It will calculate minimum, maximum, range, mean, standard deviation, variance, coefficient of variation, quartiles, median, and 90th percentile. It uses \fIdb.select\fR to create list values for statistical calculations. \fINOTES\fR If the database and driver are not specified, the default values set in \fIdb.connect\fR will be used. .SH EXAMPLE In this example, random points are sampled from the elevation map (North Carolina sample dataset) and univariate statistics performed: \fC .DS .br g.region rast=elevation \-p .br v.random output=samples n=100 .br v.db.addtable samples column="heights double precision" .br v.what.rast samples raster=elevation colum=heights .br v.db.select samples .br .br v.db.univar samples colum=heights .br .DE \fR .SH SEE ALSO \fI r.univar, v.univar,, db.select, d.vect.thematic \fR .SH AUTHOR Michael Barton, Arizona State University .PP and authors of \fIr.univar.sh\fR .PP \fILast changed: $Date: 2011-09-04 15:23:30 +0200 (Sun, 04 Sep 2011) $\fR .PP Full index .PP © 2003-2014 GRASS Development Team