Spatial (MOSC)

MOSC Banner

From Google Maps to WGS84

edited Nov 8, 2012 11:29PM in Spatial (MOSC) 2 commentsAnswered
Hi guys,
I'm working on Oracle 10g RDBMS (10.2.0.5) with Locator.
I've loaded some shapefile into my database.
In my mapviewer I'm able to see my overlayed WGS84 Fuse 32N (Italy) data on Google Maps, using MapGuide OS Server. 
Using an onmouseclick event I'm able to get the Google coordinates but I'd like to save the WGS84-32N coordinates.
During onSave function, I'm using a trigger like this:

CREATE OR REPLACE
TRIGGER "P_VC"."TRG_EC_STAB_GEOMETRY" BEFORE
  UPDATE OF GEOMETRY ON EC_STAB FOR EACH ROW

  DECLARE
  geometria mdsys.sdo_geometry; 
 
  BEGIN
  geometria := sdo_cs.transform(mdsys.sdo_geometry (2001,3857, :new.geometry.sdo_point,null,null),32632);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center