AnsweredAssumed Answered

Help displaying coordinates from an Excel file.

Question asked by johnrkegg on May 23, 2017
Latest reply on Jun 3, 2017 by curtvprice

I am working on a map and I am having trouble with it. I was wondering if you all could help me out.. So, I am trying to make a map of trees in a park. I have lat and lon of tree location in decimal degrees, tree count, tree species, trunk diameter, and photo id number in an excel file. I can add the excel file to ArcMap, but I cannot display the X and Y coordinates from the full excel file. However I can display the coordinates if I just add the excel file of the X and Y coordinates. I would like to be able to display the coordinates from the whole excel file so I can use select by attribute and other tools in the table on ArcMap for later purposes. The second problem I am having is when I display the X and Y coordinates from the only X and Y excel file the points are not in the correct area (Bellaire, TX) so I would like to fix that also. The converted graphics points are the correct locations of the trees and I got them from adding the points individually with the go to XY toolbar. Any help would be greatly appreciated. Any problems with the attached files or any other questions let me know. Thank you.

Outcomes