My Oracle Support Banner

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: and later   [Release: and later ]
Information in this document applies to any platform.


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() ;
var themebasedfoi = new MVThemeBasedFOI(''location'',''lapbiat.loc'');

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(
'Finland KKJ to Google',
TFM_PLAN(SDO_TFM_CHAIN(294914, 1639, 4326, 1000000000, 4055, 19847, 3785)),

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

Both methods give incorrect results


To view full details, 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 a vibrant support community of peers and Oracle experts.