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 |