Development of a Comprehensive Database System for Safety Analyst

Table 1

Source files and their data elements to build a safety database.

Road network	HPMS files	TDM model	Crash data	Intersection
Segment ID	Routes	Travel direction	Accident ID	Intersection ID
Ramp ID	Functional classification	Functional classification	Crash location	Intersection location
Segment length	Access control	Operation way; (one- or two-way)	Cash date	Type of control
Begin milepost	Speed limit	Speed limit	Collision type	Number of legs
End milepost	Through lanes	Number of lanes	Severity
Route ID	Lanes_Left	County	Relationship to junction
County	Lanes_Right	Area code	Direction of involved vehicle
Increasing milepost direction	AADT	Ramp configuration (sometimes available)	Maneuvers by involved vehicle
	Urban	Ramp type (sometimes available)
	County	Segment ID
		Ramp ID
		Segment length