Tag: mysql

Fun with tables.

table from mysql -H html output:

InjurySeverity IncidentID IncidentDateTime Onroad CrossingFeature
5 2371350 2010-04-17 01:18:00 99th Ave Camelback Rd
5 2401688 2010-08-13 00:00:00 99th Ave Union Hills Dr
5 2416950 2010-10-31 11:03:00 99th Ave Lindgren Ave

table from myphpadmin:

IncidentID IncidentDateTime Onroad CrossingFeature
2446148 2010-09-23 06:41:00 Via Linda 117th St
2453234 2010-09-23 07:45:00 Missouri Ave 63rd Ave
2445966 2010-09-23 08:22:00 University Dr Hardy Dr
2451975 2010-09-23 11:10:00 Ina Rd La Cholla Blvd
2451005 2010-09-23 13:49:00 Colombo Ave Charleston Rd
2454504 2010-09-23 15:10:00 Glenn St Orlando Ave
2454482 2010-09-23 15:31:00 8th St Tyndall Ave
2453231 2010-09-23 15:44:00 Camelback Rd 79th Ave
2454471 2010-09-23 15:45:00 Oklahoma St 12th Ave
2448706 2010-09-23 16:13:00 3rd Ave Encanto Blvd
2448069 2010-09-23 17:00:00 Delaware Dr Apache Trl

Arizona Bicyclist and Ped Crash Map

Volunteer Needed

crashmap

URGENT: Google has announced the tool used to present the crash maps, below, called “Fusion Tables” is being discontinued Dec 3, 2019.
Azbikelaw is looking for a volunteer familiar with GIS and web-presentation to help effect transition to something else.

Please see this article for more info. Below is the historical data and procedures.

Continue reading “Arizona Bicyclist and Ped Crash Map”

ADOT Traffic Collision Database

ACIS — Arizona Crash Information System; was ASDM?

It turns out (who knew?) that ADOT sells their crash database for a nominal sum. I purchased the 2010 version, the latest full-year available (2011 is supposed to be ready in July). This data is either similar to (or synonymous with) something referred to as the Arizona (or ADOT?) Safety Data Mart — thus the acronym asdm sprinkled throughout. Continue reading “ADOT Traffic Collision Database”

FARS and PBcat

Commencing with the recently-released 2010 data FARS (The USDOT’s Fatality Analysis and Reporting System) will have far more specialized detail on Pedestrian and Bicyclists crashes.

“Motorist Failure to Yield — signed intersection” One of several dozen crash types defined by PBCAT

618 cyclists (person type 6 bicyclist, and 7 other pedalcyclist) were killed in 2010 in traffic collisions — and as noted at the link above, only collisions with motor vehicles in-transport are tracked by FARS. So for example, a bicyclist who lost control and died as a result of crashing into a tree would not be tracked here, nor would a bicyclist who strikes a parked motor vehicle. Continue reading “FARS and PBcat”