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

▶
nodes 2019 exploring the u s national bridge index
SMART_READER_LITE
LIVE PREVIEW

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

May 29, 2023 152 likes •322 views

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:

slide-1
SLIDE 1

Michael McKenzie

M.S. Civil/Structural Engineering October 10, 2019

NODES 2019 Exploring the U.S. National Bridge Index

slide-2
SLIDE 2

Why?

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

slide-3
SLIDE 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

slide-4
SLIDE 4

Data

slide-5
SLIDE 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

slide-6
SLIDE 6

Data

slide-7
SLIDE 7

Problem

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

slide-8
SLIDE 8

Schema

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

slide-9
SLIDE 9

Schema

  • Insert image
slide-10
SLIDE 10

Query

slide-11
SLIDE 11

Query

slide-12
SLIDE 12

GRANDstack Application

slide-13
SLIDE 13

Next Steps...

  • Decode...decode...decode
  • Create audit records & logs
  • Build out the schema

Goals...

  • Predictive analytics
  • Budget projects
  • Funding & repair recommendations
slide-14
SLIDE 14

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

About me...

(graphs)-[:ARE]->(everywhere)

slide-15
SLIDE 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