Prototype Data Dashboard for Multi-Source Transportation and Community Health Data Analytics
Publication: International Conference on Transportation and Development 2024
ABSTRACT
This study had a primary objective of creating a versatile and scalable data dashboard prototype that highlights transportation and community health data, using El Paso as a case study. The dashboard serves as a centralized hub for various data sources within the city, facilitating visual analysis to uncover the intricate connections between these two crucial domains. It’s important to note that the primary aim was not to develop a final product for the city, but rather to establish a proof-of-concept, engage potential users, and conduct scenario analysis. The true impact of this study is expected to extend beyond the creation of the dashboard itself, as it has the potential to influence significant city-wide or regional policy changes based on the valuable insights derived from the comprehensive data analysis. This initiative aims to provide a robust tool for decision-makers and stakeholders to make informed choices that could ultimately benefit the community’s transportation and health outcomes.
Get full access to this chapter
View all available purchase options and get full access to this chapter.
REFERENCES
ADT (Application Development Trend). (2006). In depth DCStat. Application Development Trend Magazine. April 5, 2—6. https://adtmag.com/Articles/2006/04/05/DCStat.aspx?Page=2&p=1. Accessed January 26, 2023.
CASA (Centre for Advanced Spatial Analysis). (2022). CityDashboard: London. Centre for Advanced Spatial Analysis, University College London. https://citydashboard.org/london.
Census. (2023). Data and tables. US Census Bureau. https://www.census.gov/data.html. Accessed January 26, 2023.
City of Baltimore. (2022). About CitiStat. Office of Performance and Innovation. City of Baltimore, Maryland. https://www.baltopi.com/about-citistat. Accessed January 26, 2023.
City of Boston. (2023a). COVID-19 in Boston. City of Boston. https://www.boston.gov/government/cabinets/boston-public-health-commission/covid-19-boston. Accessed January 26, 2023.
City of Boston. (2023b). Imagine Boston 2030 metrics dashboard. City of Boston. https://data.boston.gov/showcase/imagine-boston-2030-metrics-dashboard. Accessed January 26, 2023.
City of Charlotte. (2022). Capital projects. City of Charlotte, North Carolina. https://charlottenc.gov/charlottefuture/Pages/Capital_Project.aspx. Accessed January 26, 2023.
City of Las Vegas. (2023). City of Las Vegas community dashboard. https://communitydashboard.vegas. Accessed January 26, 2023.
City of New York. (2022). NYC open data dashboard. City of New York. https://opendata.cityofnewyork.us/dashboard. Accessed January 26, 2023.
Crisis Dashboards. (2021). https://www.citydashboard.com.au/melbourne.php. Accessed January 26, 2022.
Delpeuch, A. (2022). OpenRefine User Manual. https://openrefine.org/docs. Accessed February 23, 2023. 70.
EPTX. (2023). El Paso Strong. City of El Paso, Texas. https://epstrong.org. Accessed February 15, 2023.
Farmanbar, M., and Rong, C. (2020). Triangulum city dashboard: an interactive data analytic platform for visualizing smart city performance. Processes, 8(2), 250. https://doi.org/10.3390/pr8020250.
Jing, C., and Du, M. (2019). Geospatial dashboards for monitoring smart city performance. Sustainability, 11, 5648. https://doi.org/10.3390/su1120564.
Fischer, F. (2021). UTEP, City of El Paso opening new COVID-19 mega-testing site. KFOX14 News, August 19, 2021. https://kfoxtv.com/news/local/utep-city-of-el-paso-opening-new-covid-19-mega-testing-site.
Microsoft. (2023). Azure Database for PostgreSQL. Microsoft Corp., https://azure.microsoft.com/en-us/products/postgresql/#overview. Accessed February 23, 2023.
Mattern, S. (2015). Mission control: a history of the urban dashboard. Places Journal, March 2015. Accessed 24 Jan 2023. https://doi.org/10.22269/150309.
Maynood University. (2023). Building city dashboard. https://dashboards.maynoothuniversity.ie. Accessed January 26, 2023.
Oberlin. (2023). Oberlin environment dashboard - bringing environmental dashboard to your community. Oberlin College, Ohio. https://environmentaldashboard.org/bring-dashboard-to-your-community#_Toc446430146. Accessed February 15, 2023.
Ratti, C., et al. (n.d.). LIVE Singapore! Senseable City Lab, Massachusetts Institute of Technology. https://senseable.mit.edu/livesingapore/visualizations.html. Accessed 26 January 2023.
Sanromã, L. (2021). The principles of visual design for dashboards. Adnia Solutions. Retrieved November 18, 2022, from https://adniasolutions.com/dashboard-design-principles/the-principles-of-visual-design-for-dashboards.
Scikit-Learn. (2023). Scikit-learn, machine learning in Python. Scikit-Learn Developers. https://scikit-learn.org/stable/ Accessed February 23, 2023. 71.
Streamlit. (2023). Streamlit documentation. Streamlit Inc. https://docs.streamlit.io. Accessed February 23, 2023.
Story, R. (2013). Folium 0.14.0 documentation. https://python-visualization.github.io/folium. Accessed February 23, 2023.
Wejo. (2023). Trafic Movements. Wejo Limites. https://www.wejo.com/products/vehicle-movements. Accessed February 15, 2023.
WSDOT (Washington State DOT). (2023). COVID-19 Multimodal transportation system performance dashboard. Washington State Department of Transportation. https://www.wsdot.wa.gov/about/covid-19-transportation-report. Accessed 2/15/2023.
Zuo, F., Wang, J., Gao, J., Ozbay, K., Ban, X. J., Shen, Y., Yang, H., and Iyer, S. (2020). An interactive data visualization and analytics tool to evaluate mobility and sociability trends during COVID-19. UrbComp 2020: The 9th SIGKDD International Workshop on Urban Computing, San Diego, California, USA.
Information & Authors
Information
Published In
International Conference on Transportation and Development 2024
Pages: 699 - 709
History
Published online: Jun 13, 2024
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.