Codes developed for Durham Public Schools (DPS).

• Code 1 fetches and processes Durham’s active address data, converting it into spatial formats like GeoPackage and Shapefile.
• Code 2 retrieves parcel boundary data, converts the coordinate rings into polygons, and saves the parcels as spatial files for mapping and analysis.
• Code 3 prepares and joins address, parcel, and dwelling unit data to estimate housing density and land use patterns per parcel in Durham, NC.
• Code 4 analyzes discrepancies between estimated dwelling units and address or land use data, visualizing these inconsistencies across various housing densities using bar charts.

Geospatial Data Engineer Intern Durham Public Schools, Durham, NC May 2023 – Aug 2023

During my internship, I applied geospatial analysis techniques using ArcGIS and Python’s ArcPy to study student population distribution and forecast growth, aiding in the transition of spatial data from older systems to ArcGIS Enterprise. I automated repetitive data extraction and update tasks by scripting in R, utilizing packages like ggplot2, dplyr, sf, jsonlite, and httr to efficiently manage parcel and census datasets tied to statewide mapping initiatives, which reduced manual labor by several hours weekly. Additionally, I developed interactive data visualizations and dashboards in Power BI to communicate insights to district planners and leadership, supporting strategic decision-making. 📊🌍