Import XY coordinate data from Rest API Query

Question

Hello, I have a table of point events with X and Y values that I retrieved using the Rest API query of an ArcGIS Server map service. I am trying to add these to ArcMap using the display XY data method, but I can't get the coordinate information right. The output of the map service WKID is 102100, but when I select WGS1984 web mercator auxiliary sphere, it looks for decimal degrees and the features don't display right. I can't seem to figure out exactly what kind of coordinate system these X and Y values are in and my searches haven't turned up much in the forums.

Can anyone give me guidance on the coordinate system returned for point events from the Rest API, and how to import this into ArcMap?

As a reference, Toledo, Ohio has an X,Y coordinate pair of (-9296994,5099544)

Thanks!

JimmyDobbins · Answer

Those coordinates are web Mercator (aux sphere). You should set the xy data's coordinate system to WGS 1984 Web Mercator (Auxiliary Sphere). Are you seeing decimal degree values in ArcMap's status bar? You can change that by setting the display units. The setting is in the data frame properties, general tab.

Melita

That worked great...thanks for the help!

MelitaKennedy · Answer

Those coordinates are web Mercator (aux sphere). You should set the xy data's coordinate system to WGS 1984 Web Mercator (Auxiliary Sphere). Are you seeing decimal degree values in ArcMap's status bar? You can change that by setting the display units. The setting is in the data frame properties, general tab.

Melita