You are not logged in.
Pages: 1
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
Offline
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?
Offline
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)
Offline
The bike/ped crashes layer on CAMPO's web viewer has been updated to show incidents between 2011 and 2013.
Offline
Pages: 1
[ Generated in 0.016 seconds, 9 queries executed - Memory usage: 537.55 KiB (Peak: 538.18 KiB) ]