My sister and I sometimes end up walking under that bridge on our night-time walks - she likes it because if you yell it echoes.
Anyway, it's right here:
So, there's an SPN location that I found before they even used it. ;-)
Though, the real question is, why wasn't I made aware that they were filming just down the road? That would have been pretty convenient.