Reprojection workflow

I have data in oracle spatial that needs to be reprojected from NAD27 to NAD83. Unfortunately the spatial layers contain circular arcs so the Oracle spatial functions will not process these records. I know that Map will reproject the data on the fly to what ever coordinate system the work dgn file contains, my question is how do I post the data back to oracle in the new coordinate system? Could I extract it to the coordinate system I want them change the SRID in the oracle metadata tables to the new coordinate system then post the data back? Any suggestions? 

Parents
  • The user is still looking for a solution to this issue. He is considering creative ideas on how to get past it.

    One suggestion is...

    1. Extract the data into a dgn file with that contains the coordinate system that I want the data to be in

    2. Change the SRID in oracle for the table(s) involved

    3. Lock the data

    4. Move it a tiny amount say 0.000001 ft so it will register as have being edited.

    5. Post back to oracle.

    The question is will it try to transform the features back to the original coordinate system when it gets posted or will it fail because I changed the SRID?

    Has anyone done this before? Are there any other suggestions?


     This is a test

Reply
  • The user is still looking for a solution to this issue. He is considering creative ideas on how to get past it.

    One suggestion is...

    1. Extract the data into a dgn file with that contains the coordinate system that I want the data to be in

    2. Change the SRID in oracle for the table(s) involved

    3. Lock the data

    4. Move it a tiny amount say 0.000001 ft so it will register as have being edited.

    5. Post back to oracle.

    The question is will it try to transform the features back to the original coordinate system when it gets posted or will it fail because I changed the SRID?

    Has anyone done this before? Are there any other suggestions?


     This is a test

Children
No Data