This page showcases work completed in GIS 550 at NC State University, demonstrating skills in relational database design, SQL, spatial database management, and web application development using the Esri platform.

GIS 550: NERI Site Observations Web Application

Problem Statement

The goal was to make complex field observation and cultural site data accessible to non-technical users through an interactive web mapping application. Raw data required significant cleaning, restructuring, and spatial processing before it could be published as web services.

Methods

Reviewed an existing Access relationship map and rebuilt a normalized relational database in pgAdmin. Imported CSV source files, defined tables, and authored custom SQL views to expose meaningful data relationships. Created an SDE database in ArcGIS Pro and imported restructured data tables alongside feature classes containing culture data.

Used Model Builder to create a geoprocessing model selecting vertebrate site sampling locations and culturally relevant structures within a user-defined distance, then published it to ArcGIS Server as a custom tool. Built an interactive web map in ArcGIS Online using Arcade expressions to configure detailed pop-ups, and developed the final application in ArcGIS Experience Builder with a Near Me widget for spatial querying.

Outcomes

The finished application lets users draw a buffer zone around a line feature and explore habitats, significant structures, and site observations within that area — with results printable for offline use. Technical challenges with ArcGIS Server mid-project were resolved through creative workarounds and iterative data management, demonstrating adaptability under real-world constraints.