This discussion is archived
4 Replies Latest reply: Sep 4, 2013 1:52 PM by gdildine RSS

can not find definition for srid 3857

gdildine Newbie
Currently Being Moderated


I have an interesting problem.  I was trying to set application in MapViewer which would include geometry over google tiles.  I created a new table with  county geom in srid 3785 by transforming a existing layer to that srid. I verifyied the srid in the geometry, and updated the user_sdo_geom_metadata to reflect the new table/geometry/

I create a theme using mapbuilder, and it display fine within application.   I went ahead and created a short javascript application using the example in the demo tutorial.  When running, I could the google maps to display, but not county geometry.  I looked at the log on the server and it provided the following error messages:

 

Aug 23, 2013 2:22:19 PM oracle.sdovis.CacheMgr2 createGeomGroup
INFO: Creating/replacing a geometry cache group: sdovis_subreg_wycare_v_jdbc:oracle:thin:@itis-db3.com:1521:orcl1 : TBL_IXN_COUNTIES_3785_GEOMETRY_PDT_GEOM.
Aug 23, 2013 2:22:19 PM oracle.sdovis.SRSCache get
WARNING: Cannot find SRS definition for srid 3857.
Aug 23, 2013 2:22:20 PM oracle.sdovis.CacheMgr2 createGeomGroup
INFO: Creating/replacing a geometry cache group: sdovis_subreg_wycare_v_jdbc:oracle:thin:@itis-db3.com:1521:orcl1 : TBL_IXN_COUNTIES_3785_GEOMETRY_3857_PDT_GEOM.
Aug 23, 2013 2:22:20 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInAdjustedMBR
INFO: [ IXN_GOOGLE_COUNTIES_3785 ] sql exec time: -1377292940032ms, total time loading 0 features: 123ms.
Aug 23, 2013 2:22:20 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
WARNING: ORA-13199: SRID does not exist.
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_CS", line 5264
ORA-06512: at "MDSYS.SDO_CS", line 3034

 

I went back an attempted to run the demo/tutorial google and got the following:

 

 

 

Aug 23, 2013 2:24:09 PM oracle.sdovis.SRSCache get

WARNING: Cannot find SRS definition for srid 3857.

Aug 23, 2013 2:24:09 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInAdjustedMBR

INFO: [ CUSTOMERS ] sql exec time: -1377293049773ms, total time loading 0 features: 125ms.

Aug 23, 2013 2:24:09 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow

WARNING: ORA-13199: SRID does not exist.

ORA-06512: at "MDSYS.MD", line 1723

ORA-06512: at "MDSYS.MDERR", line 17

ORA-06512: at "MDSYS.SDO_CS", line 5264

ORA-06512: at "MDSYS.SDO_CS", line 3034

 

I have check the coordinate system creation for 3875, and it appears to be correct.

I am running Oracle 11.2.0.1.0

  • 1. Re: can not find definition for srid 3857
    user12155310 Newbie
    Currently Being Moderated

    Hi,

     

    try it with 3785 ,

     

    hope it helps.

  • 2. Re: can not find definition for srid 3857
    gdildine Newbie
    Currently Being Moderated

    That's the really weird part.  Everything is already set up correctly as 3785.   Geom object in table, metadata, etc.  I even verified that 3785 was correctly set up as a crs.

  • 3. Re: can not find definition for srid 3857
    jsharma Pro
    Currently Being Moderated

    srid 3857 is defined in database version 11.2.0.3 or later.

     

    It (3857) is the preferred SRID to use for bing/nokia and other map tile layers that use the Spherical Mercator projection.

    So if you're using the builtin tile layers (eg OM.layer.NokiaTileLayer) they use the srid 3857.

     

    Leave the counties table in 8307, or upgrade to 11.2.0.3

     

    Or use a server-side tile layer definition (i.e. use the mapviewer admin page to create a tile layer definition for a built-in tile layer). That will use 3785 instead.

    The use something like (check that the data source and tile layer name are correct)

        var tileLayer = new OM.layer.TileLayer(
        "baseMap",
        {
            dataSource:"mvdemo",
            tileLayer:"nokia_map",
            tileServerURL:baseURL+"/mcserver"
       

    });

     

    instead of var tileLayer = new OM.layer.NokiaTileLayer(layerName, layerOptions);

     

    One issue with using 3785 is that you will see a shift/offset unless you add the transformation rules that specify that the datum shift should be ignored.

    See the Oracle Maps blog psot:

    A note on using Spherical Mercator (epsg:3785) with 11g

  • 4. Re: can not find definition for srid 3857
    gdildine Newbie
    Currently Being Moderated

    Thanks, this note was helpful.  In particular, it is important to read the note referenced above when considering working with MapViewer and Google.  I was actually trying to move from a custom project to something compatible with google.  I ended up using the approach in the Oracle Spatial  Coordinate System documentation which discusses handling Google.  In particular transforming from my custom projection to SRID 4055, with the use case "USE_SPHERICAL" worked best.   After doing this, the data aligned nicely.

     

    Thanks again.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points