Adult Abundance Report

The Abundance Report under Adult Reporting allows you to create a range of reports, including graphs and the ability to download subsets of data into excel.

The Abundance Report menu provides the ability to filter data by choosing the Local Government Areas (LGAs) or Contiguous Local Authority Groups (CLAGs), species of mosquito, date ranges and trap locations.  This is a step by step process and is described below.

To get started, select the “Report” menu and scroll down until “Abundance Report” is highlighted.  Then click on this highlighted heading.

ReportsMenu

The Reports Menu with the Abundance Report highlighted

You will be taken to the first of a series of fields that allow you to narrow down the subset of data you may be interested in.  The first field includes all the Local Government Areas that you have access to.  In this instance, the Town of Bassendean and the Cities of Bayswater and Belmont have been selected, so only data from these three Local Governments will be presented in the report.  Multiple LGAs can be selected by holding down the SHIFT key and selecting the first and last LGA if they are in consecutive order.  Alternatively, you can hold the Ctrl key to select multiple LGAs that are not in consecutive order.

Please note: Only Local Governments within Contiguous Local Authority Groups (CLAGs) are able to select multiple LGAs from within the list.  If you are not part of a CLAG, the only option in this list will be your current LGA.

 

AdultAbundanceReportFilter2

Selecting the Local Government Areas to generate a report

In most cases, this list will only include the LGA you currently work within. Once you have chosen your Local Government Area/s, click on the blue “Select” button to confirm your selection and move to the next field.

The following section allows you to choose the species of mosquitoes you want to include in the report and the time period that the report will cover.

Previously selected categories are listed above the selection boxes, e.g. the selected LGA’s that will be included in the report are listed above the species box.

All species that have ever been recorded in any traps within the selected LGA’s are displayed in the “Species” list.  Once again, multiple species can be selected by holding down the SHIFT key and selecting the first and last species to be included in the report as long as they are in consecutive order.  Alternatively, you can hold the Ctrl key to select multiple mosquito species that are not in consecutive order, see below.

 

AdultAbundanceReportFilter3

The species selection and start and End dates to generate the report

You are also requested to select the “Start” and “End” period for the report.  You can type over the auto-completed date fields.  These are populated with the earliest record in the “Start” field and the current date in the end field in an attempt to report on the greatest period possible.  However, data will only be recorded for traps set and collected within the selected LGAs for the selected species within the selected time frame.

Once you have chosen the mosquito species and time period for the report, click on the blue “Select” button to confirm your selection and move to the field.

The following selection allows you to choose the specific trap sites you want  want to include in the abundance reports.

Previously selected categories are listed above the selection boxes, for example, the selected LGAs, mosquitoes species and the designated time period are all recorded at the top of the new screen.

The next selection is the ability to choose one or more sites for the report.  The sites automatically listed include all those within the selected LGA/s, have at least one of the selected species present within the traps within the selected date range.

 

AdultAbundanceReportFilter4

Selection of sites for the Abundance reports

Once again, multiple sites can be selected by holding down the SHIFT key and selecting the first and last trap site to be included in the report, as long as they are in consecutive order.  Alternatively, you can hold the Ctrl key to select multiple sites that are not in consecutive order.

Once the sites are selected, you have three options for generating different types of abundance reports, including:

At this point, select the type of report to be produced by clicking the most appropriate button.  Each report will be described below.

Chart Site Abundance

When you select the “Chart Site Abundance” button, data from the selected fields are used to create graphs and datasheets of the requested information based on each site locality chosen.  This tab allows trends to be examined across and between sites within the LGA.

Gaia - Chart Site Abundance Button

The Chart Site Abundance button

Please note: this tab displays data based on site locations only.

After clicking this tab, you will be taken to a web page with a graph that shows the total abundance of mosquitoes collected at each selected field site over the time period nominated.

4 Abundance Report - Chart Trapping Site abundance

Graph showing the total abundance of mosquitoes collected at requested field sites over time

A legend is provided under the graph that shows each field site selected and each location is shaded a different colour.  You will also notice a tick box before each legend label.  These can be switched on or off by clicking on the check box.  Initially all sites are graphed.

Additionally, a “Toggle All” switch has been added below the bottom right axis of the graph.  This check box will turn all sites on or off, allowing sites to then be turned on or off individually by clicking the legend labels.  The “Toggle all” check box allows you to reset the graph and the select a range of data to add or remove.  The image below shows the same data with a number of sites turned off, hence fewer lines (data) is shown on the graph.

5 Abundance Report - Chart Trapping Site Abundance toggles

Use of the toggle switches to turn sites on and off

 

Users also have the ability to zoom in or out on the graph.  By placing the mouse within the axes of the graph and scrolling back or forward on the mouse wheel the graphed area will adjust the data being viewed.  This allows the user to zoom in on a set of data points to review the data in more detail.  By zooming out on the graph, more data is displayed (if available) and long term trends can be observed.  Similarly, by zooming in on a graph a smaller subset of data can be viewed, which is helpful if a range of dots cluster closely together.

Graph zoom out

Demonstrating the impact of zooming out on a graph

Graph zoom in

Demonstrating the impact of zooming in on a graph

Please note: if using the zoom function on the graph, you may need to select the graph and drag it towards the top of the image to reset the bottom axis.

Additionally, information is provided to the viewer at each point (circle) on the graph.  By scrolling your mouse over a point on the graph you will be provided with:

  • the site name;
  • date of collection; and
  • the total abundance of mosquitoes collected in that trap at that particular date.

This allows you to search for specific details to edit data or find corresponding data.

4A Abundance Report - Chart Trapping Site Abundance Scroll over for site names etc

Text displayed when the mouse is scrolled over points within the graph

The horizontal axis (Trap Date) has not been fixed.  This allows the user to click within the graph itself and drag the image to the left and/or right to look at longer term trends without losing resolution in the data.  If we select long term data collection sites, we can potentially observe up to four decades of data along the horizontal axis.  By scrolling to the left and right in this way, we can observe trends over long time periods.

 

abundance map scrolled left

Graph with the horizontal axis dragged to the left

 

Abundance map scrolled right

Graph with the horizontal axis dragged to the right

To the top right of the graph are another range of functions that are available to the user.  These include:

  • Save as Image – which allows you to save the current graph;
  • Download Site XLSX – allows you to save the current data set behind the figure based on each field site within an excel sheet; and
  • Download Species XLSX – allows you to save the current data set behind the figure based on each species collected across all field sites.

The “Save as Image” button will produce the graph in “.png” format and it will be downloaded so you can open it in your default picture editor.  The graph cannot be changed in this format, but provides you with the ability to save and print the graph. A range of menu items are available from the menu under the graph, dependant on the program that the image opens in.

Save as Image button

Click the blue text stating “Save as Image” to produce a graph for insertion into reports

 

6 Abundance Report - Chart Trapping Site Abundance save as image

Graph produced by clicking the “Save as Image” button on the top right of the graph.

The “Download Site XLSX” button will produce an excel spreadsheet of Site data based on the selected variables that created the graphs in the reporting system.  This data can be saved in excel, modified and graphed to provide flexibility to users to draw alternate graphs or conduct statistical analyses on the data.  This button will produce excel spreadsheets of raw data for each site over time as per the images below.

 

Download Site XLSX button

Click the blue text stating “Download Site XLSX” to produce excel spreadsheets of raw data

 

The raw data will download into an excel file.  In this instance, each site will be loaded into a separate sheet within an excel workbook.  Thus, multiple spreadsheets of data will be produced and each site can be examined in detail by clicking on each sheet at the bottom of the excel table.  This data can be saved and edited as per any normal excel spreadsheet.

7 Abundance Report - Chart Trapping Site Abundance download to XLSL 2

An example of the data produced in Excel when you click the “Download Site XLSX” link

 

Download Species XLSX

The “Download Species XLSX” button will produce an excel spreadsheet of Species data based on the selected variables that created the graph in the reporting system. This data can be saved in excel, modified and graphed to provide flexibility to users to draw alternate graphs or conduct statistical analyses on the data. This button will produce excel spreadsheets of raw data for each species over time as per the images below.

Download Species XLSX button

 

Click the blue text stating “Download Species XLSX” to produce excel spreadsheets of raw data

The raw data will download into an excel file. In this instance, each Site will be loaded into a separate sheet within an excel workbook. Thus, multiple spreadsheets of data will be produced and the species composition of each site can be examined in detail by clicking on each sheet at the bottom of the excel table. This data can be saved and edited as per any normal excel spreadsheet.

7 Abundance Report - Chart Trapping Site Abundance download to XLSL

 

An example of the data produced in Excel when you click the “Download Species XLSX” link

Chart Species Abundance

When you select the “Chart Species Abundance” button, data from the selected fields are used to create graphs and datasheets of the requested information based on each species chosen. This tab allows trends to be examined across and between species within the Atlas.

Chart Species Abundance button

The Chart Species Abundance button

Please note: this tab displays data based on species only.

After clicking this tab, you will be taken to a web page with a graph that shows the total abundance of mosquitoes collected at each selected field site over the time period nominated.

Chart Species Abundance graph

Graph showing the total abundance of each mosquito species at requested field sites over time

A legend is provided under the graph that shows each mosquito species selected with each mosquito species shaded a different colour. You will also notice a tick box before each legend label. These can be switched on or off by clicking on the check box. Initially all mosquito species selected are graphed.

Additionally, a “Toggle All” switch has been added below the bottom right axis of the graph. This check box will turn all mosquito species on or off, allowing each species to then be turned on or off individually by clicking the legend labels. The image below shows the same data with a number of mosquito species turned off, hence fewer lines (data) is shown on the graph.

Chart Species abundance with toggles

Use of the toggle switches to turn displayed mosquito species on and off

Additionally, information is provided to the viewer at each point on the graph. By scrolling your mouse over a point on the graph you will be provided with:

  • the mosquito species name;
  • date of collection; and
  • the total abundance of mosquitoes collected in that trap.

This allows you to search for specific details to edit data or find corresponding data.

Point Data - Chart Species Abundance

 

Text displayed when the mouse is scrolled over points within the graph

The horizontal axis (Trap Date) has not been fixed. This allows the user to click within the graph itself and drag the image to the left and/or right to look at longer term trends without losing resolution in the data. If we select long term data collection sites, we can currently observe up to four decades of data along the horizontal axis. By scrolling to the left and right in this way, we can observe trends over long time periods.

 

Chart Species Abundance axis to left

Graph with the horizontal axis dragged to the left

 

Chart Species Abundance axis to right

Graph with the horizontal axis dragged to the right

To the top right of the graph are another range of functions that are available to the user. These include:

  • Save as Image – which allows you to save the current graph; and
  • Download XLSX – allows you to save the current data set behind the figure based on each species selected within an excel sheet.

The “Save as Image” button will produce the graph in “.png” format and it will be downloaded so you can open it in your default picture editor. The graph cannot be changed in this format, but provides you with the ability to save and print the graph. A range of menu items are available from the menu under the graph, dependant on the program that the image opens in.

Save as Image button

Click the blue text stating “Save as Image” to produce a graph for insertion into reports

Chart Species Save as image graph

Graph produced by clicking the “Save as Image” button on the top right of the graph

The “Download XLSX” button will produce an excel spreadsheet of Species data based on the selected variables that created the graphs in the reporting system. This data can be saved in excel, modified and graphed to provide flexibility to users to be able to draw alternate graphs or conduct statistical analyses on the data. This button will produce excel spreadsheets of raw data for each species over time as per the images below.

Download XSLSX button

Click the blue text stating “Download Site XLSX” to produce excel spreadsheets of raw data

The raw data will download into an excel file. In this instance, each species will be loaded into a separate column of the spreadsheet. This data can be saved and edited as per any normal excel spreadsheet. A second sheet provides a list of the sites that the data is based upon dependent on the sites selected to run the report.

excel species data

An example of the data produced in Excel when you click the “Download XLSX” link

Abundance Map

When you select the “Abundance Map” button, data from the selected fields are used to create a geographic representation of the requested information based on each site locality chosen. This tab allows trends to be examined across and between sites within the LGA or CLAG.

Abundance Map button

The Abundance Map button

Please note: This tab displays data based on site locations.

After clicking this tab, you will be taken to a web page with a map that shows the total abundance of mosquitoes collected at each selected field site over the time period nominated.

Initial Abundance map

 

The Abundance Map

You can zoom in and out of the map by placing the mouse within the map and scrolling backward and forward. Alternatively you can press the “+” or “-” buttons on the top left of the map to incrementally zoom in or out of the map.

Zoom Buttons

 The zoom buttons on the top left of the map.  The “+” symbol will incrementally zoom in on the map; while the “-” will incrementally zoom out of the map.

Zoomed abundance map

Results of zooming in on a specific area within the map

As you zoom in on the map, the sites will start to separate into pie charts displaying the total abundance of all mosquito species collected at that location over all field collections.

The mosquito species have been separated into categories.  Any species that is brightly coloured is known to be involved in the transmission of mosquito-borne diseases or shown to have the potential to transmit diseases.  Mosquito species shaded in grey are not currently known to transmit human diseases and are of low public health significance, although they may still pose a nuisance risk to residents.  The colours have been standardised so that each species will always be represented by the same colour.

The size of the pie chart represents the overall abundance of mosquitoes collected at the site.  The smallest pie chart represents values between 0 and 1000 mosquitoes; the intermediate sized pie chart represent abundances between 1000 and 5000 mosquitoes and the largest pie chart represents greater than 5000 mosquitoes.

Chart map legend average

The pie chart legend: shows the average abundance of mosquitoes at any trap site in the Abundance Map.

 You are able to click on any of the pie charts to see more information.  If you do this, a drop down box appears.  At the top left of the box is displayed the site name (in this case “Peel 19”.  Below this is a list of each species collected in the trap in numerical order (highest abundance to lowest abundance).  Once again, grey species are not currently known to transmit human diseases, while coloured species are known to transmit mosquito-borne diseases or have the potential to do so.

Species composition at a site in ABundance Map

 Data displayed if you click on a single pie chart

Initially the top ten or so species are displayed in the drop down box.  A scroll bar is provided to the right of the list of species, so that you can scroll down and see other species collected in lower abundances.

scrollbar

The highlighted scroll bar allows you to move through the list of species collected at any one site

 You are also able to examine the pie charts on each trap night by clicking on the blue “more details” button at the top right of any pie chart.

more details - abundance map tab

The “More Details” tab

By clicking on this link, a new web page will open that will show the data for the species selected on each night (date) that this particular trap was set. At the top of the new page, you are presented with the overall pie chart for all species selected across all collections at this particular site, as below:

More details - Abundance map - total pie chart

The overall abundance of selected species at one particular site for all previously recorded collections

Below the total abundance pie chart, is a list of each collection date at the chosen site. Users are presented with the date of each collection at this site, the total abundance of species at this particular time and another pie chart (summarising the data) for the composition of the fauna collected on that particular occasion.

more details - Abundance Map - breakdown of pie charts

Breakdown of species composition on each trap night at the chosen site

This analysis is particularly useful to examine trends of species composition over time as the variations in the coloured species on each pie chart can indicate when disease vectors are most active in your region.  Also, the trend in abundance can be seen to rise in summer months (or during the wet season in the north of the State) and decline in the cooler months (or during the dry season in the north of the State).  This information can be of particular importance when considering mosquito management plans and the potential use of chemicals for treatments.

In the first column, you will notice that the dates are listed in blue numerals.  You can select any of these dates to be taken to the original record of that site on that particular trap night.

more details - ABundance maps - date selection

Blue dates that can be selected to see the original records associated with this particular trap site on this particular date

After selecting a specific date, the original records are displayed and can be edited (if you own the record).  You can review information including:

  • Trap location;
  • Trap Set details;
  • Trap Pickup details; and
  • Trapped Species details.

Abundance Record

The Adult Mosquito Monitoring information displayed for the date selected

At the top of the map are four tabs and by clicking on any of these you can review information including:

  • Adult Mosquito Monitoring – displays the trap location details;
  • Trap Set – displays the trap set details and any environmental conditions;
  • Trap Pickup – displays the trap pickup details and any recorded environmental variables; and
  • Trapped Species – displays the list and abundance of each species collected on this particular date.

For further information about these tabs, review the information provided in the Users Manual under “Adult Mosquito Monitoring”.