
Spatial Patterns of COVID-19 Transmission and Commuter Movement Analysis
Explore the spatial patterns of COVID-19 transmission from workplace hot spots to residential areas, focusing on the movement of commuters in Orleans Parish. Discover how data from the American Association of State Highway and Transportation Officials (AASHTO) can help model people's journey to work and analyze the impacts on virus spread. Learn about accessing and utilizing CTPP data for effective analysis and decision-making.
Download Presentation

Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Modeling the Spatial Pattern of Community Transmission of Coronavirus/COVID-19 from Hot Spot Workplaces to Home James E. Mitchell, Ph. D. James E. Mitchell, Ph. D. IT IT Statewide Program Officer Statewide Program Officer GIS, Embedded at LADOTD GIS, Embedded at LADOTD jim.mitchell@la.gov Penelope Z. Weinberger Penelope Z. Weinberger CTPP Program Manager, American Assoc. of State Highway and Transportation Officials pweinberger@aashto.org
Pattern of Commuters to Orleans Parish Every day 86,065 commuters travel to Orleans Parish (shown in black) for work. Before implementing social distancing and stay at home strategies, workers who were exposed to the Commuters provided a travel-related mode of transmission into heir home Parishes.
COVID-19 Positive Cases by County April 5, 2020 By April 5th the pattern of commuters into New Orleans started to emerge as the number of positive COVID-19 cases in each Louisiana Parish and surrounding Mississippi counties.
The American Association of State Highway and Transportation Officials (AASHTO) Journey to Work AASHTO Comprehensive Transportation Planning Products (CTPP) models the movement of people from home to work. Based on US Census, American Community Survey (ACS) 5-year data. Used to validate most commercially-sold location- based travel data. Available for the entire US, at various levels of geography (county, MSA, state, etc.).
How to Access How to Access Journey to Work Journey to Work Data Data Step 1 Step 1 Choose the CTPP 2012-2016 Button Step 2: Step 2: Expand the CTPP 5-Year Dataset (2012-2016) + Expand Part 3: Flows Important steps for reformatting the CTPP Important steps for reformatting the CTPP data: data: Remove all titles, headers, footers, and information at the top and bottom Highlight each Highlight each FIPS Code field. To ensure they are in Text Format, on the Data Ribbon, click the Text to Columns Button, follow the prompts Step 3: Step 3: Choose Table A302100 Total worker (1) (Workers 16 years and over) You will see a data table data table and have options for selecting its contents, format, format, etc etc. . options for selecting its contents, Combine State + County FIPS Combine State + County FIPS to create a unique Join Field (in Excel or GIS) From here, you can download the data to a spreadsheet or other formats. The spreadsheet will require reformatting to join it into GIS.
Pattern of Commuters to East Baton Rouge Parish Every day 73,734 commuters travel to East Baton Rouge Parish (shown in black) for work. After terminating the stay at home strategy, workers will return to this pattern of daily commuting.
Pattern of Commuters to Lafayette Parish Every day 41,698 commuters travel to Lafayette Parish (shown in black) for work. After terminating the stay at home strategy, workers will return to this pattern of daily commuting.
Pattern of Commuters to Ouachita Parish Every day 10,723 commuters travel to Ouachita Parish (shown in black) for work. After terminating the stay at home strategy, workers will return to this pattern of daily commuting.
Conclusions and Applications As return to normal activities progress, commuter patterns can be used to determine how reinfection might manifest. This may assist on how to stage rescinding stay at home policies. Early in the COVID-19 Pandemic, commuting patterns provided a means to model the direction and locations where the Coronavirus was likely to spread In either case, knowing where to stage or place limited resources, testing centers, etc. can assist decision-makers.