I don't remember if it's already been suggested or not. But Also in the info, there should be a place for the police report #. Shouldn't there?
I believe we need to go by the book on this. If you get harrassed or assaulted or whatever, you are supposed to call the police right away. That's what they've told the couple times I've been involved in something like this.
chris
Exactly... that is what I am in the process fo defining. Think of it as a project requirements document (hey, once a geek, always a geek. :^) )
Joe
Daniel Porter <dan_p-@yahoo.com> wrote :
I wasn't planning on jumping in, however if this idea
does come to fruition, then a couple of points should
be addressed:
1) Accountability: There would need to be some sort of
safeguard against abuse. If anyone can anonymously
willy nilly enter a report that then fires off emails
left and right to all on the OBRA list and designated
law enforcement, you definitely have the potential for
abuse.
I do think that the best solution is to allow folks
that experience something to be able to do the data
entry, otherwise it could become a burden on whoever
is designated as "data enterer" and the database will
languish.
I'd suggest adding an accountability layer whereas the
"victim" has to enter who they are into the system
(even if it is not displayed in the report).
2) Would anyone be able to run a report, or would it
be only available to certain "administrators". Are
there any privacy restrictions related to this?
(playing devils advocate here) Would you want to be
entered in the database maliciously and have your info
be able to be displayed by any person?
3) This database should be accessible/usable by all
cyclists - regardless of their OBRA affiliation. Ie -
the BTA might want to link to it.
Just my .02
--- jo-@aracnet.com
wrote:
That is open for discussion. You can do it one of
two ways.
The person involved with the incident files the
'report'. Then:
1) A broadcast email is sent out to all on the obra
chat group of the incident
2) Nothing is done, but the incident is stored in
the database
In either case, the incident can be retreived by
performing a web-based search from the web frontend.
It can also be setup so that an email can be sent to
the law enforcement jurisdiction that the incident
took place in, but you will have to have a point of
contact for the jurisdiction.
Joe
Cp53-@aol.com
wrote :
SO, When somebody has an incident, should we shoot
out an email to the group
with the specifics? Who will do the data entry?
chris
To respond to the whole group send to
ob-@topica.com.
To respond to the list manager send to
cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to
ob-@topica.com.
To respond to the list manager send to
cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Okay so it looks like there is enough interest in doing this project.
I appreciate the input from the technical people. To put your minds at
ease, I'm quite experienced and proficient with web based application
development (that's what Fusium does). Coding, ui design, and relational
database design are things I do every day. All points were well taken.
I will start with a simple application, with moderators to approve or reject
user entries. If someone knows where I can find a listing or even a
database of all current makes/models (ie all vehicles for each brand) that'd
be very helpful. I wouldn't mind someone else doing that for me.
I'll get to it soom. But first, I've got some Tufo's to glue...
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
I wasn't planning on jumping in, however if this idea
does come to fruition, then a couple of points should
be addressed:
1) Accountability: There would need to be some sort of
safeguard against abuse. If anyone can anonymously
willy nilly enter a report that then fires off emails
left and right to all on the OBRA list and designated
law enforcement, you definitely have the potential for
abuse.
I do think that the best solution is to allow folks
that experience something to be able to do the data
entry, otherwise it could become a burden on whoever
is designated as "data enterer" and the database will
languish.
I'd suggest adding an accountability layer whereas the
"victim" has to enter who they are into the system
(even if it is not displayed in the report).
2) Would anyone be able to run a report, or would it
be only available to certain "administrators". Are
there any privacy restrictions related to this?
(playing devils advocate here) Would you want to be
entered in the database maliciously and have your info
be able to be displayed by any person?
3) This database should be accessible/usable by all
cyclists - regardless of their OBRA affiliation. Ie -
the BTA might want to link to it.
Just my .02
--- jo-@aracnet.com wrote:
That is open for discussion. You can do it one of
two ways.
The person involved with the incident files the
'report'. Then:
1) A broadcast email is sent out to all on the obra
chat group of the incident
2) Nothing is done, but the incident is stored in
the database
In either case, the incident can be retreived by
performing a web-based search from the web frontend.
It can also be setup so that an email can be sent to
the law enforcement jurisdiction that the incident
took place in, but you will have to have a point of
contact for the jurisdiction.
Joe
Cp53-@aol.com wrote :
SO, When somebody has an incident, should we shoot
out an email to the group
with the specifics? Who will do the data entry?
chris
To respond to the whole group send to
ob-@topica.com.
To respond to the list manager send to
cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to
ob-@topica.com.
To respond to the list manager send to
cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
That is open for discussion. You can do it one of two ways.
The person involved with the incident files the 'report'. Then:
1) A broadcast email is sent out to all on the obra chat group of the incident
2) Nothing is done, but the incident is stored in the database
In either case, the incident can be retreived by performing a web-based search from the web frontend. It can also be setup so that an email can be sent to the law enforcement jurisdiction that the incident took place in, but you will have to have a point of contact for the jurisdiction.
Joe
Cp53-@aol.com wrote :
SO, When somebody has an incident, should we shoot out an email to the group
with the specifics? Who will do the data entry?
chris
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
SO, When somebody has an incident, should we shoot out an email to the group with the specifics? Who will do the data entry?
chris
I would have a the DB setup as a RDBS:
Table: Location
Date (YYYY/MM/DD) <
City
County
State
Street/intersection
Address/mile marker
Table: Vehicle
Make
Type
Color
Sex (of driver)
State (License)
Date (YYYY/MM/DD) <
Year
I have a number of queries that can be based on this construct. Erik, if you want to exchange info, please feel free.
Joe
Steve-@clark.wa.gov wrote :
Yes Eric,
In normalizing the database, there should be (in addition to your list):
Vehicle Make
Vehicle model
Vehicle year (if known)
Plus, rather than just approximate location, perhaps:
Road
City
State
Mile post
Approximate location (if mile post isn't known)
Driver information such as male/female and hair color might also be useful.
The above would enable searching the database by make and model, and also by
road. This could lead to some information that could be very useful down the
road.
If a report doesn't include a list of minimal information such as Vehicle
make, color, city, state and road, it shouldn't be added to the database as
it would not be useful information.
-----Original Message-----
From: Erik Voldengen [mailto:eri-@fusium.com]
Sent: Thursday, September 30, 2004 12:00 PM
To: ob-@topica.com
Subject: FW: [OBRA Chat] Road Rage idea
I didn't realize I only replied to dave. Read below.
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
I could do it. Perhaps we could collectively arrive at a list of
information to gather, and I'll make a place where we can log
incidents and search the database based on some of these attributes.
I'll start with the info elements:
- date occurred
- approximate location
- severity rating (1-10)
- vehicle color
- vehicle description
- license plate
- explanation of event
Anything else?
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
-----Original Message-----
From: Dave German [mailto:dave_g-@hotmail.com]
Sent: Thursday, September 30, 2004 9:41 AM
To: chrisri-@freightliner.com;
ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
This is a great idea. The data that could be assembled would be
of
great
use in campaigning for action and change on behalf of our local
officials.
They seem to respond better to hard data. Is there anyone out
there
with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and
harassment
of
cyclists on the road. One of the ideas is to set up a internet
page
to
log
in occurrences with details(license plate, location, action).
This
information can be used to provide high incidence areas, and
high
incidence
drivers. The local and state police will be forced to act once
data
is gathered. Additionally insurance companies could access
this
information.
Collected numbers and facts have a way of bringing visibility to
a
problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com
<mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter
tools
and
more! http://special.msn.com/msn/election2004.armx
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
Also to aid in analyzing data, producing queries, generating statistics,
etc., the severity rating could be further qualified by assigning driver
behavior types such as 'not giving enough room', 'forced off road', 'threw
object', 'verbal assault', 'used car as weapon', etc. This would help in
defining what types and how often we are seeing these behaviors from the
motoring public.
Dave
From: Steve-@clark.wa.gov
Reply-To: Steve-@clark.wa.gov
To: eri-@fusium.com, ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 12:25:21 -0700
Yes Eric,
In normalizing the database, there should be (in addition to your list):
Vehicle Make
Vehicle model
Vehicle year (if known)
Plus, rather than just approximate location, perhaps:
Road
City
State
Mile post
Approximate location (if mile post isn't known)
Driver information such as male/female and hair color might also be useful.
The above would enable searching the database by make and model, and also
by
road. This could lead to some information that could be very useful down
the
road.
If a report doesn't include a list of minimal information such as Vehicle
make, color, city, state and road, it shouldn't be added to the database as
it would not be useful information.
-----Original Message-----
From: Erik Voldengen [mailto:eri-@fusium.com]
Sent: Thursday, September 30, 2004 12:00 PM
To: ob-@topica.com
Subject: FW: [OBRA Chat] Road Rage idea
I didn't realize I only replied to dave. Read below.
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
I could do it. Perhaps we could collectively arrive at a list of
information to gather, and I'll make a place where we can log
incidents and search the database based on some of these attributes.
I'll start with the info elements:
- date occurred
- approximate location
- severity rating (1-10)
- vehicle color
- vehicle description
- license plate
- explanation of event
Anything else?
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
-----Original Message-----
From: Dave German [mailto:dave_g-@hotmail.com]
Sent: Thursday, September 30, 2004 9:41 AM
To: chrisri-@freightliner.com; ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
This is a great idea. The data that could be assembled would be of
great
use in campaigning for action and change on behalf of our local
officials.
They seem to respond better to hard data. Is there anyone out there
with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and
harassment
of
cyclists on the road. One of the ideas is to set up a internet page
to
log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high
incidence
drivers. The local and state police will be forced to act once data
is gathered. Additionally insurance companies could access this
information.
Collected numbers and facts have a way of bringing visibility to a
problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com
<mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter
tools
and
more! http://special.msn.com/msn/election2004.armx
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
What's a "10"? Death? What's a "1"? Get off the road you spandex fairy!
----- Original Message -----
From: "Erik Voldengen" <eri-@fusium.com>
To: <ob-@topica.com>
Sent: Thursday, September 30, 2004 12:00 PM
Subject: FW: [OBRA Chat] Road Rage idea
I didn't realize I only replied to dave. Read below.
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
I could do it. Perhaps we could collectively arrive at a list of
information to gather, and I'll make a place where we can log incidents
and search the database based on some of these attributes.
I'll start with the info elements:
- date occurred
- approximate location
- severity rating (1-10)
- vehicle color
- vehicle description
- license plate
- explanation of event
Anything else?
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
-----Original Message-----
From: Dave German [mailto:dave_g-@hotmail.com]
Sent: Thursday, September 30, 2004 9:41 AM
To: chrisri-@freightliner.com; ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
This is a great idea. The data that could be assembled would be of
great
use in campaigning for action and change on behalf of our local
officials.
They seem to respond better to hard data. Is there anyone out there
with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and
harassment
of
cyclists on the road. One of the ideas is to set up a internet page
to
log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high
incidence
drivers. The local and state police will be forced to act once data
is
gathered. Additionally insurance companies could access this
information.
Collected numbers and facts have a way of bringing visibility to a
problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com
<mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter tools
and
more! http://special.msn.com/msn/election2004.armx
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
Yes Eric,
In normalizing the database, there should be (in addition to your list):
Vehicle Make
Vehicle model
Vehicle year (if known)
Plus, rather than just approximate location, perhaps:
Road
City
State
Mile post
Approximate location (if mile post isn't known)
Driver information such as male/female and hair color might also be useful.
The above would enable searching the database by make and model, and also by
road. This could lead to some information that could be very useful down the
road.
If a report doesn't include a list of minimal information such as Vehicle
make, color, city, state and road, it shouldn't be added to the database as
it would not be useful information.
-----Original Message-----
From: Erik Voldengen [mailto:eri-@fusium.com]
Sent: Thursday, September 30, 2004 12:00 PM
To: ob-@topica.com
Subject: FW: [OBRA Chat] Road Rage idea
I didn't realize I only replied to dave. Read below.
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
I could do it. Perhaps we could collectively arrive at a list of
information to gather, and I'll make a place where we can log
incidents and search the database based on some of these attributes.
I'll start with the info elements:
- date occurred
- approximate location
- severity rating (1-10)
- vehicle color
- vehicle description
- license plate
- explanation of event
Anything else?
___
Erik Voldengen 2037 NW Lovejoy 503-226-7099
Fusium, Inc. Portland, OR 97209 www.fusium.com
-----Original Message-----
From: Dave German [mailto:dave_g-@hotmail.com]
Sent: Thursday, September 30, 2004 9:41 AM
To: chrisri-@freightliner.com; ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
This is a great idea. The data that could be assembled would be of
great
use in campaigning for action and change on behalf of our local
officials.
They seem to respond better to hard data. Is there anyone out there
with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and
harassment
of
cyclists on the road. One of the ideas is to set up a internet page
to
log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high
incidence
drivers. The local and state police will be forced to act once data
is gathered. Additionally insurance companies could access this
information.
Collected numbers and facts have a way of bringing visibility to a
problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com
<mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter
tools
and
more! http://special.msn.com/msn/election2004.armx
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
Chris, I am not savvy with web design or software technology much at all. But if there is any way I can help this at all. Please let me know. I would like to help any way possible. This is such a worthwhile cause to bring some awareness and change to a big problem.
Thanks for your idea.
chris
I am talking with a couple friends of mine who are cyle commuters and DB web
programmers to see if they will donate time to this. Seems like a fairly
simple task.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com <mailto:chrisri-@freightliner.com>
-----Original Message-----
From: Dave German [mailto:dave_g-@hotmail.com]
Sent: Thursday, September 30, 2004 9:41 AM
To: chrisri-@freightliner.com; ob-@topica.com
Subject: RE: [OBRA Chat] Road Rage idea
This is a great idea. The data that could be assembled would be of great
use in campaigning for action and change on behalf of our local officials.
They seem to respond better to hard data. Is there anyone out there with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and harassment
of
cyclists on the road. One of the ideas is to set up a internet page to log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high incidence
drivers. The local and state police will be forced to act once data is
gathered. Additionally insurance companies could access this information.
Collected numbers and facts have a way of bringing visibility to a problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com <mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter tools and
more! http://special.msn.com/msn/election2004.armx
This is a great idea. The data that could be assembled would be of great
use in campaigning for action and change on behalf of our local officials.
They seem to respond better to hard data. Is there anyone out there with
the knowledge and resources to host the site and manage the data?
Dave
From: Chris <chrisri-@freightliner.com>
Reply-To: chrisri-@freightliner.com
To: ob-@topica.com
Subject: [OBRA Chat] Road Rage idea
Date: Thu, 30 Sep 2004 08:50:47 -0700
I was talking to one of the BTA people about the road rage and harassment
of
cyclists on the road. One of the ideas is to set up a internet page to log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high incidence
drivers. The local and state police will be forced to act once data is
gathered. Additionally insurance companies could access this information.
Collected numbers and facts have a way of bringing visibility to a problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com <mailto:chrisri-@freightliner.com>
To respond to the whole group send to ob-@topica.com.
To respond to the list manager send to cmur-@obra.org
To unsubscribe send to obra-uns-@topica.com
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter tools and
more! http://special.msn.com/msn/election2004.armx
I was talking to one of the BTA people about the road rage and harassment of
cyclists on the road. One of the ideas is to set up a internet page to log
in occurrences with details(license plate, location, action). This
information can be used to provide high incidence areas, and high incidence
drivers. The local and state police will be forced to act once data is
gathered. Additionally insurance companies could access this information.
Collected numbers and facts have a way of bringing visibility to a problem.
Chris Rinehart
Freightliner Mfg Engrg CIW
503-745-6905
chrisri-@freightliner.com <mailto:chrisri-@freightliner.com>
© 2026 Oregon Bicycle Racing Association