Puget Sound SAGESeptember 2019
GIS & Cartography - QGISSeattle, WA
I was tasked with creating six maps using King County Assor data. The goal of project is to asses how neighborhoods can receive development projects without displacing current residents. The neighborhood under investigation is historically of lower income with a high proportion of residents of color. A Link light rail station is planned for completion in 2031. Puget Sound Sage has been working with community and faith-based groups to assess residential needs in a rapidly changing urban environment of the Puget Sound. On the technical end, the GIS component is part of the organization's near-term work plan. This component identifies properties that are likely to be targeted for acquisition and development from outside investors.
Technical Tasks
- Data Acquisition
- King County Assessor
- City of Seattle Open Data Portal
- Geoprocessing
- Clipping
- Buffer Analysis
- Field Calculation
- Shape Area
- Markov Chains
- Cartographic Publishing
About the Client
Puget Sound Sage is a POC, LGBTQIA, and women-led organization that advocates for equitable policy change. The organization champions transofrmational policy decisions that benefit current residents rather than merely reducing the harms of developmental inequalities that many other organizations consider inevitibe. With eyes towards climate, economic, and racial justice, they engage in community-based research and coalition building to sustain an inclusive and locally conscious sphere of activism.
Health Promotion Research Center, University of WashingtonAugust-September 2019
Educational Workshop - SPSSSeattle, WA
This was a customized five-hour workshop teaching SPSS sytnax, data cleaning, and basic data analysis. We walk through a bare-bones dataset discussing biometric measurements from a clinical study of people screened for Type II Diabetes. The audience is a group of researchers seeking to build confidnece in their ability to manage sensitive datasets and track their procedures using SPSS sytnax. After walking through building syntax from scratch, we then moved on to evaluating syntax and data that was authored by a researcher at the Health Promotion Research Center (HPRC). The main goal for the workshop was to give a primer on syntax, but most importantly to teach study skills and probelm-solving so that trainees would eventually be able to work independently, ask the right questions when they need help, and seek solutions on their own.
Workshop Progression
- Descriptive Statistics and Histograms
- Outlier detection using Z-Score calculations and Box Plots
- Recoding variables
- Filtering outliers and determining under which circmustances this is appropriate.
- Comparing Means and ANOVA
- Independent Samples T-Tests
- Scatterplots
- Simple Linear Regression
- Interpreting work from other scholars
About the Client
The HPRC is a CDC-funded subdivision of the UW School of Public Health. They conduct community-based research to assess urgent health needs, design interventions, and measure the success of health promotion and morbidity prevention programs.