OLIVIA SCALORA

GEOSPATIAL DATA ANALYST | DESIGNER

oliviascalora@gmail.com
Philadelphia, PA

selected works below

Predictive Modeling and Data Analysis

Predicted Employee Turnover Risk Dashboard | Guilford County, North Carolina

A proof-of concept analytical and informational dashboard which will associate a voluntary turnover risk score with each employee such that appropriate preventative measures can be taken by Human Resources to increase employee retention. Developed for Guilford County, North Carolina Human Resources.
R | OpenStreetMap | JavaScript | Python

Predicting Opioid Overdoses | Mesa, Arizona

A geospatial risk model to predict the liklihood of opioid overdose occurences in Mesa, Az, a city in the midst of a crisis. The project highlights locations in Mesa where intervention is recommended based on the predictions. A hypothetical web application is conceptualized to demonstrate the applicability of the model.
R | tidyverse

Predicting Flood risk | Calgary, AB - Pittsburgh, PA

A predictive model is trained and tested on Calgary, AB flood data, and applied to Pittsburgh geography to locate areas of flood risk using ArcGIS Pro and R workflows.
ArcGIS Pro | Spatial Analyst Toolbox | R

Locating Eviction Risk | Philadelphia, PA

A dashboard which illustrates eviction risk through L&I violations and complaints as well as expiring housing subsidies. An awareness and advocacy tool for policy makers to understand Philadelphia neighborhoods in greatest need of limited resources.
SQL | JavaScript | Apache Airflow | Google Cloud Storage | PostGIS

Fairmount Storymap | Philadelphia, PA

A story map highlighting qualitative analysis results, describing the experienced changes in demographics and neighborhood quality of Fairmount in Philadelphia, PA
Python | JavaScript | OpenStreetMap | ArcGIS Pro

Predicting House Sale Price | Boulder City, CO

Proximity to natural geographic features such as lakes and mountains, municipal boundaries, demographic data, and building features are used to build a predictive model for future house sale prices in Boulder City, CO based on observed past sale prices.
R

Memo to the Mayor | Reducing Recidivism Through Fair Algorithms

An exercise in addressing baked-in biases of data through cost/benefit analysis.
R

Renter's Rights and Landlord Transparency

Research writing sample published in the 2021 edition of UPenn's Planning student journal, 'Panorama'. This essay breaks down the current practices of renters rights' and landlord transparency in Philadelphia.

Architectural & Spatial Design

Druid Hill Park Bridge | Baltimore, MD

Druid Hill Park Bridge aims to explore how design intervention is able to mitigate physical and social barriers in urban settings, specifically between neighborhood and park.
ArcGIS Pro | Rhinoceros 3D | Adobe InDesign | Adobe Photoshop