Ben Landers Portfolio - Research Work

Graduate Research Assistant

Lab: RTGS Lab, GEMS Informatics Center, University of Minnesota

Research Advisor: Dr. Bryan Runck

Duration: August 2024 - Present

1. Conservation Parcel Prioritization Model

Project Overview:

Developed a comprehensive geospatial suitability model to prioritize land parcels for conservation efforts in Hennepin County, Minnesota. The model analyzes multiple environmental and spatial criteria to score and rank parcels based on their conservation value.

Technical Implementation:

  • Language: Python
  • Key Libraries: Pandas, GeoPandas, Shapely, NumPy, Matplotlib, Seaborn, SciPy, Scikit-learn
  • Data Sources: Protected Areas, Natural Spaces, Minnesota Biological Survey (MBS), Minnesota Land Cover Classification System (MLCCS), Wildlife Action Network, Important Bird Areas, Bee Habitat, Risk of Development layers, Water Resources (Shoreland Buffers, Floodplains, Wetlands, Headwaters, Groundwater data)

Model Components:

  • Spatial Context (30% weight): Distance to Protected Areas, Distance to Natural Spaces, Potential Easement Analysis
  • Habitat Quality and Diversity (25% weight): Quality Ranking based on MBS and MLCCS data, Quality Community identification, Habitat Diversity assessment
  • Size (15% weight): Relative and Absolute Size scoring
  • Wildlife and Plant Conservation (15% weight): Wildlife Action Network rankings, Bird Habitat, Pollinator Habitat
  • Risk of Conservation (10% weight): Risk of Development scoring
  • Water Resources (5% weight): Shoreland Buffer analysis, Floodplain presence, Wetlands coverage, Headwater area identification, Groundwater Recharge potential, Groundwater Contamination susceptibility

Key Achievements:

  • Successfully automated complex multi-criteria spatial analysis
  • Streamlined data processing workflow for efficient execution
  • Provided actionable rankings for conservation decision-making
  • Used SciPy and Scikit-learn for statistical validation of model results
Hennepin Prioritization Model outputs
Figure 1: Hennepin Prioritization Model Output Symbolized for Priority with Natural Breaks

2. ETL Pipeline Development for Conservation Model

Project Overview:

Developing a command-line interface (CLI) based ETL (Extract, Transform, Load) pipeline to automate the extraction of input datasets for the conservation parcel prioritization model and load them into a SQL database.

Technical Implementation:

  • Language: Python
  • Key Technologies: SQL database management, CLI development, data pipeline automation
  • Purpose: Streamline data acquisition and preparation for the conservation model

Key Features:

  • Automated extraction of geospatial datasets from multiple source locations
  • Data transformation and standardization
  • Loading processed data into SQL database for efficient querying
  • Command-line interface for easy execution and configuration

Status: In Development