• Login
    View Item 
    •   Home
    • University of Alaska Fairbanks
    • College of Engineering and Mines (CEM)
    • Institute of Northern Engineering
    • Arctic Infrastructure Development Center (AIDC) Publications
    • Center for Safety Equity in Transportation (CSET)
    • CSET Project Reports
    • View Item
    •   Home
    • University of Alaska Fairbanks
    • College of Engineering and Mines (CEM)
    • Institute of Northern Engineering
    • Arctic Infrastructure Development Center (AIDC) Publications
    • Center for Safety Equity in Transportation (CSET)
    • CSET Project Reports
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Browse

    All of Scholarworks@UACommunitiesPublication DateAuthorsTitlesSubjectsTypeThis CollectionPublication DateAuthorsTitlesSubjectsType

    My Account

    Login

    First Time Submitters, Register Here

    Register

    Statistics

    Display statistics

    Develop a Regional Multi-Source Database System for Safety Data Management and Analysis in RITI Communities in Washington State

    • CSV
    • RefMan
    • EndNote
    • BibTex
    • RefWorks
    Thumbnail
    Name:
    CSET_2017BaselineData_Final.pdf
    Size:
    1.915Mb
    Format:
    PDF
    Download
    Author
    Wang, Yinhai
    Zeng, Ziqiang
    Gottsacker, Christopher
    Yang, Hao (Frank)
    Keyword
    Baseline data
    Multi-source database system
    Transportation
    safety data management and analysis
    rural
    tribal
    Metadata
    Show full item record
    URI
    http://hdl.handle.net/11122/10197
    Abstract
    Rural, Isolated, Tribal, and Indigenous (RITI) communities across the United States are disadvantaged from a transportation safety perspective. Particular concern is focusing on rural road safety. Since RITI communities often do not have the capability and resources to sufficiently solve roadway safety problems, several challenges are encountered for addressing transportation safety issues in RITI communities, including: (1) Crashes are often distributed along roads in RITI areas without known patterns; (2) Strategies to address safety issues are diverse for different RITI communities and draw from several safety areas. As a result, there is a critical need to realize equitably-augmented safety solutions that address the needs of these underserved and underinvested RITI communities. To address this gap, this project aims to develop a regional multi-source database system for traffic safety data management and analysis of RITI communities in Washington State. The existing crash data sources in RITI communities in Washington was identified and documented. The crash data on rural routes was extracted from the raw data from Washington State Department of Transportation and integrated into the multi-source database system, including traffic flow characteristics, crash attributes and contribution factors, crash-related trauma data and medical records, weather conditions, etc. The Colville tribe also provided the crash data in their tribal communities under a confidentiality agreement. A multi-source database fusion and integration system architecture was designed. Microsoft SQL Server 2012 was used to implement the database and manage the data. A six-step data quality control method was employed to clean the data by wiping out the outliers from spatial and temporal aspects. The tribal crash data was made accessible to authorized users so they can download the datasets by using password, while the WSDOT crash data was set to be public for all the users. A safety analysis module was developed for visualizing the data in the regional multi-source database system in RITI communities. The data visualization platform is developed based on the Vaadin Framework. The users can interact with the interface for data analysis. A safety performance index and a potential safety improvement index were also developed. By combining the two indexes, one can easily identify crash hotspots and the key influencing factors to consider in an improvement package.
    Date
    2019-05
    Type
    Technical Report
    Collections
    CSET Project Reports

    entitlement

     
    ABOUT US|HELP|BROWSE|ADVANCED SEARCH

    The University of Alaska Fairbanks is an affirmative action/equal opportunity employer and educational institution and is a part of the University of Alaska system.

    ©UAF 2013 - 2023 | Questions? ua-scholarworks@alaska.edu | Last modified: September 25, 2019

    Open Repository is a service operated by 
    Atmire NV
     

    Export search results

    The export option will allow you to export the current search results of the entered query to a file. Different formats are available for download. To export the items, click on the button corresponding with the preferred download format.

    By default, clicking on the export buttons will result in a download of the allowed maximum amount of items.

    To select a subset of the search results, click "Selective Export" button and make a selection of the items you want to export. The amount of items that can be exported at once is similarly restricted as the full export.

    After making a selection, click one of the export format buttons. The amount of items that will be exported is indicated in the bubble next to export format.