I have a list of 6,000 Bangkok addresses that need to be standardised from freeform text.. example of data:
Manor Complex, 32/1 Sukhumvit Soi 39, Bangkok, Thailand
85/75 Soi Chaeng Wattana 12, near Big C Chaeng Wattana, Chaeng Wattana Road, Thung Song Hong Subdistrict, Lak Si District., Bangkok, Thailand
342/3-4 Phaya Thai Road, Thanon Phaya Thai Subdistrict, Ratchathewi District., Bangkok, Thailand
Behind The Esplanade Ratchadapisek Road Din Daeng Subdistrict Din Daeng District, Bangkok, Thailand
Near Thon Buri Hospital 2, Boromarajonani Rd., Sala Thammasop Sub-District, Thawi Watthana District, Bangkok, Thailand
I basically need to clean these up so that they are able to be used by google maps.
I'm a GIS expert with 10s of successfully completed projects on and outside freelanser.com. I have already developed a semiautomatic utility for formatting and cleaning up addresses. The utility integrates Google Maps, GeoCoding, GeoNames, String Matching, and Spelling Correction.
Hi,
I have a lot of experience with geocoding and reverse geocoding, including in foreign countries with specific address formats (Thailand, Japan for instance). I have developed scripts to send requests to Google API and get the results compiled back in a file. I have completed some geocoding projects here on freelancer.com I suggest you check my reviews.
I have a question though regarding the addresses, what is the source of these addresses? I tried the ones you attached in your file and in order to get results from Google I need to remove part of the information. This will mean somehow a cleanup of the source file before running it by Google and potentially iterations to send additional requests with more or less information for some records until Google recognizes it.
Do you have additional info about what you want to display on the map? If it's a type of business (restaurant for instance) it could help narrow down the results returned by Google.
In any case a sample file with more addresses would be helpful.
As far as the time to get the results goes, it's mostly driven by Google limitations for geocoding requests based on IP. There is a cap to the number of daily requests for the free API and unless you are willing to pay for additional requests this drives the delivery time.
Do not hesitate if you have any questions. I'm also US based which could make communication easier.
I look forward to hearing from you and starts working on your project.
Regards.
Xav.
Thanks for inviting me in to submit my proposal. Looking forward to work with you. Please send a sample in excel how addresses are now and how you want addresses to be.
Well , I am a good database administrator and a quick thinker . I have some experience in this field and would like to help you in every possible way i could and if the fastest time of all . Work will be 100 % satisfactory & appreciable.
Regards ,
Harshit ( New Freelancer )
Data cleansing in Excel using certain function options.
I have done this type of work before.
I can also geocode the addresses and plot it in a map using GIS
Dear Project owner,
I am a Thai native developer who live in Thailand and have experience with database and web development more than 6 years.
I have a plan for handle your data already and guarantee on correction arrange and match with zip code.
If you still have question, can contact me for discuss or interview before decide.
Regards,