WEB APPLICATIONS

Seattle Capital Projects Dashboard
I took the lead in the design and development of the Seattle Capital Projects Dashboard, an application on the Socrata Open Data platform now deployed in multiple cities. This project includes proprietary development of a Content Management System (CMS) to input data from program and communication staff and connect to an internal project controls information system (VBA and SQL). I also set up a publishing review process that is supported by pixel-perfect review documents in pdf format. Without the automated review process, regular publishing of this information would not be feasible.

INTERACTIVE VISUALIZATIONS AND DASHBOARDS

2016 Customer Satisfaction Survey
The 2016 Seattle DOT customer satisfaction survey provides the City with insights on respondents’ perceptions and satisfaction regarding key transportation services. Displaying information in a visually refined dashboard provides an engaging experience and allows easy cross-tabular exploration of the results.
Paid Parking Occupancy Survey Results
An interactive visualization of parking occupancy measured by manual surveys in 2017. Use this chart to explore where it is more difficult to find a parking space. The underlying information is used to inform parking rate changes and the basis for complex parking transaction and occupancy analyses.
Puget Sound Regional Travel Study Example
This visualization depicts data on household and individual travel patterns from the 2014-2015 Puget Sound Regional Travel Study. The visualization is designed to maximize the interactive experience with cross-dimensional origin and designation information. The data was pre-processed to provide goespatial labeling.
Bikeshare Open Data Summary
Visualization of open data from the City of Seattle’s previous Bikeshare program.The layout emphasizes origin and destination estimation. The result is tool for time series and geospatial analysis with an engaging interactive experience.
Gehl Public Life Data Protocol Sample
Sample interactive visualization and analysis of information collected using the Gehl Open Public Life Data Protocol, version Beta. The visualization helps communicate the level of data collected and informs how they could be used in further implementation of the program. The protocol was developed by the Gehl Institute, the Municipality of Copenhagen, the City of San Francisco, and with support and input from Seattle DOT.
Transit Performance Summary
This visualization is a sample of information that will be built in to the Seattle Transportation Benefit District performance site. Performance information was merged with GTFS static databases to create the interactive, comprehensive view of each route.
Vision Zero Dashboard
This dashboard was prepared for a public-facing site to communicate the progress the City is making towards its goal of zero traffic fatalities and serious injuries by the year 2020. The dashboard uses a heat map to show occurrences over time and location and helps the user characterize the nature of accidents.
Tree Inventory Open Data
This visualization tied directly to an open GIS data endpoint without the use of pre-processing techniques. As a concept project, this visualization required only a few hours to produce.
StreetsLayer Visualization
This visualization consumes several GIS streets layers that are published through open endpoints. Developers and civic technologists can use the data to perform analysis on transportation issues in Seattle. In order to display the information in tableau, the data was accessed and pre-processed in Python.

Bike Share Distance Matrix Analysis
Is it faster to take transit or bikeshare? To answer that question on Seattle’s first generation bikeshare program, you need to calculate travel times between stations and account for walking to/from the station. I used the Google distance matrix API and plotted the results based on number of trips actually taken and coded them Red, cycling is faster, and Blue, transit is faster.

Open Data City of Seattle Salaries
To provide transparency in governance, the City of Seattle released the salary information for most employees on the open data platform. This visualization connects to that data and organizes it for analysis and exploration.

CIVIC TECHNOLOGY

Traffic Cruising Project
I led a project at the 2017 Data Science for Social Good (DSSG) program hosted by the University of Washington eScience Institute. The City of Seattle, four full-time data science fellows, and two data science faculty at the eScience Institute worked together over a 10-week period. The project was featured by Microsoft News.

PUBLISHED DOCUMENTS

Move the Needle Performance Report
The Seattle DOT Moving the Needle performance report organizes key indicators and performance measures around the mission and vision of the department. I contributed to the organization of the information and developed a majority of the graphical assets for this consultant-designed report using Adobe Illustrator, Photoshop, and Tableau.
Project Controls Summary
This pixel-perfect report is an example of the type of projects I have created that transcend traditional government reporting. The document summarizes the status of capital projects conducted by the Seattle Department of Transportation for internal use. I designed the report to automatically query the proprietary information system (VBA and SQL), and was one of the first at Seattle DOT to consistently communicate ongoing program data using iconography, graphical layout, and visual composition techniques.
Council District Report
I developed the layout and graphical elements for this public-facing report and composed most of the content. The document helps constituents gauge the performance and activity in specific geographical locations of the City. With a minimalist approach, I employed strong grid functions and consistent, clean tabular presentation. Data were collected and processed from multiple disparate sources.