Hi,
We have upgraded an 11g database to 19c and saw an issue in Mapviewer initially. A lot of our data is geodetic and stored as SRID 8307, some applications that we have developed display the data on top of tile layers using SRID 3785. Now, in 11 I remember we had to create a concatenated op to correctly transform between the 2. The 11g database has been upgraded completely to 19c rather than a pure data migration as such the concat. op is still present I think. Now, when I look and compare the results of a transform using sdo_cs.transform I get a very different answer in the Y coordinate. I'm assuming it has something to do with the above but I am struggling to work out how to resolve it at all. Has any one had a similar issue?
if I do "select x,y from table(sdo_util.getvertices(sdo_cs.transform(sdo_geometry(2001,8307,null,sdo_elem_info_array(1,1,1),sdo_ordinate_array(-1,53)),3785)));"
The results I get in 11g are:
-111319.490793274 6982997.92038979
and 19c gives:
-111319.490793274 6948849.38482675
Appreciate your help!