Map and Table Calculation

AGGPRD( ) or ColumnAggregatePrd() function

Returns the predominant value of an entire column, predominant values per group, the weighted predominant value of an entire column, or weighted predominant values per group.

Syntax

AGGPRD(Column)
AGGPRD(Column, Group)
AGGPRD(Column, , Weight)
AGGPRD(Column, Group, Weight)
ColumnAggregatePrd(Column)
ColumnAggregatePrd(Column, Group)
ColumnAggregatePrd(Column, , Weight)
ColumnAggregatePrd(Column, Group, Weight)

Input

Column is a column
Domain type: any domain
Group is the 'group by' column
Domain type: any Class, ID, Group or Bool domain
Weight is the weight column
Domain type: any Value domain

Output

AGGPRD(Column) or ColumnAggregatePrd(Column)

returns:

the predominant value of a column

Domain:

the domain of the input column

 

AGGPRD(Column, Group) or ColumnAggregatePrd(Column, Group)

returns:

predominant values per group

Domain:

the domain of the input column

 

AGGPRD(Column, , Weight) or ColumnAggregatePrd(Column, , Weight)

returns:

weighted predominant value

Domain:

the domain of the input column

 

AGGPRD(Column, Group, Weight) or ColumnAggregatePrd(Column, Group, Weight)

returns:

weighted predominant values per group

Domain:

the domain of the input column

Notes:

Tip:

When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

TabCalc

Examples

TabCalc example:

OutCol1 = AGGPRD(Area)

OutCol2 = AGGPRD(Area,Landuse)

OutCol3 = AGGPRD(Area,,Weights)

OutCol4 = AGGPRD(Area,Landuse,Weights)

 

Parcel

Landuse

Area

Weights

OutCol1

OutCol2

OutCol3

OutCol4

00123

Residential

4000

2

3500

3500

17500

4000

00124

Residential

3500

1

3500

3500

17500

4000

00125

Commercial

17500

4

3500

17500

17500

17500

00126

Residential

7500

1

3500

3500

17500

4000

00127

Industrial

20000

?

3500

20000

17500

?

01272

Institutional

12500

2

3500

12500

17500

12500

04625

Residential

5000

1

3500

3500

17500

4000

 

See also: