1. Datagration Knowledge Base
2. P#
3. Neighborhood Functions

AggregateGrid

Use 1 - Returns the aggregated value according to specified aggregation type, for the same cell with the current entity.

Aggregation types:

1. Min

2. Max

3. Sum

4. Average

5. Inverse Distance Average

Syntax

AggregateGrid(grid name, aggregation)
• grid name: name of grid
• aggregation: type of aggregation

Example

AggregateDGrid("Grid 113", "Average")

By default the functions uses the PetroVisor signals "surface x-coordinate", "surface y-coordinate" and coordinates unit"m", alternatively the functions allows 3 more arguments different PetroVisor/unit to be used as coordinates.

Example

AggregateGrid("Grid 113", "Average","m","alternative x-coordinate", "alternative y-coordinate")

Use 2 - Returns the aggregated value according to specified aggregation type, for the same cell with the current entity.

Aggregation types:

1. Min

2. Max

3. Sum

4. Average

5. Inverse Distance Average

Syntax

AggregateGrid(grid name, aggregation, coordinate unit name, coordinate x name, coordinate y name)
• grid name: name of grid
• aggregation: type of aggregation
• Coordinate unit name: Name of coordinate
• Coordinate x name: name of x coordinate signal
• Coordinate y name: name of y coordinate signal

Example

AggregateDGrid("Grid 113", "Average", "m", "alternative x - coordinate", "alternative y - coordinate"))

Use 3 - Returns the aggregated value according to the specified aggregation type, for the entities which are located in sector defined from current entity.

Aggregation types:

1. Min

2. Max

3. Sum

4. Average

5. First

6. Last

7. Count

Uses PetroVisor signals "surface x-coordinate", "surface y-coordinate" and unit "m" for coordinates.

Syntax

AggregateGrid(grid name, aggregation, radius, start angle, end angle)
• grid name: name of grid
• aggregation: type of aggregation
• start angle: sector start angle
• end angle: sector end angle

Example

AggregateGrid("Grid 113", "Average",1000, 315, 45)

By default the functions uses the PetroVisor signals "surface x-coordinate", "surface y-coordinate" and coordinates unit"m", alternatively the functions allows 3 more arguments different PetroVisor/unit to be used as coordinates.

Example

AggregateGrid("Grid 113", "Average","m","alternative x-coordinate", "alternative y-coordinate")

Use 4 - Returns the aggregated value according to specified aggregation type, for the entities which are located in sector defined from current entity.

Aggregation types:

1. Min

2. Max

3. Sum

4. Average

5. First

6. Last

7. Count

Uses PetroVisor signals "surface x-coordinate", "surface y-coordinate" and unit "m" for coordinates.

Syntax

AggregateGrid(grid name, aggregation, radius, start angle, end angle, coordinate unit name, coordinate x name, coordinate y name)
• grid name: name of grid
• aggregation: type of aggregation
• start angle: sector start angle
• end angle: sector end angle
• Coordinate unit name: Name of coordinate
• Coordinate x name: name of x coordinate signal
• Coordinate y name: name of y coordinate signal

Example

AggregateGrid("Grid 113", "Average",1000, 315, 45, "m", "alternative x-coordinate", "alternative y-coordinate"))

By default the functions uses the PetroVisor signals "surface x-coordinate", "surface y-coordinate" and coordinates unit"m", alternatively the functions allows 3 more arguments different PetroVisor/unit to be used as coordinates.