Database Software

Hi,

I've been struggling with a problem related with Google Maps visualization. I'm aware that Google Maps uses spherical math in its projections while Oracle Spatial uses ellipsodial math and that this difference may lead to inconsistencies.

I've data that uses SRID 82086 (Irish Transverse Mercator Grid) and I want to see this data displayed on a Google Map on OBIEE. However when I try this my layers are shifted in relation to where they should be. I know that for this to work correctly we need to make some kind of transformation and I've read this 2 links:

http://docs.oracle.com/cd/E16338_01/appdev.112/e11830/sdo_cs_concepts.htm#CIHJFBFG

http://yangiiiyang.blogspot.co.uk/2012/01/miss-is-as-good-as-mile.html

and I've done my fair share of searching here in the forums but I'm still having troubles.

The first option of using the SRID 4055 isn't really an option since the data I got has the SRID 82086 like I said before. So what I tried to do was to declare an EPSG rule between my ellipsoidal and spherical coordinate systems just like those 2 links mention.

I did something like this:

CALL sdo_cs.create_pref_concatenated_op(
8208623785,
'CONCATENATED OPERATION 82086',
TFM_PLAN(SDO_TFM_CHAIN(82086, 1000000000, 4055, 19847, 3785)),
NULL);

However I don't know if I'm doing this as I should and I also don't know if after doing this I should doing something more... What I can tell you is that by doing only this I still can't get the correct results!

If you can help me and give me an explanation step by step of what I should do I would appreciate that.

Thank you