All Functions This page contains a comprehensive list of all available functions organized by category. Each function links to its detailed documentation page with syntax, examples, and test cases.
Function Categories
Function Description ENTITY() Returns a reference to an entity. INPUT() Returns a reference to an input.
Function Description BIND_VALUE() Binds the given value to the given feature. BIND_VALUES() Binds the given array of values to the given feature or features. BIND_COLUMNS() Binds columns from a table to the given features.
Function Description RELATED() Joins a feature or an aggregation using a key as base UNNEST() Unnests an array of rows into a table of rows
Function Description CAST() Returns the given expression casted to the given type, or raise an exception if the conversion... UNSAFE_CAST() Returns the given expression casted to the given type, allowing to change or remove entity type TRY_CAST() Returns the given expression casted to the given type, or NULL if the cast fails. NULL() Returns a NULL value of the given type. EMPTY() Returns an EMPTY filling for empty parameters in functions.
Function Description VARIANT() Returns a reference to a variant of the given feature with the given replacements in its... MACRO() Returns a reference to a macro of the given feature with the given inputs. UDF() Returns a reference to a UDF (user-defined function).
Function Description NULLIF() Returns NULL when two values compare equal; otherwise returns the first value IF() Returns one value if a condition is true, another if false CASE WHEN Returns the result of the first condition that evaluates to true CASE WHEN VALUE Returns the result corresponding to the first matching value in a simple case expression COALESCE(...) Returns the first non-NULL value from a list of values
Function Description AND Returns TRUE when both boolean operands are TRUE. OR Returns TRUE when at least one boolean operand is TRUE. NOT Returns FALSE if the operand is TRUE, TRUE if it is FALSE.
Function Description = [equals] Returns TRUE if the first value equals the second value != [not] Returns TRUE if the first value does not equal the second value IS NULL Returns TRUE if the expression evaluates to NULL. IS NOT NULL Returns TRUE if the expression does NOT evaluate to NULL. DISPLAYS AS Returns TRUE if two values are not distinct, treating NULL values as comparable. IS NOT DISTINCT FROM Returns TRUE if two values are not distinct, treating NULL values as comparable (SQL-standard... NOT DISPLAYS AS Returns TRUE if two values are distinct, treating NULL values as comparable. IS DISTINCT FROM Returns TRUE if two values are distinct, treating NULL values as comparable (SQL-standard spelling).
Function Description < [less] Returns TRUE if the first value is strictly less than the second value <= [less] Returns TRUE if the first value is less than or equal to the second value > [greater] Returns TRUE if the first value is strictly greater than the second value >= [greater] Returns TRUE if the first value is greater than or equal to the second value BETWEEN Returns TRUE if a value is within a specified range (inclusive) NOT BETWEEN Returns TRUE if a value is NOT within a specified range (inclusive). LEAST(...) Returns the least (minimum) value from a list of arguments. GREATEST(...) Returns the greatest (maximum) value from a list of arguments.
Function Description LIKE Returns TRUE if a string matches a specified pattern with wildcards. NOT LIKE Returns TRUE if a string does NOT match a specified pattern with wildcards. LIKE multiple Case-sensitive or case-insensitive pattern matching: LIKE / ILIKE with ANY, ALL, or NONE...
Function Description IN Returns TRUE if a value exists in a list of values. NOT IN Returns TRUE if a value does NOT exist in a list of values.
Function Description + [addition] Adds two numeric values, or adds an interval to a date or timestamp. UNARY_MINUS() Negates a numeric expression (unary minus). UNARY_PLUS() Explicit unary plus on an expression (no-op on the value). - [subtraction] Subtracts the right-hand value from the left-hand value (numeric, temporal, or interval forms). FACTORIAL() Returns the factorial of a non-negative integer (n!). CLAMP() Constrains a value to a closed interval: the result is the value limited to lie between low and... * [multiplication] Returns the product of two numbers, or scales an interval by an integer factor. / [division] Divides the left-hand number by the right-hand number, producing a DOUBLE result. TRY_DIVIDE() Same as DIVIDE, but returns NULL if the divisor is zero. // [integer] Divides the left-hand number by the right-hand number while preserving the dividend's type (integer... TRY_DIVIDE_TYPE() Same as DIVIDE_TYPE, but returns NULL if the divisor is zero. % [remainder] Returns the remainder after dividing the left-hand number by the right-hand number.
Function Description ROUND() Rounds a number to the nearest integer or to a specified number of decimal places. TRUNCATE() Returns the integer part of a number by discarding the fractional part. FLOOR() Returns the largest integer less than or equal to the input. CEIL() Returns the smallest integer greater than or equal to the input.
Function Description ABS() Returns the absolute value of a number. SIGN() Returns the sign of a number: -1 for negative, 0 for zero, 1 for positive.
Function Description ^ [exponentiation] Raises a number to a power (integer or floating-point operands of the same type). SQRT() Returns the square root of a number. CBRT() Returns the cube root of a number. EXP() Returns e raised to the power of the given number. LN() Returns the natural logarithm (base e) of a number. LOG() Returns the logarithm of a number to a specified base.
Function Description COS() Returns the cosine of an angle in radians. SIN() Returns the sine of an angle in radians. TAN() Returns the tangent of an angle in radians. ACOS() Returns the arccosine (inverse cosine) of a number, in radians. ASIN() Returns the arcsine (inverse sine) of a number, in radians. ATAN() Returns the arctangent (inverse tangent) of a number, in radians. ATAN2() Returns the arctangent of y/x, using the signs of both arguments to determine the quadrant.
Function Description COSH() Returns the hyperbolic cosine of a number. SINH() Returns the hyperbolic sine of a number. TANH() Returns the hyperbolic tangent of a number.
Function Description DEGREES() Converts an angle from radians to degrees. RADIANS() Converts an angle from degrees to radians.
Function Description FROM_BASE() Returns the decimal (base 10) equivalent of a number expressed in a specified base. TO_BASE() Returns the string representation of a decimal number in a specified base.
Function Description E() Returns the mathematical constant e (Euler's number). PI() Returns the mathematical constant π (pi). INFINITY() Returns the floating-point representation of positive infinity. NAN() Returns the floating-point representation of NaN (Not a Number).
Function Description IS_FINITE() Returns TRUE if a floating-point number is finite (neither infinite nor NaN). IS_INFINITE() Returns TRUE if a floating-point number is infinite (positive or negative). IS_NAN() Returns TRUE if a floating-point value is NaN (Not a Number).
Function Description WIDTH_BUCKET_REGULAR() Returns the bucket number for a value in equally-spaced buckets within a range. WIDTH_BUCKET() Returns the bucket number for a value in a histogram with custom bin boundaries.
Function Description Bitwise AND Returns the bitwise AND of two bitstrings. Bitwise OR Returns the bitwise OR of two bitstrings. Bitwise XOR Returns the bitwise XOR (exclusive OR) of two bitstrings. Bitwise NOT Returns the bitwise NOT (complement) of a bitstring, flipping every bit. Bitwise left shift Returns the bitstring shifted left by N positions, filling with zeros on the right. Bitwise right shift Returns the bitstring shifted right by N positions, filling with zeros on the left. BIT_COUNT() Returns the number of 1-bits in the two’s-complement binary representation of an integer.
Function Description LOWER() Returns the string with all characters converted to lowercase. UPPER() Returns the string with all characters converted to uppercase. TITLE() Returns the string with the first letter of each whitespace-delimited word in uppercase and the...
Function Description TRIM() Returns the string with whitespace from both ends removed. LTRIM() Returns the string with whitespace from the left (beginning) removed. RTRIM() Returns the string with whitespace from the right (end) removed. LPAD() Returns the string padded on the left to a specified length with a padding string. RPAD() Returns the string padded on the right to a specified length with a padding string.
Function Description STARTS_WITH() Returns TRUE if a string starts with a specified prefix. ENDS_WITH() Returns TRUE if a string ends with a specified suffix. POSITION Returns the 1-based index of the first occurrence of a substring within a string. STRPOS() Returns the position of a substring within a string, optionally finding the N-th occurrence.
Function Description LEFT() Returns the first n characters of the string (or the full string when n is greater than its... RIGHT() Returns the last n characters of the string (or the full string when n is greater than its... SUBSTR() Returns a substring from a string starting at a specified position. SPLIT() Returns an array of substrings from a string split by a delimiter. SPLIT_PART() Returns a specific part of a string after splitting by a delimiter.
Function Description REVERSE() Returns the string with all characters in reverse order. REPLACE() Returns the string with all occurrences of a substring replaced with another substring. FORMAT(...) Builds a VARCHAR from a C-style format string and one scalar argument per placeholder. TRANSLATE() Returns a string with character-level replacements applied based on character-to-character mappings. BASE64_ENCODE() Encodes a string as standard Base64 text. BASE64_DECODE() Decodes a Base64 string back to plain text. HEX_ENCODE() Encodes a string as a contiguous hexadecimal string (two hex digits per byte). HEX_DECODE() Decodes a contiguous hexadecimal string back to plain text. URL_ENCODE() Encodes a string for safe use in URL components using percent-encoding (RFC 3986). URL_DECODE() Decodes a percent-encoded string (RFC 3986).
Function Description CONCAT(...) Returns a single concatenated string from a list of strings. [` CONCAT_WS(...) Returns a concatenated string from a list of strings with a separator between each element.
Function Description LENGTH() Returns the number of characters in a string. CHR() Returns the character corresponding to the given Unicode code point. CODEPOINT() Returns the Unicode code point of the first character in a string.
Function Description WORD_STEM() Returns the stem (root form) of a word using language-specific stemming rules. SOUNDEX() Returns a four-character Soundex code representing the phonetic sound of a string.
Function Description LUHN_CHECK() Returns TRUE if a string passes the Luhn algorithm (modulus 10 checksum).
Function Description MD5() Returns the MD5 hash of a string as a 32-character hexadecimal string. SHA1() Returns the SHA-1 hash of a string as a 40-character hexadecimal string. SHA256() Returns the SHA-256 hash of a string as a 64-character hexadecimal string.
Function Description REGEX_CONTAINS() Returns TRUE if the haystack string contains a match for the regular expression pattern (substring... REGEX_MATCH() Returns TRUE if the entire string matches the regular expression pattern. Unlike REGEX_CONTAINS,... REGEX_EXTRACT_FIRST() Returns the first substring that matches the pattern, optionally selecting a capture group index (0... REGEX_EXTRACT_ALL() Returns an array of every non-overlapping substring that matches the pattern, in left-to-right... REGEX_SPLIT() Splits a string by a regular expression pattern and returns the parts between matches as an array. REGEX_REPLACE_FIRST() Returns the haystack with the first regular-expression match replaced by the replacement string. REGEX_REPLACE_ALL() Returns the haystack with every non-overlapping regular-expression match replaced by the...
Function Description ADD() Returns the date/timestamp after adding an interval. DATE_ADD() Returns the date/timestamp after adding a given number of a given units to the given date or... SUBTRACT() Subtracts an interval from a timestamp or date, or returns the interval between two timestamps or... DATE_SUBTRACT() Returns timestamp1 minus timestamp2 in the given unit. Chaining-friendly: the base value comes... DATE_DIFF() Returns the difference between start and end in the given unit (end − start). Matches the...
Function Description FIRST_DAY_OF() Returns the first calendar day of the period containing the given date or timestamp, as midnight on... LAST_DAY_OF() Returns the last calendar day of the period containing the given date or timestamp, as midnight on... DAYS_IN() Returns the number of calendar days in the MONTH, QUARTER, HALF (half-year), or YEAR that contains...
Function Description SEQUENCE() Generates an inclusive array of dates or timestamps separated by an interval. DATE_SEQUENCE() Returns an array of timestamps: count values beginning at start, each separated by interval.
Function Description DATE_PART() Returns the part of the given timestamp in the given unit.
Function Description DATE_TRUNC() Returns the given date or timestamp truncated to the given unit. DATE_FORMAT() Returns a string from the given date or timestamp and format. TO_ISO8601() Returns an ISO 8601 string from the given timestamp or interval.
Function Description FROM_UNIXTIME() Returns a timestamp from the given unix timestamp (BIGINT representation of the number of seconds... TO_UNIXTIME() Returns a unix timestamp (BIGINT representation of the number of seconds since 1970-01-01 00:00:00...
Function Description LOCAL_TO_UTC() Treats a naive TIMESTAMP as local wall time in the given zone and returns the same instant as a... UTC_TO_LOCAL() Interprets a naive UTC TIMESTAMP as an instant and returns it in the given timezone (TIMESTAMPTZ).
Function Description JSON_PARSE() Returns the given string as a JSON expression. TRY_JSON_PARSE() Returns the given string as a JSON expression, or NULL if the string is not valid JSON. JSON_PARSE_AS() Returns the value of a JSON expression represented as a string in the given type. JSON_EXTRACT() Returns the value of the given JSON path in the given JSON expression. JSON_EXTRACT_SCALAR() Returns the scalar value of the given JSON path in the given JSON expression. JSON_FORMAT() Returns the given JSON expression as a string. JSON_ARRAY_COUNT() Returns the number of elements in a JSON array. JSON_KEYS() Returns the keys of a JSON object as an array of strings. JSON_TYPE() Returns the type of a JSON value as a string.
Function Description ELEMENT_AT_POS() Returns the element at the specified position in an array. ELEMENTS_AT_POS() Returns the elements at multiple specified positions in an array. SLICE() Returns a slice of an array using start:length:step semantics. SLICE_END() Returns the elements at multiple specified positions in an array.
Function Description CONTAINS() Returns TRUE if the array contains the specified element. CONTAINS_SEQUENCE() Returns TRUE if the array contains the specified sequence as a contiguous subsequence. ARRAY_POSITION() Returns the 1-based position of the first occurrence of an element in an array. ARRAY_LOOKUP(...) Returns the value corresponding to a lookup key using parallel key-value arrays.
Function Description ARRAY_SORT() Returns the sorted version of an array. ARRAY_REVERSE() Returns the reverse of an array. ARRAY_ENUMERATE() Returns an array of rows pairing each 1-based position with the corresponding element. ARRAY_ENUMERATE_FLATTEN() Returns an array of rows pairing each 1-based position with the flattened fields of the... ARRAY_ROTATE() Returns a new array whose elements are rotated circularly; positive amounts shift left, negative... ARRAY_DISTINCT() Returns an array with distinct elements, sorted in ascending order. ARRAY_REMOVE() Returns an array with all occurrences of the specified element removed. FLATTEN(...) Flattens a nested array structure into a single-level array.
Function Description ARRAY_UNION() Returns the union of two arrays, eliminating duplicate elements. ARRAY_INTERSECT() Returns the intersection of two arrays using set semantics. ARRAY_EXCEPT() Returns the difference of two arrays using set semantics. ARRAYS_OVERLAP() Returns TRUE if any elements are common between the two arrays.
Function Description ARRAY_COUNT() Returns the number of elements in an array. ARRAY_SUM() Returns the sum of all numeric elements in an array. ARRAY_PRODUCT() Returns the product of all numeric elements in an array as a DOUBLE. ARRAY_MEDIAN() Returns the statistical median of numeric array elements as a DOUBLE. ARRAY_STDDEV_POP() Returns the population standard deviation (divide by N) of numeric array elements as a DOUBLE. ARRAY_STDDEV_SAMP() Returns the sample standard deviation (divide by N-1) of numeric array elements as a DOUBLE. ARRAY_VAR_POP() Returns the population variance (divide by N) of numeric array elements as a DOUBLE. ARRAY_VAR_SAMP() Returns the sample variance (divide by N-1) of numeric array elements as a DOUBLE. ARRAY_AVG() Returns the arithmetic mean (average) of all numeric elements in an array. ARRAY_MIN() Returns the smallest value in an array using natural ordering. ARRAY_MAX() Returns the largest value in an array using natural ordering. ARRAY_HISTOGRAM() Returns a frequency histogram of values in an array as an array of value-count pairs.
Function Description ALL(...) Returns TRUE if all elements in the boolean array are true. ANY(...) Returns TRUE if any element in the boolean array is true. NONE(...) Returns TRUE if no elements in the boolean array are true. ARRAY_NOT() Returns an array with inverted boolean values (logical NOT applied to each element).
Function Description ARRAY_CONCAT(...) Concatenates multiple arrays into a single combined array with optional deduplication.
Function Description REPEAT() Creates an array by repeating an element a specified number of times.
Function Description ARRAY_JOIN() Joins the elements of an array into a single string using a specified delimiter.
Function Description COSINE_SIMILARITY() Calculates the cosine similarity between two arrays. DOT_PRODUCT() Calculates the dot product of two arrays. EUCLIDEAN_DISTANCE() Calculates the Euclidean distance between two arrays. NORMALIZE() Normalizes a numeric array by dividing each element by the sum of all elements.
Function Description MERGE(...) Merges multiple row structures into a single row with combined fields
Function Description INDEX_UNIQUE() Returns an index unique computed from the given array and key. INDEX_MULTI() Returns an index multi computed from the given array and key. ELEMENT_AT_KEY() Returns one element at the given key from the given index, array or array of rows. ELEMENTS_AT_KEY() Returns multiple elements at the given key from the given index, array or array of rows.
Function Description EXTRACT(...) Returns the extracted fields from the given expression. UNWRAP() Returns the first field values from an array of single-field rows as a simple array. UNWRAP_ONE() Returns the value of the first field of the first element in an array of single-field rows. ZIP(...) Combines multiple arrays into a single array of structured rows with named fields. ARRAY_MERGE(...) Merges multiple arrays of rows element-wise into a single array of combined rows, with optional... CARRY(...) Carries one or more scalar values into each row of an array of rows, adding them as new fields EXTEND(...) Adds computed feature fields to a base row or array of rows with field bindings TRANSFORM Transforms an array of rows using a subquery with optional METHOD RECURSE(...) Produces an array of rows by iterating a seed ROW, optionally traversing entity relationships
Function Description BOOL_AND() OVER ... Returns TRUE if all boolean values in the window frame are true. BOOL_OR() OVER ... Returns TRUE if any boolean value in the window frame is true.
Function Description ROW_NUMBER() OVER ... Returns a unique sequential number for each row within its partition, starting at 1. RANK() OVER ... Returns the rank of the current row within its partition, with gaps. Rows with equal values for the... DENSE_RANK() OVER ... Returns the rank of the current row within its partition, without gaps. Similar to RANK but... NTILE() OVER ... Returns the bucket number (1 to n) for each row in a partition, where n is the number of buckets. PERCENT_RANK() OVER ... Returns the relative rank of the current row: (rank - 1) / (total rows - 1). CUME_DIST() OVER ... Returns the cumulative distribution: (number of rows <= current row) / (total rows).
Function Description ANY_VALUE() OVER ... Returns an arbitrary non-null value from the window frame, if one exists. ARRAY_AGG() OVER ... Returns an array of all values in the window frame. MIN_BY() OVER ... Returns the value of the first expression corresponding to the minimum value of the second... MAX_BY() OVER ... Returns the value of the first expression corresponding to the maximum value of the second... STRING_AGG() OVER ... Concatenates string values in the window frame in order up to the current row, separated by the...
Function Description IS_DOWNSTREAM_OF() Returns TRUE if the current feature is dependent of the given feature in the dependency DAG IS_UPSTREAM_OF() Returns TRUE if the current feature is a dependency of the given feature in the dependency DAG DEPTH_RELATIVE_TO() Returns the depth of the current feature relative to the given feature in the dependency DAG
Function Description KEYSET() Returns a reference to a keyset. PREPARED_STATEMENT() Returns a reference to a prepared statement of the given feature with the given inputs. TYPEOF() Returns the type of the given expression in FeatureQL. SQLTYPEOF() Returns the name of the translated storage type for the expression (after FeatureQL is lowered for... VERSION() Returns registry version; reload time is set only on a dev workstation.
Function Description SCD_AT_TIME() Returns the state of an SCD (slowly changing dimension) value at the given point in time. ACCUMULATION_AT_TIME() Returns the state of an accumulation of events at the given point in time.
Function Description TO_ACTIVITY_BITS() Returns the activity bits for the given array of activity dates and date reference. FROM_ACTIVITY_BITS() Returns the activity dates for the given activity bits and date reference. BINARY_REPRESENTATION() Returns the binary representation as a string of the given activity bits UPDATE_ACTIVITY_BIT() Returns the activity bits for the given activity bits and whether the current day is active. IS_ACTIVE() Returns whether the given activity bits is active for the given time period ACTIVITY_STATUS() Returns the activity status between two time periods for the given activity bits COUNT_ACTIVE() Returns the number of active days for the given activity bits and time period RECENCY() Returns the number of days since the last active day for the given activity bits
Function Description HASH01() Returns a value between 0 and 1 based on the given hashing key. GRADUAL_ROLLOUT() Returns the exposure to a new version based on the given hashing key and rollout parameters.
Function Description SAMPLE_UNIFORM() Returns a value uniformly chosen between two bounds based on the given hashing key. SAMPLE_GAUSSIAN() Returns a value chosen from a normal distribution between two bounds based on the given hashing key. SAMPLE_VALUE(...) Returns a value from the given array of values and proportions based on the given hashing key. SAMPLE_BOOL() Returns the discrete event (true or false) with the given probability based on the given hashing... SAMPLE_EXPONENTIAL() Returns a value drawn from an exponential distribution with the given rate, based on the given... SAMPLE_POISSON() Returns an integer drawn from a Poisson distribution with the given rate, based on the given... SAMPLE_LOGNORMAL() Returns a value drawn from a log-normal distribution, clamped to [lower, upper], based on the given... SAMPLE_GEOMETRIC() Returns the number of trials until first success, drawn from a geometric distribution, based on the... SAMPLE_WEIBULL() Returns a value drawn from a Weibull distribution based on the given hashing key.
Function Description CURRENT_TIMESTAMP() Returns the current date and time. RANDOM() Returns a random number in the range 0.0 <= x < 1.0
Function Description EVAL_CONST() Returns the result of evaluating a constant formula as a literal.
Function Description ST_GEOMPOINT() Creates a GEOMETRY point from x and y coordinates. ST_GEOGPOINT() Creates a GEOGRAPHY point from longitude and latitude coordinates in WGS84. ST_GEOMFROMTEXT() Creates a GEOMETRY value from a WKT (Well Known Text) string. ST_GEOGFROMTEXT() Creates a GEOGRAPHY value from a WKT (Well Known Text) string. Coordinates are interpreted as... ST_MAKELINE() Creates a LINESTRING from two geometry or geography inputs. ST_MAKEPOLYGON() Creates a POLYGON from a closed LineString shell. ST_COLLECT() Combines two geometries or geographies into a collection without dissolving boundaries. ST_GEOMFROMWKB() Creates a GEOMETRY value from a WKB (Well Known Binary) byte string. ST_GEOGFROMWKB() Creates a GEOGRAPHY value from a WKB (Well Known Binary) byte string. Coordinates are interpreted... ST_GEOMFROMGEOJSON() Creates a GEOMETRY value from a GeoJSON string. ST_GEOGFROMGEOJSON() Creates a GEOGRAPHY value from a GeoJSON string. Coordinates are interpreted as lon/lat in WGS84. ST_TOGEOGRAPHY() Casts a GEOMETRY to GEOGRAPHY, reinterpreting coordinates as lon/lat in WGS84 without reprojection. ST_TOGEOMETRY() Casts a GEOGRAPHY to GEOMETRY, reinterpreting the WGS84 lon/lat coordinates as planar x/y without...
Function Description ST_ASTEXT() Returns the WKT (Well Known Text) representation of a geometry or geography. ST_ASGEOJSON() Returns the GeoJSON representation of a geometry or geography. ST_ASWKB() Returns the WKB (Well Known Binary) representation of a geometry or geography.
Function Description ST_DISTANCE() Returns the minimum distance between two geometries or geographies. ST_AREA() Returns the area of a geometry or geography. ST_LENGTH() Returns the length of a linear geometry or geography. ST_PERIMETER() Returns the perimeter of an areal geometry or geography. ST_AZIMUTH() Returns the azimuth angle in radians from point A to point B, measured clockwise from north...
Function Description ST_INTERSECTS() Returns TRUE if two geometries or geographies share any portion of space. ST_CONTAINS() Returns TRUE if geometry/geography A fully contains geometry/geography B. ST_WITHIN() Returns TRUE if geometry/geography A is fully within geometry/geography B. ST_DWITHIN() Returns TRUE if the distance between two geometries or geographies is less than or equal to a... ST_EQUALS() Returns TRUE if two geometries or geographies represent the same point set. ST_DISJOINT() Returns TRUE if two geometries or geographies do not share any space. ST_TOUCHES() Returns TRUE if two geometries share boundary points but no interior points. ST_CROSSES() Returns TRUE if two geometries have some but not all interior points in common. ST_OVERLAPS() Returns TRUE if two geometries of the same dimension have overlapping interiors.
Function Description ST_X() Returns the X coordinate of a point (or longitude for geography). ST_Y() Returns the Y coordinate of a point (or latitude for geography). ST_GEOMETRYTYPE() Returns the OGC type name of a geometry or geography as a string. ST_NUMPOINTS() Returns the total number of vertices in a geometry or geography. ST_NUMGEOMETRIES() Returns the number of sub geometries in a collection, or 1 for singular geometries. ST_DIMENSION() Returns the topological dimension of a geometry or geography. ST_ISEMPTY() Returns TRUE if a geometry or geography is empty. ST_ISVALID() Returns TRUE if a geometry is topologically valid (no self intersections, proper ring closure,... ST_SRID() Returns the SRID (Spatial Reference ID) of a geometry. ST_ISCLOSED() Returns TRUE if a geometry is closed (start point equals end point for lines; always TRUE for... ST_STARTPOINT() Returns the first vertex of a LineString. ST_ENDPOINT() Returns the last vertex of a LineString. ST_ISSIMPLE() Returns TRUE if a geometry has no anomalous geometric points such as self-intersections or... ST_GEOMPOINTN() Returns the Nth vertex of a LineString (1-indexed). ST_ISPOINT() Returns TRUE if the geometry or geography is a Point. ST_EXTERIORRING() Returns the outer ring of a Polygon as a LineString. ST_ISLINE() Returns TRUE if the geometry or geography is a LineString. ST_ISPOLYGON() Returns TRUE if the geometry or geography is a Polygon. ST_NUMINTERIORRINGS() Returns the number of interior rings (holes) in a Polygon. ST_INTERIORRINGN() Returns the Nth interior ring (hole) of a Polygon as a LineString (1-indexed). ST_ISCOLLECTION() Returns TRUE if the geometry or geography is a Multi* or GeometryCollection. ST_GEOMETRYN() Returns the Nth sub-geometry from a geometry collection (1-indexed).
Function Description ST_CENTROID() Returns the geometric center of mass (centroid) of a geometry or geography. ST_BUFFER() Returns a geometry/geography that represents all points within a given distance of the input. ST_ENVELOPE() Returns the bounding box of a geometry or geography as a polygon. ST_CONVEXHULL() Returns the convex hull of a geometry or geography. ST_SIMPLIFY() Returns a simplified version of a geometry using the Douglas Peucker algorithm. ST_INTERSECTION() Returns the geometry/geography representing the point set intersection of two inputs. ST_UNION() Returns the geometry/geography representing the point set union of two inputs. ST_DIFFERENCE() Returns the geometry/geography representing the point set difference of A minus B. ST_SYMDIFFERENCE() Returns the geometry/geography representing the point set symmetric difference of two inputs (union... ST_REVERSE() Returns a geometry with the vertex order of each component reversed. ST_SNAP_TO_GRID() Snaps all vertices of a geometry to a uniform grid with the given cell size. ST_SETSRID() Sets the SRID on a geometry without modifying or reprojecting coordinates. ST_TRANSFORM() Reprojects a geometry from its current SRID to a target SRID. ST_DUMP() Explodes a Multi* or GeometryCollection into an array of its component geometries.
Function Description ST_UNION_AGG() Aggregate function that dissolves all geometries in a group into a single geometry. ST_COLLECT_AGG() Aggregate function that collects all geometries in a group into a single GeometryCollection without... ST_EXTENT() Aggregate function that returns the bounding box of all geometries in a group as a polygon.
Summary
Total Functions: 416Total Categories: 19This documentation is automatically generated from the FeatureMesh registry.