Showing the Number of Rows at Each Location

When there are multiple cases for a single location–that is, multiple data rows for a single pair of unique latitude and longitude coordinates–this may not be apparent from the map because of overplotting of symbols. The multiple rows at a location can be seen in the data table, but identifying them may not be easy. Mapdata provides several ways to find co-located data, and one of them is available from the Table/Counts by location menu item.

That option displays a table like the following.

A table showing the number of row counts for each unique location

This table contains a single row for each unique set of geographic coordinates, which are shown in the first two columns. The third column shows the number of cases for that location.

The table may contain additional columns if there are any columns in the data table that contain candidate keys for the geographic coordinates–that is, a unique identifier for every unique set of geographic coordinates.

The table of counts by location can be saved with the Ctrl-S hotkey.