0 Replies Latest reply: May 26, 2011 9:32 AM by jsharma-Oracle RSS

    New SRID (3857) in 11.2.0.2 (use instead of 3785)

    jsharma-Oracle
      The new srid epsg:3857 in 11.2.0.2 does not require a tfm_plan or the use case use_spherical to correctly line up with google or bing background maps. The doc wasn't updated in time. See the sample results below.

      . First geom. In 8307, 2nd in 3785 with no tfm_plan or use case, 3rd 3785 with use_spherical, 4th 3857.

      MVDEMO@sdolnx2>select * from v$version ;

      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      PL/SQL Release 11.2.0.2.0 - Production
      CORE 11.2.0.2.0 Production
      TNS for Linux: Version 11.2.0.2.0 - Production
      NLSRTL Version 11.2.0.2.0 - Production

      MVDEMO@sdolnx2> select city, location, sdo_cs.transform(location, 3785) loc3785_oldcs,
      sdo_cs.transform(location, 'USE_SPHERICAL', 3785) loc3785_usespherical,
      sdo_cs.transform(location, 3857) loc3857_newWebMercator from cities where rownum < 4
      CITY
      ------------------------------------------
      LOCATION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
      --------------------------------------------------------------------------------
      LOC3785_OLDCS(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINA
      --------------------------------------------------------------------------------
      LOC3785_USESPHERICAL(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO
      --------------------------------------------------------------------------------
      LOC3857_NEWWEBMERCATOR(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, S
      --------------------------------------------------------------------------------
      New York
      SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-73.943849, 40.6698, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-8231391.6, 4935892.96, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-8231391.6, 4963758.56, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3857, SDO_POINT_TYPE(-8231391.6, 4963758.56, NULL), NULL, NULL)

      Los Angeles
      SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-118.4112, 34.112101, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-13181475, 4019893.75, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-13181475, 4043864.4, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3857, SDO_POINT_TYPE(-13181475, 4043864.4, NULL), NULL, NULL)

      Chicago
      SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-87.684965, 41.83705, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-9761045.7, 5108079.09, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3785, SDO_POINT_TYPE(-9761045.7, 5136601.49, NULL), NULL, NULL)
      SDO_GEOMETRY(2001, 3857, SDO_POINT_TYPE(-9761045.7, 5136601.49, NULL), NULL, NULL)