The Biological Records Tool for QGIS (version 2.8.0)

This is the help for version 2.8.0 of the FSC QGIS plugin which is the last release compatible with version 2.n.n of QGIS. If you want to see the help pages for version 3.n.n of the plugin, which is compatible with version 3.n.n of QGIS, then follow this link: FSC QGIS plugin for version 3 of QGIS.

The main purpose of the Biological Records Tool is to allow you to take a spreadsheet of biological records and map them in QGIS, either as points for individual records, or by aggregating records by OS grid squares. The aggregating feature can also be used on an existing point layer rather than a spreadsheet of records. Biological Records Tool toolbuttonTo start the Biological Records Tool, click the relevant button on the TomBio toolbar. By default, the biological records tool docks initially at right of the QGIS window.

Mapping individual records from CSV files

Biological Records Tool interfaceThe first step in using this tool with a spreadsheet of records is to open the spreadsheet using the create new source layer from CSV button. In fact, the tool can only open Comma Separated Value (CSV) files, so you must first save your spreadsheet as a CSV file.

Once the CSV is opened, it will be represented by an item in the source layer drop-down list. This drop-down list shows all CSV layers that have been opened plus any point vector layers. (See next section on working with point layers.) At this point you can also use QGIS' attribute table tool to view the data in the CSV if you wish.

You must set the value of the drop-down list OS grid ref column to the name of the column in your spreadsheet that contains the OS grid reference. Alternatively, if your spreadsheet contains eastings/northings, or long/lat, values, then specify the relevant fields using the x column and y column drop-down lists. 

If you are specifying an easting/northing (or long/lat), then you can also use the input CRS button to indicate the CRS used to encode the data in your spreadsheet. (If you have specified an OS grid ref column, then the CRS must be British National Grid – EPSG:27700.) If desired, you can also use the output CRS button to specify a different CRS to be used in the map layer to be generated (first un-check the match to input CRS box).

Biological Records Tool create layer buttonIf the value of the second drop-down list at the foot of the tool (referred to as the aggregation drop-down) is set to records as points (the default), then clicking the create map layer button creates a new map layer with a point for every record in the spreadsheet. Each point is located at the centre of the grid reference square represented by the associated grid reference. 

The records as grid squares option in the aggregation drop-down also results in individual records being represented in the output map layer, but instead of generating a point for each record the tool will generate a polygon representing the square corresponding to the grid reference for each record. It’s a handy way of visualising data encoded with grid references of varying levels of precision. This option can only be used if the records in the input spreadsheet are geocoded with OS grid references.

When you map individual records in the ways described above, columns in the spreadsheet are represented by attributes in the new map layer and you can use the identify features tool or the the attribute table tool to see the attribute value behind each record.

Working with point layers

Biological Records Tool source layerInstead of using a CSV file as a source layer, you can use a point layer. This is useful if you have a source of biological records already expressed as a GIS point layer rather than a spreadsheet. The name of any open point layer is represented in the source layer drop-down list (along with any open CSV files). When you select a point layer from this list, you do not need to specify a grid-reference or x/y columns since the location of the biological records is represented by the location of the points themselves.

Aggregating records (atlas maps)

Records can be aggregated by grid square to create ‘atlas’ type maps. If the output CRS is set to British National Grid (EPSG:27700), then you can select any of the following aggregation levels from the aggregation drop-down:

  • 10 m squares (8-figure grid ref)
  • 100 m squares (6-figure grid ref)
  • 1 km squares (monad grid ref)
  • 2 km squares (tetrad grid ref)
  • 5 km squares (quadrant grid ref)
  • 10 km squares (hectad grid ref)

Biological Records Tool user-defined grid sizeIf you set any other CRS, to aggregate records you must select the user-defined atlas size option and specify a grid size. The grid size is specified in the control immediately to the right of the aggregation drop-down in map units corresponding to the output CRS. So if the CRS specifies map units in decimal degrees (long/lat) then you specify a grid size in degrees (e.g. 0.5), whereas if your CRS specifies map units in metres then you also specify a grid size in metres (e.g. 10000).

Biological Records Tool create layer buttonSetting the aggregation options as described above and then clicking the create map layer button results in a new map layer, but instead of a point (or square) in the new map layer for every record in the input spreadsheet, you only get one single polygon at each cell of the specified grid where a record occurs. The cell is represented by either a square or a circle depending on the value you set in drop-down list to the left of the aggregation drop-down. The default is atlas squares but you can change it to atlas circles.

Because records are aggregated in these atlas maps, the original attribute values for individual records are not preserved. Instead atlas maps created with this tool have the following attributes:

  • GridRef. This is a text-type attribute which specifies the grid reference (if the output CRS is British National Grid). If an easting/northing was used to georeferenced the records, then instead of the grid reference, then this field contains the easting/northing (or long/lat) separated by a ‘#’ character.
  • Records. This is numeric attribute which stores the number of records in the input spreadsheet which fall within this grid square.
  • Abundance. This is a numeric attribute which indicates the abundance associated with each grid square. By default, this is the same as the records attribute, but if a column is specified by the abundance column drop-down list, then this attribute will contain the sum of the values of this column for all records in the spreadsheet which fall within this grid square. If, for any record, no value is specified in this column, then an abundance of 1 is assumed for that record.
  • Richness. This is a numeric attribute that indicates the number of different taxa represented by records in the input spreadsheet which fall within this grid square. (See next section to understand this fully.)
  • Taxa. This is a text attribute that indicates the different taxa represented by records in the input spreadsheet which fall within this grid square. The name of each taxon is separated by a ‘#’ symbol. (See next section to understand this fully.) Note that the size limit for a text attribute is 255 characters, so if there are more than just a few taxa, this can get truncated.

Sometimes individual records in a spreadsheet geocoded with OS grid references might be too coarse to be used in a map aggregated at a finer scale. For example in a spreadsheet with records of mixed precision being aggregated at monad (1 km square) level, then all records at a coarser precision (tetrad, quadrant or hectad) will not be used in the aggregation. When this happens, those records ‘missed out’ are logged on the log tab of the tool. 

Working with taxa

All of the functions described thus far could be used to map spreadsheets of anything – whether biological records or locations of public houses – the only requirement is a spreadsheet with a column for grid reference (or easting/northings or long/lats), or a point layer. But the Biological Records Tool has other capabilities that are geared specifically to biological records. Chief amongst these is the ability to specify a column that identifies different taxa (e.g. species) in the spreadsheet (or point layer) and thereafter map each taxon separately if desired.

Biological Records Tool specifying taxon detailsSetting the taxon column enables these features. When this column is set, you need to tell the tool which taxa to deal with when creating maps. You do this from the Taxa tab. If the Taxon column is a name recognised by the tool (see section on environment options) then the ‘taxon tree’ on the taxa tab will be generated automatically. Otherwise you must click the Biological Records Tool load taxa buttonload taxa button to generate it. The taxon tree lists all the individual taxa found in the spreadsheet and makes them individually selectable. The map creation functions detailed in the previous sections will only operate on records for which taxa have been selected in this list.

Biological Records Tool taxon treeIf the taxa listed in the taxon column are scientific binomials, the tool will treat them as such if you check the scientific names checkbox. When this is checked then taxa of the same genus listed in the taxon tree are grouped under an item representing the genus. 

Furthermore, if you have a column in the spreadsheet which groups taxa at some other level (e.g. family) then you can specify this in the grouping column drop-down and taxa will also be grouped under items representing different values of this. 

The example here shows the setup for a CSV file that has a column called Taxon which has scientific names. Another column called TaxonGroup indicates whether the taxon is a butterfly or a dragonfly. The resulting tree is also shown with some items expanded. In this tree an individual species could be selected by checking the box next to its name. All species in a genus could be selected by checking the box next to the genus name. All species in a group (here either butterflies or dragonflies) could be selected by checking the box next to the group.

Biological Records Tool convenience buttonsFor convenience, the tool has a couple of buttons for unchecking or checking all items in the taxon tree – check all and un-check all – and two buttons to the left of these allow you to expand the entire tree (the + button) or contract the entire tree (the  button).

When working in single map mode (see next section for more information) and more than one taxon is selected (or when the taxon column is not specified), the single map layer created when records are mapped (as appears in the layers panel) is given name based on the filename of the entire spreadsheet. But when a single taxon is selected, then name of the map layer is based on the name of the taxon and, for aggregated maps, the level of aggregation.

Working in batch mode

Biological Records Tool map generation modeThus far we’ve only talked about generating one map layer at a time, but when working with spreadsheets that have a taxon column specified, we can instruct the biological Records tool to generate separate maps for each selected species rather than a single map for them all. To do this change from single map mode to batch map mode on the options tab.

When batch map mode is specified then a separate map layer is created for each taxon checked in the taxon tree when the create map layer button is clicked. This can lead to a great many layers being created on one click – for example in a spreadsheet with 400 taxa, checking all taxa in the taxon tree and then clicking the create map layer button will create 400 map layers and list them all in the layer panel. By default these will all be checked in the layers panel – meaning they will all be displayed in the map view. If you want to see one of them on its own, you would need to uncheck the other 399!  Biological Records Tool check/un-check allThis would be extremely tedious so there is a convenience button – hide all generated map layers – to un-check them all. There is also a corresponding button – show all generated map layers – to check them all.

The tool is designed to allow you to generated map layers from an underlying spreadsheet really quickly. You will often find that you want to delete generated layers – perhaps because you’ve made a mistake or perhaps you just want to remove them from the layers panel and the map view. Biological Records Tool delete buttonsThe left-most of the two delete buttons – remove last map layer – allows you to delete the last layer created by the tool. The one on the right – remove all map layers – allows you to delete all layers created by the tool in the current session.

By default, QGIS assigns each newly created map layer a random single symbol style. If you are creating many maps, perhaps hundreds at a time for an atlas project, you will likely want each map to conform to a certain style. Once a style – perhaps a complex style – is developed for a layer, it can be saved independently of the layer as a ‘QML’ file. Biological Records Tool styles controlsYou can tell the biological recording tool to apply an external style file to each new layer it creates using by specifying the path to the external style file – use the browse style file button on the options tab to locate the style file – and checking the apply style checkbox. 

The transparency slider immediately under these controls can be used to set the layer transparency at the point of creation. Remember, all of these style settings can be set on a layer after creation, but if you are generating many layers, it can be much more convenient to set them when they are created.

Output options

Biological Records Tool output optionsMap layers generated by the Biological Records Tool are temporary layers - known in QGIS' vocabulary as 'memory layers'. These temporary layers do not persist from one QGIS session to the next unless you specifically save them as permanent layers. So, for example, if you save a project which contains one or more of these temporary layers, when you open the project again, the layer names will appear in the QGIS layers panel, but the data will be missing from the map view. To make it easy to recognise these layers, the Biological Records Tool always prefixes the name of the layers with 'TEMP'.

Once a series of map layers has been created, it is possible to generate a series of bitmap images – one for map layer generated by the tool – each showing all displayed background layers (i.e. all open layers except those generated by the tool) and just one layer generated by the tool. Do this with the save images for all map layers button. This is good for generating maps for an online atlas for example. The generated map images are saved to the image folder specified on the options tab – use the browse image folder button to locate the image folder.

The Biological Records Tool gives you several ways of persisting the data in these temporary layers. The format drop-down list in the output options (options tab), lists the different methods of saving the layers.

  • ImageUse this option to generate a series of image files – one for temporary layer generated by the tool – each showing all displayed background layers (i.e. all open layers except those generated by the tool) and just one layer generated by the tool. The images are generated directly from the QGIS map view.
  • Shapefile. Use this option to generate a permanent shapefile for each temporary layer generated by the tool.
  • GeoJSONUse this option to generate a permanent GeoJSON file for each temporary layer generated by the tool.
  • Composer imageUse this option to generate a series of  image files – one for temporary layer generated by the tool – each showing all displayed background layers (i.e. all open layers except those generated by the tool) and just one layer generated by the tool. The image files are generated from a map composer
  • Composer PDF. This option is the same as the previous one except that instead of producing image files, it produces PDFs.

Biological Records Tool save layers buttonOnce an option is selected in the format drop-down list, use the save button to save the layers or images into the folder that you have specified using the browse output folder button. Due to a limitation of batch processing with map composers, this button must be manually clicked once for each layer when using either of the two map composer options. (You must also start the process by displaying a single temporary layer in the QGIS layers panel.)

The Shapefile is for making permanent shapefiles from your temporary layers. Once used, you can clear all the temporary layers using the delete all button and then open the permanent vector layers if you wish. The GeoJSON option is great for saving layers that can be used on the internet, for example with OpenLayers javascript library. For both these options, the CRS of the layers produced is specified using the CRS selection. This means that you can save the permanent layers with a different CRS to that used for the temporary layers if you wish. Again, this can be useful for saving layers to use with libraries like OpenLayers that want GeoJSON layers to be project in WGS84 for example.

If using either of the two options that use a map composer, you must define just one map composer. Any text items in the composer are searched for the token '#name#' and this is replaced with the name of the taxon derived from the name of the temporary layer. Version 2.6.0 introduced a new feature whereby other replaceable tokens can be defined in a CSV file and then used in the map composer in the same way as the '#name#' token. The name of any special token used must match a column header in the CSV file. The value used to replace the special tag - e.g. '#CommonName#' - will be the values corresponding to the column (e.g. 'CommonName') and row for the taxon. 

Taxon metadata optionsThe illustration below shows a CSV file defining metadata for butterflies. The CSV must contain a column called 'Taxon' which contains the names of the taxa (these must match the names that would be derived for the '#name#' token). The CSV file can be created in a program such as Excel. Before it can be used as a taxon metadata layer, it must be opened as a no geometry CSV layer in QGIS. The easiest way to do that is to open it using the create new source layer from CSV button on the Biological Records tool. Then select it in the taxon metadata layer from the drop-down list in the output options and check the box next to it as shown in the illustration on the right.

Taxon metadata layer viewed in attribute table tool

If the CSV file shown above were used as a taxon metadata layer, then any '#CommonName#' tokens in the composer would be replaced by the values in the 'CommonName' column for each corresponding taxon. Similarly, and '#Notes#' tokens in the composer would be replaced by the text in the 'Notes' column corresponding to the taxon. In this example, a '#Notes#' token would be replaced by text for Small Tortoiseshell and would simply be removed for the taxa without any value specified in the 'Notes' column. Text values do not have to be limited in length, so substantial amounts of text can be used to replace a token if desired.

Video tutorials

Youtube link

QGIS Biological Records tool: the basics

This video demonstrates  the basics of the Biological Records tool - creating point and atlas maps from records in CSV files. Note that the video was made with an earlier version of the Tom.bio Tools so the interface may look a little different, but the basic process remains the same.

Youtube link

QGIS Biological Records tool: mapping by species

This video demonstrates how to build a selectable list of taxa from your spreadsheet and generate maps for each species. Note that the video was made with an earlier version of the Tom.bio Tools so the interface may look a little different, but the basic process remains the same.

Youtube link

QGIS Biological Records tool: batch generating atlas maps

This video demonstrates how to batch generate large numbers of high quality species distribution maps - ideal for atlas projects. Note that the video was made with an earlier version of the Tom.bio Tools so the interface may look a little different, but the basic process remains the same.

Youtube link

QGIS Biological Records tool: Irish grid example

This video has an example of using the QGIS Biological Records tool to generate 'atlas' style maps in the Irish context. In this example the CSV input file as data geocoded as easting/northings aligned to the Irish National Grid. Note that the video was made with an earlier version of the Tom.bio Tools so the interface may look a little different, but the basic process remains the same.

Youtube link

QGIS Biological Records tool: WGS84 example

This video has an example of using the QGIS Biological Records tool to generate 'atlas' style maps in an international context. In this example the CSV input file as data geocoded as latitude and longitude to the WGS84 CRS. Note that the video was made with an earlier version of the Tom.bio Tools so the interface may look a little different, but the basic process remains the same.

(Back to help homepage)