Data maps · 8 min read

How to Filter, Query and Analyse Data on a Map

Explore the data behind your map: browse the table, read the statistics, filter by any field, clip to an area and count, buffer or bin places in your browser.

Updated · by the mapbow team

A map with three thousand pins on it is a starting point, not an answer. The answer comes when you narrow it down – only the 4-star hotels, only the stores inside this territory, only the schools with more than 500 students – and then summarise what is left. mapbow has the tools for this built into every layer: a table of every feature, statistics, filters and a set of analysis tools that turn one layer into another. Everything runs in your browser, on your own imported data and on mapbow's ready-made layers alike.

Explore and filter a layer step by step

  1. Open a layer's Data tab. Select a layer (click it in Layers, or click one of its places and then Layer style) and open the Data tab.
    The Data tab: the table, statistics and every field.
    Step 1 The Data tab: the table, statistics and every field.
  2. Browse the table. Open the table lists every feature: search across all columns, click a heading to sort, click a row number to fly to it. On your own layers every cell can be edited.
    Hotels in the table, searched for "sydney".
    Step 2 Hotels in the table, searched for "sydney".
  3. See the statistics. Statistics sums the layer up: how many features, total length and area for lines and shapes, the minimum, average, median, maximum and sum of every number field, and the most common values of any field.
    Statistics for a layer of hotels.
    Step 3 Statistics for a layer of hotels.
  4. Filter it. In the Filter tab choose a field and a rule - is, is not, contains, is one of, greater than, at least, less than, at most, has a value, is empty. Only the matching features stay on the map, and the count updates as you type.
    Only hotels with 4 stars or more.
    Step 4 Only hotels with 4 stars or more.
  5. Clip it to an area. Draw an area (or Use a drawn area) keeps only what is inside it - the CBD, a suburb, a sales territory. Combine it with a field filter, and clear either at any time.
    4-star hotels inside the CBD only.
    Step 5 4-star hotels inside the CBD only.
  6. More analysis tools. The Tools panel has the rest: count points in areas, hex bins, buffers, convex hulls, bounding boxes, centroids, Voronoi zones, merging areas and simplifying shapes. They work on what the filter shows, and each creates a new layer.
    Tools › Explore your data and Analyse.
    Step 6 Tools › Explore your data and Analyse.

Getting more from the table and statistics

  • Find one record fast. Type a name, postcode or phone number into the table's search box – it looks in every column.
  • Find the extremes. Click a heading such as stars or sales to sort, then click the row number of the top row to fly to it.
  • Fix your own data in place. On imported and drawn layers you can edit any cell, add a column (for example a "Region" or "Visited" column) and delete rows. Ready-made data layers are read only.
  • Turn a statistic into a map. Under Statistics, pick a field to see its most common values as bars, then use Colour the layer by that field – one click from "what is in here?" to a coloured category map.

Filter rules explained

RuleUse it forExample
is / is notOne exact valuestate is NSW
containsPart of a text valuename contains "Medical"
is one ofSeveral values at oncetype is one of cafe, bakery
greater than / at leastNumbers above a level (at least includes the value itself)stars at least 4
less than / at mostNumbers below a levelprice at most 250
has a value / is emptyFinding gaps or complete recordsphone is empty

The value box suggests values from the data, and the most common ones appear as quick chips. The tab shows "N of M shown", and the layer list marks a filtered layer "N shown" so you never forget a filter is on. Hidden features stay in the layer – press Clear filter and they come back. The filter is saved with the map, so the shared map shows the same places.

The analysis tools

Open Tools on the left rail. The Explore your data group opens the table, statistics, filter and clip for any layer. The Analyse group turns a layer into a new one:

ToolWhat it makesTypical question
Count in areasAreas coloured and labelled by how many points fall inside eachHow many customers per postcode?
Hex binsEven hexagons coloured by the number of points in eachWhere are cafés densest?
BufferA zone of a set distance (km, miles or metres) around every feature, or the selected oneWhat is within 500 m of the rail line?
Convex hullThe smallest outline that contains a layerWhat area do our jobs cover?
Bounding boxThe rectangle around a layerWhat extent does this data span?
CentroidsA point at the centre of every area or lineWhere is the middle of each suburb?
VoronoiZones of the map closest to each pointWhich store is nearest each area?
Merge areasTouching and overlapping areas joined into one outlineWhat does the whole region look like?
SimplifyLighter, smoother lines and outlines (your own layers, or data layers you own)Can this detailed boundary load faster?

Every tool works on what the layer's filter shows, so filter first and analyse second. Results are new layers you can style, filter and analyse again. For hexagons in depth, see how to make a hex bin map; for smooth density, how to make a heat map.

Worked example: premium hotels per suburb

A tourism business wants to know which Sydney suburbs have the most 4- and 5-star hotels.

  1. Add the layers. In Add data, choose Australia and add Hotels and Suburbs & localities (for New South Wales only, to keep it light). That uses the map's two free data layers.
  2. Filter the hotels. Select the hotels layer, open Filter and set stars – at least – 4.
  3. Clip to greater Sydney. Under Clip to an area press Draw an area and outline the metropolitan area.
  4. Count. Open Tools › Count in areas, pick the suburbs as the areas and the hotels as the points, and run it. A new layer appears with each suburb coloured and labelled by its number of premium hotels.
  5. Read and share. Click a suburb for its count, open the new layer's Statistics for the average per suburb, and press Share to send the map.

Swap hotels for your own imported customer list and suburbs for postcodes or sales territories, and the same five steps answer "where are our customers?". To draw your own areas first, see how to create a sales territory map.

Filter your map data

Frequently asked questions

Can I filter a map by a column in my spreadsheet?

Yes. Every column you import becomes a field. Choose it in the layer's Filter tab with a rule such as is, contains, at least or is empty.

Does filtering delete my data?

No. Hidden features stay in the layer. Press Clear filter to show them again.

How do I count points inside areas?

Use Tools › Count in areas. Pick an areas layer and a points layer; the result is a new layer coloured by count, with the count in each popup.

Can I edit the attribute table?

On your own imported and drawn layers, yes: edit cells, add columns and delete rows. Ready-made data layers are read only.

Do I need GIS software for this?

No. Filtering, statistics and the analysis tools all run in your browser. If you want to continue in QGIS or ArcGIS, you can export the layers.

Keep reading

Free to start · no sign-up

Your map is two minutes away

Pick a country, add the places that matter, draw on it, and share it with the world - on any device.