Bicycle Austin forum

badgnome

Member

Registered: 2012-01-26

Posts: 50

bike crashes map

Made this at work the other day using TxDOT CRIS data. Next is a version with 2011 to 2013 bike crashes by individual counties along with pedestrian versions.

http://www.campotexas.org/wp-content/up … 13-CSA.pdf

parent directory: http://campotexas.wpengine.com/safety-data/

TxDOT site: http://www.txdot.gov/government/enforce … stics.html

Jack

Member

Registered: 2013-03-27

Posts: 345

Re: bike crashes map

Very interesting; thanks for posting.
Do you have data on crash locations/causes to go along with it.  At that resolution, I can't tell where a given dot is located (what street, what block).  Or, and I wouldn't be surprised, is there a way to zoom in that I can't figure out without coaching?

badgnome

Member

Registered: 2012-01-26

Posts: 50

Re: bike crashes map

Very interesting; thanks for posting.
Do you have data on crash locations/causes to go along with it.  At that resolution, I can't tell where a given dot is located (what street, what block).  Or, and I wouldn't be surprised, is there a way to zoom in that I can't figure out without coaching?

I think the cause may be found in the 'charges' table which can be joined to the main 'crash' table. I found the charges (some of which may not apply) here that could be referenced:

10     ALCOHOL/DRUGS     1990-01-01     9999-12-31
11     ASSAULT/MANSLAUGHTER WITH VEHICLE     1990-01-01     9999-12-31
12     BICYCLE OFFENSES     1990-01-01     9999-12-31
13     COMMERCIAL & MOTOR CARRIER VIOLATIONS     1990-01-01     9999-12-31
14     DRIVER LICENSE & REGISTRATION VIOLATIONS     1990-01-01     9999-12-31
15     DRIVER'S MISCELLANEOUS VIOLATIONS     1990-01-01     9999-12-31
16     INSURANCE AND INSPECTION     1990-01-01     9999-12-31
17     MOTORCYCLE VIOLATIONS     1990-01-01     9999-12-31
18     OVERTAKING (PASSING)     1990-01-01     9999-12-31
19     PARKING VIOLATIONS     1990-01-01     9999-12-31
20     REPORTING VIOLATIONS (TRAFFIC VIOLATIONS)     1990-01-01     9999-12-31
21     RIGHT OF WAY     1990-01-01     9999-12-31
22     SEATBELT /  HELMET USAGE     1990-01-01     9999-12-31
23     SIGNAL INTENTION     1990-01-01     9999-12-31
24     SPEEDING     1990-01-01     9999-12-31
25     TRAFFIC SIGNS, SIGNALS, AND ROAD MARKINGS     1990-01-01     9999-12-31
26     TURNING VIOLATIONS     1990-01-01     9999-12-31
27     VEHICLE/EQUIPMENT DEFECTS     1990-01-01     9999-12-31
28     WRONG SIDE/WRONG WAY     1990-01-01     9999-12-31

I have done one for Travis County, but can make a series by zip code using the more detailed CAPCOG street network.  Is there a place on this forum they could be uploaded to?

Your browser should have + and - controls for zoom or a % zoom pull down.

Last edited by badgnome (2014-09-12 20:31:22)

badgnome

Member

Registered: 2012-01-26

Posts: 50

Re: bike crashes map

The bike/ped crashes layer on CAMPO's web viewer has been updated to show incidents between 2011 and 2013.

http://www.austintexas.gov/GIS/CAMPOInteractiveMap/