best way to convert a csv file with UTM to lat long

21257
39
06-16-2016 08:33 AM
Highlighted
New Contributor III


I have a huge amount of .csv files each with hundreds of rows and each has its own value of an easting and northing

How can i quickly change these UTM coordinates and convert them to a lat/long  coordinate value using ArcMap.

What might you suggest is the most efficient method? Im very new to this, so any help and details is greatly apprecaited

Reply
0 Kudos
39 Replies
Highlighted
Occasional Contributor

I have fond that the winning combination for tackling these kind of issues is using ArcGIS + FME which handles files wonderfully and can make the transformations you are looking to make a breeze. It works wonders by reprojecting  You can download a fully working trial at FME Desktop | Data Integration & Productivity | Safe Software

Give it a try and let me know how it goes. You can try using the  tool AttributeReprojector:

Sorry if I mention another tool instead of solving the issue with ESRIs software, but I really had great experience working with this software combo. BTW, I'm just a regular FME user and not affiliated with them.

Reply
0 Kudos
Highlighted
New Contributor III

Thanks for the information Hector, the tools look awesome from FME, unfortunately the cost ranges from $6400 to 20k, this is a bit expensive for my company and will not pass go! Even using the trial only band aids my problem, im looking for a long term solution this this using the tools that I have, i appreciate your help in any event

thank you kindly

marina

Reply
0 Kudos
Highlighted
Occasional Contributor

Oh yes, I know what you mean. I made the case to my bosses on the basis $2250USD would save a lot in processing time and faster workarounds for the analysis and we are now seriously considering buying the standard desktop version. but I digress...

Have you tried using the Project—Data Management toolbox | ArcGIS for Desktop tool?

I find it difficult in ArcGIS to have a CSV file and convert it to SHP to show the points on my map, I use FME for this

Reply
0 Kudos
Highlighted
MVP Honored Contributor

If you want to stay fully within ArcMap, convert your CSV to a layer using Make XY Event Layer. Then, calculate lat/longs using Add Geometry Attributes, specifying WGS 1984 as the coordinate reference system. Both tools can be run using batch processing to loop through your files.

edit: forgot to mention event layers are temporary layers. You will likely need to run Copy Features to save the file to disk at some point.

Highlighted
New Contributor III

Hi Darren, I think that is the most efficient way to go about this, i appreciate your help

Reply
0 Kudos
Highlighted
Regular Contributor II

While I agree with Darren, you might want to read before you go ahead...here is the tips about .csv files

CSV, TXT, and GPX files—ArcGIS Online Help | ArcGIS

Another good information for you to read ...    https://brocku.ca/maplibrary/Instruction/Part_One_GPS_Data_Collection.pdf

I do not remember if I was able to load the .csv to DNR Garmin and save it as a shapefile in a quick way...it has been a while I last used...but worth trying to research it.

Import CSV: Data loss and rounding.    <----  it talks about import .csv to DNR Garmin how to use it..

Reply
0 Kudos
Highlighted
MVP Honored Contributor

This is possible with DNRGPS (new version of DNR Garmin), but it's difficult if not impossible to run in batch mode. Also, you'd need to convert all of your easting/northing field names to x_proj/y_proj. It's just not set up well for this.

Reply
0 Kudos
Highlighted
Regular Contributor II

Yeah, unless if  Marina is comfortable and knows how to deal with it or not...   I was just giving another way around to make the job easier..

Reply
0 Kudos
Highlighted
New Contributor III

Thanks Robert, I will check out the information, there's always more than one way to accomplish something!

Reply
0 Kudos