topic Re: Using Excel sheet to geocode xy (lat/lon) in Geoprocessing Questions

Using Excel sheet to geocode xy (lat/lon)

MeganWeiss — Fri, 18 Jan 2013 18:30:00 GMT

I have an excel sheet that I am trying to geocode with no luck. First I tried in decimal degrees which is the format in which I received the data, but it was either not recognizing what I had or putting it in a different hemisphere. I now have them in minutes, degree, second format, but now it won't let me choose my xy since it says its 'text' Does anyone know how to correct this so that I can accurately map my data? Thanks!

Re: Using Excel sheet to geocode xy (lat/lon)

RichardLaing — Sun, 20 Jan 2013 21:40:44 GMT

I have an excel sheet that I am trying to geocode with no luck. First I tried in decimal degrees which is the format in which I received the data, but it was either not recognizing what I had or putting it in a different hemisphere. I now have them in minutes, degree, second format, but now it won't let me choose my xy since it says its 'text' Does anyone know how to correct this so that I can accurately map my data? Thanks!

Megan
Make sure your Excel column headings have no spaces or unusual characters and the cells are numerical. Keep your coordinates in decimal degrees. In ArcMAP add the data, then in the Table of Contents right click the data and choose "Display XY Data". In the window that pops up, under "Coordinate system of input coordinates" click "edit" and choose the Geographic coordinate system that you are working in. Click "OK" and it should add it to your TOC.

Rick

Re: Using Excel sheet to geocode xy (lat/lon)

MeganWeiss — Tue, 22 Jan 2013 14:19:14 GMT

Thanks Rick. I had tried decimal degrees before but that was also having problems. It puts my data far from where it should be. This data was provided to me by the state transportation agency. The coordinate systems are the same, yet the data still won't overlap. I'm starting to think that the data provided is very incorrect.

Re: Using Excel sheet to geocode xy (lat/lon)

markdenil — Wed, 23 Jan 2013 13:55:57 GMT

Are you sure the values are really latitude and longitude, and not from some other coordinate system?

Where is "far from where it should be"?

Do the values look like they desribe the place you expect the features to land?

Re: Using Excel sheet to geocode xy (lat/lon)

MelitaKennedy — Wed, 23 Jan 2013 17:21:15 GMT

Hi Megan,

Earlier you said that the data ended up in the wrong hemisphere so here are two things to check. Are the longitude and latitude fields labeled correctly? If you're using x and y for the field names, x = longitude and y = latitude. Also, if the data is in the US, the longitude values must be negative.

Melita