Metro Transit Maps: Show People Where They Can Go

I was recently out for a run in North Minneapolis when I saw something I wasn’t expecting to see: the #9 bus. After years of living in Minneapolis near the eastern end of the 9’s route, it hadn’t occurred to me that I could cross the city at a northwest angle to reach Theodore Wirth Park. That was a real eye-opener, and something I’ll be using soon.

Which made me wonder: Could I easily figure out where else I can reach from my home using the Metro Transit website?

It can be done, but it’s not obvious how. But, it seems like the pieces are there to do it.

Metro Transit provides a zoomable map with all of their routes, which allows one to see which routes are nearby.

Metro Transit Map Routes

They also have a route discovery option where clicking on a street will reveal which routes serve it.

Routes Serving Lake Street

And, they provide interactive route maps like this one for the 21:

Interactive 21 Route

But, tying this together is a bit tricker. If you go to the full version of the interactive route map, you’ll see a list of all routes along the right column of the page.

Interactive Route Finders

If you select a route, it will display like the Route 21 example above. Things get more interesting if you select more then one route (hold down the Command key while clicking routes on a Mac or possibly the Ctrl key on Windows).

Where I can Go Map

Doing that creates a “where can I go” map. One that’s limited to a maximum of 5 routes.

To take some friction out of this, it would be cool if Metro Transit built in the ability to select a location, and their walking tolerance, to trigger a display of available routes.

Perhaps, if people had an easier time figuring out where they could get to without a transfer, they’d take more of those trips?

Another option that would be slick. Show people where they can get to within a specific amount of time, including transfers. For example, where could I get to within 45 minutes?

E-Pulltabs Projections vs Reality for Vikings Stadium Funding #wilfare

Electronic pulltabs seem to be underperforming in a variety of ways. Here are some examples.

Tim Nelson at MPR’s Stadium Watch blog has been following the stadium construction project from every angle. While the construction side of things seems to be moving along rather smoothly, the financing side feels like a slow motion train wreck to me.

Here are the assumptions that went into convincing the legislature that gamblers could be exploited at a high enough level to pay $348 million plus interest share of an NFL subsidy:

E-pulltabs devices: 15,400
Revenue/day/device: $225
Revenue/day/location: $1,400
Devices/location: 6.2 (just dividing the above figures to get this).

They also mentioned that having e-pulltabs running in 2,500 bars was a conceivable goal by October 2013.

To hit 2,500 active venues by October, they’ll need to install nearly 200 per month. As of Feb 15th, 168 locations have games installed. Here’s a look at how those two compare:

E-pulltabs Venues vs Projections

How about revenue per device per day? The devices had a nice honeymoon with Vikings fans/lobbyists showing up at O’Gara’s for the launch of their ticket subsidizing devices. However, the honeymoon appears to be over:

E-Pulltabs Revenue per device per day

How about revenue per day per location? The goal is $1,400. That was exceeded during the honeymoon phase, but then:

E-Pulltabs Revenue per Location Per Day

Only 8 venues met or exceeded the $1,400 in revenue per day projection in January. Among those who did not

If revenue per device and revenue per location isn’t hitting projections, perhaps that could be solved by increasing the number of devices per location? This, of course, assumes that revenue is being held back due to eager e-pulltabs players being unable to lose money due to all devices being checked out by other gamblers. But, I get the impression that demand is not beating supply based on the trend in devices per location:

Devices per Location vs 6.2 Devices/Location Expectation

Some of the top performing locations only have 4 devices, which may support my theory that the only way e-pulltabs will work is if they become attractive to problem gamblers. Interacting with an iPad (or similar) device isn’t a social activity. Perhaps e-pulltabs will do better if vendors focus less on sports bars and more on day drinking establishments? For example, Porky’s Bar on Payne ranked #2 for e-pulltabs revenue in January, so we’re literally taking money out of St Paul’s East Side to subsidize Zygi Wilf’s Park Ave condo.

Which bar is #1 in the state for subsidizing the NFL’s interest in rebuilding stadiums every 30 years with other people’s money? Harry’s Bar in Hill City, MN:

Harry's Bar, Hill City, MN

This looks like trickle-up economics to me.

If revenue settles in at the current rate per device and bars decide that five devices are plenty, the number of venues needed to hit revenue projections is far higher.

Or, worst case scenario, bars will decide that it’s not worth the effort to deal with e-pulltabs infrastructure, training, and space allocations at these revenue levels and drop this program.