Projection shifted by 31,000 meters south

[BrianHare]

The XY coordinate system was set to WKID 3785 (deprecated Mercator) so I figured id set it to WKID 3857 (current web Mercator). Upon doing so, every layer in a MXD is now set to be about 31,000 meters south of its actual location when displayed on google maps.

So I changed the dataset XY coordinates back to 3785, but no luck. Still broken.  I made sure the data frame and all projections are 3785  but when it's overlayed on a "Streets" basemap its still shifted south. I attempted to republish the service and other things.

Any ideas on what I did and how to get it to align back up? 

[JakeSkinner]

Hi Brian,

Can you provide more details on how you set the coordinate system?

[BrianHare]

For the dataset, I right clicked the dataset and went into properties. Then I clicked XY coordinate system tab. I typed in 3857 and selected WGS 1984 Web Mercator (aux sphere). Then press apply.

[MelitaKennedy]

Do me a favor and try to set it to 3395. That's World Mercator. A North-South offset when working with Web Mercator data is often because the layer is actually on an ellipsoidal Mercator version.

Also, if you have any of the unchanged 3785 data (that is, has not been redefined yet), could you export the coordinate system / save as a .prj file and post the contents here? If it's a shapefile, there will already be a .prj file.

Thank you,

Melita

[BrianHare]

3395 did nothing.

PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]]

That is what the .prj was as a shape file, before it was importanted as a feature class to our database.

[MelitaKennedy]

Thank you very much for hanging on with our questions. I'm now going to ask a few questions to make sure I understand the workflow. 

1. When you reset it from 3785 to 3857 and back, did you use Define Projection / data property page or the Project Tool?

2. You said that it's not lining up against Google maps data. Does it line up in either version against an Esri basemap in ArcMap or ArcGIS Pro?

The WKT you posted is 3857, not 3785. Here's 3785: 

PROJCS{"WGS_1984_Web_Mercator",GEOGCS["GCS_WGS_1984_Major_Auxiliary_Sphere",DATUM["D_WGS_1984_Major_Auxiliary_Sphere",SPHEROID["WGS_1984_Major_Auxiliary_Sphere",6378137.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],UNIT["Meter",1.0]]

Melita

[JayantaPoddar]

Could you share a zipped sample data with us to review?