I noticed that Location was on the spreadsheet, but not on the form.
I added it to the form, but then the spreadsheet moved that question
to the end of the spreadsheet, which is already reserved for
comments. After messing with it for 40 minutes, I haven't found a
good way to fix it.
I propose we get a consensus set of questions/fields, and then I'll
just redo the whole survey and get it polished for mass consumption.
Here's what I propose as the starting set of questions, based on what
we have now (in order):
"Date" [Text field]
"Location (Street, nearest intersection, and city)" [Text field]
"Cyclist" [Text field]
"Driver" [Text field]
"Time & light/dark" [Text field]
"How did collision happen? (hit from behind, right hook,
etc.)" [Paragraph]
"Fatality" [Yes/No/Unknown]
"Hospitalization" [Yes/No/Unknown]
"Who at Fault" [Text field]
"Hit and Run" [Yes/No/Unknown]
"Legal penalties" [Text field]
"Driver intoxicated" [Yes/No/Unknown]
"Bike Lights" [Yes/No/Unknown] ...or should it be a Text Field?
"Helmet" [Yes/No/Unknown]
"Current Status of Incident" [Paragraph]
"Final Outcome of Incident" [Paragraph]
"Comments" [Paragraph]
The one I'm most unsure about is the "How did accident happen?" I'm
thinking something like a categorization of collisions along the lines
of
bicyclesafe.org. Maybe multiple choice with an "Other" text field?
What do you think? I want to get this wrapped up and ready for
primetime by the end of next week, if we can.
Thanks for your feedback!
Adam