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_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_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 (vertices) 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
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