Traffic Crash Data Dictionary:
Bernalillo County, NM
ArcIMS Demonstration Project - March 2003
Contract Number C04950
Conducted for the New Mexico Traffic Safety Bureau
State Highway and Transportation Department
Prepared by the Division of Government Research (DGR)
at the University of New Mexico
Larry Spear, Program Manager
Susan Bucklin, GIS Technician
Jason Snyder, GIS Specialist
11/13/06
This project illustrates various traffic crash data for major roads in Bernalillo County, New Mexico for 2005 using ESRI's ArcIMS. ArcIMS is a useful tool for local agencies and individuals who need better access to traffic crash data. The facilities present in ArcIMS together with the relative ease of using this software should allow casual and less sophisticated users easy access to traffic crash and other geographically oriented data.
Crash Data
Crash data for calendar year 2005 were derived from SAS files maintained by DGR and the New Mexico Traffic Safety Bureau (NMTSB). A point-based Arc/Info coverage was produced and then converted to a shapefile for use in ArcIMS. The crash coverage that was produced contains one record for each route location (ROUTE, SYSTEM, SPUR, and MILEPT) on state funded roads and intersections (ASTREET and BSTREET) at which crashes occurred. Thus, there can be more than one crash at a given route location or intersection. The Arc/Info coverage (or shapefile) is contained in a directory or file called CR04_83. It contains only some of the data items present in the comprehensive crash files.
Traffic crash data were aggregated using SAS. The data were matched to Bernalillo County's road geography using DGR's GRNDB GIS. They were then transferred to Arc/Info using specialized SAS Macros that write Arc/Info import/export format files.
The data variables contained in CR05_83 are as follows:
| Variable | Format | Description |
| AREA | 4 12 F 3 | Area: 0.0 for point data |
| PERIMETER | 4 12 F 3 | Perimeter: 0.0 for point data |
| CR04_83_ | 4 5 B | Internal ID number |
| CR04_83_I | 4 5 B | Feature ID number |
| ASTREET | 30 30 C | First intersecting street name |
| BSTREET | 30 30 C | Second intersecting street name |
| AFC | 1 1 I | Functional classification flag for ASTREET |
| BFC | 1 1 I | Functional classification flag for BSTREET |
| FATAL | 4 5 B | Number of fatal crashes |
| PCTFAT | 4 6 F 2 | Of total crashes, percent fatal |
| KILLED | 4 5 B | Total number of people killed in crashes |
| CLASSA | 4 5 B | Number of incapacitating injuries in crashes |
| CLASSB | 4 5 B | Number of visible injuries in crashes |
| MCINV | 4 5 B | Number of motorcycle involved crash(es) |
| OCCTOT | 4 5 B | Total number of people for all crashes |
| PCTKA | 4 6 F 2 | Of total crashes, percent killed or incapacitated |
| ALC | 4 5 B | Number of accidents where alcohol was involved |
| PCTALC | 4 6 F 2 | Of total crashes, percent involving alcohol |
| FPCTALC | 4 6 F 2 | Percent fatal for alcohol-involved crashes only |
| FI | 4 5 B | Number of fatal and injury crashes |
| PCTFI | 4 6 F 2 | Of total crashes, percent fatal or injury |
| PDO | 4 5 B | Number of property damage only crashes |
| PCTPDO | 4 6 F 2 | Of total crashes, percent property damage only |
| MORN | 4 5 B | Number of crashes between 6:00am and 8:59am |
| PCTMORN | 4 6 F 2 | Of total crashes, percent morning crashes (see above) |
| FPCTMORN | 4 6 F 2 | Percent fatal among morning crashes only (see above) |
| DAY | 4 5 B | Number of crashes between 9:00am and 2:59pm |
| PCTDAY | 4 6 F 2 | Of total crashes, percent day crashes (see above) |
| FPCTDAY | 4 6 F 2 | Percent fatal among day crashes only (see above) |
| EVE | 4 5 B | Number of crashes between 3:00pm and 5:59pm |
| PCTEVE | 4 6 F 2 | Of total crashes, percent evening crashes (see above) |
| FPCTEVE | 4 6 F 2 | Percent fatal among evening crashes only (see above) |
| NIGHT | 4 5 B | Number of crashes between 6:00pm and 5:59am |
| PCTNIGHT | 4 6 F 2 | Of total crashes, percent night crashes (see above) |
| FPCTNIGH | 4 6 F 2 | Percent fatal among night crashes only (see above) |
| ANGLE | 4 5 B | Number of angle crashes as defined by analysis in crash report |
| PCTANG | 4 6 F 2 | Of total crashes, percent angle crashes |
| FPCTANG | 4 6 F 2 | Percent fatal among angle crashes only |
| PED | 4 5 B | Number of pedestrians involved in crashes |
| PCTPED | 4 6 F 2 | Of total crashes, percent involving pedestrians |
| FPCTPED | 4 6 F 2 | Percent fatal among pedestrians crashes |
| TOTAL | 4 5 B | Total number of crashes at a location |
| NODE | 4 5 B | Unique ID # for an intersection |
Additional Note: More information about the traffic crash data can be found in the Accident Level Analysis File documentation (PDF format) on DGR’s web page (www.unm.edu/~dgrint/accf.html).