Oracle Maps Not Using Correct Transformation With Google Base Map (Doc ID 1344717.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.2.0.2.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms


Testing Oracle maps with a Finnish dataset (SRID294914) and trying to display the data with a Google base map. The data is not converted correctly.

The code used in Mapviewer is

mapview = new MVMapView(document.getElementById("map"), baseURL);
//Google Maps base layer
baseMap = new MVGoogleTileLayer() ;
mapview.addMapTileLayer(baseMap);
.
.
.
var themebasedfoi = new MVThemeBasedFOI(''location'',''lapbiat.loc'');
themebasedfoi.setBringToTopOnMouseOver(true);
mapview.addThemeBasedFOI(themebasedfoi);
.
.
.


Tried setting EPSG rule two ways:

KKJ to WGS84 using 1639 to Popular Vis using 1000000000 to 3785 using 19847
-CALL sdo_cs.create_pref_concatenated_op(
2949143785,
'Finland KKJ to Google',
TFM_PLAN(SDO_TFM_CHAIN(294914, 1639, 4326, 1000000000, 4055, 19847, 3785)),
NULL);

From documentation example:
-CALL sdo_cs.create_pref_concatenated_op(
2949143785,
'Finland KKJ Zone 3 to Google',
TFM_PLAN(SDO_TFM_CHAIN(294914, 1000000000, 4055, 19847, 3785)),
NULL);

Both methods give incorrect results

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms