You mixed up your lat and longs.
Mathew Coyle, EADA10
Alberta-Pacific Forest Industries Inc.
ArcGIS 10.2 Testing
ArcGIS 10.1 SP1
Windows 7 SP1 64-bit
By chance are your longitudes missing a negative sign?
The problem is that you selected Projected Coordinate System as a 'Coordinate System of Input Coordinates' and it should be Geographic Coordinate System (GCS).
Google uses WGS 1984 as a GCS so to use this GCS for your data you have to:
- in Spatial Reference Properties dialog box click Select
- then Geographic Coordinate System -> World -> WGS 1984.prj
BTW: coordinates assignment standard is:
X Field - Longitude: -97.105016
Y Field - Latitude: 33.159106
Last edited by m.gasior; 04-20-2012 at 04:38 AM.
Last edited by SamanthaM; 04-30-2012 at 07:10 AM.
ArcMap doesn't like spaces in the field names. While you're removing those, make sure there are no extra spaces at the beginning or end of your field names. It doesn't look there are any, but for future reference ArcMap also doesn't like funny characters in your field names (for example, '#').
Also, there is no such thing as latitude -97.039914.
Last edited by dkwiens; 04-30-2012 at 10:01 AM.
check up further, that was longitude not latitude
Please follow these Steps to avoid further confusion:
1. go to your original spreadsheet and re-label the columns Field_Y_Latitude (the ones like 33.159106) and Field_X_Longitude (the -97.105016 ones).
2. resave the sheet as a .csv file called "XYPoints.csv"
3. start ArcMAP and run the Add XY Data tool browsing to input "XYPoints.csv"
4. set X Field: = Field_X_Longitude and Y Field: = Field_Y_Latitude.
5. at the bottom of the box hit EDIT... and Select in Geographic Coordinate Systems folder North Americafolder: "North American Datum 1983.prj "which will show up as GCS_North_American_1983
6. In ArcMAP table of contents Right-Click on the "XYPoints.csv Events" layer and Data > Export Data and specify the coordinate system as the layers source data in whatever file format you want Shapefile or Feature Class.
You can then either do step 6 again and use your Data Frames Projected coordinate system (assuming you have set it to that of a base map in Texas State Plane) for a projected shapefile output or use the Data Management > Projection and Transformations > Project tool and output your data into Texas State plane or whatever.
All the other posts have given correct advice, but don't bother trying to find a "solution"; you've just run into a common problem mixing up X and Y for Latitude and Longitude. Maybe it just sounds better that way.
Last edited by Hardolph; 04-30-2012 at 10:34 PM.
@Vaayu, thank you very much
Importing the excel x,y data worked great. However, using the "go to x,y" tool from the toolbar up top does not seem to work. I input the coordinates exactly as they are in the excel file. I then try different options such as zoom to, flash, or add point and it does not work. What am I doing incorrectly?
Again this is a seperate issues from the input XY data from excel, that worked great. This is using the go to xy tool.
Thanks again for your help everyone, I really appreciate it.
for the Go To X-Y tool with the coordinates as shown you need to change the entry format to "decimal degrees" by clicking the small drop down arrow on the right end of the toolbar. You have it selected for "degrees minute seconds" which would look more like 98 33 22 W for X and 35 48 27 N for Y in the entry windows.
it does not go to the coordinates because you have reversed the inputs: Long: = -97.080497 (the X coordinate) and Lat: = 33.155781 (the Y coordinate).
The Go To tool does not "know" that you have reversed them, but there is no latitude -97.080497 or anything above -90 for that matter in degrees, so it just sits.