WGS 1984 Web Mercator (Auxiliary Sphere) – WKID changed at version 10 for ArcGIS server

For ArcGIS Server 9, The WKID for the coordinate system, ‘WGS 1984 Web Mercator (Auxiliary Sphere)’ was 102100. It is then changed to 3857 at ArcGIS Server 10.

The background behind this is:

The EPSG assigned the 3857 code in March 2008, to signify the spherical Mercator projection that has become widespread with web mapping services, as Google, Bing and OpenStreetMap began to use this projected coordinate system.
To be in sync, Esri changed their WKID to match this EPSG code, and this happened at the v10 release.

As Dekho maintains only one version of upgrade scripts for both ArcGIS 9 and 10, we only have it with original WKID which is 102100.

So if you are using ArcGIS Server 10 and you have not already updated the WKID to correct one, you need to run the following update statement.

SQLSERVER:

UPDATE COORDINATESYSTEM set id = 3857 where id = 102100
GO

ORACLE:

UPDATE COORDINATESYSTEM set id = 3857 where id = 102100;
commit;

Those who use ArcGIS Server 9 do not need this.

2 Comments

• Rod January 21, 2012 at 1:40 am

  Should this be 102100

  Reply
• Shivani K January 22, 2012 at 10:17 pm

  Good catch Rod,
  I will correct it.

  Thanks,
  Shivani

  Reply