I have a .csv file with multiple well locations in Australia. The data is in GDA 1994, although I have put in the easting and northings into GIS manually in UTM Zone 52S and it plots them right where they belong. Among the data columns are three different type of coordinates: lat/long in d m s; easting and northing in meters; and lat/long in decimal degrees. I can manually enter a well's coordinates with the easting and northing and they plot where they should just fine. I have around 3000 wells so manually entering them all will take forever.
Unfortunately, when I bring in the .csv, right click, and go to Display XY Data the easting and northing columns/fields are not available. Both lat-long fiels show up, but of course they plot incorrectly. I have tried different coordinate systems in the base map, doesn't work. I have tried just bringing them in, then projecting them. No surprise, that didn't work. I even tried deleting all the other columns except the easting, northing, and name. Then nothing was available.
Any ideas as to why it would not want the easting and northing?
The map coordinate system is set to UTM, so I don't understand.