5 Replies Latest reply: Jul 10, 2013 10:36 PM by Boomz RSS

    problem about rule 32647 to 3785 (Google Map)

    Boomz

      From http://yangiiiyang.blogspot.com/2012/01/miss-is-as-good-as-mile.html about CONCATENATED 8307 to 3785(google map) it's work.

       

      but SRID of my data is 32647 and I tried to check this

       

      SELECT MDSYS.SDO_CS.DETERMINE_DEFAULT_CHAIN(32647, 3785) FROM DUAL; 
      

       

      result is >>> (32647, 4326, 4055, 3785, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , )

      Then i do like that guide.

       

      CALL sdo_cs.create_pref_concatenated_op(302,

      'CONCATENATED OPERATION 32647 to 3785',

      TFM_PLAN(SDO_TFM_CHAIN(32647, 1000000000, 4326, 1000000000, 4055, 19847, 3785)),

      NULL);

       

      The layers not show.

      What should I do...

        • 1. Re: problem about rule 32647 to 3785 (Google Map)
          jsharma-Oracle

          Use SRID 3857 instead if you are using database version 11.2.0.3 (or later).

           

          If however you don't have 3857 defined (i.e. your db version is older than 11.2.0.3) then you'd can use the tfm_plan but the tfm_chain will be different.

          It'll be the usual operation to go from 32647 to 4326 (i.e. projected to geog) and then a null op between 4326 and 4055 (i.e. coord_op_id 1000000000).

          So the first 1000000000 is incorrect.

          Will find out what it should be but my guess is 16047 based on the following info:

          SQL> select coord_ref_sys_name, coord_sys_id, source_geog_srid, projection_conv_
          id from sdo_coord_ref_sys where srid=32647 ;


          COORD_REF_SYS_NAME
          --------------------------------------------------------------------------------


          COORD_SYS_ID SOURCE_GEOG_SRID PROJECTION_CONV_ID
          ------------ ---------------- ------------------
          WGS 84 / UTM zone 47N
                  4400             4326              16047

          so 16047 is the operation_id for 32647 to 4326.

           

          For 3785 the entry is:

          SQL> select coord_ref_sys_name, coord_sys_id, source_geog_srid, projection_conv_
          id from sdo_coord_ref_sys where srid=3785 ;


          COORD_REF_SYS_NAME
          --------------------------------------------------------------------------------


          COORD_SYS_ID SOURCE_GEOG_SRID PROJECTION_CONV_ID

          ------------ ---------------- ------------------

          Popular Visualisation CRS / Mercator

                  4499             4055              19847

          so 19847 is the operation_id for the transformation between 3785 and 4055.

          • 2. Re: problem about rule 32647 to 3785 (Google Map)
            mhorhamm-Oracle

            Which database version do you use?

            • 3. Re: problem about rule 32647 to 3785 (Google Map)
              Boomz

              Hi jsharma

               

              thanks for your guess , I try to change 1000000000, 4326 >>> 16047, 4326 The layers still not show. and my db version is  11.2.0.1

              • 4. Re: problem about rule 32647 to 3785 (Google Map)
                Boomz

                my db version is  11.2.0.1

                • 5. Re: problem about rule 32647 to 3785 (Google Map)
                  Boomz

                  jsharma


                  I got it , 16047 isn't the operation_id for 32647 to 4326. but it is -16047


                  thank you for your help