Blog

Spatial Data Aggregation

Use highlighted regions and data uploads in ZeeMaps to conduct quick spatial data aggregation. For example, you can analyze data for the different territories you have marked on your map.

Spatial Regions Highlighting

You can highlight areas on your map by zip codes, counties, cities, states or geometrical areas like circles and rectangles. An area of interest will often comprise of several smaller areas. For example, a sales territory map might divide the country into several regions, each containing multiple states.

The fastest way to highlight large number of US zip code areas or counties on your map is by uploading a spreadsheet with address and color information. This is far quicker than highlighting regions on your map one at a time. This blog post explains how to do that. When you upload a spreadsheet to highlight zip codes or counties, your spreadsheet can contain additional columns of data that will be taken as “fields” for that zip code or county.

For other areas like US States, or countries, you’ll need to highlight the areas using the Additions -> Highlight Regions menu on your map, and then upload your data using the Additions -> Add (Upload) Multiple markers, separately.

Spatial Analysis

Now that you have different territories marked on your map, you can access the spatial aggregate data feature.

As an example, we are using the map of Las Vegas zip codes divided into five colored regions. Each highlighted zip code has population fields that describe populations in 2011 and 2012, and the median income. The map is shown below. Click on any of the highlighted zip code to see the details for that zip code.

When visiting the map on the ZeeMaps site, we select ‘View’ and ‘Aggregate data by region’ from your map menu.

Spatial Data Aggregate Map Menu

Spatial Data Aggregate Map Menu

In the resulting dialog, choose your field values and whether you’d like to see results presented as sum, average or count.

Spatial Aggregate of Marker Field Data

Edit Marker Field Data

Hit ‘Submit’ to see your aggregate data results that will give you the sum of populations for 2011 and 2012, and the average of the median income in each of the five colored regions that we have defined on the map.

Spatial Aggregation Data Results

Aggregated data results

This example shows the 2011 and 2012 population and median household incomes for zip codes in Las Vegas, NV. ZeeMaps allows you to define your own marker fields, so you can perform this spatial analysis on any of your fields.

At present, you can only spatially aggregate marker data by highlighted colours. In the future, we will be extending this so you can also aggregate data by geographical areas, e.g., get spatial analysis by countries, states, and so forth.

If you’d like to try out the aggregate data by regions feature, you can use this sample map – the zip codes in Las Vegas, NV that we’ve been using as an example in this post. Let us know what you think.

Garage sales are easy with map marker features

There are some ZeeMaps features that are particularly useful for people organising garage sales, yard sales or even estate sales. One such feature allows you to copy or move a marker from your map to others that you own. And if you are a paid user, you can also add a marker to all your maps at once.

To access the copy/move feature, click on a marker on one of your maps. An information box with details of your marker will appear and you’ll see five icons in the bottom right corner. If you hover over the third icon which looks like two pages, it says ‘Copy/Move’.

Copy/move a marker to plan garage sales

When you click on this icon, you’ll be taken to a ‘Select a Map’ window. Choose the one or more you want from the dropdown list of all your maps and select ‘Copy’ or ‘Move’. Your marker will be copied or moved to the map or maps you requested.

To add a marker to all your maps at once, you must be a paid user. To enable this feature, go to your sign-in information on the top right of the page. Select ‘Account’ from the dropdown and then the ‘Settings’ tab. Tick the box that says ‘Enable marker additions to all maps at once.’ Click on the Save button at the top of the page to save these settings.

Enable marker additions to plan a garage sale

Open one of your maps, and select ‘Additions.’ Whether you choose ‘Add Marker – Simple’ or ‘Add Marker – Detailed’, the ‘Add Entry’ information box will appear. At the bottom there is a checkbox where you can choose ‘Add to all my maps.’

Add to all my maps to plan a garage sale

Planning garage sales more effectively 

The copy/move feature and the ability to add a marker to all your maps at once make it easier to organise community garage sales or yard sales. A customer had this to say on our testimonials page: “Thank you sooo much! I love this software! I am so glad I found you! I am telling all my friends who have to map garage sales for their communities. What a time saver!”

We’ve heard that the copy/move feature is also really useful for sales teams. Each salesperson is given a map with their own leads and customers, but when customers need to be assigned to a different team member, this feature allows that to happen easily.

Similarly, we have many people using ZeeMaps to plot locations for each staff member on a daily basis – to mark where roofs need repair or broken glass needs fixing, for example. If a staff member is running late or gets sick, their locations can quickly be transferred to another map.

My Maps Merge and Switch between Maps

ZeeMaps allows you to merge maps (two or more) and easily switch between maps you’re working on.

Merge my maps

To merge maps, you have to be a paid user. You won’t be able to take the following steps if you’re on the Basic plan, which is free. Please check pricing information here.

When you merge maps you create a new map that contains all the points, highlighted regions, legends, connections and annotations that each of the original maps contain.

To do this, click on the ‘My Maps’ link on the homepage. Alternatively, you can hover over your sign-in details at the top right of the page and select the ‘My Maps’ menu option from there. Select two or more maps by clicking anywhere in a map row except the map name. Once they are highlighted, go to ‘Map Operations’ and select ‘Merge’.

My maps merge

You’ll be asked for a title and a description of the new merged map, and whether you’d like to proceed.

Once the new map is created,  you can access it in ‘My Maps’ and print it or use it on websites, blogs or social media platforms. You can also save your new map as a PDF, PNG or CSV file.

The new merged map exists in addition to the originals, so you can still access your original maps. However, changes to the originals do not reflect in the merged map.

Switch between maps

You don’t have to be a paid user to switch between maps and it’s a feature that makes ZeeMaps even smoother to use. You can only switch between maps that you own. You can check what you’ve got by looking in ‘My Maps’.

If you are working in one map and would like to switch to another of your maps, go to ‘Map’ on the left of the menu bar and select ‘Switch Map’.

Switch between my maps

You’ll then be taken to a ‘Select a Map’ window where you can see all your maps and you can choose the one you want from the dropdown list.

This is a useful feature if you are working on store location maps or customer maps for example, and want to ensure they are consistent in appearance (marker color, annotation style, etc.)

OneDrive Spreadsheets: Map Location Data

ZeeMaps allows you to create interactive maps from location data stored in Microsoft’s OneDrive spreadsheets. ZeeMaps can periodically update the map as the spreadsheet changes.

You upload and attach your OneDrive spreadsheet to a map only once, then the map can be automatically kept updated as your spreadsheet changes. This way, you do not have to worry about making changes to both your spreadsheet and your map.

In order for this to work, make sure that you do not:

  1. Change the name or location of the spreadsheet
  2. Change the columns of your spreadsheet.

If you make any of the above two changes to your spreadsheet, then you must delete all data from your map and re-upload and attach your spreadsheet.

Attach a OneDrive Spreadsheet to a map

To attach a OneDrive spreadsheet to a map, first create a map on ZeeMaps. Use the Additions -> Add (Upload) Multiple Markers menu item on your map, and then select the Cloud Drive Spreadsheet Option.

Upload Data from OneDrive Spreadsheet to a a map

Upload Data from OneDrive Spreadsheet to a a map

In the Cloud Drives drop-down, select the Microsoft OneDrive option for the Provider control, and hit the Fetch My Spreadsheets button.

Select OneDrive Provider

Select OneDrive Provider

At this point, a window should be activated that asks you to sign-in to your Microsoft OneDrive account and give ZeeMaps access. Once you’ve granted access, you should see a list of your spreadsheets and be able to select the spreadsheet that you want to upload to the map. From here on, follow the steps for uploading a spreadsheet to a map.

If you want your spreadsheet changes to be automatically reflected on your map, make sure that you check the option for “Regularly update from Cloud Spreadsheet” in Step 2 of the confirmation process for the upload:

Periodically Update Map from OneDrive Spreadsheet changes

Periodically Update Map from OneDrive Spreadsheet changes

From then on, the map should be automatically updated when your spreadsheet changes.

To see what spreadsheets are attached to your map, use the View -> Cloud Drive Sheets menu item on your map.