I am unable to display the coordinates XY since I do not visualise the fields containing them into the drop-down menu of the "Display XY" or Make XY Event layer. The fields are perfectly fine in the tables. There are no spaces, blanks. Tried imported the files as Excel, CSV, DBF.
Ideas on why is this happening? Solutions? Thanks in advance!
Solved! Go to Solution.
Check the field properties, very likely they are string for coordinates they need to be double. Might have to add new fields as doubles and calc the fields from the old string fields. Also check for things in the fields like commas as the software uses this to define them as strings.
Bring in the excel table to ArcMap, export it out as a dbf or GeoDatabase table, you have to export as ArcMap will not edit excel. Open the new table add in 2 new fields for the lat/Longs, define as double. Using the field calculator calculate their values to be the old lat/long fields, this should bring them over and save them as double.Once done, then right click on table, add X,Y enent and you should see the new fields. Make sure Lat is Y and Long is Z. Under projection, set it to 4326 / WGS 84 if it’s really Lat/Longs. The points should show up in the right place, if so then export out as Shapefile or FeatureClass and your done.