[SEDONA-626] SRID of geometries returned by many ST functions are incorrect

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.6.1
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Kristin Cowalcijk
• Created: 11/Jul/24 11:19
• Updated: 19/Aug/24 00:22
• Resolved: 19/Aug/24 00:22

Description

Some ST functions that transform geometry to geometry do not preserve the SRID of the input geometry. For instance:

SELECT ST_SRID(ST_Collect(ST_GeomFromText('POINT (10 20)', 1000)))
+---------------------------------------------------------+
|st_srid(st_collect(st_geomfromtext(POINT (10 20), 1000)))|
+---------------------------------------------------------+
|                                                        0|
+---------------------------------------------------------+

While some other functions do preserve the SRID of the input geometry:

SELECT ST_SRID(ST_Buffer(ST_GeomFromText('POINT (10 20)', 1000), 1))
+-----------------------------------------------------------+
|st_srid(st_buffer(st_geomfromtext(POINT (10 20), 1000), 1))|
+-----------------------------------------------------------+
|                                                       1000|
+-----------------------------------------------------------+

Additionally, ST_Transform should alter the SRID of the output geometry, but it preserves the SRID of the input geometry:

sedona.sql("SELECT ST_SRID(ST_Transform(ST_GeomFromText('POINT (10 20)', 3857), 'EPSG:4326'))").show()
+----------------------------------------------------------------------+
|st_srid(st_transform(st_geomfromtext(POINT (10 20), 3857), EPSG:4326))|
+----------------------------------------------------------------------+
|                                                                  3857|
+----------------------------------------------------------------------+

User has to put ST_SetSRID everywhere when they want geometries with proper SRIDs.

Issue Links

• links to: GitHub Pull Request #1521