Harospec Data

hare-o-spec

Data is messy and increasingly complex. We transform data into meaningful information for decision-makers, using innovative and cost-effective tools. Our services are based upon several core tenets that inform all stages of the analytical process:

  • Analysis should directly inform decision-making
  • Information should be presenting in modern, accessible formats
  • Methodologies should be tranparent and reproducible
  • Tools should be modular and cost-effective

Contact us for more information and to solicit services.

Services

Data Visualization

Creating both static and dynamic data visualizations using cost-effective open source tools such as R and Shiny

KPIs

Transforming raw data into metrics that help measure progress and meet targets

ETL

Wrangling messy data into useable formats that are ready for analysis.

Reporting

Creating modern, web-ready reports that present information in effective and digestable formats

Data Collection

Gathering data from myriad sources using automated, efficient workflows (E.g. APIs)

GIS

Utilizing modern open source tools to understand location based data and create maps.

Dashboards

Custom web-based interactive business intelligence tools and dashboards.

Modeling

Applying theory and statistics to create tools that estimate, predict, and forecast into the future.

Big Data

Harnessing the power of large, complex datasets sourced from new technololgies.

Work

Examples of our work, which highlight our emphasis on web-based data visualization and automated analysis.

*
All Urban Planning Transportation Personal Other GIS

Data Viz

web-based visualization

Shiny

web apps

Data Collection

APIs

Reports

interactive documents

Animation

Vehicle Crashes

Data Exploration

land use dashboard

Data Reporting

reporting dashboard

Data Modeling

estimating & forecasting

Munging

data prep & cleaning

Data Viz Gallery

Our visualizations are produced using cost-effective, open-sourced libraries such as ggplot2 which are reproducible and transparent.

Posts

Examples of applying data science to manage and visualize recreational projects.

Analysis of music music genres and characteristics over time using a large Spotify database.
2 min read

Data analysis and visualization of environmental data related to the 2019 wildfires in Australia
1 min read

Analysis of Central Park Squirrel Census dataset as part of the October 29th, 2019 TidyTuesday data series.
1 min read

Bird observations collected with Ebird and visualized with leaflet.
1 min read

Backcountry ski tour data collected with the Gaia App and visualized with leaflet.
1 min read

Publications

Master’s Thesis from the University of Washington, 2014
PDF

Research for the City of Seattle published by the U.S. Department of Energy, 2014
PDF

Experience

 
 
 
 
 

Data Science Contractor

New Leaders

Jan 2024 – Present
Provided ad hoc data science services
 
 
 
 
 

Consultant

Resource Systems Group Inc (RSG)

Sep 2021 – Present
Provided analytical consulting services to clients on throughout the United States on projects related to climate change, urban planning, and transportation. Project examples included mobile source GHG forecasting, regional and state transportation plans, scenario planning, travel demand modeling, land use planning, and project prioritization. Analytical services included creation of interactive data tools, data visualization, statistics, data pipelines, general programming scripts, and custom data analysis workflows.
 
 
 
 
 

Modeling Program Coordinator

Tahoe Regional Planning Agency (TRPA)

Oct 2019 – Aug 2021 Stateline, Nevada
Managed the regional transportation and land use modeling program. Work included managing ongoing enhancements and application of the regional activity-based transportation model, improving regional land use modeling, creating automated workflows and web-based tools, technical writing, statistics, data collection, big data analysis, and program development.
 
 
 
 
 

Data Modeler/Analyst

Tahoe Regional Planning Agency (TRPA)

Jul 2017 – Sep 2019 Stateline, Nevada
Performed a variety of data analysis and modeling tasks to support regional transportation and land use planning. Examples include updating and running the activity-based Tahoe travel demand model, developing web-based analytical tools using R-Shiny; organizing data collection efforts such as the regional travel survey; curating a respository of regional Census data; managing state of California air quality reporting requirements; regional transportation plan forecasting; project analysis
 
 
 
 
 

Commissioner

Urban Forestry Commission - City of Seattle

Sep 2016 – Sep 2017
Reviewed and analyzed urban forestry policies for the City of Seattle. Work included reviewing proposed projects and city-wide policies and making recommendations to the Seattle City Council.
 
 
 
 
 

Field Surveyor

Seattle Audobon Society - Puget Sound Seabird Study

Jun 2015 – Jun 2017
Surveyed winter seabird activity in the Puget Sound.
 
 
 
 
 

Founder

Friends of North Lake Union (FONLU)

Jun 2015 – Jun 2017
Founded and managed an environmental restoration and advocacy community group. Work included grant writing, project management, and community outreach.
 
 
 
 
 

Board Member

Wallingford Community Council

Jun 2015 – Jun 2016
Reviewed and discussed infrastructure, urban planning, and community projects and made recommendations to the City of Seattle.
 
 
 
 
 

Assistant Planner

Puget Sound Regional Council (PSRC)

Oct 2014 – Jun 2017 Seattle, California
Supported the regional Transportation Improvement Program (TIP) and transportation funding project selection for the largest MPO in the state of Washington. Responsibilities included SQL database management, web-mapping, project analysis, and project tracking.
 
 
 
 
 

Outreach & Data Analyst

City of Seattle

Jul 2013 – Apr 2014 Seattle, Washington
Managed a nation-wide survey of public street light systems as part of the Municipal Solid State Street Light Consortium. Reponsibilities included data collection and analysis, which culminated in a report published by the US Department of Energy on energy efficient public street lighting. Presented findings at the national IES Street & Area Lighting Conference.
 
 
 
 
 

Communication Specialist

University of Washington

Sep 2012 – Jun 2013 Seattle, Washington
Work included graphic design, communication, and program support for the Graduate and Professional Student Senate (GPSS).
 
 
 
 
 

Assistant

Solar Energy International

Jan 2011 – Mar 2011 Carbondale, Colorado
Assistant to the Executive Director at SEI. Work included renewable energy education and program support. As part of this role I completed a several months of technical training on the renewable energy industry. I received SEI Records of Completion in five areas that included photovoltaic installation and design, as well as renewable analysis and energy business.
 
 
 
 
 

Green the Capitol Intern

U.S. House of Representatives

Jul 2010 – Oct 2010 Washington D.C.
Sustainability research and policy support for the Architect of the Capitol and Congressman Rick Larsen. Work included analyzing facilities practices for the capitol properties to identify sustainability improvements and conducting congressional policy research.
 
 
 
 
 

1st Place Winner: Environmental Challenge International (ECi) Competition

Air & Waste Management Association (AWMA)

Apr 2010 – Jun 2010
 
 
 
 
 

1st Place Winner: PNWIS/AWMA Environmental Challenge

Air & Waste Management Association (AWMA)

Sep 2009 – Nov 2009

Contact

To solicit services, submit questions, or request additional information please submit a message and we will reply shortly

Popular Topics

Analysis Animation Big Data Dashboards Data Collection Data Munging Data Science Data Viz GIS Modeling Reporting Research Socioeconomics Statistics Transportation Urban Planning