Geocoding Addresses with the Enterprise Architect (Uploading a File)
With Route4Me Enterprise Architect, you can geocode thousands of addresses in seconds. Geocoding enables you to significantly increase the accuracy of your customers’ locations and ensure that your routes are as precise and efficient as possible. It also helps to fix insufficient or misspelled addresses by processing them and outputting complete and correct data. With geocoded addresses, you can spatially display your customers’ locations and recognize certain patterns that will enable you to make your routing activities more efficient and your business more profitable.
Enterprise Architect allows you to import addresses for geocoding in two main ways – by uploading a file/spreadsheet from your computer or by adding addresses from your Route4Me Address Book. To geocode addresses from an upload file, first, go to the “Addresses” tab at the top of the screen.
Next, you need to import a file/spreadsheet with addresses into the Enterprise Architect from your computer. To do so, click on the “Load” button in the top right corner. Then, select the file with addresses from your computer, and upload it into the “Addresses” tab respectively.
Currently, Enterprise Architect supports CSV file format only. For a spreadsheet to be successfully uploaded and processed, it should contain a header row and data rows. The header defines the type of information you are importing (i.e., addresses, zip codes, cities, etc.), while the corresponding data rows contain the actual address information.
Once the addresses are uploaded into the Enterprise Architect, they are displayed in the “Addresses” tab respectively. To delete one or multiple addresses from the list, first, select the addresses you want to remove, then click on the “Delete” button.
To geocode the uploaded addresses, click on the “Geocoder” button in the navigation menu.
Then, select the column(s) with the data (addresses) that you want to geocode from the left-side list and transfer them to the right-side list by clicking on the corresponding button.
Check the box next to the “Address Parser” to enable it. The “Address Parser” allows you to fix and properly geocode the incomplete or misspelled addresses.
You can also automatically upload the addresses to your Route4Me Address Book, once they are geocoded. To do so, check the corresponding box.
Click “Start” to geocode the uploaded addresses.
Once the addresses are geocoded, they are displayed in the “Addresses” tab with three additional columns. The “fixed_address” column contains fixed and complete names of the corresponding addresses when the “lat” and “lng” columns display the latitude and longitude coordinates of the geocoded addresses.
To download the list of the geocoded and fixed addresses, click on the “Save” button in the top right corner. You can also view and edit the geocoded addresses in your Route4Me Address Book if you selected the “Upload to Address Book” option.