| Subject: | RE: Road Rage idea |
| Date: | 09/30/2004 04:29 AM |
| From: | jo-@aracnet.com |
|
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 |
