Funded by U.S. Department of Transportation “State and Local Government Data Analysis Tools for Roadway Safety” grant, the Yakama Nation Roadway Safety Data Portal is an online comprehensive roadway safety data visualization and evaluation platform. The system is based on a transportation multi-source data management, fusion, analysis, and visualization platform that the University of Washington STAR Lab team has developed, called the Digital Roadway Interactive Visualization and Evaluation Network (DRIVE Net) (Xiao et al., 2015; Wang et al., 2016). The system provides users with the capability to store and manage the safety data efficiently. Besides data management, the system also supports various analytical and visualization functions, such as crash data visualization, crash modeling analysis, roadway safety performance index estimation, network screening and hotspot identification, etc.
- Point-based Crash Visualization
- Segment-based Safety Index Visualization
- Zipcode-based Safety Index Visualization
- Intersection-based Safety Index Visualization
- Crash Heatmap
- Safety Performance Regression/Visualization
- Crash Data Download
- Summary Report
The STAR Lab team had worked with Yakama Nation DNR Engineering team to check the available safety related data sources, collect, store and manage the collected data into the developed database management system. Specifically, the data preparation included the following steps.
The UW research team had worked with the Yakama Nation DNR Engineering team for safety-related datasets including the Highway Safety Information System (HSIS) dataset, statewide weather station data by Washington State Department of Transportation (WSDOT), WSDOT crash data portal, and Washington state GIS roadway network data. These datasets were then cleaned and stored to the database
Multi-source datasets were integrated into the database system, for redundant data across data sources, if all attribute values are duplicated, then the entire data was deleted. For some cases where redundant attributes were used, correlation analysis and monitoring was performed to determine whether the original data can be restored.
The datasets used in this research were managed in the database system in MS SQL server and PostgreSQL databases.
This section provides guidance for setting up Express-based client development and deployment environments for Yakama Nation Roadway Safety Data Portal API Server.
The API server, which is developed by Express.js. Therefore, Node.js needs to be installed to use npm and webpack for client code development and deployment.
- Git clone source code from this repository and install all dependencies.
git clone https://github.com/AI-Group-STAR-Lab-UW/yakama-nation-roadway-safety-data-portal.git
cd yakama-nation-roadway-safety-data-portal/yakama-nation-roadway-safety-data-portal-server/
npm install
- Host the API Server in your local site.
nodemon app.js
If nodemon is not recognized as internal or external command, add the npm prefix path to the environment variables. Please visit here for the more detailed solution: Link.
Or you can either run the following command to host the server.
node app.js
-
Check if the API server run successfully. Go to http://localhost:3010 see if the website shows
Yakama Nation Roadway Safety Data Portal API Server Running!. -
Customize server port. The port number can be set in
app.js. The current port is set as3010.
The official-hosted API server can be accessed through http://128.95.29.72:3010.
This section provides guidance for setting up React-based client development and deployment environments for Yakama Nation Roadway Safety Data Portal.
Node.js needs to be installed to use npm and webpack for client code development and deployment.
- Check if the API server run successfully. Go to http://128.95.29.72:3010 and see if the website shows
Yakama Nation Roadway Safety Data Portal API Server Running!. You can also customize your own API Server based on the given datasets. The path is set in./yakama-nation-roadway-safety-data-portal/yakama-nation-roadway-safety-data-portal/src/constants/domain.js, which can be replaced by customized API server urls.
- Git clone source code from this repository and install all dependencies.
git clone https://github.com/AI-Group-STAR-Lab-UW/yakama-nation-roadway-safety-data-portal.git
cd yakama-nation-roadway-safety-data-portal/yakama-nation-roadway-safety-data-portal/
npm install
- For local development, run
npm startthen the website can be hosted locally; for production deployment, runnpm run build.
Al Pinkham, Engineering Planner II, [email protected]
HollyAnna Littlebull, Traffic Safety Coordinator, [email protected]
Portia Shields, Data Manager, [email protected]
Paul Teicher, Senior Policy Analyst, [email protected]
Tom Bragan, Traffic Records Division, NHTSA, [email protected]
Yinhai Wang, Professor and Director of PacTrans, [email protected]
Wei Sun, Postdoc Research Associate, [email protected]
Meng-Ju (Dennis) Tsai, Research Assistant, [email protected]
Sam Ricord, Research Assistant, [email protected]
Meixin Zhu, Research Assistant, [email protected]
This project exists thanks to all the people who contribute from Yakama Nation DNR Engineering, USDOT, and UW STAR Lab.
Yakama Nation Roadway Safety Data Portal is MIT licensed.