OCMS Support > OCMS Support > Knowledgebase

Search help:

Geocoding OCMS Clients


What is Geocoding?

Geocoding is the process of converting addresses (like "1600 Amphitheatre Parkway, Mountain View, CA") or postal codes into geographic coordinates, which you can use to place markers on a map, or position the map.

What can geocoding be used for?

From simple data analysis to business and customer management to distribution techniques, there is a wide range of applications for which geocoding can be used. With geocoded addresses, you can spatially display the address locations and recognize patterns within the information. You can also display your address information based on certain parameters, allowing you to further analyze the information.

How can you do this with OCMS?

You can run a report showing the various cities that your clients are located in. You can get a list of your clients with their postal codes in Excel file using the Find Client link located in the sidebar and geocode them using the absolutely amazing free software.

The program is called Google Fusion Tables.

You will need to start with a Gmail account if your location does not already use this as their email client. (If you do not have an account click here for instructions).

Once you have a Gmail account you can start by going to Find a Client on the OCMS sidebar.

Find a Clinet in My Agency

Leave this blank if you want a list of all clients who have registered in your agency (this does not mean they have received services), click Search.  Once you see the list of clients click on Add/ Remove Columns.


Scroll down until you see postal code drag it to the top, you can remove any other columns by dragging to this drop-down.

 add remove options

Once you have your list with postal codes click on Export.      Export

Save the file in excel format, make sure you know where this is saved.

save as excel


Below you will see only the postal code and client number were saved.


Now click here to create a fusion table once you are on the site click on Create a Fusion Table.

Import new table.


Click Choose File and find the file you just saved.

Now click on Next.

If your column names are in row 1 click Finish or use the drop-down to find the correct row first.

Click Next.



Click Finish.

This is your first screen (Rows tab)  (These are not real clients they are just examples)

Cards Tab  (Not real clients, just examples)


Map of Postal Code

There are many things this can do, this is just one example. 


postal code map

You can also run a Client Contact List Report by narrowing down your information.

Use the Client Contact Report to include only clients who have received services.

client contact list report


Take some time to play with different reports and information to see what works best for you.

For help with fusion tables

This feature is not included in OCMS, however, we have added it to help with your reporting using third-party software.


Was this article helpful? yes / no
Related articles Find a Client
Find a Session
Employer Directory
Article details
Article ID: 146
Category: Geocoding Clients
Date added: 2018-01-17 16:40:46
Views: 129
Rating (Votes): Article rated 5.0/5.0 (1)

« Go back

Powered by Help Desk Software HESK, in partnership with SysAid Technologies