BirdsCallPSWC

A comprehensive data analysis project for Processing and Visualizing Bird Call Survey Data from Puget Sound WildCare (data are not included).

Overview

This project processes bird call survey responses collected in 2024 and 2025, cleaning and standardizing the data to create interactive visualizations and geographic maps showing bird call distribution across Washington State.

Features

1. Data Cleaning and Preprocessing

• Species Name Standardization: Cleaning and normalizing bird species names
• Referral Centers: Processing and categorizing wildlife referral center information
• Timestamp Standardization: Converting various date/time formats to a consistent format
• Location Cleaning:
  • City name correction using fuzzy matching against Washington State municipalities
  • Automatic mapping of cities to their corresponding counties
  • Handling of ambiguous or incomplete location data

2. Interactive Summary Charts

Generate interactive visualizations for both 2024 and 2025 data:

• Year-over-year comparison charts
• Bird species distribution analysis
• Temporal trends and patterns
• Referral center statistics

3. Interactive Geographic Maps

Create dynamic, interactive maps showing bird call distributions:

• City-level Maps: Choropleth maps showing call frequency by city
• County-level Maps: Regional distribution across Washington State counties
• Available for both 2024 and 2025 datasets
• Interactive tooltips with detailed statistics
• Color-coded visualization based on call volume

Project Structure

BirdsCallPSWC/
├── data/                          # Raw and cleaned datasets
│   ├── 2024/                      # 2024 survey data
│   └── 2025/                      # 2025 survey data
├── map/                           # Generated interactive maps
├── report/                        # Analysis reports and outputs
├── CityLimits/                    # GIS city boundary data
├── CountyBoundaries/              # GIS county boundary data
├── birdCallSummary2024.ipynb      # 2024 data analysis notebook
├── birdCallSummary2025.ipynb      # 2025 data analysis notebook
├── preprocess.ipynb               # Data preprocessing pipeline
├── map.ipynb                      # Map generation notebook
├── timestamp.py                   # Timestamp standardization utilities
├── barPlots.py                    # Bar chart generation
├── pieCharts.py                   # Pie chart generation
└── README.md                      # This file

Acknowledgments

• Puget Sound Wildlife Center (PSWC) for collecting the survey data
• Wikipedia for providing comprehensive Washington State municipality data
• Contributors who participated in the bird call surveys