[mapguide-users] Another mapguide and fusion question

[Andreas Nordgren]

Hello mapguide friends,

I am running mapguide 2.2 RC4 and maestro 3.0 b3! The spatial information I have Is in a oracle database and in the Swedish coordinate system  SWEREF (99 12 00): EPSG 3007. Now I want to combine this with Yahoo or Google maps in a fusion layout.
In the map definition  I have first tried to set the coordinate system to  EPSG 3785: PROJCS["WGS84.PseudoMercator",GEOGCS["LL84",DATUM["WGS84",SPHEROID["WGS84",6378137.000,298.25722293]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Popular Visualisation Pseudo Mercator"],PARAMETER["false_easting",0.000],PARAMETER["false_northing",0.000],PARAMETER["central_meridian",0.00000000000000],UNIT["Meter",1.00000000000000]]
Maestro didn't like the string above and I got an error message telling me: "system.argumentException: This causes two bindings in the collection to bind to the same property."
But after a little bit of googeling I found out that the new ESPG for using with google is 3857. So I have also tried this WKTEXT string in the map definition:
PROJCS["Popular Visualisation CRS / Mercator",GEOGCS["Popular Visualisation CRS",DATUM["Popular Visualisation Datum",SPHEROID["Popular Visualisation Sphere",6378137,0,AUTHORITY["EPSG","7059"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6055"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9102"]],AXIS[E,EAST],AXIS["N",NORTH],AUTHORITY["EPSG","4055"]],PROJECTION["Mercator_1SP"],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],PARAMETER["Central_Meridian",0],PARAMETER["Latitude_of_origin",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["East",EAST],AXIS["North",NORTH],AUTHORITY["EPSG","3785"]]
This one works but my oracle spatial data pop up in the north see.  I realize that I have to do some sort of coordinate transformation of my oracle spatial data. Oracle have a built in tool but sad enough I'm using 10g and my MDSYS.CS_SRS table isn't equipped with the latest  coordinate systems that google/yahoo uses. 
So to my question are if I'm on the right track here or have I misunderstood something?

Best regards
Andreas