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 issue

• Raster SQL

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

  • Fixed an issue in the ST_Contour function where nodata values in raster objects were incorrect.

Category

Description

Performance optimization

• Raster SQL

  The ST_PointValues function can use data block caching to improve performance.

• Utility SQL

  The ST_3DGridPath function supports 3D pathfinding without considering barriers.

Fixed issue

• Utility SQL

  Fixed an issue where the database would crash due to 3D pathfinding operations.

Description

Fixed issue

• Trajectory SQL

  Fixed an issue where exceptions would occur when a trajectory and a BoxNDF object used by the ST_{2D|2DT|3D|3DT}DWithin function intersect.

• Raster SQL

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

Category

Description

New features

• Geometry SQL

  • Multi-bounding box spatial indexing can be used for geometric objects to improve the filtering effect of indexes and enhance 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 is added to split a trajectory into individual points.

  • The ST_DumpSegments function is added to split a trajectory into continuous segments.

• 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.

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:

    • The AI_CreateModel function is added to create an AI model.

    • The AI_AlterModel function is added to modify the information of an AI model.

    • The AI_SetModelToken function is added to set token information for one or more AI models.

    • The AI_CallModel function is added to call an AI model.

    • The AI_DropModel function is added to delete an AI model.

  • The following helper functions are added:

    • The AI_ResizeImage function is added to resize an image.

    • The AI_ImageAsBase64 function is added to convert an image into a Base64 string.

    • The AI_ImageFromBase64 function is added to convert a Base64 string into an image.

    • The AI_LoadFile function is added to load a file from OSS.

  • The following GUC parameters are added:

    • The polar.ai.http_keep_alive parameter is added to specify whether to keep the HTTP connection active.

    • The polar.ai.http_timeout_mesc parameter is added to set the HTTP connection timeout.

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

    • The polar.ai.retry_interval_msec parameter is added 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 issue

• Trajectory SQL

  • Fixed an issue where using multi-bounding box indexes to retrieve trajectories of different dimensions produced unstable results.

  • Fixed an issue where the ST_AsTable function would only return the first value when returning a string.

Category

Description

New feature

• Raster SQL

  The ST_PointValues function is enhanced. A resampling parameter is added to support resampling based on surrounding data values when retrieving values.

Fixed issue

• Trajectory SQL

  • Fixed a potential memory leak issue during trajectory text parsing.

  • Fixed an issue where the ST_intersection function returned a line when intersecting at a single point.

Category

Description

New features

• Raster SQL

  The postgis_raster compatibility mode is added to support Raster data in PostGIS 3.X.

Fixed issue

• Trajectory SQL

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

• FDW SQL

  Fixed a crash that occurred in Cached Plan mode when the query condition was empty.

Category

Description

New features

• Trajectory SQL

  The ST_AccompanyIntervals function is added to calculate the intervals during which two trajectories move together. The function returns the time periods or sub-trajectories of the joint movement.

• The MapMatching module is added to correct trajectories using road network data.

• MapMatching SQL

  • The ST_MapMatching function is added for trajectory-to-road-network matching. It matches an input trajectory to road network data and outputs the matched trajectory as a geometric object.

  • The OSMNT driver format is added. This format supports importing PBF-based OSM data into a road network structure.

  • The following functions for managing map matching workspaces are added:

    • The ST_CreateWorkspace function is added to create a map matching workspace.

    • The ST_LoadWorkspace function is added to load a map matching workspace and load the road network topology into memory.

    • The ST_ClearWorkspace function is added to clear the in-memory topology from a map matching workspace.

    • The ST_DropWorkspace function is added to delete a map matching workspace.

Performance optimization

• Geometry SQL

  The ST_AsGeoJSON function is enhanced to accept Record as an input type.

Fixed issue

• Geometry SQL

  Fixed an issue where indexes could not be used during JOIN operations in PolarDB for PostgreSQL (Compatible with Oracle) 2.0.

• Trajectory SQL

  • Fixed an issue where the ST_intersection function returned an incorrect intersection result.

  • Fixed an issue where the actual behavior of the ST_Split function did not match its description when cut_point.max_point was selected.

• GeomGrid SQL

  Fixed an issue where the ST_AsGrid function incorrectly handled null objects.

• Graph SQL

  Fixed an out-of-memory (OOM) issue that occurred when creating a B-tree index on graph properties.

Category

Description

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), which is equivalent to the C function atan2.

Fixed issue

• Geometry SQL

  Fixed a database crash that occurred when you input an EWKT geometric object with an SRID that was missing a semicolon (;).

• Trajectory SQL

  Fixed a spelling error in the protobuf definition of the ST_AsProtobuf and ST_TrajFromProtobuf functions. FiledType is corrected to FieldType.

• GeomGrid SQL

  The level parameter in the ST_As3DGrid, ST_AsText, ST_GridLevelFromZ, and ST_GridLevelAsZ functions is changed to _level. This resolves an extension creation failure in the Oracle-compatible version.

Category

Description

Fixed issue

• Geometry SQL

  Fixed an issue where the results of spatial topology relationship calculations were unstable for a LineString where all point coordinates were identical.

• Raster SQL

  Fixed an issue where a raster event trigger could cause other triggers to be deleted.

• Trajectory SQL

  Fixed an issue where the ST_TrajFromProtobuf function produced unstable results in some scenarios.

• Sfmesh SQL

  Fixed a crash caused by an excessively long reference path in an Sfmesh object.

Category

Description

Fixed issue

• Raster SQL

  • Fixed an issue where the memory state was incorrect when the ST_HMTAsRaster function converted a heatmap tile to an internal state.

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

• Trajectory SQL

  • Fixed a crash that occurred when the ST_makeTrajectory function received a NULL property.

  • Fixed a crash that occurred when constructing a trajectory from a JSON object whose events were specified as NULL.

• Scene SQL

  • Fixed a program crash caused by abnormal OSGB data.

  • Fixed an occasional crash during SFMesh to GLTF conversion.

  • Fixed a crash caused by an invalid pointer after an SQL error interruption.

• Utility SQL

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

Category

Description

New features

• Geometry SQL

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

• Raster SQL

  The ganos.raster.max_cache_size parameter is added for the ST_ImportFrom function to resolve OOM issues during large data imports.

Performance optimization

• Scene SQL

  Accelerated JPEG image compression and decompression.

Fixed issue

• Geometry SQL

  • Fixed a crash caused by releasing the geometry execution cache.

  • Fixed an issue where ePQ could not be used with a support index in PolarDB for PostgreSQL 14.

• Trajectory SQL

  Fixed an issue where the ST_intersection function could not handle cases where a line segment on a trajectory intersects the target geometric object at multiple points.

Category

Description

New features

• Trajectory SQL

  The ST_InsertAttr function is added to support adding new attributes to a trajectory.

• GeomGrid SQL

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

• SfMesh SQL

  • The ST_YupToZup function is added to support converting a Y-axis-up model to a Z-axis-up model.

  • The ST_ZupToYup function is added to support converting a Z-axis-up model to a Y-axis-up model.

  • The ST_TileOption function is added to get the user-defined tile options of an sfmesh object.

  • The ST_SetTileOption function is added to set the user-defined tile options of an sfmesh object.

  • The ST_HasTileOption function is added to query whether an sfmesh object has user-defined tile options.

  • The ST_ClearTileOption function is added to clear user-specified tile options from an sfmesh object.

• Utility SQL

  • The 3D grid pathfinding feature is added.

    • The GridCost data type is added to represent the cost of a grid path.

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

    • The ST_SetCost function is added to set the cost for a given array of grids.

    • The ST_CostUnion function is added to merge all grid cost arrays.

    • The ST_3DGridPath function is added to calculate a 3D geographic grid path.

Performance optimization

• Geometry SQL

  • The compatibility of the Ganos_Geometry plug-in is enhanced. It can coexist with the PostGIS plug-in. You can create the PostGIS plug-in before you create the Ganos_Geometry plug-in.

  • 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 support color balancing using the gamma correction method.

  • The ST_ImportFrom function is enhanced to support specifying the schema where chunk_table is located.

• SfMesh SQL

  • The ST_AsGltf and ST_AsGlb functions are enhanced.

    • You can import userdata information into the extras property of a node in a glTF or GLB structure.

    • You can place JSON strings from userdata as JSON objects into the extras property of a node.

    • The speed of converting complex sfmesh to glTF is accelerated.

    • You can export geometric objects or sub-objects by specifying export options during conversion.

  • When converting an sfmesh object to 3DTiles, you can choose to output or not output the sfmesh or geometry objects of specified sub-objects.

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

• Utility SQL

  The ST_As3dTiles function is enhanced to improve conversion performance.

Fixed issue

• Geometry SQL

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

• Raster SQL

  Fixed an issue where bands were missing when the ST_MosaicFrom function was used with more than three bands.

• Trajectory SQL

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

• Utility SQL

  Fixed an issue where the IFCSpace was incorrect for some IFC data imported by the ST_ImportIFC function.

Category

Description

New features

New features

• Geometry SQL

  Parametric objects such as elliptical arcs and Bezier curves are added.

• Raster SQL

  The ST_AsTile function is added. This function supports getting a tile of a regular size (256 or 512) by specifying a Geometry.

• GeomGrid SQL

  • The GiST 2D spatial index for GeomGrid and H3Grid is added. It supports queries such as GeomGrid (or H3Grid) && Geometry, GeomGrid (or H3Grid) ~ Geometry, and GeomGrid (or H3Grid) @ Geometry.

  • The ST_AsMVTGeom function is added to support converting a geographic grid object (GeomGrid or H3Grid) into a geometric object in the tile coordinate system.

• Utility SQL

  The ST_ValidateOSGB function is added to validate OSGB data and return a list of missing 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 grid, improving performance.

• Raster SQL

  • Raster Chunk reading is enhanced using in-place memory parsing to improve performance.

  • The ST_ImportFrom function is enhanced. It supports the mapping_oss_file parameter when importing files from Minio and HDFS to improve import performance.

  • Automatic calculation of raster statistics during raster import is supported.

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

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

  • Updating raster statistics is supported.

    • The ST_ComputeStatistics function is enhanced to allow overwriting existing statistics.

    • The ST_SummaryStats function is enhanced to allow overwriting existing statistics.

  • When creating or importing a raster, the name field in attributes is set to the raster file name by default.

    • The ST_ImportFrom function is enhanced. The name field in attributes is set to the raster file name by default.

    • The ST_CreateRast function is enhanced. The name field in attributes is set to the raster file name by default.

Fixed issue

• Geometry SQL

  Fixed an "Invalid dimension" error that occurred when using the AddGeometryColumn function to register a geometry column.

• Raster SQL

  • Fixed a potential OOM error when the ST_SummaryStats function was used for pixel value statistics.

  • Fixed a potential crash when clipping a mosaic object.

• Geometry Pyramid SQL

  Fixed an issue with the ST_BuildPyramid function where creation failed when calling ST_BuildPyramid('a.table'...) with a schema-qualified table name.

Category

Description

New features

• New features

  • Geometry SQL

  • A function is added to dynamically generate tiles. This function can reduce the size of generated tiles compared to ST_AsMVT.

    • The ST_AsMVTEx function is added. Compared to ST_AsMVT, it filters vector features with less impact on display based on relationships between different vector features. This reduces the MVT size and improves visualization efficiency. The filtering effect is controlled by the new scale_factor parameter. The new mvt_size_limit parameter limits the maximum number of vector features an MVT can contain.

  • A feature is added to calculate a heatmap for a specified window.

    • The ST_AsHMT function is added to support heatmap statistics for a specified window range and pixel size.

    • The ST_HMTAsArray function is added to support specifying the output array format for heatmap tiles.

    • The ST_HMTStats function is added to support calculating statistical information for heatmap tiles.

  • Raster SQL

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

  • Trajectory SQL

    Adds the ST_AsHMT function for generating heatmap statistics based on a specified window range and pixel size.

  • SfMesh SQL

    • Added the ST_SnapToPolygon function to smoothly snap terrain to 3D polygon roads.

    • Added the ST_RayIntersection function to batch-calculate the intersections of terrain and parallel rays.

  • Scene SQL

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

    • The new CAST function converts sfmesh data into GLB-based scene data.

  • Importer SQL

    • Added the ST_As3dTiles function to convert sfmesh data into 3D Tiles for preview.

    • Added the ST_ImportObj function to import data in the OBJ format and convert it to the sfmesh data type.

  • GeomGrid SQL

    • The new ST_AsH3Grid function converts geometry objects into arrays of H3 cell IDs.

    • The new ST_GridDisk function returns all H3 cells within grid distance k from an origin H3 cell.

    • The new ST_GridRing function returns all H3 cells at grid distance k from an origin H3 cell.

    • The new ST_GridPath function gets the path between two H3 cells.

    • The new ST_GridDistance function gets the grid distance between two H3 cells.

    • The h3grid data type now supports BTree indexes.

Performance optimization

• SfMesh SQL

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

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

• Scene SQL

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

Fixed issue

• Geometry SQL

  • Fixed an issue where calling the ST_DWithin function in text mode would report a "function not unique" error when multiple extensions were created simultaneously.

  • Fixed a potential runtime error in the Geometry module's ST_AsMVTGeomEx function when using the parameter clip=true.

• Raster SQL

  • Fixed an issue where the ST_Values function returned an incomplete number of records when specific bands were specified.

  • Fixed an issue where the ST_Values function returned a missing number of records when the specified range exceeded the Raster range.

  • Fixed a memory leak in the ST_MosaicFrom function.

  • Fixed data inaccuracy caused by a length overflow in the ST_ExportTo function.

• Trajectory SQL

  • Fixed an issue where the multi-bounding box index for trajectories did not support NULL values.

• Scene SQL

  • Fixed a crash that occurred when parsing non-standard OSGB data with topology errors.

  • Fixed an issue with inaccurate memory release in st_3dclip.

• Importer SQL

  • Imported table names are now converted to lowercase to prevent "table not found" issues due to case sensitivity.

  • Fixed an OSG import failure caused by a trailing slash (/) in the import path.

Category

Description

New features

• New features

  • GeomGrid SQL

    • Adds support for Uber H3 indexes.

      • Adds the H3Grid data type to represent H3 encodings.

      • Adds the ST_H3FromLatLng function to get an H3Grid object from a specified latitude and longitude.

      • Adds the ST_H3FromText function to convert a standard H3 encoding to an H3Grid object.

      • Adds the ST_H3FromInt function to convert a bigint value to an H3Grid object.

      • Adds the ST_AsInt function to convert an H3Grid object to a bigint value.

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

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

  • Geometry SQL

    • Adds random sampling and pixel filtering functions to reduce the size of dynamically generated tiles.

      • Adds the ST_IsRandomSampled function. This function returns a Boolean value that indicates whether a record is sampled based on the provided properties and sample rate.

      • Adds the ST_AsMVTGeomEx function. Compared with ST_AsMVTGeom, this function adds the `res_prec` parameter. This parameter filters out vector features that have little impact on the display effect. This reduces the size of the generated Mapbox Vector Tile (MVT).

    • Enhances the geography data type.

      • The ST_LineSubstring function now supports the geography data type. It can get subsegments based on the spherical distance.

      • The ST_LineInterpolatePoint function now supports the geography data type. It can get points based on the spherical distance.

      • The ST_LineInterpolatePoints function now supports the geography data type. It can interpolate points based on the spherical distance.

      • The ST_LineLocatePoint function now supports the geography data type. It can get the nearest distance percentage based on the spherical distance.

  • Raster SQL

    • Adds the ST_Polygonize function to support the vectorization of raster objects.

  • Scene SQL

    • Adds the ST_ShadowRatio function to calculate the shadow ratio for a given point at a specific time or over a period of 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 any geometry type.

• FDW SQL

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

• Scene SQL

  • The ST_AsB3DM function is enhanced to support exporting GLB to B3DM format.

Fixed issue

• GeomGrid SQL

  • Fixed an issue where the ST_AsGrid function had incorrect grid calculations at certain levels.

• Geometry SQL

  • Fixed vector pyramid compatibility with metadata from version 3.7.

  • Fixed a crash that occurred when the ST_Union function was used without performing an extension upgrade.

• Raster SQL

  • Fixed an issue in the contour generation function ST_Contour where the band parameter started from 0.

• Trajectory SQL

  • Fixed an issue where the trajectory module could not be installed due to a dependency on pg_type.

• Importer SQL

  • Fixed a crash that occurred when the ST_ImportOSGB function was used to import OSGB data.

Category

Description

New features

GeomGrid SQL adds the GeoSOT 3D grid code feature:

• The ST_AsBox3D function is added to return the range of a 3D geographic grid object as a Box3D.

• The ST_AsMeshGeom function is added to return the range of a geographic grid object as a mesh geometry object.

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

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

• The ST_HasZ function is added to check if a geographic grid contains a Z dimension.

• The ST_Level function is added to get the subdivision 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 check if the spatial range represented by a 3D geographic grid object intersects with a geometric object.

• The ST_3DContains function is added to check if the spatial range represented by a 3D geographic grid object contains a geometric object.

• The ST_3DWithin function is added to check if the spatial range represented by a 3D geographic grid object is within a geometric object.

• The ST_As3DGrid function is added to convert a 3D geometric object into a geographic grid representation.

• The &&& operator is added to check if the spatial range represented by a 3D geographic grid object intersects with a geometric object.

• The @@> operator is added to check if the spatial range represented by a 3D geographic grid object contains a geometric object.

• The <@@ operator is added to check if the spatial range represented by a 3D geographic grid object is within a geometric object.

Performance optimization

• GeomGrid SQL

  • The ST_AsText function is enhanced to convert a 3D geographic grid object to text encoding.

  • The ST_GridFromText function is enhanced to convert 3D geographic grid text encoding to a geographic grid object.

• Raster SQL

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

  • The ST_ImportFrom function is enhanced to support HDF5 subdataset import.

  • The ST_CreateRast function is enhanced to support HDF5 subdataset import.

• Scene SQL

  • The data type supports gateway mode, allowing storage of OSGB objects on OSS.

  • The performance of ST_ComputeViewShed is optimized.

• Importer SQL

  • The import tool supports importing OSS-based OSGB data in gateway mode.

Fixed issue

• Raster SQL

  • Fixed a crash in the ST_InterpolateRaster function.

  • Fixed an issue with incorrect minimum values for Double and Float.

• SfMesh SQL

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

• Trajectory SQL

  • Fixed an issue where the multi-bounding box index for trajectories did not support NULL values or trajectories with only one point.

Category

Description

New features

• The ST_AsMVT3D and ST_AsMVTGeom3D functions are added to support 3D vector tiling for Geometry3D data.

• The ST_AsTableFormat function is added to output the type of the value returned when ST_AsTable is called for a trajectory.

• Support is added for importing OSS-based glTF and GLB files as SFMesh objects.

  • The ST_ImportGLTF function is added to support glTF file import.

  • The ST_ImportGLB function is added to support GLB file import.

Fixed issue

• Fixed an issue where the ST_intersection function made an incorrect judgment when intersecting two overlapping trajectory segments.

Category

Description

New features

• The ST_MosaicFrom function is enhanced to support parallel operations.

• The ST_MosaicFrom function is enhanced to support mosaicking images of different resolutions or projections.

• Importer SQL reference is added.

  • The ST_ImportOSG function is added to support importing OSGB data from Object Storage Service into a database according to a fixed table schema.

  • The ST_ImportIFC function is added to support importing IFC data from Object Storage Service into a database according to a fixed table schema.

• Support for model merging operations for the Scene data type is added:

  • The ST_CombineMeshes function is added to support merging geometric models within a Scene object.

  • The ST_CombineTextures function is added to support merging texture images within a single Scene object.

  • The ST_Combine function is added to support merging multiple Scene objects into one.

• Support for viewshed analysis for the Scene data type is added:

  • The ST_ComputeFrustum function is added to support frustum computation.

  • The ST_ComputeViewShed function is added to support viewshed computation.

• SFMesh function changes

  • The ST_FromSuperMap function is added to support converting an SFMesh object based on the SuperMap coordinate system to an SFMesh object based on the WGS84 coordinate system.

  • The ST_3DIntersects function is enhanced to support fast intersection calculation for axis-aligned box3d and Meshgeom.

  • The ST_3DContains function is enhanced to support fast containment checks of a single point within a solid meshgeom.

Fixed issue

Fixed a crash that occurred when using the ST_makeTrajectory function to create a two-point trajectory with a start and end time.

Category

Description

New features

• The ST_ClusterDBSCAN function is added to support DBSCAN clustering in latitude and longitude coordinates.

• The ST_CurveRecognize function is added to identify curves and turning radii in a trajectory.

• The ST_AsGrid function is optimized to support 2D degenerate grid calculations.

• The pgRouting plug-in is upgraded to 3.4.2.

• Settings for sfmesh materials and textures are enhanced.

  • 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 support merging sfmesh object nodes.

Category

Description

New features

• Compatibility with the PostGIS plug-in is upgraded to version 3.3.2.

• The ST_Angle function is added to output the angle of each turn in a trajectory as an array.

• The ST_CurvatureRadius function is added to output the radius of each turn in a trajectory as an array.

• Meshgeom and SFmesh are enhanced to support creation from Polyhedral Surface and TIN types.

• Support for setting and getting user-defined binary data on SFMesh and Material data types is added.

  • The ST_BinData function is added to support getting binary data.

  • The ST_SetBinData function is added to support setting binary data.

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

  • The ST_ClearBinData function is added to support clearing binary data.

• The ST_Affine function uses a root node transformation matrix instead of actual coordinate value transformation.

• Node in an SFMesh object allows using a NULL object as an empty node to support placeholder operations.

• The ST_FlipCoordinates and ST_SwapOrdinates functions use a node transformation matrix instead of actual coordinate value transformation.

• Support for setting and getting Node information in an SFMesh object is added.

  • The ST_NodeID function is added to support querying the associated ID of a node.

  • The ST_SetNodeID function is added to support setting the ID of a node.

Fixed issue

• Fixed a crash in the trajectory ST_AsTable function when the x,y,t dimension was NULL.

• Fixed an issue where the node object index number in an SFMesh object was incorrect in some scenarios.

• Fixed an issue where the result was incorrect when a Meshgeom object containing an SRID was converted to WKT output.

• Fixed an issue where degenerate polygons in a MeshGeom object could not be triangulated.

• Fixed an analysis and calculation error that occurred with SFMesh nested expressions.

Category

Description

New features

• Support for converting between GeoHash characters and Int types is added:

  • The ST_GeoHashID function is added to convert a GeoHash string to an integer type.

  • The ST_GeoHashFromID function is added to convert an Int type to a GeoHash string.

• Support for partial updates for vector pyramids is added:

  • The ST_UpdatePyramid function is added to support updating vector pyramids.

  • The ST_SetUpdatePyramidRules function is added to support setting rules for pyramid update operations.

  • The ST_BuildPyramidUseGeomSideLen function is added to support building vector pyramids by considering the size of the vector bounding box.

• The ST_InterpolateRaster function is added to support spatial interpolation.

• The ST_Contour function is added to support contour generation.

• The ST_Statistics function is added to support statistical analysis of raster data with custom weights using MultiPoint.

• The ST_Resample function is added for trajectory resampling.

• The ST_Density function is added for trajectory density statistics.

• The ST_StayPoint function is added for trajectory stay point identification.

• Support for clipping and simplifying Scene data types is added:

  • The ST_Intersection function is added to support clipping glTF and OSGB models.

  • The ST_Simplify function is added to support simplifying geometric data for glTF and OSGB models.

  • The ST_ScaleImage function is added to support simplifying image data for glTF and OSGB models.

• The ST_UserData function is added to support storing and accessing user-defined additional attribute data.

• The ST_ECEFToENU function is added to support converting ECEF coordinates to ENU coordinates.

Fixed issue

• Fixed an issue where the raster object became empty after running st_buildhistogram.

• Fixed a crash and z-value error caused by passing a null value to the trajectory ST_AsTable function.

• Fixed an incorrect result issue when splitting by GeoHash in ST_Split.

• Fixed an attribute field encoding error in ST_Tile.

Category

Description

New features

• The ST_3DIntersection and ST_3DDifference functions are added to support 3D spatial clipping operations.

• Mesh object coordinate transformation functions are added:

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

  • The ST_FlipCoordinates function is added to swap the X and Y dimension values.

• MESHGEOM is enhanced to support empty normal vectors and texture coordinate information.

Fixed issue

• Fixed a potential crash during queries if the percentage for raster data was not calculated.

• Fixed an inconsistent length error during storage when a Mesh object contained multiple referenced objects.

Category

Description

New features

• The ST_Intersection aggregate function is added to support aggregating an array of Geometry objects.

• The ST_AddZ function is added. It supports passing a Z-coordinate array as a parameter to convert a Geometry 2D/3DM to a Geometry 3D/4D.

• The ST_SetValue function is enhanced to support setting pixel values based on the spatial range of a specified geometric object.

• The ST_ExportTo function is enhanced to support exporting a Raster object to a COG file.

• The ST_CreateRast function is enhanced to support converting regular grid point records or arrays into a raster object.

• The ST_Split function is enhanced. When splitting by time, it supports specifying a start time and splitting by trajectory point ordinal number.

Fixed issue

• Fixed a potential crash in the ST_makeTrajectory function.

• Fixed an issue where the ST_lcsSimilarity function could not recognize time periods in days.

• Fixed an issue where the ST_AsEWKB function could not convert a trajectory built from a data table.

• Fixed a memory usage issue in the ST_BuildPyramid function when building a vector pyramid for very large data.

Category

Description

New features

• The ST_Union function is enhanced to support batch execution based on memory usage, preventing OOM errors with large data volumes.

• The ST_SetValue function is added to support setting pixel values at specified pixel locations.

• Raster data now supports the HDFS file system.

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

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

  • The ST_ExportTo function is enhanced to support exporting 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 a table type.

Fixed issue

Fixed an issue where anonymous temporary tables could not 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 raster ST_PointValues function is added to return the pixel values of all bands.

Fixed issue

• Fixed an issue where the raster ST_Clip function returned an incorrect band order.

• Fixed a low-performance issue during raster updates caused by a missing primary key index.

• Fixed an issue where retries were not supported when reading trajectory data from OSS failed.

Category

Description

New feature

GanosBase adds support for the PostgreSQL 14 series.

Performance optimization

The cache for trajectory objects in external storage is enhanced to improve access performance.

Fixed issue

• Fixed an issue where file extensions were missing when exporting raster data to OSS.

• Fixed an issue where statistics collection failed for some raster data.

Category

Description

New features

• ST_LinearStretch: Linearly stretches an image and returns it as a new raster.

• ST_BuildPercentiles: Calculates statistics on the pixel value percentiles of an image.

• ST_ComputeStatistics: Calculates the statistics, histogram, and percentiles of raster data at once.

• ST_Percentile: Gets the pixel percentiles of an image.

Performance optimization

• The ST_SummaryStats and ST_BuildHistogram functions support parallel computing.

• The ST_ExportTo function now returns false instead of an error message if the object file already exists when exporting data.

• When the ST_ImportFrom function encounters an error while importing data, it returns specific error details to help with troubleshooting.

Fixed issue

• Fixed an issue where half a pixel might be lost due to rounding during raster cropping.

• Fixed an issue where importing and calculating statistics for raster data containing values such as NAN and INF would fail.

Category

Description

New features

• ST_PixelAsPolygon: Converts a raster pixel to a Polygon object.

• ST_PixelAsPolygons: Converts a set of raster pixels to a collection of Polygon objects.

• ST_PixelAsPoint: Converts a raster pixel to a geometric object represented as a point.

• ST_PixelAsCentroid: Converts a raster pixel to a geometric object represented by its centroid.

• ST_PixelAsPoints: Converts a set of raster pixels to a collection of point objects.

• ST_PixelAsCentroids: Converts a set of raster pixels to a collection of centroid objects.

Performance optimization

• Geometry is compatible with PostGIS 3.1.4 interfaces.

• The ST_AsDatasetFile function supports output in Grib2 data format.

Fixed issue

• Fixed an issue where the spatial reference was incorrect when importing raster netCDF data.

• Fixed an issue where an incorrect equals result under multiple bounding boxes could lead to bounding box update errors.

Category

Description

Performance optimization

• The ST_ImportFrom function is enhanced to map OSS files to in-memory files, speeding up data import.

• The GiST index and TrajGist index add the trajgist_ops_multi operator family for multi-bounding box index keys.

• Vector pyramids now support metadata information queries.

Fixed issue

Fixed a memory leak issue when performing intersection checks on trajectory objects.

Category

Description

Performance optimization

• The raster surface calculation functions (ST_Hillshade, ST_Slope, and ST_Aspect) are enhanced to return a Raster object instead of a pixel matrix.

• The ST_Split function is enhanced to split a trajectory object into an array of sub-trajectories based on specified rules.

Fixed issue

Fixed an issue where ST_SrEqual failed under certain conditions.

Category

Description

New features

• The ST_removeDriftPoints function is added to delete drift points from a trajectory using specified rules.

• The ST_Split function is added to split a trajectory using a specified geometric object.

• The ST_ExportTo function is added to export a trajectory to external file storage, retaining only metadata in the database.

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

• The ST_importFrom function is added to convert a trajectory from external storage mode back to being stored within the database.

• The ST_StorageLocation function is added to return the external storage location of a trajectory.

• The ST_AKID function is added to return the AccessKey ID used for interacting with OSS when reading a trajectory.

• The ST_SetAccessKey function is added to set the AccessKey (including AccessKey ID and AccessKey secret, similar to a username and password) for interacting with OSS when reading a trajectory.

• The ST_SetAkId function is added to set the AccessKey ID for interacting with OSS when reading a trajectory.

• The ST_SetAkSecret function is added to set the AccessKey secret for interacting with OSS when reading a trajectory.

• The ST_SetStorageLocation function is added to set the storage location of the external file when reading a trajectory.

• The ST_DeleteGTF function is added to delete all exported trajectory files in a specified folder.

Fixed issue

• Fixed a filtering failure issue when creating a vector pyramid using a string.

• Fixed an issue where the layer list could not be displayed when connecting with QGIS.

Category

Description

New features

• The ST_AsDatasetFile function is added to return a binary stream of a raster object from a specified range in a specified file format.

• The ST_RasterDrivers function is added to query the status of all raster data drivers.

Fixed issue

Fixed a reprojection failure in the ST_Clip function when a spatial reference was specified.

Category

Description

New feature

Support for parallel query for spatial indexes is added to improve query efficiency.

Performance optimization

The ST_SubRaster function supports raster pixel type conversion and pixel value stretching. It supports AI recognition scenarios that convert multi-band remote sensing images to three-band images.

Fixed issue

• Fixed a potential database crash caused by parsing invalid histogram information in a raster.

• Fixed a potential database crash on exit after a projection change operation.

• Fixed a potential crash during raster data import.

Category

Description

New features

• The ST_RPCGeoreference function is added to get the Rational Polynomial Coefficients (RPC) information of raster data.

• The ST_SetRPCGeoreference function is added to set the RPC information of raster data.

• The ST_RPCRectify function is added to rectify a raster based on its RPC parameters and return the rectified raster object.

• Support for creating a GiST index in parallel is added.

Fixed issue

Fixed an issue where a custom spatial reference might not be exported when using pg_dump.

Category

Description

New feature

The Simple storage policy is added to optimize large object storage.

Performance optimization

When a raster object with chunked data is updated with another raster object, the system automatically deletes the chunked data of the original raster object.

Fixed issue

• Fixed an issue where the Trajectory extension could not be upgraded.

• Fixed an error that occurred in some cases when resampling a raster object using the Average method.

• Fixed an issue where query results could be incorrect if a trajectory object had identical trajectory points with different timestamps.

• Fixed an issue where the process would exit directly after a Geos object conversion failed. A prompt with the reason for the failure is now provided.

Category

Description

New features

• To accelerate spatio-temporal data index construction and improve spatial query efficiency, the storage model for spatio-temporal objects is optimized. It now supports using spatio-temporal large object feature signatures. The polar_enable_storage_partial parameter is added to support combined in-row and out-of-row storage for spatio-temporal objects. For more information, see Feature signature for spatio-temporal large objects.

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

• The ST_BuildPyramid function is added to support parallel creation of pyramids for raster data.

• The Trajectory Empty object is added to support returning a NULL object in scenarios where requirements are not met.

Fixed issue

• Fixed an issue where the ST_AddZ function might produce incorrect results in 16BSI cases.

• Fixed an issue where the Trajectory module could not be upgraded in some cases.

• Fixed an issue where some functions in the Trajectory module could not use indexes.

• Fixed an issue where some nd functions did not correctly handle non-intersecting time periods, causing an error to be returned instead of false.

Category

Description

New features

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

• The ST_Transform function is added to transform a trajectory from one spatial reference system to another.

Performance optimization

When creating a vector pyramid, you can now specify the creation range. This resolves an issue where the spatial range could not be automatically calculated in some scenarios.

Fixed issue

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

Category

Description

New features

• A feature is added to return vector pyramids in image format (stream-based) for fast graphical display of vector data.

• The JPEG2000 compression algorithm is added for the raster data type, supporting compressed storage of 16-bit raster data.

Performance optimization

The st_dwithin distance query is optimized to improve query performance.

Fixed issue

• Fixed a time intersection error for the trajectory data type.

• Fixed a bug in the GanosBase in-memory topology index.

Category

Description

New features

• The ganos_update function is added. You can use the select ganos_update() ; command to upgrade all GanosBase plug-ins to the latest version.

• The Trajectory data type is added:

  • Gist index support is added for indexing trajectory types, providing six operator families for different dimensional analysis needs.

  • The BoxND spatio-temporal bounding box type is added. It can be used for spatio-temporal range representation and trajectory storage.

  • Operators for intersection (&&), contains (@>), and within (<@) are added for different dimensions.

  • Four classes of trajectory processing functions are added: ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin.

  • Statistics collection for trajectory types and scan cost estimation based on statistics are provided.

  • A new indexing method, TrajGist, is provided for better index selection.

Performance optimization

• Spatio-temporal range queries are optimized. GIST index two-stage query optimization improves query performance.

• Vector pyramid functionality is improved:

  • Source data with any SRID coordinate is supported. Both 3857 and 4326 tile outputs are supported.

  • The pixelSize parameter setting is added to aggregate point data and reduce the number of tiles.

Fixed issue

• Fixed a failure to update Ganos_Raster in some cases.

• Fixed a potential crash when GanosBase binary files were updated to a new version.

• Fixed an issue where the top-level tile had an excessive amount of data after building a vector pyramid for point data with default parameters.

Category

Description

New features

• Support for NetCDF data with SubSets is added. Data can be imported by specifying the layer name.

• Support for custom metadata and time series information for raster data is added:

  • The ST_MetaItems function is added to get the names of all custom metadata items.

  • The ST_MetaData function is modified to get custom metadata items and return them in JSON format.

  • The ST_SetMetaData function is added to set metadata items.

  • The ST_BeginDateTime function is added to get the start time of raster data.

  • The ST_EndDateTime function is added to get the end time of raster data.

  • The ST_SetBeginDateTime function is added to set the start time of raster data.

  • The ST_SetEndDateTime function is added to set the end time of raster data.

  • The ST_SetDateTime function is added to set the start and end times of raster data, along with the band acquisition time.

• Support for returning raster data in stream-based image formats is added:

  • The ST_AsImage function is added to get a stream-based image format.

  • The ST_AsPNG function is added to get a stream-based PNG image format.

  • The ST_AsJPEG function is added to get a stream-based JPEG image format.

• Support for spatial grid data types and operations is added:

  • The geomgrid data type is added.

  • The ST_AsText function is added to convert a grid data type to a text representation.

  • The ST_AsGeometry function is added to convert a grid data type to a geometry data type.

  • The ST_AsBinary function is added to convert a grid data type to a binary data type.

  • The ST_AsBox function is added to convert a grid data type to a BOX data type.

  • The ST_AsGrid function is added to calculate the corresponding geometric grid data for a geometry data type.

  • The ST_GridFromText function is added to convert a text-based grid representation to a geometric grid data type.

  • The ST_GridFromBinary function is added to convert a binary-based grid representation to a geometric grid data type.

  • The ST_Intersects function is added to check if a grid data type and a geometry data type intersect.

  • The ST_Contains function is added to check for containment relationships between grid data types and between grid and geometry data types.

  • The ST_Within function is added to check if a grid data type is within another grid or geometry data type.

• Fast display storage for vector data types is added:

  • The ST_BuildPyramid function is added to create a support data table for fast display.

  • The ST_DeletePyramid function is added to delete a support data table for fast display.

  • The ST_Tile function is added to get vector data in MVT format.

Fixed issue

• Fixed an Out Of Memory issue that occurred when creating a pyramid in some cases.

• Fixed an issue where a moving object could not create a time point of "2000-01-01".

• Fixed an issue where using ST_Intersection on a moving object returned an incorrect sub-trajectory in some scenarios.

• Fixed a crash that occurred during a GanosBase upgrade.

• PostGIS compatibility is upgraded to 2.5.4.

Category

Description

New features

• Support for the Cloud Optimized GeoTIFF (COG) file format is added. You can read pyramid information that is stored in COG files.

• The ST_AddZ function is added to add a Z-value to a geometric object using the pixel values of raster data.

• Enhanced capabilities for obtaining the spatial extent information of raster objects:

  • The ST_Extent function is added to obtain the spatial extent of a raster object as a bounding box.

  • The ST_Envelope function is added to obtain the spatial extent of a raster object as a geometric object.

  • The ST_ConvexHull function is added to obtain the convex hull of a raster object based on its georeference information.

  • The ST_Height function is added to obtain the pixel height of a raster object.

  • The ST_Width function is added to obtain the pixel width of a raster object.

Bug fixes

• Fixed a performance issue caused using 1 × n chunking for external raster data. You can now customize the chunk size using storage options.

• Fixed an issue where the results of the ST_Values function were inconsistent with coordinate sorting when querying line objects in certain directions.

• Fixed an issue where the ST_BestPyramidLevel function could return a negative number in some cases.

• Fixed an issue where the ST_BuildPyramid function could repeatedly create pyramids in some cases.

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

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

• Fixed an issue where the ST_ClearChunks function failed for table names that contain both uppercase and lowercase letters.

• Fixed an issue where overviews could not be created for external pyramids in some cases.

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

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

Category

Description

New features

• The following functions are added to query the metadata of raster data:

  • The ST_XMin function is added to obtain the minimum value on the x-axis of raster data.

  • The ST_YMin function is added to obtain the minimum value on the y-axis of raster data.

  • The ST_XMax function is added to obtain the maximum value on the x-axis of raster data.

  • The ST_YMax function is added to obtain the maximum value on the y-axis of raster data.

  • The ST_ChunkHeight function is added to obtain the chunk height of raster data.

  • The ST_ChunkWidth function is added to obtain the chunk width of raster data.

  • The ST_ChunkBands function is added to obtain the number of bands in a raster chunk.

• The ST_SrFromEsriWkt function is added to convert a spatial reference string from the Esri format to the OGC format.

• Added support for Zstandard (Zstd) and Snappy compression for the raster data type.

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

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

Bug fixes

• Fixed an issue where an invalid OSS path caused a database crash.

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

Category

Description

New features

• Added MD5 operation functions for spatial raster objects. These functions can be used for operations such as data consistency checks and duplicate removal:

  • The ST_MD5Sum function is added to obtain the MD5 value of a raster object.

  • The ST_SetMD5Sum function is added to set the MD5 value of a raster object.

• Added functions to manage authentication for spatial raster objects stored in OSS:

  • The ST_AKId function is added to obtain the AccessKey ID of a raster object stored in OSS.

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

  • The ST_SetAKId function is added to set the AccessKey ID of a raster object stored in OSS.

  • The ST_SetAKSecret function is added to set the AccessKey secret of a raster object stored in OSS.

• Added functions to manage spatial raster metadata:

  • The ST_ScaleX function is added to obtain the pixel width of a raster object on the x-axis in a spatial reference system.

  • The ST_ScaleY function is added to obtain the pixel width of a raster object on the y-axis in a spatial reference system.

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

  • The ST_SkewX function is added to obtain the skew of a raster object on the x-axis in a spatial reference system.

  • The ST_SkewY function is added to obtain the skew of a raster object on the y-axis in a spatial reference system.

  • The ST_SetSkew function is added to set the skew of a raster object in a spatial reference system.

  • The ST_UpperLeftX function is added to obtain the x-coordinate of the upper-left point of a raster object in a spatial reference system.

  • The ST_UpperLeftY function is added to obtain the y-coordinate of the upper-left point of a raster object in a spatial reference system.

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

  • The ST_PixelWidth function is added to obtain the pixel width of a raster object in a spatial reference system.

  • The ST_PixelHeight function is added to obtain the pixel height of a raster object in a spatial reference system.

Bug fixes

Fixed an issue where extension upgrades failed due to aggregate functions.