So as a side project, I have a database of clients that I want to put on a map so that all clients on the database will be placed at their corresponding locations. I have set up the database by address, city, state, and zipcode. I'm not entirely sure on the way to approach this. Since it will be a database that will be updated as time goes on, I wanted to eventually automate it to allow my coworkers to access this geocoded database via interactive map or application and add new locations. The database is roughly 600 rows of data on an excel file with multiple tabs (by state). I know this may be a vague question so please feel free to ask me questions that are pertinent to helping answer this question.
In all, my end goal is to create an interactive web map and application that will enable someone to type in the office name, address or any other available attribute and display it on a map. The image I have in my head is similar to what Google does when you search for a location on GoogleMaps.
Thanks for any and all help!
I have a few questions and comments...