William (Billy) Charlton

Scientific Researcher at
Technische Universität Berlin

https://billyc.github.io
charlton@tu-berlin.de
@billyinberlin

Place of birth: Takoma Park, Maryland, United States of America
Citizenship: United States of America

Research Area

An expert in transport modeling, data management, and data visualization, I aim to support informed decisionmaking and advance the art of data visualization by developing platforms and technologies that let people see and communicate what their data is trying to tell them.

Positions

2017–present Scientific Researcher, Technische Universität Berlin Berlin, Germany

Doctoral adviser: Kai Nagel
Building web-based data visualization tools for the MATSim agent-based transport simulation framework.

2013–2017 Director of Data, Puget Sound Regional Council Seattle

Led 22-person team responsible for all technical details of travel modeling, land use modeling, and geographic information systems (GIS) in support of the Seattle metropolitan region’s future growth plans.

2011–present Founder and CEO, Because LLC San Francisco, Seattle

Consulting for private firms and government agencies needing expertise in web-based data visualization, travel demand modeling, and software development. Clients include Sidewalk Labs, San Francisco County Transportation Authority, NACTO, WSP Inc., others.

2007–2011 Deputy Director for Technology Services, San Francisco County Transportation Authority San Francisco

Continued development of SF-CHAMP, an activity-based transportation model. Supported decisionmaking for congestion pricing, bus rapid transit, land use development, and many other studies. Managed the modeling, IT, and graphics teams.

2003–2007 Principal Transportation Planner, San Francisco County Transportation Authority San Francisco

Developed the SF-CHAMP travel model in support of the agency’s decisionmaking needs.

1999–2003 Software Developer, Wind River Systems Alameda

Developed front-end desktop software for developer tooling of embedded systems.

1991–1999 Transportation Engineer, Parsons Brinckerhoff (now WSP) Washington DC, Seattle, San Francisco

Developed travel modeling software for many government clients across the globe.

Education

2023 (expected) Doctor of Engineering (Dr. Ingr.), Technische Universität Berlin Berlin, Germany

Advised by Professor Kai Nagel
Dissertation: “Web-Based Data Visualization in Support of Agent-Based Microsimulation Models”
Degree expected in October 2023. Duration, August 2017 - October 2023.

1996 Master of Science in Civil Engineering, Northwestern University Evanston, Illinois

Advised by Joseph Schofer and Frank Koppelman.
Thesis: “Familiar Driver Response to In-Vehicle Route Guidance Systems”

1991 Bachelor of Science in Civil Engineering, Cornell University Ithaca, New York

Transportation engineering focus
Received the Crandall Award for Writing in Engineering

Skills

Technical team management. Managed a 22 person technical team and a six person team at previous positions. Reported to the Executive Director in both positions, providing budget and work program for each agency. I excel at creating motivated technical teams by providing guidance, mentorship, and skill-building.

Agent-based and activity-based modeling. Deep familiarity with MATSim and ActivitySim. Developed SimWrapper, a web-based dashboard tool for analyzing MATSim and ActivitySim outputs.

Programming languages. Over ten years experience writing advanced Java, Python, TypeScript, R, C, and C++. Built successful Android mobile applications in Java. Taught introductory Python and R courses.

Data analysis. Expert in web-based data visualization techniques including Deck.gl and three.js. Expert in the R/Tidyverse data analysis platform. Comfortable with Python/Pandas.

Front end web developer Modern web front-end developer, expert in Vue.js and familiar with React. I have built countless single page application websites, from internal tools such as timesheet and expense report creators to full data analysis portals including 3D animations and map-based visualizations.

Other technical skills. Expert in Git and code management. Vast experience with setting up data flow pipelines. Very comfortable with Docker and related DevOps technologies. I consider myself a technology generalist: I am very familiar with many technologies and can pick up others quickly.

Publications [Interactive Version]

Conference

C1
Integration of a parcel-level land use model and an activity-based travel model
Paul Waddell, Liming Wang, Billy Charlton. 11th World Conference on Transport Research, 2007.

Journal

J1
Application of travel demand microsimulation model for equity analysis
Joe Castiglione, Rachel Hiatt, Tilly Chang, Billy Charlton. Transportation Research Record 1977(1), 2006.

Book Chapter

Teaching Experience

2020 Data Science for Agent-Based Transport Modeling TU Berlin

Developed new 3-credit course for VSP department, focusing on R for data science, including exploratory data analysis, data visualization, and online publication of results.

2016 Programming with Python UW eScience Institute

One-day workshop for scientists as part of Software Carpentry workshop series.

2016 Version Control with Git TRB Applications Conference, Denver

Developed and led afternoon workshop on collaboration with Git, based on Software Carpentry workshop series.

Service

Chair of the Board, Zephyr Transport Foundation, 2018-2020.

Certified Volunteer Teacher, Software Carpentry Organization.

Reviewer for Transportation Research Board ADB40/AEP50.