Release notes for GanosBase

Category

Description

Fixed issue

• Trajectory SQL

  The following issue is fixed: The ST_{2D|2DT|3D|3DT}DWithin function returns incorrect or unexpected results when trajectories and bounding boxes (BOXNDF) specified in the function intersect.

• Raster SQL

  The following issue is fixed: Raster tables fail to be created when Data Transmission Service (DTS) is configured to capture DDL operations.

Category

Description

New feature

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

• Trajectory SQL

  The following issue is fixed: The ST_intersection function returns the coordinates for stationary trajectory points as NaN.

Category

Description

New feature

• The PolarDB for AI module is added, which allows you to manage and invoke AI models within a database system by using standard SQL language. 

• Polar_AI SQL

  • The following model management functions are added:

    • AI_CreateModel: creates an AI model.

    • AI_AlterModel: modifies the information of an AI model.

    • AI_SetModelToken: sets token information for one or more AI models.

    • AI_CallModel: calls an AI model.

    • AI_DropModel: deletes an AI model.

  • The following helper functions are added:

    • AI_ResizeImage: resizes an image.

    • AI_ImageAsBase64: converts an image into a Base64-encoded string.

    • AI_ImageFromBase64: converts a Base64-encoded string into an image.

    • AI_LoadFile: loads a file from Object Storage Service (OSS).

  • The following GUC parameters are added:

    • polar.ai.http_keep_alive: specifies whether to enable persistent HTTP connections.

    • polar.ai.http_timeout_mesc: specifies the timeout period for HTTP connections.

    • polar.ai.retry_times: specifies the maximum number of retry attempts for failed HTTP requests.

    • polar.ai.retry_interval_msec: specifies the interval between retry attempts for failed HTTP requests.

• Trajectory SQL

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

Fixed issue

• Trajectory SQL

  • The following issue is fixed: The use of multi-bounding box indexes in queries for trajectories across different dimensions may lead to unstable or inconsistent results.

  • The following issue is fixed: The ST_AsTable function replicates the value in the first row of a string column to all subsequent rows in the column.

Category

Description

New feature

• Raster SQL

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

Fixed issue

• Trajectory SQL

  • The following issue is fixed: A memory leak may occur during trajectory data parsing.

  • The following issue is fixed: The ST_intersection function returns a line when the two geometries specified in the function intersect at a point.

• TSDB SQL

  The following issue is fixed: The ganos_tsdb extension cannot be upgraded in the process in which it is running.

Category

Description

New feature

• Trajectory SQL

  The ST_AccompanyIntervals function is added. 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.

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

• MapMatching SQL

  • The ST_MapMatching function is added, 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 PDF-based OSM data into the road network structure.

  • The following functions that manage 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, which loads the road network topology into memory.

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

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

Feature optimization

• Geometry SQL

  The ST_AsGeoJSON function is added to convert geometries into the GeoJSON format.

Fixed issue

• Geometry SQL

  The following issue is fixed: Indexes cannot be used for join operations in PolarDB for PostgreSQL (Compatible with Oracle) clusters.

• Trajectory SQL

  • The following issue is fixed: The result of the ST_intersection function is incorrect.

  • The following issue is fixed: The ST_Split function does not operate as expected when the cut_point.max_point parameter is used in the function.

• GeomGrid SQL

  The following issue is fixed: The ST_AsGrid function fails to correctly convert empty geometries.

• Graph SQL

  The following issue is fixed: An out of memory (OOM) error occurs when a B-tree index is created on a specific attribute in the database.

Category

Description

Fixed issue

• Geometry SQL

  The following issue is fixed: The calculations of spatial topological relationships for LineStrings become unstable or generate inconsistent results when all point coordinates of the LineStrings are identical.

• Raster SQL

  The following issue is fixed: A grid event trigger may cause other triggers to be deleted.

• Trajectory SQL

  The following issue is fixed: The ST_TrajFromProtobuf function is unstable in specific scenarios.

• Sfmesh SQL

  The following issue is fixed: An excessively long reference path in an sfmesh object may cause a crash.

Category

Description

New feature

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

Feature optimization

• SfMesh SQL

  The computational efficiency of the ST_3DIntersects function is optimized.

Fixed issue

• Geometry SQL

  The following issue is fixed: The ST_GeomFromGeoJSON function crashes.

• Raster SQL

  • The following issue is fixed: The ST_AsTile function crashes in specific scenarios.

  • The following issue is fixed: The ST_CreateRast function crashes in specific scenarios.

• Scene SQL

  The following issue is fixed: The ST_ScaleImage function crashes in specific scenarios.

• Utility SQL

  The following issue is fixed: The ST_3DGridPath function crashes in specific scenarios.

Category

Description

Fixed issue

• Raster SQL

  • The following issue is fixed: A memory exception occurs when the ST_HMTAsRaster function converts heatmap tiles into raster objects.

  • The following issue is fixed: The ST_MosaicTo function crashes in specific scenarios.

• Trajectory SQL

  • The following issue is fixed: The ST_makeTrajectory function crashes when it receives a NULL attribute.

  • The following issue is fixed: A crash occurs when a JSON object whose events attribute is set to NULL is used to create a trajectory.

• Scene SQL

  • The following issue is fixed: A crash occurs due to abnormal OpenSceneGraph Binary (OSGB) data.

  • The following issue is fixed: A crash occasionally occurs during SFMesh to GL Transmission Format (GLTF) conversion.

  • The following issue is fixed: A crash occurs when a pointer becomes invalid after a failed or an interrupted SQL operation.

• Utility SQL

  The following issue is fixed: The import tool crashes in specific scenarios.

Category

Description

New feature

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

Feature optimization

• Scene SQL

  The compression and decompression of JPEG images are accelerated.

Fixed issue

• Geometry SQL

  • The following issue is fixed: A crash occurs when the execution cache of a geometry is released.

  • The following issue is fixed: The elastic parallel query (ePQ) feature is unavailable for an index named support in PolarDB for PostgreSQL 14.

• Trajectory SQL

  The following issue is fixed: 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 feature

• 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 3DGridPath function 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 by using a 3D grid system.

Feature 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 by 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.

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

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

    • Accelerate conversion of complex sfmesh objects into glTF.

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

  • Allow you to 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 issue

• Geometry SQL

  The following issue is fixed: The ST_AsHMT function returns incorrect clipping results for specific polygon data.

• Raster SQL

  The following issue is fixed: If the number of bands specified in a ST_MosaicFrom function is greater than 3, bands are missing.

• Trajectory SQL

  The following issue is fixed: The ST_lcsSimilarity function cannot handle single-point trajectories.

• Utility SQL

  The following issue is fixed: The IFCSpace of specific IFC data imported by the ST_ImportIFC function is incorrect.

Category

Description

New feature

• Geometry SQL

  The elliptical arc and Bezier curve parametric objects are added.

• Raster SQL

  The ST_AsTile function is added. This function allows you to 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.

Feature 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 by using Multi-Cloud Object Storage (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 issue

• Geometry SQL

  The following issue is fixed: The Invalid dimension error message appears when the AddGeometryColumn function is invoked to register a geometry column.

• Raster SQL

  • The following issue is fixed: An OOM error may occur when the ST_SummaryStats function is invoked to calculate pixel size statistics.

  • The following issue is fixed: The system may stop responding when the object to be merged is clipped.

• Geometry Pyramid SQL

  The following issue is fixed: The ST_BuildPyramid function fails to create a vector pyramid for a spatial geometry data table if the name of the table includes a schema name.

Category

Description

New feature

• Geometry SQL

• A function used to dynamically generate tiles is added. The function generates tiles that have smaller sizes than the tiles generated by 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 viewable field.

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

Feature 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 issue

• Geometry SQL

  • The following issue is fixed: When multiple extensions are created at the same time and the ST_DWithin function is invoked in text mode, an error message appears, indicating that the function is not unique.

  • The following issue is fixed: An error may occur when the ST_AsMVTGeomEx function uses the clip=true parameter in the geometry module.

• Raster SQL

  • The following issue is fixed: Specific records are missing in the result when you specify specific bands in the ST_Values function.

  • The following issue is fixed: Specific records are missing in the result when you specify a range that exceeds the raster range in the ST_Values function.

  • The memory leak issue of the ST_MosaicFrom function is fixed.

  • The following issue is fixed: Data inaccuracy is caused by data length overflow in the ST_ExportTo function.

• Trajectory SQL

  • The following issue is fixed: The NULL value is not supported in multi-bounding box indexes of a trajectory.

• Scene SQL

  • The following issue is fixed: The system crashes when it parses nonstandard OSGB data (with topology errors).

  • The accurate memory release issue of the ST_3DClip function is fixed.

• Importer SQL

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

  • The following issue is fixed: The import fails because the OSG import path contains forward slashes (/).

Category

Description

New feature

• 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 longitude and latitude.

    • 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_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 MVTs and improves visualization efficiency.

  • The support for the GEOGRAPHY data type is enhanced.

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

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

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

    • The ST_LineLocatePoint function supports the GEOGRAPHY data type and allows you to 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.

Feature optimization

• GeomGrid SQL

  • The ST_AsGeometry, ST_AsText, ST_AsBinary, and ST_Level functions are enhanced to support the H3Grid data 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 issue

• GeomGrid SQL

  • The following issue is fixed: The ST_AsGrid function encounters incorrect grid computing at specific levels.

• Geometry SQL

  • The following issue is fixed: Vector pyramids are incompatible with the metadata of Ganos 3.7.

  • The following issue is fixed: The ST_Union function fails when an extension update is not performed.

• Raster SQL

  • The following issue is fixed: The band parameter of the ST_Contour function starts from 0. The ST_Contour function is used to generate contour lines or contour planes.

• Trajectory SQL

  • The following issue is fixed: The trajectory module cannot be installed because the module depends on pg_type.

• Importer SQL

  • The following issue is fixed: The ST_ImportOSGB function fails when you import OSGB data.

Category

Description

New feature

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.

Feature 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) sub-datasets.

  • The ST_CreateRast function is enhanced to import HDF5 sub-datasets.

• Scene SQL

  • The gateway data type supports OSGB objects stored in Object Storage Service (OSS).

  • The ST_ComputeViewShed function is optimized.

• Importer SQL

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

Fixed issue

• Raster SQL

  • The following issue is fixed: The ST_InterpolateRaster function fails.

  • The following issue is fixed: The minimum values of Double and Float are incorrect.

• SfMesh SQL

  • The following issue is fixed: The buffer surface of the ST_3DBuffer function is abnormal when the angle between the linestrings is too small.

• Trajectory SQL

  • The following issue is fixed: The multi-bounding box index of a trajectory does not support NULL or a trajectory that has only one point.

Category

Description

New feature

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

• The following issue is fixed: The ST_Intersection function incorrectly determines the intersection of two overlapping segments.

Category

Description

New feature

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

• The following sfmesh functions are added or enhanced:

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

The following issue is fixed: Unexpected downtime occurs when you invoke the ST_makeTrajectory function to construct a two-point trajectory by using the start time and end time of the trajectory.

Category

Description

New feature

• 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 extension 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 feature

• Ganos is compatible with PostGIS 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 issue

• The following issue is fixed: The ST_AsTable function fails when x,y,t is NULL.

• The following issue is fixed: The index number of a node in an sfmesh object is incorrect in specific scenarios.

• The following issue is fixed: The result is incorrect when an SRID contained in a Meshgeom object is converted into a well-known text (WKT) output.

• The following issue is fixed: Degenerate polygons in meshgeom objects cannot be triangulated.

• The following issue is fixed: An analysis or computation error occurs when sfmesh nested expressions are used.

Category

Description

New feature

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

  • The ST_GeoHashID function is added to convert GeoHash strings into INT-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 issue

• The following issue is fixed: The raster object becomes empty after the ST_BuildHistogram function is invoked.

• The following issue is fixed: Downtime and Z-value errors occur due to the null values of the ST_AsTable function.

• The following issue is fixed: Incorrect results are returned when the GeoHash mode is used for the ST_Split function.

• The following issue is fixed: Errors occur in attribute field encoding for the ST_Tile function.

Category

Description

New feature

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

• The following issue is fixed: If you do not calculate the percentage of raster data, raster data queries may cause system downtime.

• The following issue is fixed: When a mesh object contains multiple referenced objects, an error message appears, indicating that the lengths are inconsistent.

Category

Description

New feature

• 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 allows you to split a trajectory by trajectory point index.

Fixed issue

• The following issue is fixed: The ST_makeTrajectory function may cause system downtime.

• The following issue is fixed: The ST_lcsSimilarity function cannot recognize a time range measured in days.

• The following issue is fixed: The ST_AsEWKB function cannot convert trajectories created from data tables.

• The following issue is fixed: A memory usage error occurs when the ST_BuildPyramid function is invoked to create a vector pyramid based on a large amount of data.

Category

Description

New feature

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

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

The following issue is fixed: Anonymous temporary tables cannot be automatically deleted during raster data operations.

Category

Description

New feature

• Raster data can be accessed by 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 issue

• The following issue is fixed: The ST_Clip function returns an incorrect order of bands.

• The following issue is fixed: Missing indexes on primary keys causes low performance during raster updates.

• The following issue is fixed: Retries are not supported when you cannot access the trajectory objects stored in an OSS bucket.

Category

Description

New feature

GanosBase is supported in PostgreSQL 14.

Feature optimization

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

Fixed issue

• The following issue is fixed: File suffixes are missing when raster data is exported to OSS.

• The following issue is fixed: Statistics are not collected for specific raster data.

Category

Description

New feature

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

Feature 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 issue

• The following issue is fixed: Half a pixel is lost due to number rounding when a raster is cropped.

• The following issue is fixed: Data of a raster cannot be properly imported or collected if the data contains values such as NAN and INF

Category

Description

New feature

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

Feature optimization

• Ganos Geometry is compatible with PostGIS 3.1.4.

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

Fixed issue

• The following issue is fixed: An incorrect SRID is obtained when raster data is imported in the NetCDF format.

• The following issue is fixed: Multiple bounding boxes cannot be properly updated when the results of the equals operations on the bounding boxes are incorrect.

Category

Description

Feature 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 issue

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

Category

Description

Feature 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 issue

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 feature

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

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

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

The following issue is fixed: The ST_Clip function encounters reprojection failures when a spatial reference system is specified.

Category

Description

New feature

Parallel queries of spatial indexes are supported to improve query efficiency.

Feature 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 issue

• The issue that Ganos unexpectedly exits when Ganos parses invalid histograms is fixed.

• The issue that Ganos unexpectedly exits after projection settings are modified is fixed.

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

Category

Description

New feature

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

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

Category

Description

New feature

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

Feature optimization

Ganos is optimized. When a raster is updated based on a different raster, Ganos can automatically delete the data chunks of the original raster.

Fixed issue

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

• The following issue is fixed: Inaccurate results are 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 feature

• 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 allows you to 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 issue

• The following issue is fixed: The ST_AddZ function returns inaccurate results when the values of input parameters are 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.

• The following issue is fixed: Some ND functions cannot identify two periods of time that do not intersect and consequently return the value error instead of the value false.

Category

Description

New feature

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

Feature 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 issue

The following issue is fixed: The GanosBase data directory is incorrectly set in specific environments.

Category

Description

New feature

• BYTEA-type images can be returned for vector pyramids. You can use this feature to visualize vector data.

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

Feature optimization

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

Fixed issue

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

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

• The TRAJECTORY data type is added:

  • GiST indexes are supported for trajectory objects, and six operator families are provided for you to create GiST indexes in six dimensions.

  • The BOXND data type is added. The data type is used to describe the spatio-temporal extents of trajectory objects and store trajectory objects.

  • The following operators are added. The operators are used to compare the spatio-temporal relationships between two objects from different dimensions: && operator, @> operator, and <@ operator. The && operator is used to check whether two objects intersect. The @> operator is used to check whether the left operand-specified object includes the right operand-specified object. The <@ operator is used to check whether the left operand-specified object is included in the right operand-specified object.

  • The ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin functions are added. The functions are used to process trajectory objects.

  • New features are added. The features are used to collect statistics about trajectory objects and estimate scan costs based on the statistics.

  • TrajGiST indexes are supported. TrajGiST indexing is an optimized indexing method.

Feature optimization

• The GiST index-based two-phase query optimization method is used to query spatio-temporal extents at higher performance.

• The mechanism that is used to build vector pyramids is optimized:

  • Source data from all coordinate systems that provide SRIDs is supported. The source data can be tiles that are based on the EPSG:3857 or EPSG:4326 coordinate reference system.

  • The pixelSize parameter is added. The parameter is used to aggregate point data. The aggregation helps reduce the number of tiles.

Fixed issue

• The bug that causes failures in updating rasters is fixed.

• The following issue is fixed: The binary files of GanosBase crash after the files are upgraded to later versions.

• The following issue is fixed: A large number of tiles exist at the top layer of a vector pyramid when the default parameter settings are used to create point data for the vector pyramid.

Category

Description

New feature

• NetCDF files that contain subsets are supported. These files can be imported into specified layers based on the layer names that you specify.

• The following functions are added to query and specify the custom metadata and time series data of a raster file:

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

  • The ST_MetaData function is modified to query the custom metadata items of a raster file and return metadata items in the JSON format.

  • The ST_SetMetaData function is added to specify a metadata item of a raster.

  • The ST_BeginDateTime function is added to obtain the start time of a raster.

  • The ST_EndDateTime function is added to obtain the end time of a raster.

  • The ST_SetBeginDateTime function is added to specify the start time of a raster.

  • The ST_SetEndDateTime function is added to specify the end time of a raster.

  • The ST_SetDateTime function is added to specify the start time and end time of a raster and the time when a band is obtained.

• The following functions are added to convert a raster into a BYTEA-type image:

  • The ST_AsImage function is added to convert a raster into a BYTEA-type image.

  • The ST_AsPNG function is added to convert a raster into a BYTEA-type image and save the image as a PNG file.

  • The ST_AsJPEG function is added to convert a raster into a BYTEA-type image and save the image as a JPEG file.

• The GEOMGRID data type is added and new functions are provided to manage data of this type:

  • The GEOMGRID data type is added.

  • The ST_AsText function is added to convert data from the GEOMGRID data type into the TEXT data type.

  • The ST_AsGeometry function is added to convert data from the GEOMGRID data type into the GEOMETRY data type.

  • The ST_AsBinary function is added to convert data from the GEOMGRID data type into the BINARY data type.

  • The ST_AsBox function is added to convert data from the GEOMGRID data type into the BOX data type.

  • The ST_AsGrid function is added to convert data from the GEOMETRY data type into the GEOMGRID data type.

  • The ST_GridFromText function is added to convert data from the TEXT data type into the GEOMGRID data type.

  • The ST_GridFromBinary function is added to convert data from the BINARY data type into the GEOMGRID data type.

  • The ST_Intersects function is added to check whether a grid object intersects with a geometric object.

  • The ST_Contains function is added to check whether a grid object includes another grid object or a geometric object.

  • The ST_Within function is added to check whether a grid object is included in another grid object or a geometric object.

• Rapid display and storage of vector data are supported.

  • The ST_BuildPyramid function is added to build a vector pyramid for a spatial geometry data table to expedite data display.

  • The ST_DeletePyramid function is added to delete a vector pyramid for a spatial geometry data table to expedite data display.

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

Fixed issue

• The following issue is fixed: In some cases, OOM errors occur when pyramids are created.

• The following issue is fixed: Ganos cannot create a trajectory point on January 1, 2000 for a moving object.

• The following issue is fixed: The ST_Intersection function returns inaccurate sub-trajectories for a moving object.

• The following issue is fixed: A crash occurs during an upgrade of GanosBase.

• This minor version is compatible with PostGIS 2.5.4.

Category

Description

New feature

• The COG format is supported. Ganos can read pyramid data that is stored in COG files.

• The ST_AddZ function is added to add the z coordinate to a geometric object based on the pixel values of the raster in which the geometric object is located.

• The capabilities for obtaining the spatial extent information of raster objects are enhanced.

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

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

  • The ST_ConvexHull function is added to obtain the minimum convex geometry that encloses all geometries within a raster.

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

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

Fixed issue

• The issue that limits the performance of Ganos is fixed. This issue is triggered when Ganos splits external raster data into chunks by using the 1 × n chunking model. After this issue is fixed, you can customize the size per chunk.

• The following issue is fixed: The ST_Values function returns linear objects whose coordinates on specific axes do not follow the sorting rules.

• The issue that the ST_BestPyramidLevel function returns negative values is fixed.

• The issue that the ST_BuildPyramid function repeatedly builds pyramids is fixed.

• The issue that chunk tables cannot be cleared when raster tables are truncated is fixed.

• The issue that the ST_ExportTo function cannot be used for the CreateOption parameter is fixed.

• The following issue is fixed: Errors are returned when the ST_ClearChunks function is invoked if the name of the table on which the function is invoked contains uppercase and lowercase letters.

• The issue that an overview cannot be created for an external pyramid is fixed.

• The issue that an internal pyramid cannot be created for a raster that has an external pyramid is fixed.

• The following issue is fixed: Inaccurate statistics are returned in queries when the rasters contain NaN values.

Category

Description

New feature

• The following functions are added to efficiently query the metadata of rasters:

  • The ST_XMin function is added to query the minimum x coordinate of a raster.

  • The ST_YMin function is added to query the minimum y coordinate of a raster.

  • The ST_XMax function is added to query the maximum x coordinate of a raster.

  • The ST_YMax function is added to query the maximum y coordinate of a raster.

  • The ST_ChunkHeight function is added to query the chunk height of a raster.

  • The ST_ChunkWidth function is added to query the chunk width of a raster.

  • The ST_ChunkBands function is added to query the number of bands based on which the data of a raster is split into chunks.

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

• The Zstandard (Zstd) compression algorithm and the Snappy compression algorithm are added. The algorithms are used to compress raster data.

• Point cloud files can be copied in binary format.

• The PROJ_LIB and GDAL_DATA environment variables can be configured, and the relevant data can be deployed.

Fixed issue

• The issue that Ganos unexpectedly exits when an invalid OSS path is specified is fixed.

• The issue that inconsistencies are detected between imported SRIDs and original SRIDs of specific rasters is fixed.

Category

Description

New feature

• The following MD5 functions are added. The functions are used to manage spatial rasters. The management operations include data consistency check and duplicate removal.

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

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

• The following functions are added to authenticate the spatial rasters that are stored in OSS buckets:

  • The ST_AKId function is added to query the AccessKey ID of a raster that is stored in an OSS bucket.

  • The ST_SetAccessKey function is added to configure the AccessKey ID and the AccessKey secret that are used to access a raster object stored in an OSS bucket.

  • The ST_AKId function is added to specify the AccessKey ID of a raster that is stored in an OSS bucket.

  • The ST_SetAKSecret function is added to specify the AccessKey secret of a raster that is stored in an OSS bucket.

• The following functions are added to manage the metadata of a spatial raster:

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

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

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

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

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

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

  • The ST_UpperLeftX function is added to query the x-coordinate of the pixel in the upper-left corner of a raster in a spatial reference system.

  • The ST_UpperLeftY function is added to query the y-coordinate of the pixel in the upper-left corner of a raster in a spatial reference system.

  • The ST_SetUpperLeft function is added to query the coordinates of the pixel in the upper-left corner of a raster in a spatial reference system.

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

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

Fixed issue

The following issue is fixed: Extension upgrades may fail when aggregate functions are invoked.