landbird data into data warehouse for simple population and community analytics using PostgreSQL plpgsql and data visualizations in R
the NSF NEON landbird dataset
NEON (National Ecological Observatory Network). Breeding landbird point counts (DP1.10003.001), RELEASE-2026. https://doi.org/10.48443/v6hs-mx57. Dataset accessed from https://data.neonscience.org/data-products/DP1.10003.001/RELEASE-2026 on July 6, 2026.
initial project to focus on creating pl/pgsql scripts to convert NEON landbird datasets into data warehouse to create data visualizations of species occurrence and abundance by year
getting started - create script to load landbird data from NEON Konza site in Kansas - calculate total abundance by species by year - secondary data product is 3D array of total count referenced species x site x year
quick front end with R shiny to generate frequency plot showing total counts vs year for each species x park
Downloaded all years for Konza. Folder organization is by NEON station by year. Each folder contains files containing categories, validation processes, bird point counts, site information, eml metadata, a readme file and list of variables.