ApsaraDB RDS:Spatio-temporal engine release notes

New features

None.

Bug fixes

• Fixed known issues.

New features

• GeomGrid SQL: Added Uber H3 index support:

  • The H3Grid data type to represent H3-encoded grid objects.

  • ST_H3FromLatLng to get an H3Grid object at a specified longitude and latitude.

  • ST_H3FromText to convert a STRING-type H3-encoded grid object to an H3Grid object.

  • ST_H3FromInt to convert a BIGINT-type H3-encoded grid object to an H3Grid object.

  • ST_AsInt to convert an H3Grid object to a BIGINT-type H3-encoded grid object.

  • ST_Parent to get the parent grid of an H3-encoded grid at a specified level.

  • ST_Children to get the child grid of an H3-encoded grid at a specified level.

• Geometry SQL: Added functions for random sampling and pixel filtering to reduce dynamically generated tile sizes:

  • ST_IsRandomSampled to return a boolean indicating whether a record is sampled, based on property values and sample rates.

  • ST_AsMVTGeomEx to filter low-impact vector elements via the res_rec parameter, reducing generated MVT size compared to ST_AsMVTGeom.

• Geometry SQL: Extended GEOGRAPHY data type support for line functions:

  • ST_LineSubstring now supports GEOGRAPHY and returns subsegments based on spherical distances.

  • ST_LineInterpolatePoint now supports GEOGRAPHY and returns points based on spherical distances.

  • ST_LineInterpolatePoints now supports GEOGRAPHY and returns interpolated points based on spherical distances.

  • ST_LineLocatePoint now supports GEOGRAPHY and returns the closest distance percentage based on spherical distance.

• Raster SQL: Added ST_Polygonize to vectorize raster objects.

• Performance optimizations

  • GeomGrid SQL

    • Enhanced the ST_AsGeometry, ST_AsText, ST_AsBinary, and ST_Level functions to support the h3grid type.

  • Raster SQL

    • Enhanced the ST_Statistics function to support statistics for any geometry type.

  • FDW SQL

    • Enhanced support for file names or field names encoded in UTF-8.

Enhancements

• GeomGrid SQL: Enhanced ST_AsGeometry, ST_AsText, ST_AsBinary, and ST_Level to support the H3Grid data type.

• Raster SQL: Enhanced ST_Statistics to collect statistics on geometries of any type.

• Foreign Data Wrapper (FDW) SQL: Added support for UTF-8-encoded file names and field names.

Bug fixes

• GeomGrid SQL: Fixed incorrect grid computation at certain levels in ST_AsGrid.

• Geometry SQL: Fixed vector pyramids failing to load metadata from GanosBase 3.7.

• Geometry SQL: Fixed ST_Union failing when an extension update has not been applied.

• Raster SQL: Fixed the band parameter of ST_Contour starting from 0 instead of 1.

• Trajectory SQL: Fixed the trajectory module failing to install due to a dependency on pg_type.

New features

• GeomGrid SQL: Added GeoSOT 3D grid code support with the following functions and operators:

  • ST_AsBox3D to return the box3d spatial range of a 3D geographic grid.

  • ST_GridLevelFromZ to calculate the grid level from altitude.

  • ST_GridLevelAsZ to convert a grid level to altitude.

  • ST_HasZ to check whether a geographic grid has a Z dimension.

  • ST_Level to get the gridding level of a geographic grid.

  • ST_Generalize to aggregate a geographic grid from a high level to a low level.

  • ST_3DIntersects to check whether the spatial range of a 3D geographic grid intersects with a geometry.

  • ST_3DContains to check whether the spatial range of a 3D geographic grid includes a geometry.

  • ST_3DWithin to check whether the spatial range of a 3D geographic grid is included by a geometry.

  • ST_As3DGrid to convert a 3D geometry to a geographic grid.

  • The &&& operator to check whether the spatial range of a 3D geographic grid intersects with a geometry.

  • The @@> operator to check whether the spatial range of a 3D geographic grid includes a geometry.

  • The <@@ operator to check whether the spatial range of a 3D geographic grid is included by a geometry.

• Performance optimizations

  • GeomGrid SQL

    • Enhanced the ST_AsText function to convert a 3D geographic grid object to a text encoding.

    • Enhanced the ST_GridFromText function to convert a 3D geographic grid text encoding to a geographic grid object.

  • Raster SQL

    • Enhanced the ST_Statistics function to support pixel statistics for any spatial object.

    • Enhanced the ST_ImportFrom function to support HDF5 subdataset import.

    • Enhanced the ST_CreateRast function to support HDF5 subdataset import.

Enhancements

• GeomGrid SQL: Enhanced ST_AsText to convert a 3D geographic grid to encoded text.

• GeomGrid SQL: Enhanced ST_GridFromText to convert encoded text of a 3D geographic grid back to a geographic grid.

• Raster SQL: Enhanced ST_Statistics to support pixel statistics on any spatial object.

• Raster SQL: Enhanced ST_ImportFrom and ST_CreateRast to import HDF5 subdatasets.

Bug fixes

• Raster SQL: Fixed ST_InterpolateRaster failing in certain cases.

• Raster SQL: Fixed incorrect minimum values for Double and Float types.

• Trajectory SQL: Fixed the multi-bounding box index of a trajectory not supporting NULL values or single-point trajectories.

New features

• Added ST_AsMVT3D and ST_AsMVTGeom3D to support 3D vector tiles for 3D geometries.

• Added ST_AsTableFormat to provide the return value data type when ST_AsTable is called on a trajectory.

Bug fixes

• Fixed an error in ST_Intersection when computing the intersection of two overlapping segments.

New features

• Enhanced ST_MosaicFrom to support parallel operations.

• Enhanced ST_MosaicFrom to mosaic images or projections at different resolutions.

Bug fixes

• Fixed unexpected downtime in ST_makeTrajectory when constructing a two-point trajectory using start and end times.

New features

• Added ST_ClusterDBSCAN to support density-based spatial clustering of applications with noise (DBSCAN) in latitude/longitude coordinates.

• Added ST_CurveRecognize to identify curves in a trajectory and their curvature radius.

• Enhanced ST_AsGrid to compute degenerated grids in 2D.

• Upgraded the pgRouting extension to 3.4.2.

Bug fixes

None.

New features

• GanosBase is now compatible with PostGIS 3.3.2.

• Added ST_Angle to return each rotation angle of a trajectory as an array.

• Added ST_CurvatureRadius to return each curvature radius of a trajectory as an array.

Bug fixes

• Fixed ST_AsTable failing when x, y, or t is NULL.

New features

• Added GeoHash string to INT conversion:

  • ST_GeoHashID to convert GeoHash strings to INT values.

  • ST_GeoHashFromID to convert INT values to GeoHash strings.

• Added partial update support for vector pyramids:

  • ST_UpdatePyramid to update a vector pyramid.

  • ST_SetUpdatePyramidRules to configure vector pyramid update rules.

  • ST_BuildPyramidUseGeomSideLen to build a vector pyramid based on vector bounding box size.

• Added ST_InterpolateRaster for spatial interpolation on raster data.

• Added ST_Contour to generate contours.

• Added ST_Statistics to collect statistics on raster data in MultiPoint mode with custom weight analysis.

• Trajectory SQL: Added ST_Resample to resample a trajectory.

• Trajectory SQL: Added ST_Density to calculate trajectory density.

• Trajectory SQL: Added ST_StayPoint to identify stay points in a trajectory.

• New features

  • Added support for converting between GeoHash strings and integers:

    • Added the ST_GeoHashID function to convert a GeoHash string to an integer.

    • Added the ST_GeoHashFromID function to convert an integer to a GeoHash string.

  • Added support for local updates to vector quick-display pyramids:

    • Added the ST_UpdatePyramid function to update vector quick-display pyramids.

    • Added the ST_SetUpdatePyramidRules function to set rules for pyramid update operations.

    • Added the ST_BuildPyramidUseGeomSideLen function to build vector quick-display pyramids based on the size of the vector bounding box.

  • Added the ST_InterpolateRaster function for spatial interpolation.

  • Added the ST_Contour function for contour line generation.

  • Added the ST_Statistics function for custom weighted statistical analysis of raster data using MultiPoint.

  • Added the ST_Resample function for trajectory resampling.

  • Added the ST_Density function for trajectory density statistics.

  • Added the ST_StayPoint function for trajectory stay point detection.

Bug fixes

• Fixed ST_BuildHistogram causing the raster object to become empty.

• Fixed ST_AsTable causing downtime and Z-value errors when NULL values are present.

• Fixed incorrect results in ST_Split when GeoHash mode is used.

• Fixed attribute field encoding errors in ST_Tile.

New features

• Geometry SQL: Added ST_Intersection as an aggregate function to aggregate an array of geometry objects.

• Geometry SQL: Added ST_AddZ to accept z-axis values and convert a 2D or 3DM geometry to a 3D or 4D geometry.

• Raster SQL: Enhanced ST_SetValue to support setting pixel values based on a geometry's spatial range.

• Raster SQL: Enhanced ST_ExportTo to export raster objects as Cloud Optimized GeoTIFF (COG) files.

• Raster SQL: Enhanced ST_CreateRast to convert multiple raster records or arrays into raster objects.

• Trajectory SQL: Enhanced ST_Split to support setting a start time when splitting by time and to split by trajectory point index.

Bug fixes

• Trajectory SQL: Fixed possible downtime caused by ST_makeTrajectory.

• Trajectory SQL: Fixed ST_lcsSimilarity failing to identify time ranges measured in days.

• Trajectory SQL: Fixed ST_AsEWKB failing to convert trajectories created from data tables.

• Geometry SQL: Fixed memory usage issues in ST_BuildPyramid when building a vector pyramid from large datasets.

New features

• Geometry SQL: Enhanced ST_Union to support batch execution based on memory usage, preventing OOM errors from large data volumes.

• Raster SQL: Added ST_SetValue to set pixel values at specified pixel positions.

• Raster SQL: Added HDFS-based raster operations:

  • Enhanced ST_CreateRast to create raster data from HDFS.

  • Enhanced ST_ImportFrom to import raster data from HDFS.

  • Enhanced ST_ExportTo to export raster data to HDFS.

Bug fixes

None.

New features

• Trajectory SQL: Enhanced ST_makeTrajectory to convert table rows to trajectory objects.

• Trajectory SQL: Added ST_AsTable to convert trajectory objects to tables.

Bug fixes

• Raster SQL: Fixed temporary tables created by anonymous users not being automatically deleted when raster data is restored.

New features

• Raster SQL: Added support for accessing raster data stored in self-managed MinIO buckets. For details, see Object storage paths.

• Raster SQL: Added ST_PointValues to return pixel values of all bands.

Bug fixes

• Raster SQL: Fixed incorrect band ordering in ST_Clip.

• Raster SQL: Fixed low performance during raster updates caused by missing primary key indexes.

• Trajectory SQL: Fixed missing retry support when trajectory objects stored in an Object Storage Service (OSS) bucket are inaccessible.

New features

• GanosBase is now compatible with PostgreSQL 14.

Enhancements

• Increased the cache size for trajectory objects stored in external storage, improving access performance.

Bug fixes

• Raster SQL: Fixed missing file suffixes when exporting raster data to an OSS bucket.

• Raster SQL: Fixed statistics failures on specific raster data.

New features

• Raster SQL: Added ST_LinearStretch to linearly stretch a raster and return a new raster.

• Raster SQL: Added ST_BuildPercentiles to calculate percentiles for specified raster bands.

• Raster SQL: Added ST_ComputeStatistics to collect all raster statistics, including histograms and percentiles.

• Raster SQL: Added ST_Percentile to query percentiles for specified raster bands.

Enhancements

• Raster SQL: ST_SummaryStats and ST_BuildHistogram now support parallel computation.

• Raster SQL: ST_ExportTo now returns false if the specified file already exists, instead of raising an error.

• Raster SQL: ST_ImportFrom now returns detailed error information when an import fails.

Bug fixes

• Raster SQL: Fixed up to half a pixel being lost when rounding pixel values during raster cropping.

• Raster SQL: Fixed import and statistics failures when raster data contains NaN or Inf values.

New features

• Raster SQL: Added the following pixel conversion functions:

  • ST_PixelAsPolygon to convert a specified pixel to a polygon object.

  • ST_PixelAsPolygons to convert pixels at a specified position to polygon objects.

  • ST_PixelAsPoint to convert a specified pixel to a geometric object represented by a specified point.

  • ST_PixelAsCentroid to convert a specified pixel to a geometric object represented by its centroid.

  • ST_PixelAsPoints to convert pixels at a specified position to geometric objects, each represented by a specified point.

  • ST_PixelAsCentroids to convert pixels at a specified position to geometric objects, each represented by its centroid.

Enhancements

• Geometry SQL: Ganos Geometry is now compatible with PostGIS 3.1.4.

• Raster SQL: ST_AsDatasetFile can now return data in Grib2 format.

Bug fixes

• Raster SQL: Fixed an incorrect SRID when importing raster data in NetCDF format.

• Raster SQL: Fixed multiple bounding boxes failing to update when bounding box equality checks return incorrect results.

Enhancements

• Raster SQL: Enhanced ST_ImportFrom to map OSS objects to in-memory files, accelerating data import.

• Added the trajgist_ops_multi operator family for GiST indexing and TrajGiST indexing on multiple bounding boxes.

• Vector pyramids now support metadata queries.

Bug fixes

• Trajectory SQL: Fixed a memory leak when checking whether two trajectories intersect.

Enhancements

• Raster SQL: ST_Hillshade, ST_Slope, and ST_Aspect now return rasters instead of pixel matrices.

• Trajectory SQL: Optimized ST_Split to split a trajectory into sub-trajectories based on a specified rule.

Bug fixes

• Fixed ST_SrEqual failing to compare two spatial reference systems in specific scenarios.

New features

• Trajectory SQL: Added the following functions for trajectory tiered storage in OSS:

  • ST_removeDriftPoints to delete drift points from a trajectory based on a specified rule.

  • ST_Split to split a trajectory based on a spatial geometry object.

  • ST_ExportTo to export a trajectory to an external file, retaining only metadata in the database.

  • ST_IsExternal to check whether a trajectory is stored in an external file.

  • ST_importFrom to migrate a trajectory from an external file back to the database.

  • ST_StorageLocation to query the location of an external trajectory file.

  • ST_AKID to get the AccessKey ID used to read trajectory data from OSS.

  • ST_SetAccessKey to configure the AccessKey pair for reading trajectory data from OSS.

  • ST_SetAkId to configure the AccessKey ID for reading trajectory data from OSS.

  • ST_SetAkSecret to configure the AccessKey secret for reading trajectory data from OSS.

  • ST_SetStorageLocation to specify the storage location of an external file when reading trajectory data.

  • ST_DeleteGTF to delete exported trajectory files from a specified folder.

Bug fixes

• Geometry SQL: Fixed data queries failing when a vector pyramid is being created using string-based queries.

• Geometry SQL: Fixed layers not rendering when connected through QGIS.

New features

• Raster SQL: Added ST_AsDatasetFile to convert a specified part of a raster to a bytea file.

• Raster SQL: Added ST_RasterDrivers to query all drivers supported by GanosBase raster data sources.

• Added the Ganos_FDW module, which provides a Foreign Data Wrapper (FDW) extension for accessing spatial vector data stored in OSS buckets:

  • ST_FDWDrivers to get all drivers supported by Ganos_FDW data sources.

  • ST_ForeignTables to query table names from an external database.

  • ST_RegForeignTables to define a table in Ganos_FDW-supported data sources as a foreign table.

Bug fixes

• Raster SQL: Fixed reprojection failures in ST_Clip when a spatial reference system is specified.

Enhancements

• Raster SQL: Enhanced ST_SubRaster to support pixel type conversion and pixel value scaling, including converting multi-band remote sensing images to three-band images compatible with AI processing.

Bug fixes

• Raster SQL: Fixed an unexpected exit when GanosBase parses invalid histograms.

• Raster SQL: Fixed an unexpected exit after projection settings are modified.

• Raster SQL: Fixed an unexpected exit when importing raster data.

New features

• Raster SQL: Added ST_RPCGeoreference to query the rational polynomial coefficients (RPC) model of a raster.

• Raster SQL: Added ST_SetRPCGeoreference to configure the RPC model of a raster.

• Raster SQL: Added ST_RPCRectify to calibrate a raster based on its RPC model and return the calibrated raster.

• Geometry SQL: Added parallel GiST index creation.

Bug fixes

• Raster SQL: Fixed the pg_dump plugin failing to back up custom SRIDs.

Enhancements

• Raster SQL: GanosBase now automatically deletes original raster data chunks when a raster is updated with different raster data.

Bug fixes

• Trajectory SQL: Fixed trajectory-related extensions failing to upgrade.

• Raster SQL: Fixed resampling errors when using the Average resampling method.

• Trajectory SQL: Fixed inaccurate query results when multiple timestamps map to the same trajectory point.

• Raster SQL: Fixed an unexpected exit when geo-spatial object conversion fails. GanosBase now reports the failure cause.

New features

• Raster SQL: Added ST_ImportFrom to import raster data in parallel.

• Raster SQL: Added ST_BuildPyramid to build raster pyramids in parallel.

• Trajectory SQL: Added support for empty trajectory objects, allowing null trajectories when specified conditions are not met.

Bug fixes

• Raster SQL: Fixed ST_AddZ returning inaccurate results when input values are 16-bit signed integers.

• Trajectory SQL: Fixed the trajectory module failing to upgrade.

• Trajectory SQL: Fixed specific trajectory module functions not using indexes.

• Trajectory SQL: Fixed specific ND functions returning an error instead of false when two non-intersecting time periods are compared.

New features

• Trajectory SQL: Added ST_JaccardSimilarity to calculate the similarity between trajectory objects.

• Trajectory SQL: Added ST_Transform to convert a trajectory from one spatial reference system to another.

Enhancements

• Geometry SQL: Added a parameter to specify the spatial extent of a vector pyramid when GanosBase cannot automatically calculate it.

Bug fixes

• Fixed invalid data catalogs.

New features

• Geometry SQL: Added support for returning bytea-format images for vector pyramids, enabling vector data visualization.

• Raster SQL: Added JPEG 2000 compression for 16-bit raster data.

• Added the ganos_update function. Run select ganos_update() ; to upgrade all GanosBase extensions to the latest version.

• Trajectory SQL: Added the TRAJECTORY data type with the following capabilities:

  • Native spatio-temporal indexes.

  • GiST index support for trajectory objects across six operator families and six dimensions.

  • The BOXND data type to describe spatio-temporal extents and store trajectory objects.

  • The && operator (intersects), @> operator (contains), and <@ operator (is contained by) for comparing spatio-temporal relationships between objects.

  • ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin to process trajectory objects.

  • Statistics collection and scan cost estimation for trajectory objects.

  • TrajGiST index support.

Enhancements

• Trajectory SQL: Optimized ST_DWithin for faster distance queries.

• Trajectory SQL: Used GiST index-based two-phase query optimization for faster spatio-temporal extent queries.

• Geometry SQL: Optimized vector pyramid building:

  • Source data from all coordinate systems with SRIDs is now supported, based on EPSG:3857 or EPSG:4326.

  • Added the pixelSize parameter to aggregate point data and reduce tile count.

Bug fixes

• Trajectory SQL: Fixed improper trajectory intersections on the t-axis.

• Raster SQL: Fixed failures in updating raster objects.

• Fixed binary files not responding after upgrading to later versions.

• Geometry SQL: Fixed an abnormally large number of tiles at the top layer of a vector pyramid when using default settings for point data.

New features

• Raster SQL: Added support for NetCDF files with subsets, allowing import into specified layers by layer name.

• Raster SQL: Added the following functions to query and configure raster file metadata and time series data:

  • ST_MetaItems to query the names of all custom metadata items in a raster file.

  • Enhanced ST_MetaData to return custom metadata items in JSON format.

  • ST_SetMetaData to set a metadata item of a raster.

  • ST_BeginDateTime to get the start time of a raster.

  • ST_EndDateTime to get the end time of a raster.

  • ST_SetBeginDateTime to set the start time of a raster.

  • ST_SetEndDateTime to set the end time of a raster.

  • ST_SetDateTime to set the start time, end time, and band acquisition time of a raster.

• Raster SQL: Added the following functions to convert rasters to bytea images:

  • ST_AsImage to convert a raster to a bytea image.

  • ST_AsPNG to convert a raster to a bytea PNG image.

  • ST_AsJPEG to convert a raster to a bytea JPEG image.

• GeomGrid SQL: Added the GEOMGRID data type with the following functions:

  • ST_AsText to convert GEOMGRID to TEXT.

  • ST_AsGeometry to convert GEOMGRID to GEOMETRY.

  • ST_AsBinary to convert GEOMGRID to BINARY.

  • ST_AsBox to convert GEOMGRID to BOX.

  • ST_AsGrid to convert GEOMETRY to GEOMGRID.

  • ST_GridFromText to convert TEXT to GEOMGRID.

  • ST_GridFromBinary to convert BINARY to GEOMGRID.

  • ST_Intersects to check whether a grid object intersects with a geometric object.

  • ST_Contains to check whether a grid object includes another grid or geometric object.

  • ST_Within to check whether a grid object is contained by another grid or geometric object.

• Geometry SQL: Added vector pyramid support:

  • ST_BuildPyramid to build a vector pyramid.

  • ST_DeletePyramid to delete a vector pyramid.

  • ST_Tile to query vector pyramid tile data in MVT format.

Bug fixes

• Geometry SQL: Fixed memory exhaustion when building vector pyramids.

• Trajectory SQL: Fixed GanosBase failing to create a trajectory point on January 1, 2000.

• Trajectory SQL: Fixed ST_Intersection returning inaccurate sub-trajectories.

New features

• Raster SQL: Added support for Cloud Optimized GeoTIFF (COG) format, enabling GanosBase to read pyramid data from COG files.

• Geometry SQL: Added ST_AddZ to add z coordinates to a geometric object based on pixel values of the containing raster.

• Raster SQL: Added the following functions for efficient spatial extent queries based on pyramid levels:

  • ST_Extent to query the spatial extent of a raster and return a bounding box.

  • ST_Envelope to query the spatial extent of a raster and return a geometric object.

  • ST_ConvexHull to get the minimum convex geometry enclosing all geometries within a raster.

  • ST_Height to query the pixel height of a raster.

  • ST_Width to query the pixel width of a raster.

  • Enhanced ST_XMin to query the minimum x coordinate of a raster.

  • Enhanced ST_YMin to query the minimum y coordinate of a raster.

  • Enhanced ST_XMax to query the maximum x coordinate of a raster.

  • Enhanced ST_YMax to query the maximum y coordinate of a raster.

Bug fixes

• Raster SQL: Fixed a performance bottleneck when splitting external raster data using the 1×n chunking model. Chunk size is now customizable.

• Raster SQL: Fixed ST_Values returning linear objects with coordinates that do not follow sorting rules on specific axes.

• Raster SQL: Fixed ST_BestPyramidLevel returning negative values.

• Raster SQL: Fixed ST_BuildPyramid repeatedly building pyramids.

• Raster SQL: Fixed chunk tables not being cleared in a timely manner when raster tables are truncated.

• Raster SQL: Fixed ST_ExportTo ignoring the CreateOption parameter.

• Raster SQL: Fixed ST_ClearChunks failing when the table name contains both uppercase and lowercase letters.

• Raster SQL: Fixed failures in creating an overview for an external pyramid.

• Raster SQL: Fixed failures in creating an internal pyramid for a raster that already has an external pyramid.

• Raster SQL: Fixed inaccurate statistics for rasters containing NaN values.

New features

• Raster SQL: Added the following functions for efficient raster metadata queries:

  • ST_XMin to query the minimum x coordinate of a raster.

  • ST_YMin to query the minimum y coordinate of a raster.

  • ST_XMax to query the maximum x coordinate of a raster.

  • ST_YMax to query the maximum y coordinate of a raster.

  • ST_ChunkHeight to query the chunk height of a raster.

  • ST_ChunkWidth to query the chunk width of a raster.

  • ST_ChunkBands to query the number of bands per chunk.

• Raster SQL: Added ST_SrFromEsriWkt to convert a spatial reference string from Esri format to OGC format.

• Raster SQL: Added Zstandard (Zstd) and Snappy compression algorithms for raster data.

• Raster SQL: Added support for copying point cloud files in binary format.

• Raster SQL: Added support for configuring the PROJ_LIB and GDAL_DATA environment variables.

Bug fixes

• Raster SQL: Fixed an unexpected exit when an invalid OSS path is specified.

• Raster SQL: Fixed inconsistencies between imported SRIDs and the original SRIDs of specific rasters.

New features

• Raster SQL: Added MD5 functions for data consistency checks and deduplication:

  • ST_MD5Sum to query the MD5 value of a raster.

  • ST_SetMD5Sum to set the MD5 value of a raster.

• Raster SQL: Added AccessKey authentication functions for rasters stored in OSS buckets:

  • ST_AKId to query the AccessKey ID of a raster stored in an OSS bucket.

  • ST_SetAccessKey to set the AccessKey ID and AccessKey secret for accessing a raster object in an OSS bucket.

  • ST_AKId to set the AccessKey ID of a raster stored in an OSS bucket.

  • ST_SetAKSecret to set the AccessKey secret of a raster stored in an OSS bucket.

• Raster SQL: Added the following metadata management functions:

  • ST_ScaleX to query the pixel width on the x-axis of the spatial reference system.

  • ST_ScaleY to query the pixel width on the y-axis of the spatial reference system.

  • ST_SetScale to set the pixel width of a raster in the spatial reference system.

  • ST_SkewX to query the skew on the x-axis.

  • ST_SkewY to query the skew on the y-axis.

  • ST_SetSkew to set the skew of a raster in the spatial reference system.

  • ST_UpperLeftX to query the x-coordinate of the upper-left pixel.

  • ST_UpperLeftY to query the y-coordinate of the upper-left pixel.

  • ST_SetUpperLeft to set the coordinates of the upper-left pixel.

  • ST_PixelWidth to query the pixel width in the spatial reference system.

  • ST_PixelHeight to query the pixel height in the spatial reference system.

Bug fixes

• Fixed extension upgrade failures caused by aggregate functions being invoked during the upgrade process.

New features

• Raster SQL: Added ST_Clip to clip objects based on pixel coordinates.

Bug fixes

• Fixed an incorrect function name for ST_NearestApproachDistance.

• Raster SQL: Fixed ST_MosaicFrom exiting unexpectedly.