DEVELOPERS NEEDED TO FILL AN “APP GAP”

We all praise the GPS apps that help us get around, but there is no current resource that tells drivers if the vehicle they’re operating is too tall for the upcoming bridge. As a truck, bus driver or fleet operator, this is pertinent information that is currently lacking while navigating our streets. Far too often, this results in "can opener" accidents, where the bridge peels off the top of the truck. These “bridge strikes” can cause damage to not only the truck and bridge, but they can sometimes be fatal to the drivers. In addition, many people have been hit by falling bridge debris after the accident.

SCOS_DataStory01_TruckPhoto
This is the second time this year trucks have hit the Norfolk Southern railroad overpass heading to Rickenbacker airport cargo facilities.” – Village of Lockbourne Mayor, Christie Ward. (Photo credit: Michelle Jones)

I-270 reopens on south side after truck hits power lines, bridge

July 17, 2017, by NBC4 Staff

...

The truck also took down several utility lines, before the dump bed fell off. The truck then slid off the road and ended up in Shawn and Carl Williamson’s backyard.

The couple said they heard what they thought at first was thunder from inside their home.

“He was already out of the truck when we got back here,” said Carl. “He was stumbling back here. I could see blood coming out of his face, dripping down his arms.”

...
Read full article at NBC4

According to the Ohio Department of Transportation, trucks haul 88% of freight in Ohio. However, this problem is larger than just freight. Many accidents also occur with moving and rental trucks. Local Franklin County officials, who see the same bridges hit over and over, are concerned about the costs of bridge strikes in terms of safety, commuter frustration and lost time for the 1,799 Columbus-based logistics, delivery and trucking companies.

There are 762 bridges in Franklin County, but information on their dimensions is often scattered and hard find. We believe there’s opportunity to fill this “app gap” and help motorists navigate their way around – or under – Columbus bridges.

There are 27,000+ bridges in Ohio, the 2nd highest count in the country, and there are 762 in Franklin County with many at risk for bridge hits.

GPS 2.0

Smart Columbus spoke with truckers, app developers, engineers, police officers, logistics companies, government agencies and researchers and found that the Ohio Department of Transportation (ODOT) spends $1 million annually to fix bridges hit by oversize vehicles. One recent bridge strike alone was estimated to have caused $210,000 in damage. While ODOT pursues reimbursement from insurance companies, time and resources could be saved if data on bridge dimensions could be applied to help avoid such collisions in the first place.

Meanwhile, many bridge strikes aren’t reported unless the truck gets stuck. We believe there’s an opportunity to create apps or other solutions that could facilitate the reporting of bridge strikes, so officials could more proactively understand and address bridge damage.

That’s why we’re publishing the following data on bridge dimensions in Franklin County. By sharing this data, we hope the development community will help us innovate solutions that can prevent bridge strikes, proactively re-route oversized trucks, make it easier to report bridge damage and more.

Together, let’s unlock the potential of this data to make our roads and bridges easier to drive on, more cost effective to manage and safer for everyone.

BRIDGE DATA SETS AVAILABLE

GETTING INTO THE DATA VIA API END POINTS

The Data API can be accessed via the following actions of the CKAN action API.

Create https://ckan.smartcolumbusos.com/api/action/datastore_create
Update/Insert https://ckan.smartcolumbusos.com/api/action/datastore_upsert
Query https://ckan.smartcolumbusos.com/api/action/datastore_search
Query (via SQL) https://ckan.smartcolumbusos.com/api/action/datastore_search_sql
OData https://ckan.smartcolumbusos.com/datastore/odata3.0/5fc21aab-daa8-41d2-ac2d-f348f7caa9b6

EXAMPLES ON HOW TO QUERY THE DATA

CODING EXAMPLES

Java Script (jQuery 3.1.0)
A simple ajax (JSONP) request to the data API using jQuery.
<-script src="//ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"><-/script->
<-script>
  var data = {
    resource_id: 'd01462c5-6069-471b-bdf3-d9acd4aa4572', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
  };
  jQuery.ajax({
    url: 'https://ckan.smartcolumbusos.com/api/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
      alert('Total results found: ' + data.result.total)
    }
  });
<-/script->

#Python 3.5
import urllib3
import certifi
https = urllib3.PoolManager(
cert_reqs='CERT_REQUIRED',
ca_certs=certifi.where())
url='https://ckan.smartcolumbusos.com/api/action/datastore_search?resource_id=d01462c5-6069-471b-bdf3-d9acd4aa4572&limit=5'
fileobj = https.request('GET',url)
print (fileobj.data)
Image