PolarDB:Release notes for the spatio-temporal database

Category

Description

Performance optimization

• Geometry SQL

  • The performance of the ST_As3DGrid function is optimized.

Category

Description

Performance optimization

• Raster SQL

  • The ST_PointValues function is optimized. When the Inverse Distance Weighting (IDW) interpolation algorithm is used, the weight coefficient is calculated based on the square of the distance to enhance the influence of nearby points on the interpolation result. This improves the calculation accuracy in raster data analysis scenarios that are sensitive to local changes.

Fixed issue

• Geometry SQL

  • Fixed an issue where a spatial relationship check could cause a crash due to a random pointer in the in-memory index when a MultiPolygon contained an EMPTY object.

  • Fixed an issue where a k-Nearest Neighbors (kNN) query would return an ERROR: index returned tuples in wrong order error.

Category

Description

Fixed issues

• Raster SQL

  • Fixed an issue where nodata values were included in calculations for the ST_PointValues function.

  • Fixed an issue where the nodata value in a Raster object was incorrect for the ST_Contour function.

Category

Description

New features

• Graph SQL

  • Added the age_create_prop_index function to create property indexes for graph models.

  • Added parameters for graph database settings:

    • Added the age_create_vertex_insert_trigger function to create INSERT triggers for vertex tables.

    • Added the age_create_vertex_update_trigger function to create UPDATE triggers for vertex tables.

    • Added the age_create_vertex_delete_trigger function to create DELETE triggers for vertex tables.

    • Added the age_create_edge_insert_trigger function to create INSERT triggers for edge tables.

    • Added the age_create_edge_update_trigger function to create UPDATE triggers for edge tables.

    • The age_create_edge_update_trigger function creates an edge list delete trigger.

Performance optimization

• Raster SQL

  The performance of the ST_PointValues function is improved by leveraging the data block cache.

• Utility SQL

  The ST_3DGridPath function supports 3D pathfinding with no barriers.

Fixed issues

• Utility SQL

  Fixed an issue where the database would crash when 3D pathfinding was used.

Category

Description

Fixed issues

• Trajectory SQL

  Fixed an issue where the ST_{2D|2DT|3D|3DT}DWithin function returned incorrect or unexpected results when trajectories and bounding boxes (BOXNDF) specified in the function intersect.

• Raster SQL

  Fixed an issue where raster tables failed to be created when Data Transmission Service (DTS) was configured to capture DDL operations.

Category

Description

New features

• Geometry SQL

  • Multi-bounding box spatial indexing can be used for geometric objects to improve spatial query performance.

  • The following parameters for multi-bounding box spatial indexing are added:

    • The ganos.geometry.mbbox_split_mode parameter specifies the method used to split a geometric object into multiple bounding boxes.

    • The ganos.geometry.mbbox_split_length parameter specifies the length of each bounding box segment.

    • The ganos.geometry.mbbox_split_points parameter specifies the number of points included in each bounding box segment.

    • The ganos.geometry.mbbox_split_max_segments parameter specifies the maximum number of bounding box segments into which a geometric object can be split.

• Trajectory SQL

  The following functions for trajectory data segmentation are added:

  • The ST_DumpPoints function splits a trajectory into individual points.

  • The ST_DumpSegments function splits a trajectory into continuous segments.

• Graph SQL

  Multi-label queries are supported.

• Polar_AI SQL

  • The AI_ModelCacheLists function is added to return the list of currently cached models.

  • The polar.ai.lru_entity_size parameter is added to specify the model cache size.

Fixed issues

• Trajectory SQL

  Fixed an issue where the ST_intersection function returned the coordinates for stationary trajectory points as NaN.

Category

Description

New features

• The Polar_AI module is added. This module lets you manage and invoke AI models within a database system using standard SQL.

• Polar_AI SQL

  • The following model management functions are added:

    • Added the AI_CreateModel function to create an AI model.

    • Added the AI_AlterModel function to modify the information of an AI model.

    • Added the AI_SetModelToken function to set token information for one or more AI models.

    • Added the AI_CallModel function to call an AI model.

    • Added the AI_DropModel function to delete an AI model.

  • The following helper functions are added:

    • Added the AI_ResizeImage function to resize an image.

    • Added the AI_ImageAsBase64 function to convert an image into a Base64 string.

    • Added the AI_ImageFromBase64 function to convert a Base64 string into an image.

    • Added the AI_LoadFile function to load a file from OSS.

  • The following GUC parameters are added:

    • Added the polar.ai.http_keep_alive parameter to specify whether to keep the HTTP connection alive.

    • Added the polar.ai.http_timeout_mesc parameter to set the HTTP connection timeout.

    • Added the polar.ai.retry_times parameter to set the number of retries for a failed HTTP request.

    • Added the polar.ai.retry_interval_msec parameter to set the interval between retries for a failed HTTP request.

• Trajectory SQL

  The ST_LeafN function is added to obtain the Nth sub-trajectory point.

Fixed issues

• Trajectory SQL

  • Fixed an issue where the use of multi-bounding box indexes in queries for trajectories across different dimensions may lead to unstable or inconsistent results.

  • Fixed an issue where the ST_AsTable function replicated the value in the first row of a string column to all subsequent rows in the column.

Category

Description

New features

• Raster SQL

  The ST_PointValues function is enhanced. Resampling parameters are added to the function to support resampling based on the surrounding values.

Fixed issues

• Trajectory SQL

  • Fixed an issue where a memory leak may occur during trajectory data parsing.

  • Fixed an issue where the ST_intersection function returned a line when the two geometries specified in the function intersect at a point.

• TSDB SQL

  Fixed an issue where the ganos_tsdb extension cannot be upgraded in the process in which it is running.

Category

Description

New features

• Raster SQL

  Added the postgis_raster compatibility mode to support Raster data on PostGIS 3.X.

• TSDB SQL

  Added the TSDB plugin to support advanced features for time series computing.

Fixed issues

• Trajectory SQL

  Fixed an issue where the ST_2DIntersects function incorrectly handled single-point trajectories.

• FDW SQL

  Fixed an issue where a crash occurred when the query condition was empty in Cached Plan mode.

Category

Description

New features

• Trajectory SQL

  Added the ST_AccompanyIntervals function. The function calculates the intervals during which two trajectories run in a specific proximity to each other and returns the intervals or corresponding sub-trajectories.

• Added the MapMatching module to correct and adjust trajectories using road network data.

• MapMatching SQL

  • Added the ST_MapMatching function, which aligns the input trajectory with road network data and returns geometric objects that represent the corrected, aligned trajectory.

  • The OSMNT driver format is supported to allow you to import PBF-based OSM data into the road network structure.

  • The following functions that manage map matching workspaces are added:

    • Added the ST_CreateWorkspace function to create a map matching workspace.

    • Added the ST_LoadWorkspace function to load a map matching workspace, which loads the road network topology into memory.

    • Added the ST_ClearWorkspace function to clear the in-memory topology structure of the map matching workspace.

    • Added the ST_DropWorkspace function to remove a map matching workspace.

Performance optimization

• Geometry SQL

  The ST_AsGeoJSON function is enhanced to support the Record input type.

Fixed issues

• Geometry SQL

  Fixed an issue where indexes cannot be used for join operations in PolarDB for PostgreSQL 14 clusters.

• Trajectory SQL

  • Fixed an issue where the result of the ST_intersection function was incorrect.

  • Fixed an issue where the ST_Split function did not operate as expected when the cut_point.max_point parameter was used in the function.

• GeomGrid SQL

  Fixed an issue where the ST_AsGrid function failed to correctly convert empty objects.

• Graph SQL

  Fixed an out-of-memory (OOM) issue that occurred when a B-tree index was created on a specific attribute in the database.

Category

Description

New features

• Graph SQL

  Added the graph computing module. This module lets you use a relational database to compute graph problems. For more information, see Apache AGE.

Performance optimization

• Raster SQL

  The ST_MapAlgebra function is enhanced to support the arctan2 function. This function calculates the arctangent of a point (y, x) and is equivalent to the C function atan2.

Fixed issues

• Geometry SQL

  Fixed an issue where the database would crash if you input an EWKT geometric object with an SRID that did not contain a semicolon (;).

• Trajectory SQL

  Fixed a spelling error in the protobuf definitions for the ST_AsProtobuf and ST_TrajFromProtobuf functions. The word FiledType is corrected to FieldType.

• GeomGrid SQL

  The level parameter of the ST_As3DGrid, ST_AsText, ST_GridLevelFromZ, and ST_GridLevelAsZ functions is changed to _level. This fixes an issue where extensions failed to be created in Oracle-compatible versions.

Category

Description

Fixed issues

• Geometry SQL

  Fixed an issue where the calculations of spatial topological relationships for LineString became unstable or generated inconsistent results when all point coordinates of the LineStrings were identical.

• Raster SQL

  Fixed an issue where a grid event trigger may cause other triggers to be deleted.

• Trajectory SQL

  Fixed an issue where the ST_TrajFromProtobuf function was unstable in specific scenarios.

• Sfmesh SQL

  Fixed an issue where an excessively long reference path in an sfmesh object may cause a crash.

Category

Description

New features

• Trajectory SQL

  • The ST_CrossingPoints function is added to identify the points at which a trajectory intersects with a specific geometry.

  • The ST_TrajFromProtobuf function is added to decode data in the Protobuf format into trajectory data. The ST_AsProtobuf function is added to encode trajectory data into the Protobuf format.

  • The ST_TrajMerge function is added to combine multiple trajectories into a single, continuous trajectory.

Performance optimization

• SfMesh SQL

  The computational efficiency of the ST_3DIntersects function is optimized.

Fixed issues

• Geometry SQL

  Fixed an issue where the ST_GeomFromGeoJSON function would crash.

• Raster SQL

  • Fixed an issue where the ST_AsTile function would crash in specific scenarios.

  • Fixed an issue where the ST_CreateRast function would crash in specific scenarios.

• Scene SQL

  Fixed an issue where the ST_ScaleImage function would crash in specific scenarios.

• Utility SQL

  Fixed an issue where the ST_3DGridPath function would crash in specific scenarios.

Category

Description

Fixed issues

• Raster SQL

  • Fixed an issue where a memory exception occurred when the ST_HMTAsRaster function converted heatmap tiles into raster objects.

  • Fixed an issue where the ST_MosaicTo function would crash in specific scenarios.

• Trajectory SQL

  • Fixed an issue where the ST_makeTrajectory function would crash when it received a NULL attribute.

  • Fixed an issue where a crash occurred when a JSON object whose events attribute was set to NULL was used to create a trajectory.

• Scene SQL

  • Fixed an issue where a crash occurred due to abnormal OpenSceneGraph Binary (OSGB) data.

  • Fixed an issue where a crash occasionally occurred during SFMesh to GL Transmission Format (GLTF) conversion.

  • Fixed an issue where a crash occurred when a pointer became invalid after a failed or an interrupted SQL operation.

• Utility SQL

  Fixed an issue where the import tool would crash in specific scenarios.

Category

Description

New features

• Geometry SQL

  The ST_TimeZone function is added to obtain the time zone information of a geometry point.

• Raster SQL

  The ganos.raster.max_cache_size parameter is added to the ST_ImportFrom function to fix the out-of-memory (OOM) issue that occurs when a large amount of data is imported.

Performance optimization

• Scene SQL

  The compression and decompression of JPEG images are accelerated.

Fixed issues

• Geometry SQL

  • Fixed an issue where a crash occurred when the execution cache of a geometry was released.

  • Fixed an issue where the elastic parallel query (ePQ) feature was unavailable for an index named support in PolarDB for PostgreSQL 14.

• Trajectory SQL

  Fixed an issue where the ST_intersection function cannot handle scenarios in which a line on a trajectory and a specific geometry intersect at multiple spatial points.

Category

Description

New features

• Trajectory SQL

  The ST_InsertAttr function is added to add new attributes to trajectories.

• GeomGrid SQL

  The ST_Degeneralize function is added to decompose a lower-level grid into a higher-level grid.

• SfMesh SQL

  • The ST_YupToZup function is added to convert a coordinate system from Y-up to Z-up.

  • The ST_ZupToYup function is added to convert a coordinate system from Z-up to Y-up.

  • The ST_TileOption function is added to query the custom tile options of an sfmesh object.

  • The ST_SetTileOption function is added to configure a custom tile option for an sfmesh object.

  • The ST_HasTileOption function is added to check whether an sfmesh object has custom tile options.

  • The ST_ClearTileOption function is added to clear the tile options that you specified for an sfmesh object.

• Utility SQL

  • The 3D grid pathfinding feature is added.

    • The GridCost data type is added to specify the cost of grid paths.

    • The ST_MatchGridLevel function is added to determine the highest available grid level based on terrain elevation data.

    • The ST_SetCost function is added to assign a cost value to an array of specified grids.

    • The ST_CostUnion function is added to merge the costs of all arrays of grids.

    • The ST_3DGridPath function is added to calculate paths using a 3D grid system.

Performance optimization

• Geometry SQL

  • The compatibility of the Ganos_Geometry extension is enhanced. The Ganos_Geometry extension can coexist with the PostGIS extension. You can create the PostGIS extension before you create the Ganos_Geometry extension.

  • The ST_AsHMT function is enhanced to support aggregate functions such as sum, min, max, and avg.

• Raster SQL

  • The ST_MosaicFrom function is enhanced to implement color balancing using the gamma correction technology.

  • The ST_ImportFrom function is enhanced. You can specify the schema in which chunk_table is located.

• SfMesh SQL

  • The ST_AsGltf and ST_AsGlb functions are enhanced.

    • Lets you import userdata into the extras attribute of nodes within the glTF or GLB file structure.

    • Lets you import JSON strings in userdata into the extras attribute of nodes as JSON objects.

    • Accelerates conversion of complex sfmesh objects into glTF.

    • Lets you convert geometric objects or child objects by specifying conversion options.

  • Lets you specify whether to convert sfmesh objects or geometry objects of specified child objects when you convert sfmesh objects into 3DTiles.

  • The ST_Affine function is enhanced to support multiplication of two transformation matrixes.

• Utility SQL

  The ST_As3dTiles function is enhanced to improve conversion performance.

Fixed issues

• Geometry SQL

  Fixed an issue where the ST_AsHMT function returned incorrect clipping results for specific polygon data.

• Raster SQL

  Fixed an issue where bands were missing if the number of bands specified in a ST_MosaicFrom function was greater than 3.

• Trajectory SQL

  Fixed an issue where the ST_lcsSimilarity function cannot handle single-point trajectories.

• Utility SQL

  Fixed an issue where the IFCSpace of specific IFC data imported by the ST_ImportIFC function was incorrect.

Category

Description

New features

New features

• Geometry SQL

  The elliptical arc and Bezier curve parametric objects are added.

• Raster SQL

  The ST_AsTile function is added. This function lets you specify a Geometry to obtain a tile whose size is 256 or 512.

• GeomGrid SQL

  • GiST 2D spatial indexes are added for GeomGrid and H3Grid, which enhances spatial queries involving GeomGrid (or H3Grid) && Geometry, GeomGrid (or H3Grid) ~ Geometry, and GeomGrid (or H3Grid) @ Geometry.

  • The ST_AsMVTGeom function is added to convert a geographic grid object to a geometry object in the tile coordinate system. The geographic grid object is of the GeomGrid or H3Grid data type.

• Utility SQL

  The ST_ValidateOSGB function is added to verify OSGB data and obtain a list of missing files or incorrect files.

Performance optimization

• Geometry SQL

  The ST_AsHMT function is enhanced to optimize the processing of geometric objects that fall within a single mesh. This improves performance.

• Raster SQL

  • The read capability of raster chunks is enhanced, and in-place memory parsing is used to improve performance.

  • The ST_ImportFrom function is enhanced. The mapping_oss_file parameter is supported when data is imported using MinIO buckets and Hadoop Distributed File System (HDFS) files. This improves import performance.

  • Raster statistics can be automatically calculated during raster import.

    • The ST_ImportFrom function is enhanced. Parameters such as compute_stats and approx are added to support automatic calculation of raster statistics during raster import.

    • The ST_CreateRast function is enhanced. Parameters such as compute_stats and approx are added to support automatic calculation of raster statistics during raster import.

  • The raster statistics can be updated.

    • The ST_ComputeStatistics function is enhanced to overwrite existing statistics.

    • The ST_SummaryStats function is enhanced to overwrite existing statistics.

  • The name field in the attributes can be set to the name of the raster file when you create or import a raster.

    • The ST_ImportFrom function is enhanced. By default, the name field in the attributes is the name of the raster file.

    • The ST_CreateRast function is enhanced. By default, the name field in the attributes is the name of the raster file.

Fixed issues

• Geometry SQL

  Fixed an issue where the "Invalid dimension" error message appeared when the AddGeometryColumn function was invoked to register a geometry column.

• Raster SQL

  • Fixed an issue where an OOM error may occur when the ST_SummaryStats function was invoked to calculate pixel value statistics.

  • Fixed an issue where the system may stop responding when the object to be merged was clipped.

• Geometry Pyramid SQL

  Fixed an issue where the ST_BuildPyramid function failed to create a vector pyramid for a spatial geometry data table if the name of the table included a schema name, such as ST_BuildPyramid('a.table'...).

Category

Description

New features

• New features

  • Geometry SQL

  • A function used to dynamically generate tiles is added. The function generates tiles that have smaller sizes than the tiles generated using the ST_AsMVT function.

    • The ST_AsMVTEx function is added. Compared with the ST_AsMVT function, the ST_AsMVTEx function filters vectors that have fewer impacts on the display effect based on the relationships between different vectors. This reduces the size of Mapbox Vector Tiles (MVTs) and improves visualization efficiency. The scale_factor parameter is added to control filter effects. The mvt_size_limit parameter is added to limit the maximum number of vectors that an MVT can contain.

  • The heatmap of a specific window can be calculated.

    • The ST_AsHMT function is added to specify the window range and pixel size for heatmap statistics.

    • The ST_HMTAsArray function is added to specify the output array format of heatmap tiles.

    • The ST_HMTStats function is added to calculate the statistical value of heatmap tiles.

  • Raster SQL

    The ST_HMTAsRaster function is added to convert heatmap tiles into Raster objects for subsequent analysis and computing.

  • Trajectory SQL

    The ST_AsHMT function is added to specify the window range and pixel size for heatmap statistics.

  • SfMesh SQL

    • The ST_SnapToPolygon function is added to support smooth fitting of terrain to 3D polygon roads.

    • The ST_RayIntersection function is added to batch calculate the intersection between the terrain and parallel rays.

  • Scene SQL

    • The ST_ComputeViewShedSurface function is added to calculate the visible surface in the field of view.

    • The cast function is added to convert sfmesh data into scene data. After the conversion, GLB-based scene data is generated.

  • Importer SQL

    • The ST_As3dTiles function is added to convert sfmesh data into 3D tiles for preview.

    • The ST_ImportObj function is added to convert geometry objects into sfmesh data.

  • GeomGrid SQL

    • The ST_AsH3Grid function is added to convert geometry objects into arrays of H3 cell IDs.

    • The ST_GridDisk function is added to return all H3 cells within grid distance k from the origin H3 cell.

    • The ST_GridRing function is added to return all H3 cells at grid distance k from the origin H3 cell.

    • The ST_GridPath function is added to query the path between two H3 cells.

    • The ST_GridDistance function is added to query the grid distance between two H3 cells.

    • The h3grid data type is added to support B-tree indexes.

Performance optimization

• SfMesh SQL

  • The ST_3DRemoveDuplicateVertex function is enhanced to weld the vertices of an sfmesh object at a specific welding distance.

  • The ST_AsGlb function is enhanced to use Draco for compression to obtain a smaller data size.

• Scene SQL

  The ST_AsB3DM and ST_AsGLB functions are enhanced to use Draco for compression to obtain a smaller data size.

Fixed issues

• Geometry SQL

  • Fixed an issue where an error message indicating that the function is not unique was reported when multiple extensions were created at the same time and the ST_DWithin function was invoked in text mode.

  • Fixed an issue where an error may occur when the ST_AsMVTGeomEx function used the clip=true parameter in the geometry module.

• Raster SQL

  • Fixed an issue where specific records were missing in the result when you specified specific bands in the ST_Values function.

  • Fixed an issue where specific records were missing in the result when you specified a range that exceeded the raster range in the ST_Values function.

  • Fixed the memory leak issue of the ST_MosaicFrom function.

  • Fixed an issue where data inaccuracy was caused by data length overflow in the ST_ExportTo function.

• Trajectory SQL

  • Fixed an issue where the NULL value was not supported in multi-bounding box indexes of a trajectory.

• Scene SQL

  • Fixed an issue where the system crashed when it parsed nonstandard OSGB data that had topology errors.

  • Fixed the accurate memory release issue of the st_3dclip function.

• Importer SQL

  • All names of imported tables use lowercase letters to improve table queries.

  • Fixed an issue where the import failed because the OSG import path contained forward slashes (/).

Category

Description

New features

• New features

  • GeomGrid SQL

    • Uber H3 indexes are supported.

      • The H3Grid data type is added to allow you to specify H3-encoded grid objects.

      • The ST_H3FromLatLng function is added to obtain an H3 grid object at specified latitude and longitude.

      • The ST_H3FromText function is added to convert an H3-encoded grid object of the STRING type into an H3grid object.

      • The ST_H3FromInt function is added to convert an H3-encoded grid object of the BIGINT type into an H3grid object.

      • The ST_AsInt function is added to convert an H3grid object into an H3-encoded grid object of the BIGINT type.

      • The ST_Parent function is added to obtain the parent grid of an H3-encoded grid at a specific level.

      • The ST_Children function is added to obtain the child grid of an H3-encoded grid at a specific level.

  • Geometry SQL

    • Functions that are used for random sampling and pixel filtering are added to reduce the sizes of dynamically generated tiles.

      • The ST_IsRandomSampled function is added to obtain a Boolean value based on user-provided property values and sample rates. The Boolean value indicates whether the record is sampled.

      • The ST_AsMVTGeomEx function is added. Compared with the ST_AsMVTGeom function, the ST_AsMVTGeomEx function filters vectors that have fewer impacts on the display effect based on the relationships between different vectors. This reduces the size of MVTs and improves visualization efficiency.

    • The support for the GEOGRAPHY data type is enhanced.

      • The ST_LineSubstring function supports the GEOGRAPHY data type and lets you obtain subsegments based on spherical distances.

      • The ST_LineInterpolatePoint function supports the GEOGRAPHY data type and lets you obtain points based on spherical distances.

      • The ST_LineInterpolatePoints function supports the GEOGRAPHY data type and lets you obtain interpolated points based on the spherical distance.

      • The ST_LineLocatePoint function supports the GEOGRAPHY data type and lets you obtain the closest distance percentage based on the spherical distance.

  • Raster SQL

    • The ST_Polygonize function is added to vectorize raster objects.

  • Scene SQL

    • The ST_ShadowRatio function is added to calculate the shadow ratio of a single point or multiple points over a period of time or at a point in time.

Performance optimization

• GeomGrid SQL

  • The ST_AsGeometry, ST_AsText, ST_AsBinary, and ST_Level functions are enhanced to support the h3grid type.

• Raster SQL

  • The ST_Statistics function is enhanced to collect statistics on geometries of any type.

• FDW SQL

  • FDW SQL is enhanced to support UTF-8-encoded file names or field names.

• Scene SQL

  • The ST_AsB3DM function is enhanced to export an object from the GL Transmission Format Binary (GLB) format to the batched 3D model (B3DM) format.

Fixed issues

• GeomGrid SQL

  • Fixed an issue where the ST_AsGrid function encountered incorrect grid computing at specific levels.

• Geometry SQL

  • Fixed an issue where vector pyramids were incompatible with the metadata of Ganos 3.7.

  • Fixed an issue where the ST_Union function failed when an extension update was not performed.

• Raster SQL

  • Fixed an issue where the band parameter of the ST_Contour function started from 0. The ST_Contour function is used to generate contour lines or contour planes.

• Trajectory SQL

  • Fixed an issue where the trajectory module cannot be installed because the module depends on pg_type.

• Importer SQL

  • Fixed an issue where the ST_ImportOSGB function failed when you import OSGB data.

Category

Description

New features

GeomGrid SQL provides the GeoSOT 3D grid code feature.

• The ST_AsBox3D function is added to obtain the box3d-type spatial range of a 3D geographic grid.

• The ST_AsMeshGeom function is added to obtain the meshgeom-type spatial range of a geographic grid.

• The ST_GridLevelFromZ function is added to calculate the height of a geographic grid based on the altitude.

• The ST_GridLevelAsZ function is added to convert the height of a geographic grid into an altitude.

• The ST_HasZ function is added to determine whether a geographic grid contains the Z dimension.

• The ST_Level function is added to obtain the gridding level of a geographic grid.

• The ST_Generalize function is added to aggregate a geographic grid from a high level to a low level.

• The ST_3DIntersects function is added to determine whether the spatial range of a 3D geographic grid intersects with a geometry.

• The ST_3DContains function is added to determine whether the spatial range of a 3D geographic grid includes a geometry.

• The ST_3DWithin function is added to determine whether the spatial range of a 3D geographic grid is included by a geometry.

• The ST_As3DGrid function is added to convert a 3D geometry into a geographic grid.

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

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

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

Performance optimization

• GeomGrid SQL

  • The ST_AsText function is enhanced to convert a 3D geographic grid into encoded text.

  • The ST_GridFromText function is enhanced to convert the encoded text of a 3D geographic grid into a geographic grid.

• Raster SQL

  • The ST_Statistics function is enhanced to support pixel statistics on any spatial object.

  • The ST_ImportFrom function is enhanced to import Hierarchical Data Format version 5 (HDF5) subdatasets.

  • The ST_CreateRast function is enhanced to import HDF5 subdatasets.

• Scene SQL

  • The gateway data type supports OSGB objects stored in OSS.

  • The ST_ComputeViewShed function is optimized.

• Importer SQL

  • OSS-based OSGB data can be imported in gateway mode.

Fixed issues

• Raster SQL

  • Fixed an issue where the ST_InterpolateRaster function would crash.

  • Fixed an issue where the minimum values of Double and Float were incorrect.

• SfMesh SQL

  • Fixed an issue where the buffer surface of the ST_3DBuffer function was abnormal when the angle between the linestrings was too small.

• Trajectory SQL

  • Fixed an issue where the multi-bounding box index of a trajectory did not support NULL or a trajectory that had only one point.

Category

Description

New features

• The ST_AsMVT3D and ST_AsMVTGeom3D functions are added to support the 3D vector slices of 3D geometries.

• The ST_AsTableFormat function is added to provide the data type of the return value when the ST_AsTable function is invoked for a trajectory.

• OSS-based glTF and glb files can be imported into databases as sfmesh objects.

  • The ST_ImportGLTF function is added to import glTF files.

  • The ST_ImportGLB function is added to import glb files.

Fixed issues

• Fixed an issue where the ST_intersection function incorrectly determined the intersection of two overlapping segments.

Category

Description

New features

• The S​T_MosaicFrom function is enhanced to support parallel operations.

• The S​T_MosaicFrom function is enhanced to support mosaic operations on raster objects of different resolutions and projections.

• The Importer SQL references are added.

  • The ST_ImportOSGB function is added to import an OSGB file from OSS into a database based on a fixed table schema.

  • The ST_ImportIFC function is added to import an IFC file from OSS into a database based on a fixed table schema.

• Models of scene data types can be merged.

  • The ST_CombineMeshes function is added to merge multiple meshes in a scene object.

  • The ST_CombineTextures function is added to merge multiple textures in a scene object.

  • The ST_Combine function is added to merge multiple scene objects.

• Visual analysis and computation of scene data types are supported.

  • The ST_ComputeFrustum function is added to compute viewing frustums.

  • The ST_ComputeViewShed function is added to compute viewsheds.

• SFMesh function changes

  • The ST_FromSuperMap function is added to convert a hypergraph-based sfmesh object into a World Geodetic System 1984 (WGS84)-based sfmesh object.

  • The ST_3DIntersects functions is enhanced to quickly compute the intersection of axis-aligned box3d and Meshgeom objects.

  • The ST_3DContains function is enhanced to quickly determine the inclusion of a single point in a solid meshgeom object.

Fixed issues

Fixed an issue where unexpected downtime occurred when you invoked the ST_makeTrajectory function to construct a two-point trajectory using the start time and end time of the trajectory.

Category

Description

New features

• The ST_ClusterDBSCAN function is added to support the density-based spatial clustering of applications with noise (DBSCAN) algorithm in a latitude and longitude coordinate.

• The ST_CurveRecognize function is added to identify the curve of a trajectory and the curvature radius.

• The ST_AsGrid function is optimized to compute degenerated grids in 2D.

• The pgRouting plugin is upgraded to 3.4.2.

• The following functions are added to configure enhanced settings for sfmesh materials and textures:

  • The ST_SetTexture function is added to support texture settings.

  • The ST_SetMaterial function is added to support material settings.

• The ST_Collect function is added to merge sfmesh object nodes.

Category

Description

New features

• The PostGIS plugin is now compatible with version 3.3.2.

• The ST_Angle function is added to obtain each rotation angle of a trajectory as an array.

• The ST_CurvatureRadius function is added to obtain each curvature radius of a trajectory as an array.

• The meshgeom and sfmesh data types can be created from Polyhedral Surface and TIN data types.

• You can set and obtain user-defined binary data from sfmesh and material data types.

  • The ST_BinData function is added to obtain binary data.

  • The ST_SetBinData function is added to set binary data.

  • The ST_HasBinData function is added to check whether user-defined binary data is obtained.

  • The ST_ClearBinData function is added to clear binary data.

• The ST_Affine function replaces the transformation matrix of actual coordinates with the transformation matrix of the root node coordinates.

• NULL objects can be used in sfmesh objects as empty nodes for placeholder purposes.

• The ST_FlipCoordinates and ST_SwapOrdinates functions replace the transformation matrix of actual coordinates with the transformation matrix of the node coordinates.

• You can set and obtain information about nodes in sfmesh objects.

  • The ST_NodeID function is added to query node IDs.

  • The ST_SetNodeID function is added to set node IDs.

Fixed issues

• Fixed an issue where the trajectory ST_AsTable function crashed when the x,y,t dimension was NULL.

• Fixed an issue where the index number of a node in an sfmesh object was incorrect in specific scenarios.

• Fixed an issue where the result was incorrect when an SRID contained in a Meshgeom object was converted into a well-known text (WKT) output.

• Fixed an issue where degenerate polygons in meshgeom objects cannot be triangulated.

• Fixed an issue where an analysis or computation error occurred when sfmesh nested expressions were used.

Category

Description

New features

• The conversion between the GeoHash strings and Int-type values is supported.

  • The ST_GeoHashID function is added to convert GeoHash strings into integer-type values.

  • The ST_GeoHashFromID function is added to convert Int-type values into GeoHash strings.

• The partial update feature is supported by vector pyramids that are used to accelerate data display.

  • The ST_UpdatePyramid function is added to update a vector pyramid.

  • The ST_SetUpdatePyramidRules function is added to configure a rule to update a vector pyramid.

  • The ST_BuildPyramidUseGeomSideLen function is added to build a vector pyramid that accelerates data display based on the size of the vector bounding box.

• The ST_InterpolateRaster function is added to support spatial interpolation.

• The ST_Contour function is added to generate contours.

• The ST_Statistics function is added to collect statistics on and analyze custom weights of raster data in MultiPoint mode.

• The ST_Resample function is added to resample a trajectory.

• The ST_Density function is added to calculate the density of a trajectory.

• The ST_StayPoint function is added to identify the stay points of a trajectory.

• Scene data types can be pruned and simplified.

  • The ST_Intersection function is added to prune gltf and osgb models.

  • The ST_Simplify function is added to simplify geometry data for gltf and osgb models.

  • The ST_ScaleImage function is added to simplify image data for the gltf and osgb models.

• The ST_UserData function is added to access user-defined attribute data.

• The ST_ECEFToENU function is added to convert Earth-centered Earth-fixed (ECEF) coordinates into east-north-up (ENU) coordinates.

Fixed issues

• Fixed an issue where the raster object became empty after the st_buildhistogram function was invoked.

• Fixed an issue where downtime and z-value errors occurred due to the null values of the ST_AsTable function.

• Fixed an issue where incorrect results were returned when the GeoHash mode was used for the ST_Split function.

• Fixed an issue where errors occurred in attribute field encoding for the ST_Tile function.

Category

Description

New features

• The ST_3DIntersection and ST_3DDifference functions are added to calculate the spatial intersection and difference of two 3D models.

• The following functions are added to convert mesh object coordinates:

  • The ST_SwapOrdinates function is added to swap the coordinates of two dimensions.

  • The ST_FlipCoordinates function is used to interchange the x and y coordinates.

• MESHGEOM objects are enhanced to support empty normal vectors and texture coordinates.

Fixed issues

• Fixed an issue where if you did not calculate the percentage of raster data, raster data queries may cause system downtime.

• Fixed an issue where when a mesh object contained multiple referenced objects, an error message appeared, indicating that the lengths were inconsistent.

Category

Description

New features

• The ST_Intersection aggregate function is added to aggregate an array of geometry objects.

• The ST_AddZ function is added to accept an array of z-axis values as a parameter and convert 2D or 3DM geometry into 3D or 4D geometry.

• The ST_SetValue function is enhanced to allow you to set pixel values based on the spatial range of a geometry object.

• The ST_ExportTo function is enhanced to export raster objects as Cloud Optimized GeoTIFF (COG) files.

• The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects.

• The ST_Split function is enhanced to allow you to specify the start time when you want to split a trajectory by time. The ST_Split function also lets you split a trajectory by trajectory point ordinal number.

Fixed issues

• Fixed an issue where the ST_makeTrajectory function may cause system downtime.

• Fixed an issue where the ST_lcsSimilarity function cannot recognize a time range measured in days.

• Fixed an issue where the ST_AsEWKB function cannot convert trajectories created from data tables.

• Fixed an issue where a memory usage error occurred when the ST_BuildPyramid function was invoked to create a vector pyramid based on a large amount of data.

Category

Description

New features

• The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes.

• The ST_SetValue function is added to allow you to specify pixel values at specific pixel positions.

• HDFS-based operations on raster data are supported.

  • The ST_CreateRast function is enhanced to create raster data based on HDFS.

  • The ST_ImportFrom function is enhanced to import raster data based on HDFS.

  • The ST_ExportTo function is enhanced to export raster data to the HDFS file system.

Category

Description

New features

• The ST_makeTrajectory function is enhanced to convert rows in a table into trajectories.

• The ST_AsTable function is added to convert trajectories into tables.

Fixed issues

Fixed an issue where anonymous temporary tables cannot be automatically deleted during raster data operations.

Category

Description

New features

• Raster data can be accessed using self-managed MinIO servers. For more information, see Object storage paths.

• The ST_PointValues function is added to obtain the pixel values of all bands.

Fixed issues

• Fixed an issue where the ST_Clip function returned an incorrect order of bands.

• Fixed an issue where missing indexes on primary keys caused low performance during raster updates.

• Fixed an issue where retries were not supported when you cannot access the trajectory objects stored in an OSS bucket.

Category

Description

New features

GanosBase is supported in PostgreSQL 14.

Feature optimizations

The size of the cache for trajectory objects stored in external storage media is increased to improve access performance.

Fixed issues

• Fixed an issue where file suffixes were missing when raster data was exported to OSS.

• Fixed an issue where statistics were not collected for specific raster data.

Category

Description

New features

• The ST_LinearStretch function is added to linearly stretch a raster and obtain a new raster.

• The ST_BuildPercentiles function is added to calculate the percentiles of the specified bands of a raster.

• The ST_ComputeStatistics function is added to collect all statistics about a raster. The statistics include the histogram and percentiles.

• The ST_Percentile function is added to query the percentiles of the specified bands of a raster.

Performance optimization

• The ST_SummaryStats and ST_BuildHistogram functions support parallel computations.

• The ST_ExportTo function returns false instead of an error message if the specified file already exists.

• The ST_ImportFrom function is optimized. If an import error occurs, the function returns the details of the error. You can troubleshoot the issue based on the error details.

Fixed issues

• Fixed an issue where half a pixel was lost due to number rounding when a raster was cropped.

• Fixed an issue where data of a raster cannot be properly imported or collected if the data contains values such as NAN and INF.

Category

Description

New features

• The ST_PixelAsPolygon function is added to convert a specific pixel of a raster into a Polygon object.

• The ST_PixelAsPolygons function is added to convert the pixels at a specific position of a raster into Polygon objects.

• The ST_PixelAsPoint function is added to convert a specific pixel of a raster into a geometric object that is represented by a specific point of the geometric object.

• The ST_PixelAsCentroid function is added to convert a specific pixel of a raster into a geometric object that is represented by the point in the center of the geometric object.

• The ST_PixelAsPoints function is added to convert a specific pixel of a raster into a geometric object that is represented by the point in the center of the geometric object.

• The ST_PixelAsCentroids function is added to convert the pixels at a specific position of a raster into geometric objects, each of which is represented by the point in the center of the geometric object.

Performance optimization

• Geometry is compatible with PostGIS 3.1.4.

• The ST_AsDatasetFile function can return data in the Grib2 format.

Fixed issues

• Fixed an issue where an incorrect SRID was obtained when raster data was imported in the NetCDF format.

• Fixed an issue where multiple bounding boxes cannot be properly updated when the results of the equals operations on the bounding boxes were incorrect.

Category

Description

Performance optimization

• The ST_ImportFrom function is enhanced to allow Ganos to map an OSS object to an in-memory file. This way, data import is accelerated.

• The operator family trajgist_ops_multi is added for GiST indexing and TrajGisT indexing. You can create a Generalized Search Tree (GiST) index or a TrajGiST index on multiple bounding boxes.

• Vector pyramids are added to support queries of metadata.

Fixed issues

The issue that memory leaks occur when Ganos is used to check whether two trajectories intersect is fixed.

Category

Description

Performance optimization

• The functions that are used to calculate the different values of a raster surface are optimized to obtain rasters rather than pixel matrixes. The functions are ST_Hillshade, ST_Slope, and ST_Aspect.

• The ST_Split function is optimized to split a trajectory into sub-trajectories based on a specific rule.

Fixed issues

The issue that the ST_SrEqual function fails to check whether two spatial reference systems are the same in specific scenarios is fixed.

Category

Description

New features

• The ST_removeDriftPoints function is added to delete the drift points of a trajectory based on a specific rule.

• The ST_Split function is added to split a trajectory based on a specific spatial geometric object.

• The ST_ExportTo function is added to export a trajectory as an external file. Only metadata is retained in the database that stores the trajectory.

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

• The ST_importFrom function is added to migrate a trajectory from the external file that stores the trajectory to the original database.

• The ST_StorageLocation function is added to query the location of an external file of a trajectory.

• The ST_AKID function is added to query the AccessKey ID that is used to read trajectory data from OSS.

• The ST_SetAccessKey function is added to specify an AccessKey pair that is used to read trajectory data from OSS. An AccessKey pair consists of an AccessKey ID and an AccessKey secret. An AccessKey ID is similar to a username, and an AccessKey secret is similar to a password.

• The ST_SetAkId function is added to specify an AccessKey ID that is used to read trajectory data from OSS.

• The ST_SetAkSecret function is added to specify an AccessKey secret that is used to read trajectory data from OSS.

• The ST_SetStorageLocation function is added to specify the storage location of an external file when trajectory data is read from the external file.

• The ST_DeleteGTF function is added to delete the files that contain the exported trajectories from a specific folder.

Fixed issues

• The issue that data cannot be filtered based on strings when a vector pyramid is being created is fixed.

• The issue that layers cannot be displayed when Quantum GIS (QGIS) is connected is fixed.

Category

Description

New features

• The ST_AsDatasetFile function is added to convert a specific part of a raster into a BYTEA-type file.

• The ST_RasterDrivers function is added to query all drivers that are supported by raster data sources in Ganos.

Fixed issues

Fixed an issue where the ST_Clip function encountered reprojection failures when a spatial reference system was specified.

Category

Description

New features

Parallel query of spatial indexes is supported to improve query efficiency.

Performance optimization

The ST_SubRaster function is optimized to convert the pixel types of raster objects and increase the pixel values. The ST_SubRaster function can also be used to convert multi-band remote sensing images into three-band images that can be recognized by AI technologies.

Fixed issues

• Fixed an issue that could cause a database crash during the raster parsing of invalid histogram information.

• Fixed an issue that could cause the database to crash on exit after a projection change operation.

• The issue that Ganos unexpectedly exits when raster data is imported into Ganos is fixed.

Category

Description

New features

• The ST_RPCGeoreference function is added to query the rational polynomial coefficients (RPC) model of a raster.

• The ST_SetRPCGeoreference function is added to specify the RPC model of a raster.

• The ST_RPCRectify function is added to calibrate a raster based on the RPC model of the raster and obtain a calibrated raster.

• A parallel mechanism, which is used to create GiST indexes in parallel, is added.

Fixed issues

The issue that may prevent the pg_dump extension from backing up custom SRIDs is fixed.

Category

Description

New features

Simple storage policies are supported to optimize storage for large spatio-temporal objects.

Performance optimization

If you use a raster object to update another raster object that contains chunked data, the system automatically deletes the chunked data from the target object.

Fixed issues

• The issue that trajectory-related extensions cannot be upgraded is fixed.

• The issue that resampling errors are returned when the Average resampling method is used to resample rasters is fixed.

• Fixed an issue where inaccurate results were returned for queries on a trajectory object when multiple timestamps display the same trajectory point along the trajectory.

• The issue that Ganos exits when geo-spatial objects fail to be converted is fixed. Ganos is optimized to report the causes of the failures.

Category

Description

New features

• Feature signatures are supported for large spatio-temporal objects. This accelerates the process of creating indexes on spatio-temporal data, expedites spatial joins, and optimizes the storage method for spatio-temporal objects. The polar_enable_storage_partial parameter is added. The parameter is used to specify optimized storage for spatio-temporal objects. Optimized storage lets you store the metadata of spatio-temporal objects in-row and store the entity data of spatio-temporal objects off-row. For more information, see Feature signature-based storage optimization for large spatio-temporal objects.

• The ST_ImportFrom function is added to import raster data in parallel.

• The ST_BuildPyramid function is added to build pyramids for rasters in parallel.

• Empty trajectory objects are supported, and null trajectory objects can be returned when the specified requirements are not met.

Fixed issues

• Fixed an issue where the ST_AddZ function returned inaccurate results when the values of input parameters were 16-bit signed integers.

• The issue that the Trajectory module cannot be upgraded is fixed.

• The issue that specific functions of the Trajectory module cannot use indexes is fixed.

• Fixed an issue where some ND functions cannot identify two periods of time that do not intersect and consequently returned the value error instead of the value false.

Category

Description

New features

• The ST_JaccardSimilarity function is added to calculate the similarity between trajectory objects.

• The ST_Transform function is added to convert a trajectory object from a spatial reference system into a different spatial reference system.

Performance optimization

A new parameter is added to specify the spatial extent of a vector pyramid when Ganos cannot automatically calculate the spatial extent of the vector pyramid that you want to build.

Fixed issues

Fixed an issue where the GanosBase data directory was incorrectly set in specific environments.

Category

Description

New features

• A new feature returns image formats from stream-based vector pyramids to enable the rapid display of vector data.

• The JPEG2000 compression algorithm is added. The algorithm is used to compress 16-bit raster data before the data is stored.

Performance optimization

The st_dwithin function is optimized to query distances at higher performance.

Fixed issues

• The issue that an improper intersection of trajectory objects exists on the t axis is fixed.

• The in-memory topology index issue of GanosBase is fixed.

Category

Description

New features

• The ganos_update function is added. You can execute the select ganos_update() ; command to upgrade all extensions of GanosBase to the latest versions.

• Adds the Trajectory data type:

  • Adds support for GiST indexes on trajectory types and provides six operator classes for analysis across different dimensions.

  • Adds the BoxND data type to represent spatiotemporal ranges and store trajectories.

  • Adds intersection (&&), contains (@>), and is contained by (<@) operators for comparisons across different dimensions.

  • Adds four trajectory processing functions: ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin.

  • Adds functionality to collect statistics on trajectory types and estimate scan costs from those statistics.

  • Adds the new TrajGist indexing method for better index selection.

Performance optimization

• Improved query performance for spatio-temporal range queries using two-phase query optimization for GiST indexes.

• Vector pyramid feature improvements:

  • Supports source data with any SRID coordinate and provides tile outputs in the EPSG:3857 and EPSG:4326 coordinate reference systems.

  • Added the pixelSize parameter to aggregate point data and reduce the number of tiles.

Bug fixes

• Fixed an issue that caused Ganos_Raster updates to fail in some cases.

• Fixed an issue where the GanosBase binary file might crash after an update to a new version.

• Fixed an issue of excessive data in the top-level tile when building a vector pyramid for point data with default parameters.

Category

Description

New features

• Adds support for Network Common Data Form (NetCDF) data that contains subsets. You can import the data by specifying layer names.

• Adds support for custom metadata and timing information for raster data:

  • Adds the ST_MetaItems function to get the names of all custom metadata items.

  • Modifies the ST_MetaData function to get custom metadata items and return them in JSON format.

  • Adds the ST_SetMetaData function to set a metadata item.

  • Adds the ST_BeginDateTime function to get the start time of raster data.

  • Adds the ST_EndDateTime function to get the end time of raster data.

  • Adds the ST_SetBeginDateTime function to set the start time of raster data.

  • Adds the ST_SetEndDateTime function to set the end time of raster data.

  • Adds the ST_SetDateTime function to set the start time, end time, and band acquisition time of raster data.

• Adds support for returning raster data in stream-based image formats:

  • Adds the ST_AsImage function to get a stream-based image format.

  • Adds the ST_AsPNG function to get a stream-based PNG image format.

  • Adds the ST_AsJPEG function to get a stream-based JPEG image format.

• Adds support for the spatial grid data type and related operations:

  • Adds the geomgrid data type.

  • Adds the ST_AsText function to transform grid data into a text representation.

  • Adds the ST_AsGeometry function to transform grid data into geometry data.

  • Adds the ST_AsBinary function to transform grid data into binary data.

  • Adds the ST_AsBox function to transform grid data into BOX data.

  • Adds the ST_AsGrid function to compute the corresponding geometric grid data for geometry data.

  • Adds the ST_GridFromText function to transform a text-based grid representation into geometric grid data.

  • Adds the ST_GridFromBinary function to transform a binary-based grid representation into geometric grid data.

  • Adds the ST_Intersects function to check if grid data and geometry data intersect.

  • Adds the ST_Contains function to check if a grid object contains another grid object or a geometry object.

  • Adds the ST_Within function to check if a grid object is within another grid object or a geometry object.

• Adds features for fast display and storage of vector data:

  • Adds the ST_BuildPyramid function to create a pyramid data table for fast display.

  • Adds the ST_DeletePyramid function to delete a pyramid data table used for fast display.

  • Adds the ST_Tile function to get vector data in Mapbox Vector Tile (MVT) format.

Bug fixes

• Fixes an issue where Out of Memory (OOM) errors occurred when creating pyramids in some scenarios.

• Fixes an issue where a trajectory point for '2000-01-01' could not be created for a moving object.

• Fixes an issue where the ST_Intersection function returned an incorrect sub-trajectory for a moving object in some scenarios.

• Fixes an issue that caused a crash during a GanosBase upgrade.

• Upgrades PostGIS compatibility to version 2.5.4.

Category

Description

New features

• Adds support for the Cloud Optimized GeoTIFF (COG) file format. This lets you read pyramid information stored in COG files.

• Adds the ST_AddZ function to add a Z value to a geometric object using the pixel values of raster data.

• Enhances the retrieval of spatial extent information for raster objects:

  • Adds the ST_Extent function to get the spatial extent of a raster object, which is returned as a BOX.

  • Adds the ST_Envelope function to get the spatial extent of a raster object, which is returned as a geometric object.

  • Adds the ST_ConvexHull function to get the convex hull of a raster object based on its georeference information.

  • Adds the ST_Height function to get the pixel height of a raster object.

  • Adds the ST_Width function to get the pixel width of a raster object.

Bug fixes

• Fixes a performance limitation caused using 1 × n chunks for external raster data. You can now customize the chunk size using storage options.

• Fixes an issue where the results from the ST_Values function did not match the coordinate sorting when querying line objects in certain directions.

• Fixes an issue where the ST_BestPyramidLevel function returned a negative number in some cases.

• Fixes an issue where the ST_BuildPyramid function repeatedly created pyramids in some cases.

• Fixes an issue where the corresponding chunk tables were not cleared when a raster table was truncated.

• Fixes an issue where the CreateOption parameter was invalid for the ST_ExportTo function in some cases.

• Fixes an issue where the ST_ClearChunks function returned an error for table names that contain both uppercase and lowercase letters.

• Fixes an issue where an overview could not be created for an external pyramid in some cases.

• Fixes an issue where an internal pyramid could not be created for a raster object that has an external pyramid.

• Fixes an issue where calculating statistics for raster data with NaN values produced incorrect results.

Category

Description

New features

• Enhances the interfaces for accessing raster data metadata:

  • Adds the ST_XMin function to get the minimum value of raster data on the X-axis.

  • Adds the ST_YMin function to get the minimum value of raster data on the Y-axis.

  • Adds the ST_XMax function to get the maximum value of raster data on the X-axis.

  • Adds the ST_YMax function to get the maximum value of raster data on the Y-axis.

  • Adds the ST_ChunkHeight function to get the chunk height of raster data.

  • Adds the ST_ChunkWidth function to get the chunk width of raster data.

  • Adds the ST_ChunkBands function to get the number of chunk bands for raster data.

• Adds the ST_SrFromEsriWkt function to convert a spatial reference string from Esri format to OGC format.

• Adds support for Zstd and Snappy compression for the raster data type.

• Adds support for binary copy for the point cloud data type.

• Adds support for setting the PROJ_LIB and GDAL_DATA environment variables and deploying related data.

Bug fixes

• Fixes a database crash caused by an invalid OSS path.

• Fixes an issue where the SRID of some imported raster data was inconsistent with its definition.

Category

Description

New features

• Adds MD5 operation functions for spatial raster objects. Use these functions for operations such as data consistency checks and duplicate removal:

  • Adds the ST_MD5Sum function to get the MD5 value of a raster object.

  • Adds the ST_SetMD5Sum function to set the MD5 value of a raster object.

• Adds operation functions for OSS authentication of spatial raster objects:

  • Adds the ST_AKId function to get the AccessKey ID of a raster object stored in OSS.

  • Adds the ST_SetAccessKey function to set the AccessKey ID and AccessKey secret for a raster object stored in OSS.

  • Adds the ST_SetAKId function to set the AccessKey ID for a raster object stored in OSS.

  • Adds the ST_SetAKSecret function to set the AccessKey secret for a raster object stored in OSS.

• Adds operation functions for spatial raster metadata:

  • Adds the ST_ScaleX function to get the pixel width of a raster object on the X-axis in the spatial reference system.

  • Adds the ST_ScaleY function to get the pixel width of a raster object on the Y-axis in the spatial reference system.

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

  • Adds the ST_SkewX function to get the rotation of a raster object on the X-axis in the spatial reference system.

  • Adds the ST_SkewY function to get the rotation of a raster object on the Y-axis in the spatial reference system.

  • Adds the ST_SetSkew function to set the rotation of a raster object in the spatial reference system.

  • Adds the ST_UpperLeftX function to get the X coordinate of the upper-left point of a raster object in the spatial reference system.

  • Adds the ST_UpperLeftY function to get the Y coordinate of the upper-left point of a raster object in the spatial reference system.

  • Adds the ST_SetUpperLeft function to set the coordinates of the upper-left point of a raster object in the spatial reference system.

  • Adds the ST_PixelWidth function to get the pixel width of a raster object in the spatial reference system.

  • Adds the ST_PixelHeight function to get the pixel height of a raster object in the spatial reference system.

Bug fixes

Fixes an issue where extension upgrades failed because of aggregate functions.