Every month I am given a comma delimited data file containing 10,000+ lines of data. Each line contains a customer number, address, and phone #. I have the task of appending a latitude and longitude to every line in the data file. I need a way of automating this task.
The automation should take a [url removed, login to view] file as the input, process the data, connect to some sort of geocoding service such as Google or mapquest and append the latitude/longitude to the end of each line, output a new delimited file named [url removed, login to view] or [url removed, login to view] which contains all the data from [url removed, login to view] with the addition of latitude and longitude for all lines.
The [url removed, login to view] file will be provided to the person chosen for the job and a fast turn around is needed. Person is chosen today and I'd like job done quickly.
"Customer Number","Name","Address Line 1","Address Line 2","City","State","Zip Code","Country","Phone Number"
810000010,Business Name,Forrest Street,Apt 405,New York City, NY,00500,US,555-555-1234
Message me if clarification is needed.
Clarification: You will need to use the address to find the Latitude and Longitude. In the past I have tried using Google Geocoding API to find the lat/long for each address.
7 freelancers are bidding on average $122 for this job
Hello, I am Oracle certified professional java programmer and have Bsc.IT. I have done many similar projects before. I will use java to automate this task. thanks
Hello! I know of a couple of API services I could use for this. Are all of the addresses in the U.S.? I'd write it up in PHP since I'm most comfortable with that :) Cheers /Johan