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.

Geocoding Addresses with the Route4Me Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Route4Me Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

To geocode the uploaded addresses, click on the “Geocoder” button in the navigation menu.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

You can also automatically upload the addresses to your Route4Me Address Book, once they are geocoded. To do so, check the corresponding box.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

Click “Start” to geocode the uploaded addresses.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

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.

Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

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.

Private: Geocoding Addresses with the Enterprise Architect (Uploading a File)

 

After geocoding the uploaded addresses, you can use them for planning optimized routes, generating territories and many other routing activities.

 

Visit Route4Me's Marketplace to Check Out Various Industry-Based Subscription Plans:

Was this article helpful?
Still can't find what you're looking for? Contact us