The Prairie Haven Overview tab is what started it all and remains the “front door” to all other views of the data.  It summarizes BirdNET-Analyzer results in a tabular view – like pivot table functionality in Excel spreadsheets.

Rather than presenting observation-based data, the tables on this page transform the data into species-level summaries. Users are able to select how they want the data to be summarized, and can also provide additional filters for further subsetting the data. Click on pictures to embiggen.

User Inputs

User inputs are found on the sidebar for this tab.

Input Name	Input Choices	Description
Model-Match Scale ‘Model Proximity’ or ‘Model Adherence’	Numerical value or range of values between 0 and 1.	This input allows you to filter that output on this tab based on BirdNET-Analyzer’s ‘Confidence’ attribute. We have renamed this input to ‘BirdNET Model-Match Scale’ because BirdNET’s confidence isn’t actually a probability and is not related to confidence intervals. Read more about that here.
Species Lookup	Categorical selection based on species present in the dataset. Multiple selection is allowed.	With this tool, you can filter the output on this tab to specific species that you have defined.
Pivot Table Selection	Your choice of 4 pivot views: 1.        Species by Month 2.        Species by Location 3.        Species by Year 4.        Species by Week	This selection determines how the data is summarized in your output table. Each row is a species, and columns show months, locations, years, or weeks.
Pivot Table Filters	Dynamic filtering tools, determined based on your Pivot Table Selection value.	The Pivot Table Filters change based on your Pivot Table Selection. These inputs allow for further filtering of the table output, including filtering by year, location, month, and week.

 

Output Explanation

Example Pivot Table Output

 

Interacting with the Output

Generating Tables:

First, to see the output print to screen, a user needs to select the Generate Table button found in the sidebar:

After generating a table, the Generate Table button is disabled until the user either selects a new Pivot Table view or adjusts any of the parameters in the sidebar. When this happens, the Generate Table will be enabled again and a new output can be rendered.

Copying the table or downloading a CSV:

There are two buttons found at the bottom of the table output, allowing a user to copy the table to clipboard, or download the table as a CSV. These options copy the table exactly as it is seen in the display.

Sorting data in the table:

Data in the table output can be sorted by the columns. This is done by selecting the columns header you want to sort by with the mouse:

If you want to sort by multiple columns, hold the shift key as you select your column header choices:

Selecting a species to view:

Double clicking on a row of the table will automatically take the user to the Species-Specific Location Drilldown. The data on this page will reflect the species that was selected.

Double click ‘American Robin’

Redirected to the Species-Specific Location Drilldown for American Robin.

Notes for Admins

The starting point for this output is the FST file which is defined in the code as `all_data`. This dataset is cleaned / formatted BirdNET-Analyzer results for all years of data and all confidence levels. Each observation in the FST file is a single bird vocalization, with attributes including the specie’s name and code, confidence level, location, date, time, and file name. The purpose of the Prairie Haven Overview Page is to transform this information into a new view. Here are the steps taken in the code to do this transformation.

1. `all_data` is filtered based on BirdNET Model-Match Scale and saved as the value `filtered_data`
2. A `create_pivot_input` function is called based on the user input for Pivot Table Selection.
   1. If ‘Species by Month’ is selected, `create_pivot_month` is called.
   2. If ‘Species by Location’ is selected, `create_pivot_location` is called.
   3. If ‘Species by Year’ is selected, `create_pivot_year` is called.
   4. If ‘Species by Week’ is selected, `create_pivot_week` is called.

The table below outlines how each function behaves:

Function Name	Pivot Table Filters	Function Behavior
`create_pivot_month`	Year, Location	` filtered _data` is filtered based on user-entered values for Species Lookup, Year, and Location. ` filtered _data` is grouped by species, with columns for each month, and the count of observations for each species is computed.
`create_pivot_location`	Year, Month, Week	` filtered _data` is filtered based on user-entered values for Species Lookup, Year, Month, and Week. ` filtered _data` is grouped by species, with columns for each location, and the count of observations for each species is computed.
`create_pivot_year`	Location, Month, Week	` filtered _data` is filtered based on user-entered values for Species Lookup, Location, Month, and Week. ` filtered _data` is grouped by species, with columns for each year, and the count of observations for each species is computed.
`create_pivot_week`	Year, Location, Week, Time	` filtered _data` is filtered based on user-entered values for  Species Lookup, Year, Location, Week and Time. ` filtered _data` is grouped by species, with columns for each week, and the count of observations for each species is computed.

 

3. The output data table is formatted.
   1. A row is added to the top of the table for total counts by column values.
   2. A column is added to the left of the table for total counts by species.