See Click Fix may be the answer to our dreams. Todd and I were trying to cadge together a reporting system for bike commuters and sidewalk walkers. We used Twitter feeds and an interactive map for users to post their reports.
Chapin Spencer pointed us to SeeClickFix, which does much of this and also allows you to set Watch Areas and direct reports from posts in those areas to the appropriate public official. Here is a first draft: