Development of a Comprehensive Database System for Safety Analyst

Table 3

Mapping between a general and the safety analyst views.

Database table name	Attribute name	Attribute values	Safety analyst view; table name	Safety analyst view; attribute/name	Safety analyst view; attribute; value
Accident	Severity	Fatal injury	Accident	accidentSeverity1	K
Accident	Severity	Severe injury	Accident	accidentSeverity1	A
Accident	Severity	Property damage only	Accident	accidentSeverity1	P
RoadwaySegment	routeType	State route	RoadwaySegment	routeType	SR
RoadwaySegment	routeType	Interstate	RoadwaySegment	routeType	I
RoadwaySegment	routeType	U.S. route	RoadwaySegment	routeType	US
RoadwaySegment	roadwayClass	Principal arterial, other	RoadwaySegment	routeType	3
RoadwaySegment	roadwayClass	Minor arterial	RoadwaySegment	roadwayClass	4
RoadwaySegment	roadwayClass	Local	RoadwaySegment	roadwayClass	7
RoadwaySegment	roadwayClass	Major collector	RoadwaySegment	roadwayClass	5
RoadwaySegment	roadwayClass	Principal arterial, other freeways or expressways	RoadwaySegment	roadwayClass	2
RoadwaySegment	roadwayClass	Principal arterial, interstate	RoadwaySegment	roadwayClass	1
RoadwaySegment	roadwayClass	Minor collector	RoadwaySegment	roadwayClass	6
RoadwaySegment	roadwayClass	Other	RoadwaySegment	roadwayClass	0
RoadwaySegment	roadwayClass	Unknown	RoadwaySegment	roadwayClass	99