This topic describes the release notes of Ganos. Ganos is a spatio-temporal database engine.

Minor version Description
3.6
  • New features
    • The ST_RPCGeoreference function is added to obtain the Rational Polynomial Coefficients (RPC) information of a raster object.
    • The ST_SetRPCGeoreference function is added to set the RPC information of a raster object.
    • The ST_RPCRectify function is added to calibrate a raster object based on the RPC parameters of the raster object. Then, this function returns the updated raster object.
    • A parallel operation is added to create GiST indexes.
  • Fixed issues

    Custom spatial references cannot be exported when you use the pg_dump utility.

3.5
  • Optimized features

    The system is optimized to automatically delete the chunk data of a raster object. This occurs when the raster object is updated by using another raster object.

  • Fixed issues
    • The trajectory extension fails to be upgraded.
    • The system fails to resample a raster object when the average method is specified.
    • The query results are invalid when multiple timestamps refer to the same trajectory point of a trajectory.
    • The related function exits after a GEOS object fails to be converted. The function also prompts the causes of the failure.
3.4
  • New features
    • The feature signatures of large spatio-temporal objects are used. This accelerates the process to create indexes on spatio-temporal data. It also improves the spatial query efficiency, and optimizes the storage mode of spatio-temporal objects. In addition, the polar_enable_storage_partial parameter is added. The parameter allows the metadata of spatio-temporal objects to be stored in-row and the entity data of spatio-temporal objects to be stored 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 create pyramids in parallel based on raster data.
    • The Trajectory Empty object is added. If the requirements are not met in some cases, null objects are returned.
  • Fixed issues
    • The ST_AddZ function may return an invalid result if the input parameter is a 16-bit signed integer (16BSI).
    • The trajectory module fails to be upgraded in some cases.
    • Some functions cannot use indexes in the trajectory module.
    • An error instead is returned. The value false is not returned. In this case, some nd functions fail to fix the issue that two periods of time do not intersect in some cases.
3.3
  • 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 a spatial reference system to another spatial reference system.
  • Optimized features

    The extent parameter can be specified when you create a vector pyramid. This fixes the issue that the spatial extent of a vector pyramid cannot be automatically calculated.

  • Fixed issues

    The data directories of Ganos cannot be specified as expected.

3.2
  • New features
    • Stream-based images can be returned for new vector pyramids. This accelerates the graphical display of vector data.
    • The JPEG 2000 compression algorithm is introduced. This algorithm is used to compress 16-bit raster data before the data is stored.
    • The ganos_update function is introduced. You can run the select ganos_update() ; command to update all the Ganos plug-ins to the latest version.
    • The TRAJECTORY data type is introduced:
      • Spatio-temporal indexes that are supported by native Ganos are supported.
      • GiST indexes are supported for trajectories. In addition, six operator families are provided to create GiST indexes in different combinations of dimensions.
      • The BOXND data type is supported. This data type is used to describe the bounding box of a spatio-temporal extent or a storage trajectory.
      • The following new operators are introduced to compare the spatio-temporal relationships between two specified objects from various dimensions: the && operator, the @> operator, and the <@ operator. The && operator is used to check whether the two specified 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 to process trajectories.
      • New features are introduced to collect statistics of trajectories and to estimate scan costs based on the trajectory statistics.
      • TrajGiST indexes are introduced to provide an improved indexing method.
  • Optimized features
    • The ST_DWithin function is optimized to query distances at higher performance.
    • 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 generate vector pyramids is improved:
      • Source data from all the coordinate systems that provide spatial reference identifiers (SRIDs) is supported. The source data is based on the EPSG:3857 or EPSG:4326 coordinate reference system.
      • The pixelSize parameter is used to aggregate point data and reduce the number of tiles.
  • Fixed issues
    • The intersection of trajectories on the t axis is invalid.
    • The system fails to update Ganos raster objects in some cases.
    • Binary files may be corrupted. This issue occurs after the binary files are upgraded to the latest version.
    • The number of tiles at the top layer of a vector pyramid exceeds the limit. This issue occurs if the default parameter settings are used to build point data for the vector pyramid.
3.0
  • New features
    • Network Common Data Form (NetCDF) files that contain subsets are supported. These files can be imported based on specified layer names.
    • 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 the custom metadata items of a raster file.
      • The ST_MetaData function is added to query the custom metadata items of a raster file and return JSON-formatted metadata items.
      • The ST_SetMetaData function is added to configure the metadata items of a raster file.
      • The ST_BeginDateTime function is added to query the start time of a raster file.
      • The ST_EndDateTime function is added to obtain the end time of a raster file.
      • The ST_SetBeginDateTime function is added to specify the start time of a raster file.
      • The ST_SetEndDateTime function is added to specify the end time of a raster file.
      • The ST_SetDateTime function is added to specify the start time, end time, and band acquisition time of a raster file.
    • The following functions are added to convert a raster into a stream-based image:
      • The ST_AsImage function is added to convert a raster into a stream-based image.
      • The ST_AsPNG function is added to convert a raster into a stream-based image in the PNG format.
      • The ST_AsJPEG function is added to convert a raster object into a stream-based image in the JPEG format.
    • The GEOMGRID data type and the functions that are added to manage this type of data are introduced:
      • The GEOMGRID data type is supported.
      • 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 intersects with a geometry.
      • The ST_Contains function is added to check whether a grid includes another grid or a geometry.
      • The ST_Within function is added to check whether a grid is included in another grid or a geometry.
    • The following functions are added to support vector pyramids and to display vector pyramids at high speeds:
      • The ST_BuildPyramid function is added to create a vector pyramid.
      • The ST_DeletePyramid function is added to delete a vector pyramid.
      • The ST_Tile function is added to query the tile data of a vector pyramid in the MVT format.
  • Fixed issues
    • Memory resources are depleted when you create a pyramid.
    • The system fails to create a trajectory point on January 1, 2000 for a moving object.
    • The ST_Intersection function returns invalid sub-trajectories for a moving object in some cases.
2.9
  • New features
    • The Cloud Optimized GeoTIFF (COG) format is supported. The pyramid data that is stored in COG files can be read.
    • The ST_AddZ function is added to add the z coordinate to a geometry based on the raster pixel value.
    • The following functions are added to enhance the capabilities that are used to obtain the spatial extents of raster objects based on pyramid layers:
      • The ST_Extent function is added to query the spatial extent of a raster object and return a box.
      • The ST_Envelope function is added to query the spatial extent of a raster object and return a geometry.
      • The ST_ConvexHull function is added to query the spatial extent of a raster object and return a geometry.
      • The ST_Height function is added to query the pixel height of a raster object.
      • The ST_Width function is added to query the pixel width of a raster object.
      • The ST_XMin function is added to obtain the minimum value of a raster object on the x axis.
      • The ST_YMin function is added to obtain the minimum value of a raster object on the y axis.
      • The ST_XMax function is added to obtain the maximum value of a raster object on the x axis.
      • The ST_YMax function is added to obtain the maximum value of a raster object on the y axis.
  • Fixed issues
    • The performance of Ganos is compromised. This issue occurs if Ganos splits external raster data into chunks by using the 1 × n chunking model. After this bug is fixed, you can customize the size per chunk.
    • The ST_Values function returns linear objects whose coordinates on some axes do not conform to the sorting rules.
    • The ST_BestPyramidLevel function returns negative values in some cases.
    • The ST_BuildPyramid function repeatedly builds a pyramid in some cases.
    • The system fails to clear chunk tables in a timely manner when you truncate raster tables.
    • The ST_ExportTo function is invalid in some cases when the CreateOption parameter is specified.
    • The system fails to call the ST_ClearChunks function. This issue occurs if the name of the table on which the function is called contains both uppercase and lowercase letters.
    • The system fails to create an overview for an external pyramid in some cases.
    • The system fails to create an internal pyramid for a raster object that has an external pyramid.
    • The statistics of raster objects are invalid. This error occurs if the raster objects contain NaN values.
2.8
  • New features
    • The following functions are introduced to enhance the capabilities that are used to access the metadata of a raster object:
      • The ST_XMin function is added to query the minimum value of a raster object on the x axis.
      • The ST_YMin function is added to query the minimum value of a raster object on the y axis.
      • The ST_XMax function is added to query the maximum value of a raster object on the x axis.
      • The ST_YMax function is added to query the maximum value of a raster object on the y axis.
      • The ST_ChunkHeight function is added to query the chunk height of a raster object.
      • The ST_ChunkWidth function is added to query the chunk width of a raster object.
      • The ST_ChunkBands function is added to obtain the number of bands of a raster tile.
    • The ST_SrFromEsriWkt function is introduced to convert a spatial reference string from the Esri format into the OGC format.
    • The Zstandard (Zstd) and Snappy compression algorithms are introduced to compress raster data.
    • The copy of point cloud files in binary format is supported.
    • The PROJ_LIB and GDAL_DATA environment variables can be configured, and the related data can be deployed.
  • Fixed issues
    • A database fails due to an invalid Alibaba Cloud Object Storage Service (OSS) path.
    • The imported SRIDs are different from the original SRIDs of some raster objects.
2.7
  • New features
    • The following MD5 functions are added to manage spatial raster objects, such as checking data consistency and removing duplication:
      • The ST_MD5Sum function is added to query the MD5 value of a raster object.
      • The ST_SetMD5Sum function is added to set the MD5 value of a raster object.
    • The following functions are introduced to authenticate the spatial raster objects that are stored in OSS buckets:
      • The ST_AKId function is added to query the AccessKey ID of a raster object that is stored in an OSS bucket.
      • The ST_SetAccessKey function is added to set the AccessKey ID and AccessKey secret of a raster object that is stored in an OSS bucket.
      • The ST_SetAKId function is added to set the AccessKey ID of a raster object that is stored in an OSS bucket.
      • The ST_SetAKSecret function is added to set the AccessKey secret of a raster object that is stored in an OSS bucket.
    • The following functions are added to manage the metadata of a spatial raster object:
      • The ST_ScaleX function is added to query the pixel width of a raster object on the x axis of the spatial reference system.
      • The ST_ScaleY function is added to query the pixel width of a raster object on the y axis of the spatial reference system.
      • The ST_SetScale function is added to query the pixel width of a raster object in the spatial reference system.
      • The ST_SkewX function is added to query the skew of a raster object on the x axis of the spatial reference system.
      • The ST_SkewY function is added to query the skew of a raster object on the y axis of the spatial reference system.
      • The ST_SetSkew function is added to set the skew of a raster in the spatial reference system.
      • The ST_UpperLeftX function is added to query the x coordinate of a raster object in the upper-left corner of the spatial reference system.
      • The ST_UpperLeftY function is added to query the y coordinate of a raster object in the upper-left corner of the spatial reference system.
      • The ST_SetUpperLeft function is added to query the coordinate of a raster object in the upper-left corner of the spatial reference system.
      • The ST_PixelWidth function is added to query the pixel width of a raster object in the spatial reference system.
      • The ST_PixelHeight function is added to query the pixel height of a raster object in the spatial reference system.
  • Fixed issues

    The system fails to upgrade extensions when aggregate functions are used.

2.6
  • New features

    The ST_Clip function is added to support clipping based on pixel coordinates.

  • Fixed issues
    • The name of the ST_NearestApproachDistance function is invalid.
    • The ST_MosaicFrom function fails in some cases.