Automatically geo-reference an existing client list with largely unverified addresses to provide the company with a global perspective of their client base
Solution
Exported static address data from the existing client business application, including client key and address information
Imported the data into an Excel or similar format for initial review and cleansing
Developed a script to systematically process each record, passing the information to a freely available plugin to identify and locate latitude and longitude coordinates
Utilised the returned coordinates to update the primary business application via another script
Benefits
Provides a simple and efficient method to parse address data and generate a dynamic view of the client base with the assistance of a mapping plugin
Incorporating the date of client opening enhances the view by indicating the growth or loss of the client base over time
Offers a fast, efficient, and repeatable process for geo-referencing client data, enabling better insights into client distribution and trends
