Insightful Map Grouping

Quickly comb through location data values and attributes and select the appropriate filters to group your data using ShowMyMap’s smart grouping function. You can have your map display groups based on value subsets you specify to facilitate a clearly defined data analysis.

How To Use Map Grouping To Get Specific Insights

Using the map above, which shows the global ranking of the top 100 hundred tallest buildings, you can apply the grouping function so that the map will only show the tallest among the newest buildings. 

The location data values include: 

  • Building name 
  • Number of floors
  • Building’s height
  • Building’s rank value 
  • City where the building is located 
  • Year when the building was constructed

Except for the building name, all the other values listed above can be manipulated for grouping. 

To narrow down the data displayed to only the tallest among the newest buildings:

  • Filter out the oldest buildings. On the lower-left section of the map, hover over the drop-down box and choose “Built.” The map markers will automatically update to represent this selected category. 
  • Next, select the year ranges you’re interested in. The map will automatically filter out markers whose year ranges do not match your selection. 
  • Lastly, apply a second filter to further limit your data to only the tallest buildings among those constructed within the years you selected. Click on “Height” on the group selection menu, and select the top height range available. 
  • Your map will now show only the tallest, newest buildings, and where they are located in the world. 

If you want to clear the group selections, simply click on the group menu; alternatively, you can click the “x” icon on each of the groups.

Which Data Can Be Grouped?
  • Data with numeric values
  • Non-numeric, repeating values (e.g. category, type, etc.)

When you create your map, the first groupable column on your location data spreadsheet is automatically displayed and represented by colored markers. You can change the default group you want displayed by going to the “Validate and Set” option screen while you’re creating your map, or by editing a saved map.

How To Disable Map Grouping

If you don’t want your map data to show any default grouping, you can simply disable the grouping feature. 

Edit your saved map. Click on “Validate and Set.” Find the “Group By” option and select “Single Color.” And save your updated map.

Automatic Map Grouping

When you’re creating your map using location data on a spreadsheet, ShowMyMap identifies actual location data, e.g addresses, city names, and zip codes, for geocoding. The remaining data is analyzed and identifiable attributes or values are used to create groups. 

Your map can display up to five or seven groups – which you can initially create in your spreadsheet. ShowMyMap applies appropriate ranges to numeric values based on the distribution of these values within your overall location data. 

Repeating values, both numerical and non-numerical, are grouped based on “popularity” or frequency of occurrence.

When a user selects two or more categories within a group, ShowMyMap’s open-matching algorithm will identify “this” OR “that” category.  On the other hand, a restrictive matching algorithm is applied for selections across multiple groups, wherein ShowMyMap then identifies “this” AND “that” category. 

ShowMyMap’s intelligent tools make both basic and advanced mapping functions easy and simple, even for those who have zero or limited knowledge of how mapping works. 

Data grouping does not require advanced knowledge in statistical methodologies or coding; you don’t even have to know how to use and create Excel formulas. ShowMyMap’s grouping function will help you group your map data exactly the way you need to do it with just a few clicks. Try it now!

Start creating map

Drag and drop your file (xls, xlsx or csv) Use our sample data, by clicking here. Or

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Copy + paste your data
Configuration

Map Fields

+ Add Custom Field
Show More

    Oh no!

    On the free tier you can only map up to 150 locations at one time. Please add a plan if you wish to map more than 150 locations.

    Related Articles