Index of Functions

The following functions are supported.

Function Description
Abs Calculates the absolute value.
Acos Calculates the arccosine.
Ascii Returns the character code for the first character in a string.
Asin Calculates the arcsine.
Atan Calculates the arctangent.
Avg Computes the average value of an aggregation of values.
Ceil Ceiling - Always returns the smallest integer value not less than the argument.
Char Returns a string of length 1 corresponding to a specified character code.
Char_Length Returns the number of characters in the string argument.
Cos Calculates the cosine.
Count Counts the number of values in an aggregation of values.
Current_Date Returns the current date.
Current_DateTime Returns the current date time.
Current_Time Returns the current time.
DateTimeToString Converts a DateTime into a string.
DateToNumber Converts a Date into a number.
DateToString Converts a Date into a string.
Day Returns the day of the month as an integer.
Exp Returns the value of the base of natural logarithms raised to the power of the argument.
Floor Always returns the highest integer value that is not greater than the argument.
FromGeoJSON Converts a string formatted in GeoJSON to a Spatial Feature geometry.
FromKML Converts a string formatted in KML to a feature geometry.
FromWKB Converts a WKB BLOB value to a feature geometry.
FromWKT Converts a string formatted in WKT to a feature geometry.
GetDate Returns the Date component of a DateTime.
GetTime Returns the Time component of a DateTime.
Hour Accepts a Time and returns the hour portion as an integer (0-23).
InStr Searches one character string for another character string.
Left Returns a specified number of leftmost characters from a string.
Log Calculates the natural logarithm.
Lower Converts a string to lower case.
Ltrim Removes leading space characters from a string and returns the resulting string.
Majority Works on an attribute and returns the value that is greater than 50% of the rows in that attribute.
MakeDateTime Create a new DateTime value from a given date and time.
Max Computes the maximum value of an aggregation of values.
Median Returns the median of all the values in the specified attribute.
MI_AggregateBuffer Returns a MultiPolygon geometry object which represents a buffered distance around the aggregated geometry objects.
MI_AggregateCentroid Returns the centroid of the minimum bounding rectangle (MBR) of an aggregated set of geometry objects.
MI_AggregateConvexHull Returns a MultiPolygon geometry object which represents a convex hull around the set of points contained within an aggregated set of geometry objects.
MI_AggregateEnvelope Returns an Envelope geometry object representing the minimum bounding rectangle (MBR) of an aggregated set of geometry object.
MI_AggregateIndividual Returns any individual value from the aggregation of values.
MI_AggregateIntersection Returns a geometry object which represents the intersection of an aggregated set of geometry object.
MI_AggregateUnion Returns a geometry object which represents the union of an aggregated set of geometry objects.
MI_Area Returns the geographical area of a geometry object.
MI_Box Creates a new Feature Geometry object which represents a rectangular box.
MI_Buffer Returns a MultiPolygon geometry object which represents a buffered distance around another geometry object.
MI_Centroid Returns the centroid of a geometry object as a Point geometry object.
MI_CentroidDistance Returns the geographic distance between the centroids of two geometry objects.
MI_CentroidWithin Determines if the centroid of a geometry object lies within another geometry object.
MI_CentroidX Returns the x-coordinate of the centroid of a geometry object.
MI_CentroidY Returns the y-coordinate of the centroid of a geometry object.
MI_Contains Determines if one geometry object entirely contains another geometry object.
MI_ContainsCentroid Determines if the centroid of a geometry object lies within another geometry object.
MI_ConvexHull Returns a MultiPolygon geometry object which represents a convex hull around the set of points contained in the input geometry.
MI_Difference Calculates the difference between two geometries.
MI_Distance Returns the geographic distance between two geometry objects.
MI_DistanceToEdge Returns the distance between two geometries using the computation type and distance units.
MI_EngineVersion Indicates the version of the engine.
MI_Envelope Returns an Envelope geometry object representing the minimum bounding rectangle (MBR) of the input geometry.
MI_EnvelopesIntersect Determines if the minimum bounding rectangles (MBR) of two geometry objects intersect.
MI_GeoHash Returns a geohash index for given geometry at a given precision.
MI_GeometryType Returns a string indicating the type of a geometry object.
MI_GridRegionStats Returns the aggregated statistics from a raster within a region object. This function also applies to an MRR file and continuous field types with numeric bands.
MI_GridLineProfile Returns the cell values from a raster along a series of points specified by the line or polyline object. This function also applies to an MRR file and continuous field types with numeric bands.
MI_GridLineStats Returns the cell values from a raster along a polyline or line object. This function also applies to an MRR file and continuous field types with numeric bands.
MI_GridMinValue Returns the minimum value for specified field and band in MRR. If field and band are not specified, it considers the default field and band that is used for MRR rendering. If the MRR contains only the continuous field, the return type is double. If the MRR contains fields other than the continuous one, the return type is a string. This function supports all field and band types in multi-field multi-band MRR.
MI_GridMaxValue Returns the maximum for specified field and band in MRR. If field and band are not specified, it considers the default field and band that is used for MRR rendering. If the MRR contains only the continuous field, the return type is double. If the MRR contains fields other than the continuous one, the return type is a string. This function supports all field and band types in multi-field multi-band MRR.
MI_GridValueAt Returns the value of a Grid at the specified point location.
MI_GridValueAtPixel Returns the value of a Grid at the specified pixel location (x, y).
MI_ImageFile Returns the filename from an ImageInfo (Raster or Grid) as a string.
MI_ImagePixelHeight Returns the height of a raster or grid image in pixels as an integer.
MI_ImagePixelWidth Returns the width of a raster or grid image in pixels as an integer.
MI_Intersection Returns a geometry object which represents the intersection between two input geometry objects.
MI_Intersects Determines if one geometry object intersects another geometry object.
MI_Length Returns the geographic length of a line or polyline geometry object.
MI_Line Creates a new Feature Geometry object which represents a line.
MI_MaxX Returns the maximum x value of the MBR of a geometry.
MI_MaxY Returns the maximum y value of the MBR of a geometry.
MI_MinX Returns the minimum x value of the MBR of a geometry.
MI_MinY Returns the minimum y value of the MBR of a geometry.
Min Computes the minimum value of an aggregation of values.
Minute Accepts a Time and returns the minute portion an integer (0-59).
MI_Perimeter Returns the geographic perimeter of a geometry object.
MI_Point Creates a new Feature Geometry object representing a point.
MI_Polygon Creates a new Feature Geometry object which represents a polygon.
MI_Transform Transforms a geometry from one coordinate system to another.
MI_Union Returns a geometry object which represents the union of two input geometry objects.
MI_Within Determines if one geometry object is entirely within another geometry object.
MI_X Returns the x coordinate of a Point geometry.
MI_Y Returns the y coordinate of a Point geometry.
MI_NumGeometries Returns the number of geometries in a MultiGeometry.
MI_NumPoints Returns the number of points (vertice s) in a geometry.
MI_GeometryN Returns the nth geometry in a MultiGeometry.
MI_PointN Returns a point that is the nth vertex in the geometry.
MI_SQLVersion Indicates the version of the SQL language the engine currently supports.
MI_EngineVersion Indicates the version of the engine.
MI_User Indicates the name of the currently logged-in user. It returns the username as a String.
MI_Roles Indicates the roles of the currently logged-in user. It returns all roles as a String, separated by a comma.
Mod Divides one numeric expression by another numeric expression and returns the remainder.
Mode Computes the mode value of an aggregation of values.
Month Returns the month portion of a date as an integer.
NumberToDate Creates a Date from a number.
NumberToString Converts a number into a string.
NumberToTime Creates a Time from a number.
ProportionAvg Computes the average of an aggregation of values which are adjusted based. on the proportion of two geometry objects.
ProportionSum Computes the sum of an aggregation of values which are adjusted based on the proportion of two geometry objects.
ProportionWtAvg Computes the weighted average of an aggregation of values which are adjusted based on the proportion of two geometry objects.
Right Returns a specified number of rightmost characters from a string.
Round Rounds a value to the nearest multiple of another value.
Rtrim Removes trailing space characters from a string and returns the resulting string.
Same Returns the value that is the same in all the records in the specified attribute.
Second Accepts a Time and returns the second portion a double (0-59.999).
Sign Returns the sign of the argument.
Sin Calculates the sine.
Space Returns a string consisting of a specified number of space characters.
Sqrt Calculates the square root.
StdDev Calculates the standard deviation of an aggregation of values.
StringByteLength Returns the number of bytes in a string for a given charset.
StringToDate Creates a Date from a character string.
StringToDateTime Creates a DateTime value from a character string.
StringToNumber Converts a string into a number.
StringToTime Converts a string into a time.
Substring Extracts a portion of a string to form a new string.
Sum Computes the sum of an aggregation of values.
Tan Calculates the tangent.
TimeToNumber Converts a time into a number.
TimeToString Converts a time into a string.
ToGeoJSON Converts a Spatial Geometry to its GeoJSON equivalent.
ToKML Converts a geometry to its KML equivalent.
ToWKB Converts a feature geometry to its WKB equivalent.
ToWKT Converts a feature geometry to its WKT equivalent.
Trim Removes leading and trailing space characters from a string and returns the resulting string.
Trunc Truncates the argument to the number of decimal places.
Upper Converts a string to upper case.
Weekday Returns an integer from 1 to 7, indicating the weekday of the specified date.
WtAvg Computes the weighted average value of an aggregation of values and weights.
Year Returns the year portion of a date as an integer.