| Returns the nodata value of the specified band as a double. Returns null if the band has no nodata value defined. | rs_bandnodatavalue |
| Retrieves the file path of an out-of-database (out-db) raster band, returning the external raster file location referenced by the raster. | rs_bandpath |
| Returns the pixel data type of the specified band as a string. | rs_bandpixeltype |
| Returns true if the first argument's extent contains the second. | rs_contains |
| Returns the convex hull geometry of a raster. | rs_convexhull |
| Returns the CRS string for a raster. | rs_crs |
| Returns the envelope (bounding box) of a raster as a geometry. | rs_envelope |
| Creates a simple example raster for testing and demos. | rs_example |
| Creates an out-of-database raster from a raster file path. | rs_frompath |
| Returns the georeference metadata of raster as a string in GDAL or ESRI format as commonly seen in a world file. Default is GDAL if not specified. Both formats output six lines: scalex, skewy, skewx, scaley, upperleftx, upperlefty. In GDAL format the upper-left coordinates refer to the corner of the upper-left pixel, while in ESRI format they are shifted to the center of the upper-left pixel. | rs_georeference |
| Returns the height of a raster in pixels. | rs_height |
| Returns true if the extents of the two arguments intersect. | rs_intersects |
| Returns the number of bands in the raster. | rs_numbands |
| Returns the centroid of the specified pixel as a Point geometry. | rs_pixelascentroid |
| Returns the upper-left corner of the specified pixel as a Point geometry. | rs_pixelaspoint |
| Returns the bounding polygon of the specified pixel. | rs_pixelaspolygon |
| Converts raster pixel coordinates to world coordinates as a point. | rs_rastertoworldcoord |
| Converts raster pixel coordinates to world X coordinate. | rs_rastertoworldcoordx |
| Converts raster pixel coordinates to world Y coordinate. | rs_rastertoworldcoordy |
| Returns the raster rotation in radians based on skew parameters. | rs_rotation |
| Returns the pixel width (scale X) of a raster. | rs_scalex |
| Returns the pixel height (scale Y) of a raster. | rs_scaley |
| Sets the Coordinate Reference System (CRS) for a raster. | rs_setcrs |
| Sets the SRID (spatial reference identifier) for a raster. | rs_setsrid |
| Returns the X skew (rotation) parameter of a raster. | rs_skewx |
| Returns the Y skew (rotation) parameter of a raster. | rs_skewy |
| Returns the SRID of a raster. | rs_srid |
| Returns the upper-left X coordinate of a raster. | rs_upperleftx |
| Returns the upper-left Y coordinate of a raster. | rs_upperlefty |
| Returns the width of a raster in pixels. | rs_width |
| Returns true if the first argument's extent is within the second. | rs_within |
| Converts world coordinates to raster coordinates as a point. | rs_worldtorastercoord |
| Converts world coordinates to raster X coordinate. | rs_worldtorastercoordx |
| Converts world coordinates to raster Y coordinate. | rs_worldtorastercoordy |
| Applies an affine transformation to a geometry. | sd_affine |
| Computes the statistics of geometries for the input geometry or geography. | sd_analyze_agg |
| Returns the area of a geometry or geography. | sd_area |
| Converts a geometry or geography to Well-Known Binary (WKB) format. | sd_asbinary |
| Returns the EWKB representation of a geometry or geography. | sd_asewkb |
| Returns the GeoJSON representation of a geometry. | sd_asgeojson |
| Returns the Well-Known Text string representation of a geometry or geography. | sd_astext |
| Returns the azimuth between two points in radians, or NULL if not available. | sd_azimuth |
| Returns the closure of the combinatorial boundary of this geometry or geography. | sd_boundary |
| Computes a geometry or geography that represents all points whose distance from the input is less than or equal to a specified distance. | sd_buffer |
| Returns the centroid of a geometry or geography. | sd_centroid |
| Returns the 2-dimensional point on geom1 that is closest to geom2. | sd_closestpoint |
| Combines multiple geometries from a set of rows into a single collection. | sd_collect_agg |
| Returns a concave hull enclosing the input geometry. | sd_concavehull |
| Returns true if geomA contains geomB. | sd_contains |
| Returns the Convex Hull of a geometry or geography. | sd_convexhull |
| Returns true if geomA is covered by geomB. | sd_coveredby |
| Returns true if geomA covers geomB. | sd_covers |
| Returns true if A crosses B. | sd_crosses |
| Returns the Coordinate Reference System (CRS) metadata associated with a geometry or geography object. | sd_crs |
| Computes the difference between geomA and geomB. | sd_difference |
| Returns the dimension of the geometry or geography. | sd_dimension |
| Returns true if geomA is disjoint from geomB. | sd_disjoint |
| Returns the distance between two geometries or geographies. | sd_distance |
| Expands multi-part geometries into child parts | sd_dump |
| Returns true if two geometries or geographies are within a specified distance of each other. | sd_dwithin |
| Returns last point of a linestring. | sd_endpoint |
| Returns the bounding box (envelope) of a geometry or geography as a new geometry. | sd_envelope |
| An aggregate function that returns the collective bounding box (envelope) of a set of geometries. | sd_envelope_agg |
| Returns true if geomA equals geomB. | sd_equals |
| Returns a new geometry with the X and Y coordinates of each vertex swapped. | sd_flipcoordinates |
| Forces a geometry or geography into a XY coordinate model. | sd_force2d |
| Forces a geometry or geography into a XYZ coordinate model with an optional Z value. | sd_force3d |
| Forces a geometry or geography into a XYM coordinate model with an optional M value. | sd_force3dm |
| Forces a geometry or geography into a XYZM coordinate model with optional Z and M values. | sd_force4d |
| Constructs a Geography from WKB Binary. | sd_geogfromwkb |
| Constructs a Geography from WKT. | sd_geogfromwkt |
| Creates a geography POINT from given longitude and latitude coordinates. | sd_geogpoint |
| Returns the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON. | sd_geometryn |
| Returns the type of a geometry or geography. | sd_geometrytype |
| Constructs a geometry from Extended Well-Known Binary (EWKB). | sd_geomfromewkb |
| Constructs a geometry from Extended Well-Known Text (EWKT). | sd_geomfromewkt |
| Constructs a Geometry from Well-Known Binary (WKB). | sd_geomfromwkb |
| Constructs a Geometry from Well-Known Text (WKT). | sd_geomfromwkt |
| Returns true if the geometry has a M dimension. | sd_hasm |
| Returns true if the geometry has a Z dimension. | sd_hasz |
| Returns the Nth interior ring of a polygon. | sd_interiorringn |
| Computes the intersection of two geometries or geographies. | sd_intersection |
| Returns the cumulative intersection of all geometries in the input. | sd_intersection_agg |
| Returns true if geomA intersects geomB. | sd_intersects |
| Returns true if the LINESTRING start and end point are the same. | sd_isclosed |
| Returns true if the geometry or geography type of the input is a collection type. | sd_iscollection |
| Returns true if the geometry or geography is empty. | sd_isempty |
| Returns true if a linestring is ST_IsClosed and ST_IsSimple. | sd_isring |
| Tests if geometry's only self-intersections are at boundary points. | sd_issimple |
| Checks whether a geometry meets the rules of a valid spatial object according to the OGC standard. | sd_isvalid |
| Returns a text explanation describing why a geometry is invalid. | sd_isvalidreason |
| Returns true if geomA finds k nearest neighbors from geomB. | sd_knn |
| Returns the length of a geometry or geography. | sd_length |
| Returns a point interpolated along a line. | sd_lineinterpolatepoint |
| Returns the location of the closest point on a LineString as a fraction of its total length. | sd_linelocatepoint |
| Merges a collection of potentially connected line segments into the fewest possible LineStrings. | sd_linemerge |
| Returns a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. | sd_linesubstring |
| Returns the M (measure) coordinate of a Point geometry. | sd_m |
| Creates a LineString from two or more input geometries. | sd_makeline |
| Creates a valid representation of an invalid geometry. | sd_makevalid |
| Returns the maximum distance between any pair of points in two geometries or geographies. | sd_maxdistance |
| Returns the minimum clearance of a geometry. | sd_minimumclearance |
| Returns a LineString representing the minimum clearance distance of the input geometry. | sd_minimumclearanceline |
| Missing argument sentinel | sd_missing_arg |
| Returns the maximum M (measure) value from a geometry or geography's bounding box. | sd_mmax |
| Returns the minimum M-coordinate (measure) of a geometry or geography's bounding box. | sd_mmin |
| Returns the geometry or geography in its canonical form. | sd_normalize |
| Returns the number of points of the geometry or geography. | sd_npoints |
| Returns the total number of rings in a geometry or geography (both exterior and interior rings). | sd_nrings |
| Returns the number of geometries in a geometry or geography collection. | sd_numgeometries |
| Returns the number of interior rings (holes) in a polygon geometry or geography. | sd_numinteriorrings |
| Returns the number of points of a linestring geometry or geography. | sd_numpoints |
| Returns true if A overlaps B. | sd_overlaps |
| Calculates the perimeter of a given geometry or geography. | sd_perimeter |
| Constructs a Point Geometry from X and Y. | sd_point |
| Constructs a Point with an M (measure) coordinate from X, Y, and M values. | sd_pointm |
| Returns the Nth point in a linestring. | sd_pointn |
| Returns a point guaranteed to lie on the surface of a geometry or geography. | sd_pointonsurface |
| Returns a MultiPoint geometry consisting of all the coordinates of the input geometry or geography. | sd_points |
| Constructs a Point with a Z coordinate from X, Y, and Z values. | sd_pointz |
| Constructs a Point with X, Y, Z and M coordinates. | sd_pointzm |
| Builds a polygonal geometry from linear components in the input geometry. | sd_polygonize |
| Creates polygons from a set of geometries that contain linework representing the edges of a polygon. | sd_polygonize_agg |
| Reduces the coordinate precision of a geometry or geography to the specified grid size. | sd_reduceprecision |
| Returns the DE-9IM intersection matrix string for two geometries, or tests whether two geometries satisfy a given intersection matrix pattern. | sd_relate |
| Returns the geometry or geography with vertex order reversed. | sd_reverse |
| Rotates a geometry counter-clockwise around the Z axis by an angle in radians. | sd_rotate |
| Rotates a geometry around the X axis by an angle in radians. | sd_rotatex |
| Rotates a geometry around the Y axis by an angle in radians. | sd_rotatey |
| Scales a geometry by multiplying ordinates with scale factors. | sd_scale |
| Densifies a geometry by adding intermediate points along segments that exceed a maximum length. | sd_segmentize |
| Sets the Coordinate Reference System (CRS) for a geometry. | sd_setcrs |
| Sets the SRID (spatial reference identifier) for a geometry. | sd_setsrid |
| Simplifies an input geometry or geography using the Douglas-Peucker algorithm. | sd_simplify |
| Simplifies a geometry, ensuring the result is a valid geometry with the same topology. | sd_simplifypreservetopology |
| Snaps input geometry to reference geometry within tolerance. | sd_snap |
| Returns the SRID (spatial reference identifier) of a geometry. | sd_srid |
| Returns the start point of a linestring geometry. | sd_startpoint |
| Returns the parts of geometries or geographies A and B that do not overlap. | sd_symdifference |
| Converts a geometry to geography, densifying edges to approximate planar lines as geodesic segments. | sd_tessellategeog |
| Converts a geography to geometry, densifying edges to approximate geodesic segments as planar lines. | sd_tessellategeom |
| Converts a geometry to a geography by changing the edge interpretation to spherical. | sd_togeography |
| Converts a geography to a geometry by changing the edge interpretation to planar. | sd_togeometry |
| Returns true if A touches B. | sd_touches |
| Transforms a geometry from one coordinate reference system to another. | sd_transform |
| Returns a geometry with coordinates translated by deltaX and deltaY. | sd_translate |
| Returns a single geometry which is the union of all components. | sd_unaryunion |
| Returns a geometry or geography that represents the point set union of two geometries or geographies. | sd_union |
| Returns a geometry that represents the point set union of all geometries. | sd_union_agg |
| Returns true if A is completely inside B. | sd_within |
| Returns the X coordinate (longitude for geography) of the point, or NULL if not available. | sd_x |
| Returns the maximum X coordinate (longitude for geography) of a geometry or geography's bounding box. | sd_xmax |
| Returns the minimum X coordinate (longitude for geography) of a geometry or geography's bounding box. | sd_xmin |
| Returns the Y coordinate (latitude for geography) of the point, or NULL if not available. | sd_y |
| Returns the maximum Y coordinate (latitude for geography) of a geometry or geography's bounding box. | sd_ymax |
| Returns the minimum Y coordinate (latitude for geography) of a geometry or geography's bounding box. | sd_ymin |
| Returns the Z coordinate of the point, or NULL if not available. | sd_z |
| Returns the maximum Z coordinate of a geometry or geography's bounding box. | sd_zmax |
| Returns a code indicating the dimension of the coordinates in a geometry. | sd_zmflag |
| Returns the minimum Z coordinate of a geometry or geography's bounding box. | sd_zmin |
