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
Recommend
More recommend