Script to automate batch processing of addresses to addresses with lat/long

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.

Ideally I would like something written in PHP or JavaScript so I can understand it and alter if needed but honestly any language will be fine. Occasionally there will be lines that are incorrectly delimited (a customer name may have a comma in it which throws of the delimited line) and it would be nice to account for this somehow even if it is just placing those lines at the end of a file for me to look at and fix by hand.

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.

Sample data:

"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.

Habilidades: Javascript, MySQL, PHP, Arquitetura de software

Veja mais: processing of data, d 555, php end script, mapquest geocoding, script automation, lat long, language processing, geocoding, batch file, automate some task -- 2, appending, google city state country, alter javascript, mysql append data, mysql append, comma fix, append line file, batch file name, delimited data, lat address php, mysql containing, mysql batch process, mysql batch job, automate number, latitude longitude google script

Acerca do Empregador:
( 1 comentário ) Las Vegas, United States

ID do Projeto: #5100193

Concedido a:


Hi, PHP expert here with experience with the Google Maps API. The task is clear, you need to look up addresses via the Google Maps API and save the results in a CSV file. I can do this for you with a well-comm Mais

$45 USD em 0 dias
(1 Comentário)

7 freelancers estão ofertando em média $122 para esse trabalho


Hello I have a script and using that I am able to provide you latitude and longitude of the addresses you provide me. If you wish you can award me and I will send the completed work within less than 3 days. Last w Mais

$166 USD in 3 dias
(59 Comentários)

Hi, Allow me to work for you, I have considerable amount of experience in web scraping. I will deploy a web program which will automatically scrape data for you. Kindly message me to discuss things further. Thanks Mais

$44 USD em 1 dia
(26 Comentários)

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

$84 USD in 31 dias
(20 Comentários)

Hello Aeon, I have read your requirement and i can done your work quickly. I will create a script for you that read your address line and find lat/long and put into another file. I will give you the file so you can r Mais

$40 USD em 1 dia
(10 Comentários)

I have good experience of php and I can do this project for you. I will need some more details. From where you get lattitude and longitude?

$222 USD in 3 dias
(5 Comentários)

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

$250 USD em 1 dia
(3 Comentários)