nodes 2019 exploring the u s national bridge index
play

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:


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

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

  3. 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

  4. Data

  5. 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

  6. Data

  7. 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

  8. 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

  9. Schema ● Insert image

  10. Query

  11. Query

  12. GRANDstack Application

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

  14. 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)

  15. 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