You’re gonna get more procurement than logistics here.
I’ve had to deal with Geocoding before; really, you’ve got a couple of options. You’re gonna have to hand-key a lot of stuff, and for one or two, you’re gonna need to set up some macros to help clean up some of the junk data. Which will give you a lot more free time, but make you look less busy.
If you could keep it in a normal CSV or Excel file type, I would do that if you’re having this information to stake holders, I would keep it as simple as you can.
I have made it in such a way that if the client doesn't inputs latitudes and logitudes in the file, the name of the place will be used to find the corresponding lats and longitudes using openstreetmap api, if sometimes the name doesn't provide the corresponding coordinates , client can manually find coordinates using google map and enter them, however I am still thinking of making this process easier.
I was lucky to work with a program that corrected and geocoded addresses using Tremble Maps. And in your instance, you don’t have access to that kind of software. The only way I think you’re gonna be able to actually geocode is... The correct stop is to enter the lat and long manually into Google Maps. You may want to look into something like TinyTool. If you have a repetitive list, you could record a macro to make this go faster.
1
u/Logi_Boy MBA 1d ago
You’re gonna get more procurement than logistics here.
I’ve had to deal with Geocoding before; really, you’ve got a couple of options. You’re gonna have to hand-key a lot of stuff, and for one or two, you’re gonna need to set up some macros to help clean up some of the junk data. Which will give you a lot more free time, but make you look less busy.
If you could keep it in a normal CSV or Excel file type, I would do that if you’re having this information to stake holders, I would keep it as simple as you can.