importing excel latitude and longtiude data to Arc Map

yeneneshabebe

Posted 12 August 2008 - 04:58 AM

yeneneshabebe

Contributor

Validated Member

45 posts

Ethiopia

Dear Sir
I am working on an excel data which contains latitiude and longtiude location of several points. I want to import this excel latitude and longtiude dta to Arcmap and generate point data from it. So how can I perform this?

Posted 12 August 2008 - 06:24 AM

Dear Sir I am working on an excel data which contains latitiude and longtiude location of several points. I want to import this excel latitude and longtiude dta to Arcmap and generate point data from it. So how can I perform this?

pfyfield

Posted 12 August 2008 - 08:21 AM

Save the excel spreadsheet as either a .txt or .dbf file (I guess the new version of excel doesn't do dbfs), then use the "Add XY Data" under "Tools" to import.

ArcMap only recognizes certain field names, for example "x" and "y," or "longitude" and "latitude," so make sure your fields are properly named.

This will create an event theme, not a shapefile. You'll need to specify a geographic coordinate system (under View-Data Frame Properties- Coordinate System tab) since that is what your data are in. Then export your data (right click on the layer- Data-Export Data) and choose to export a shapefile or feature class with "the data frame" option button so the projection of the export will be defined as geographic.

Let us know if this works for you...

Paul FyfieldCartographer, Bureau of Land ManagementOregon State OfficePortland, Oregonpfyfield@blm.gov

yeneneshabebe

Posted 15 August 2008 - 01:59 AM

Save the excel spreadsheet as either a .txt or .dbf file (I guess the new version of excel doesn't do dbfs), then use the "Add XY Data" under "Tools" to import.

ArcMap only recognizes certain field names, for example "x" and "y," or "longitude" and "latitude," so make sure your fields are properly named.

This will create an event theme, not a shapefile. You'll need to specify a geographic coordinate system (under View-Data Frame Properties- Coordinate System tab) since that is what your data are in. Then export your data (right click on the layer- Data-Export Data) and choose to export a shapefile or feature class with "the data frame" option button so the projection of the export will be defined as geographic.

Let us know if this works for you...

Dear pfyfield,Thank you for ur quick reply. I have tried to rename the field name to latitude and longitude in excel and the arc map consider the field name. But importing the coordinate values degree minute & seconds is a problem. The arc map consider the degree minute and seconds as different value and displays it on different fields. Originally the degree minute & seconds value were written separately in different columns . So again I tried to write all the coordinate values of latitude in one column and also the values of longtiude in one column each value with the degree minute & seconds symbol,but it doesn't work.Dear pfyfield, please would you send me the detail procedure how to do it starting from excel(i.e coordinate value arrangement (degree,minute & seconds) in excel column up to importing to Arcmap. I think the main problem is the coordinate value arrangement.Thank you in advance for ur cooperation.

pfyfield

Posted 17 August 2008 - 09:42 AM

pfyfield

Master Contributor

Validated Member

100 posts

Gender:Male

Location:Portland, Oregon

United States

You just need to get your lat-long values into a single field with decimal degrees. If you have one field for latitude in degrees, another one for minutes, and a third for seconds, then divide seconds by 60, add to minutes, divide that value by 60, and add to degrees. Likewise with longitude.

Paul FyfieldCartographer, Bureau of Land ManagementOregon State OfficePortland, Oregonpfyfield@blm.gov

ProMapper

Posted 18 August 2008 - 01:45 AM

ProMapper

Master Contributor

Validated Member

222 posts

Gender:Female

Location:India

Interests:promapper@gmail.com

India

Hi Yenenesh

It is just about fifteen minutes task, if you can send me the excel file, I will convert it to shp file and send it across to you. Just send me the file in mail, please zip it with maximum compression for easy upload. My email promapper@gmail.com