One of MapMate's strengths is the range of analysis queries that it is possible to run on your data. The first four videos cover aspects of analysis using the standard MapMate queries:

The browse list control buttons - every time you run a query in MapMate the results are presented in a 'browse list' (looking rather like a spreadsheet). Each browse list has a standard set of controls at the top.

Using the data entry window to filter your data and run queries - it's possible to do lots of data analysis from the data entry window, quite apart from MapMate's specific Analysis section.

Using the "F9 Custom Query" from the data entry window to design your own query.

Using "wildcards" to group together data for recorders or sites that have similar names, in the Analysis section of MapMate.

Adding a custom query to MapMate

If you need an analysis query that does something different to the standard ones that MapMate supplies, you'll need to add a Custom user query, covered in the fifth video on this page:

Adding a custom user query

Some examples of BSBI queries that you can copy and past into your MapMate database are provided on the custom queries page of this website.

If you want to explore further and start writing the code for your own custom queries, Martin Rand's comprehensive Introduction to SQL for Mapmate Users (pdf download, 2.3Mb) is strongly recommended. See also the MapMate data model described in Appendix A of the BSBI MapMate Book.