When you upload your data to eSpatial online, every location point in your Excel spreadsheet is plotted on a map. However, you may not always want to see all the data at the one time – or you may want to perform an analysis and save it. You can easily do this with eSpatial mapping software. Get a free trial.
How it works
eSpatial allows you to create a map from an Excel spreadsheet in a Workspace and then analyze it in a countless number of ways. By using the Save As button, you can save maps – created from the same data – within the one Workspace, and access them anywhere, anytime.
Let’s take an example…
I have uploaded my spreadsheet data – my US Customers – using eSpatial. Here’s the result.
This is an interesting, simple pin map – not only does it show me where my customers are, but it also indicates levels of sales (by the color of the pins) attributed to each customer.After I have saved this under an appropriate name – National Map Of Customers – I can start exploring other ways of expressing the mapped data.
For instance, what if I wanted to concentrate on customers in Arizona only?
Filtering for analysis
I would need to turn on a filter that singles out Arizona from the rest of the US and zoom in closer on the map. This would be the result (I could probably zoom in a bit closer):
To save this new view of my original mapped data, I would click the Save icon from the control panel and select Save As (clicking SaveĀ would overwrite my original map).
I will give this map a new name – Arizona Customers.
Now I have created two map views out of my original data, contained in the same Workspace. But there are countless other ways I could analyze and visualize this data. For the sake of brevity, I’ll provide just two more examples.
One-point radius mapping
Zooming in closer to the map of Arizona, I decide I want to find how many customers fall within 5 miles of The Botanical Garden. To do this, I will go to the top toolbar and click the icon to place a temporary point on the map:
When I place this on The Botanical Garden, I will add a radius range of 5 miles. This gives me the visualization below. (Although you can’t see it, the center point of the radius circle is placed in The Botanical Garden).
In the same way that I saved the Arizona map, I will save this map – i.e., using Save As again.
Now I will go back to my original map – National Map of Customers. I will open this by clicking the folder icon on the control panel:
I can now see all the map views that I have saved.
The existing map provides a lot of visual detail – perhaps too much. So I want a simplified overview that perhaps I could share with colleagues in my office, to indicate state-by-state customer level. I decide that a good way to communicate this quickly is by creating a heat map. And here it is:
I will save this exactly the same way I have saved my map views – using the Save As command.
Now I have four different visualizations of the same data – each telling something different. While in this Workspace, I can access each data map quickly and easily, just by clicking on my open folder icon in the control panel.
Name the Workspace
For convenience, I am now going to name the Workspace in which all the maps created from the same data are contained. First…
Then…
Now when I go into my library, I will find the named Workspace and be able to access the multiple views of the same data.
Share different map analysis with different colleagues
One of the benefits of eSpatial being online mapping software is that you can create maps and share them, simply by cutting and pasting the URL link of an eSpatial map. Find out more about sharing here.