steven.riley@comcast.net

X Y Long and Lat projecting to the wrong location!!!

Discussion created by steven.riley@comcast.net on Jul 29, 2011
Latest reply on Aug 2, 2011 by steven.riley@comcast.net
I'm new at this so forgive my newness : )

I am currently adding an excel table with Lat/Long coordinates.  However, when it projected into the layer, it is not in the correct location. In this case Colorado.  It shows up in Nebraska. 

How do I get the coordinates to map over correctly?

My steps:

Add data. 
Select the Excel sheet.
Now it is in my table of contents.
I right click the Excel sheet and select display XY data.
I change the fields to be correctly set for the X and Y.

Here is the info on the description:

Projected Coordinate System:
  Name: USA_Contiguous_Albers_Equal_Area_Conic

Geographic Coordinate System:
  Name: GCS_North_American_1983

I hit Enter.
Then Ok.
Now I have the sheet1event and sheet1 in the table of contents.
Sheet one has table data. Sheetevent has no data.
Sheet1event has the following info:
Data Type: XY Event Source
Location: C:\Documents and Settings\USA COMPUTER CITY\Desktop\Project 2\mercury_colorado_sites.xls
Table: Sheet1$
X Field: Latitude
Y Field: Longitude
Has Object-ID Field: No

Projected Coordinate System: USA_Contiguous_Albers_Equal_Area_Conic
Projection: Albers
False_Easting: 0.00000000
False_Northing: 0.00000000
Central_Meridian: -96.00000000
Standard_Parallel_1: 29.50000000
Standard_Parallel_2: 45.50000000
Latitude_Of_Origin: 37.50000000
Linear Unit:  Meter

Geographic Coordinate System: GCS_North_American_1983
Datum:  D_North_American_1983
Prime Meridian:  Greenwich
Angular Unit:  Degree

Again there is no data in fields on the sheet1event table.

When I do a Full extent I can see the sheet1event symbol but it is located in what would be Nebraska.

I ran the layers in define and then projection with Geo Transformation as directed for the exercise I was working on.

It seems that may be the issue although I'm not sure.

I also can't seem to set up the sheet1event to see any data in the fields such as long and lat but it is in the sheet1.

I also cannot do the Geo Trans.  I was adding the NAD_1983_to_WGS_1984_1.

Thank you for any assistance in advance.

Rookie Steven =)

Outcomes