EPE for Batch Geocoding
Mon, 03/03/2014 - 8:47am
 |
 16 years
|
I know EPE can do batch geocoding but I don't know how. I have a CSV file with Lat, Lon, Street, City, State, and Zip columns. How do I use this with EPE to get Lat/Lon filled in?
@Panache
I know EPE can do batch geocoding but I don't know how. I have a CSV file with Lat, Lon, Street, City, State, and Zip columns. How do I use this with EPE to get Lat/Lon filled in?
First, make sure when you run EPE, that Enable Internet under "Options" is checked.
Then load your file.
Finally, click on Tools > Batch Geocoding
figured it out.
I added a Name field. I then defined the fields in M-column CSV Fields. Next I open the csv in EPE. It had a warning box about invalid lat/lon. I clicked the apply to entire file box, then ignore. EPE created records for all entries without lat/lon. went to tools -> Batch Geocoding and it did geocoding for every record in the file. There were errors from when Google did not find the locations as given but these need to be worked out individually.
Also
Make sure the Lat/Lon fields are empty, not zero... I had some code that stripped details from a screen capture to aid in my POI creation. I used zero as the place holder and wondered why batch geocoding didn't work in E_P_E.
Well, duh... Zero is a coordinate!
Striving to make the NYC Metro area project the best.