NODES 2019 Exploring the U.S. National Bridge Index Michael - PowerPoint PPT Presentation

NODES 2019 Exploring the U.S. National Bridge Index Michael McKenzie M.S. Civil/Structural Engineering October 10, 2019

Why? August 1, 2007 I-35W Bridge Minneapolis, MN

Data Files hosted by the National Bridge Index (NBI) website: https://www.fhwa.dot.gov/bridge/nbi/ascii.cfm ● 1992 to 2018 ● 50 States & Washington, DC & Puerto Rico ● Files: 1,872 ○ Delimited: 468 ○ No-Delimiter: 1,404 ● Total Number of Rows: 23,643,682 ● Properties per Row: 122

Data

Data Cleaning & Decoding Recording and Coding Guide for the Structure Inventory and Appraisal of the Nation’s Bridges https://www.fhwa.dot.gov/bridge/mtguide.pdf

Data

Problem :NEXT_FILE :NEXT_RECORD :File :CONTAINS :Row :FILE_FOR :LOCATED_IN :DATA_FOR :SHARED_BRIDGE :OF_COUNTY :OF_STATE :County :State :Place :OF_PLACE :Bridge :BORDERS :MAINTAINS :OWNS :Entity

Schema :NEXT_FILE :NEXT_RECORD :File :CONTAINS :Row :FILE_FOR :LOCATED_IN :DATA_FOR :SHARED_BRIDGE :OF_COUNTY :County :State :OF_STATE :Place :OF_PLACE :Bridge :BORDERS :MAINTAINS :OWNS :Entity

Schema ● Insert image

Query

Query

GRANDstack Application

Next Steps... ● Decode...decode...decode ● Create audit records & logs ● Build out the schema Goals... ● Predictive analytics ● Budget projects ● Funding & repair recommendations

About me... Programmer at CALIBRE Systems, Inc. GraphDB DC Organizer (www.meetup.com/GraphDB-DC/) Washington, DC, USA Contact web: mckenzma.com LinkedIn: www.linkedin.com/in/mckenzma/ GitHub: github.com/mckenzma Neo4j Community: community.neo4j.com/u/mckenzma/summary (graphs)-[:ARE]->(everywhere)

Hunger Games Questions for “Exploring the U.S. National Bridge Index” 1. Easy: When did the I-35W bridge collapse? a. October 10, 2019 b. July 4, 1776 c. August 1, 2007 2. Medium: What two places are included in the NBI files other than the 50 states of the United States? a. Washington, DC & Puerto Rico b. Washington, DC & Bermuda c. Puerto Rico & Bermuda 3. Hard: What does NBI stand for? Answer here: r.neo4j.com/hunger-games