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.
Note: each entry needs to have corresponding ZIP codes for Bangkok
11 freelancers are bidding on average $535 for this job
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.
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
Hi as per your request post on here do u want the final output in the form of kml / kmz ? and one more thing is the raw data contains the zipcode?