Taking Routing Data Beyond Routing

Derek Graham
Posted on August 18, 2011

Make no mistake about it — providing school transportation is a business that demands not only service, but also efficiency. And the lion's share of the expense — driver salaries and fuel — is directly related to routing.

It is hard to imagine, at least in medium-to-large operations, that planning and analysis can take place without computerizing bus routes in some form or fashion. How can we demonstrate efficiency if we can't quantify it?

Street names, intersections, geographical locations, student names, addresses, school and grade along with bus stop locations and driving instructions: Once we accept that some electronic form of these transportation data is essential, then it's time to think out of the box and realize the multitude of uses for those data.

In a related article in the August 2011 issue, we discussed the importance of documenting route hazards, including information in the computer routing database that helps drivers be aware of potential dangers each time the bus is routed across a given road segment. Such documentation could have prevented the multiple-fatality Fox River Grove bus-train crash in 1995. It is essential that drivers be provided with the critical safety information needed to protect their student passengers.

Here, we will look at some other uses of the basic data needed to plan and manage school buses, ranging from data analysis to relatively new applications.

Key performance, service indicators
The Council of the Great City Schools published a self-initiated report titled "Managing for Results in America's Great City Schools 2009" (available at In this report, the council identified key performance indicators (KPIs) relevant to school transportation, recognizing that there is value in measuring performance over time and comparing performance with other school districts. Implicit in this recognition is the need for the school district to have the ability to generate the KPIs.

When Charlotte-Mecklenburg (N.C.) Schools, for instance, embarked on a project of consolidating bus stops to improve efficiency for 2009-10, a natural question was, "How much farther were students being asked to walk?" The answer, extracted from their computer routing system, was that the average home-to-stop distance increased by only .06 miles, while reducing buses operated by 87 and cutting stops by 10,000 — all without losing riders as a result of the change.

Because the district has tracked these data for years, doing a comparison following the implementation of a new policy was very straightforward. In fact, being able to project the impact of new policy decisions was a key factor in securing school board approval.

The North Carolina Department of Public Instruction has been publishing transportation service indicators for five years now. The publication — available at — allows school districts to gauge their own service from one year to the next and to compare with other districts in a given year. Average and longest school bus riding times, bus utilization and student distance from home to stop are among the data that are tracked.

The picture painted by these comparative data helps school superintendents, board members and transportation directors — not to mention the general public — truly understand the result of transportation plans and the policy decisions that drive those plans.

School redistricting
Lee Lindsay, transportation director for Lee County (Ala.) Schools, gave a related presentation to delegates at the 2011 Southeastern States Pupil Transportation Conference in Oklahoma City in June.

Lee Lindsay of Lee County (Ala.) Schools says he got into computer routing to make transportation as efficient as it could be, but other benefits quickly began to surface.
Lee Lindsay of Lee County (Ala.) Schools says he got into computer routing to make transportation as efficient as it could be, but other benefits quickly began to surface.

Lindsay explained that he got into computer routing because of doubts that the current system of transportation was as efficient as it could be. But other benefits quickly began to surface. The use of these key data as they related to school redistricting was invaluable as the school district underwent a major change in school/grade combinations.

Much the same, I was involved in convincing school superintendents to volunteer for North Carolina's computer routing program — before it became mandatory in 1992. While transportation directors easily recognized the importance of maintaining bus stops and routes electronically, the superintendents and local boards (who ultimately made the decision) were most attracted by the ability to graphically analyze the composition of students in various geographical regions of the district.

Locating sex offenders
A list of locations of convicted sex offenders is just as easy to geocode (address-match) as the list of students to be transported. Since this is of such concern to parents, it only makes sense to use those identified locations when establishing bus stops.

Several of today's routing systems include options to alert the routing specialist when a stop is created within a specified distance of a sex offender location, and they can even store specifics of the age and gender of the victims (e.g., "convicted of molesting females, ages 6 and 16").

Describing another side benefit of computer routing, Lindsay vividly recalls a conversation with a grandmother related to the bus stop to which her granddaughter would be assigned. "Thank you, thank you, thank you!" she said to him, after being made aware of the nearby location of a known sex offender.

Regardless of whether the bus stop can be moved or must be located nearby, the mere knowledge that the potential danger exists is important to parents and caregivers.

In light of a significantly mobile population in Lee County — exacerbated by the presence of a military base — there are many parents who are unaware that known sex offenders might be living nearby.

"Sharing this information is something that doesn't cost us extra money but is very, very much appreciated by parents," Lindsay says.

Stop-arm violations
The first national illegal stop-arm passing count, conducted by the National Association of State Directors of Pupil Transportation Services (NASDPTS), noted nearly 77,000 motorists illegally passing about 112,000 school buses participating in the project. This is a national problem that can be addressed locally.

By definition, stop-arm violations take place at bus stops. Routing systems maintain location information on bus stops, so the process of generating maps showing incidents reported by drivers is quite simple. These maps can then be passed along to local law enforcement agencies for their use in stepped-up enforcement, school bus ride-alongs, etc.

Knowing where the problems occur is step one. Sharing that information is a big step two.

Sharing information
In fact, there is so much information in a computer routing system that it seems a real shame to use it for a single purpose. There is a good deal of effort required to get a routing system up and running, calibrated and reliable. So why stop there?

The performance indicators, redistricting, sex offenders and illegal-passing examples described here are just a few applications where these basic — yet extensive — data can be used and shared for the overall benefit of transportation departments and the students they serve.

Derek Graham, an SBF editorial advisory board member, has been the state pupil transportation director in North Carolina for 16 years. He is a past president of NASDPTS.

Related Topics: NASDPTS, routing

Comments ( 1 )
  • herzog

     | about 7 years ago

    i think it is terrible that the schools are asking kids to walk a mile and then some just to catch the bus- whats happening to the system that these busses cannot get them at their driveway-? where we live there are sex offenders- big fast trucks and the elements-i have been tryin to get her school to take 10 min out of their precious time to keep my child and another safe-perhaps bus drivers should be doing two routes so there is time- by the by- we live in the woods not any city blocks where there is safty in numbers

More Stories
File photo courtesy Des Moines (Iowa) Public Schools

Fed Mandate for Lap-Shoulder Belts Looks Unlikely

It was no big surprise that NTSB’s latest report calls for lap-shoulder belts on school buses. What was surprising was how the agency decided to direct that recommendation: not to the feds, but to the states.


Flush Mounting Bracket

A new flush mounting bracket from Pro-Vision Systems is designed to allow bus cameras to be mounted recessed into the bulkhead of a school bus or a transit bus.


SOS Alert Device

The Mobile Defender – Model S is a small device that employers can give to employees to use as a panic button during their shifts.

Be the First to Know

Get the latest news and most popular articles from SBF delivered straight to your inbox. Stay on top of the school bus industry and don't miss a thing!