MI_GridValueAt

Description

Returns the value of a Grid at the specified point location.

If the Grid file type is numeric, as is the case for continuous grids (.GRD), the return type is a double.

If the Grid file type is character-based, as in the case of classified grids (.GRC), the return type will be a string.

This function also applies to MRR file and all field types are supported.

Syntax

MI_GridValueAt ( GridInfo, Point, field, band)

Arguments

GridInfo is an expression which returns a GridInfo, where GridInfo is the name of the raster column in the table, by default it is MI_RASTER.

Point is an expression which returns a point geometry representing the X and Y coordinate. See MI_Point for more information.

field specifies the field index. It is an optional parameter.

band specifies the band index of the field selected. It is required only if the field parameter is specified.

Example

Determines the grid value of the MI_RASTER column at the specified point geometry from the table named GRIDTABLE.

select MI_GridValueAt("MI_RASTER", MI_POINT(-107.7, 37.9, 'EPSG:4326'), 1, 0) from "/GRIDTABLE"

Remarks

Raster tables expose a RasterInfo and grid tables expose a GridInfo as the value for the MI_Raster column. This function applies to grid images (.GRD, .GRC, and .MRR).