Rhiza Labs is proud to announce the addition of an important new feature to its Rhiza Insight tool: geocoding. Users are now able to import a spreadsheet of street addresses within Rhiza Insight, and the tool will automatically assign a latitude/longitude for each valid address. This means you can now create a maps of customers or members, or any other set of locations that are important to you. This feature is currently limited to US-based locations for the time being.
Here’s exactly how this feature works. Let’s say you have a spreadsheet of addresses that you would like to see on a map. In this case, I have a spreadsheet of the addresses of non-profit organizations in Santa Fe, NM, along with their assets, revenue and expense numbers (btw, we got this data from the nice folks at Socrata):
I was able to save this data from Excel as a CSV (Comma Separated Value) file. I then went through the normal import process within Rhiza Insight. When I got to Step 3 of the import process, I now have the ability to choose to geocode the dataset by simply defining which attributes of the data are the best to use for Street, City, State and Zip. You can see this part of the process in the image below:
Once I finished the import process, I visualized the data showing all records as purple dots with 65% transparency (so you could see when there were multiple dots in the same area). Here’s an interactive version of the snapshot. Feel free to zoom, pan and click on the dots for more information. You can also close the legend by clicking on the legend’s tab:
Please note that you can always decide to make a dataset private by sharing it only with your private workgroup. This allows you to import data about individual addresses that you may not want to share publicly.
Give it a try on our free trial site at http://insight.rhiza.imagebox.com and let us know how you’re using this new feature.