Wednesday, June 04, 2008

Cars v Cyclists

There's a point of impact photo on the internets of a car possibly with a drunk, sleeping or both driver plowing into a group of racing cyclists last weekend. It's a very graphic photo. I can't bring myself to put it here.

Ugh...

Meanwhile local police are searching for a driver that collided with a bicycle ridden by a 14-year-old girl at the I-229 & Minnesota Ave interchange. I learned last evening at the FAB board meeting that this press release was published 14 days after the incident.

Here's an interesting (to me) timeline...

5/15 - DJ Andy airs his complaint about a bicyclist at the I-229 & Cliff interchange. DJ Andy threatens cyclist with his 4,000lb vehicle and imagines shooting the errant cyclist with a bee bee gun.

5/19 - 14 year-old girl on bicycle gets struck 1 mile west of I-299 & Cliff at the I-229 & Minnesota interchange. Driver leaves the scene.

(logical fallacy alert - there is no evidence of a link between the first two items)

5/21 - I share drive time radio with a local police officer about riding bicycles on roadways and sidewalks. Officer fails to bring up 5/19 incident. With all due respect, opportunity missed. Sir.

Update 6:15pm - the more I think about this the more I hope the 14 year-old girl didn't report the incident until the day before the press release - which makes the timeline only partially less interesting.

6/2 - Local police issue press release seeking 40 year-old balding driver "wearing glass." Once we figure out what it looks like to wear glass it shouldn't be too hard to find the guy.

Press release says they seek a "silver Honda with South Dakota organizational plates similar to C2676." Apparently they need some SQL help too. Any geek boys out there want to put that SQL statement in comments?

Clearly there is more work to do in this town.

Next post - what my mom says I did wrong when I was on the air.

7 comments:

conundrummer said...

Here goes:

SELECT
ICIS.LICENSE_PLATE, ICIS.MAKE, ICIS.COLOR, ICIS.FIRST_NAME, ICIS.LAST_NAME, ICIS.ADDRESS

FROM
ICIS

WHERE
ICIS.LICENSE_PLATE LIKE '%C2676%' AND ICIS.MAKE LIKE 'HONDA' AND ICIS.COLOR LIKE 'SILVER'

noelnjen said...

Something like this should do the trick...

select *
from Cars
where Make = 'Honda'
and Color in ('Silver', 'Gray')
and State = 'SD'
and (PlateNumber like '%C2676%' or
PlateNumber like '%2676%' or
PlateNumber like '%C267%' or
PlateNumber like '%C_676%' or
PlateNumber like '%C2_76%' or
PlateNumber like '%C26_6%')

thE_kErnEl said...

SELECT * FROM AUTOMOBILES WHERE COLOR=SILVER AND LICENSE LIKE 'c'

or something like that . . .

mytzpyk said...

I (heart) geeks!

conundrummer said...

Geeks <3 minus car too!

DIRK said...

What?!? You guys lost me. I'll stick with simply reading blogs.

sararah said...

The only (knock on wood) car vs bike accident I have been in was also a hit and run, at 26th and Bahnson on the east side. The guy turned left into me (I was in the crosswalk, riding so I'm not sure what the rules are here) and didn't hit me at all. I screamed some profanities and managed to catch his plates as he drove off. All he got was a ticket for leaving the scene of an accident I guess.

Someone must have called 911 when it happened, because cop cars, an ambulance, and a fire truck all responded to it. Good times, good times. I hope they find the guy.