i use postgis and h2gis and i have tested ST_Transform function on both systems:
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT('||to_char(5873455.6,'9999999.99')||' '||to_char(445588.07,'999999.99')||')',25833),4326))
on postgis i get the following result
POINT(58.4155109850716 2.92774013845001)
on h2gis
POINT (58.454757350381854 2.9198520253289484)
different coordinates with the same statement.
Could someone explain the difference or what went wrong ?
أكثر...
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT('||to_char(5873455.6,'9999999.99')||' '||to_char(445588.07,'999999.99')||')',25833),4326))
on postgis i get the following result
POINT(58.4155109850716 2.92774013845001)
on h2gis
POINT (58.454757350381854 2.9198520253289484)
different coordinates with the same statement.
Could someone explain the difference or what went wrong ?
أكثر...