Information about pedestrian infrastructure and volume is indispensable to monitoring, evaluating, and improving the environment for comfortable and safe walking. However, determining and organizing the various types of data in a way that is easy to update and analyze can present challenges. This study designed and developed a relational database for pedestrian infrastructure and volume, and comprises two core components (node table and approach table) and several sub-components (tables for crosswalks, sidewalks, buffers, signs, transits, bikeways, bicycle parking, and volumes)....
