I'm somewhat new to ArcGIS and am having trouble adding data in X,Y coordinate form to my new map. I've looked over the topics here in depth but can't seem to figure out what's going wrong -- so thanks for any help you can give!
What's happening is that the data I'm adding, which are actually degrees, are projecting as if they were meters. So they are all in a few-square-meter cluster near 0, 0 degrees (off the coast of Africa). I thought this would happen if the coordinate and projections are different, but they appear to be the same.
Here are the steps I've taken:
1. Create new .MXD file. (I'm using version 10.5.1)
2. Add new baselayer, Open Street Map.
3. "Add XY Data" using an Excel (.XLSX) file. This Excel file contains one row for each location (they are child care providers), with columns for descriptive data, and a column each for the X coordinate and the Y coordinate. The X coordinates are around -140 and the Y's are around 40. The format in Excel for the fields was numeric with 8 decimal points. This yields an event layer. The data "look right" without reference to the map (i.e., they are dispersed correctly, showing me they are being interpreted as numeric data) - but are in the wrong place (at 0, 0 degrees)
4. I also exported the Event Layer into a shapefile, using the data frame's coordinate system. I can view the underlying attribute table fine, but the data are still in the weird location.
The complete Source infromation for the two items is below. Thanks again!
WKID: 3857 Authority: EPSG
Linear Unit: Meter (1.0)
Data Type: XY Event Source
X Field: POINT_X
Y Field: POINT_Y
Has Object-ID Field: No
Projected Coordinate System: WGS_1984_Web_Mercator_Auxiliary_Sphere
Linear Unit: Meter
Geographic Coordinate System: GCS_WGS_1984
Prime Meridian: Greenwich
Angular Unit: Degree