Development of a Comprehensive Database System for Safety Analyst

Table 2

Sample of the metadata file for data mapping.

Database table name (fixed)	Database attribute name (fixed)	User file name (to be filled by user)	User file attribute name (to be filled by user)
RoadwaySegment	agencySegmentID	CDS_Network	ID1
RoadwaySegment	beginLocation	CDS_Network	Beg_Route_
RoadwaySegment	endLocation	CDS_Network	End_Route_
RoadwaySegment	routeName	CDS_Network	Route_MAST
RoadwaySegment	routeType	CDS_Network	Route
RoadwaySegment	county	CDS_Network	County_code
RoadwaySegment	length	CDS_Network	Datum_Seg2
RoadwaySegment	terrain	HPMS_terrain	Terrain
RoadwaySegment	roadwayClass	CDS_Network	F08_FType1
RoadwaySegment	medianType	LasVegas_Median	MedianType
RoadwaySegment	accessControl	HPMS_Access	Value_name
RoadwaySegment	medianWidth	LasVegas_Median	MedianWidth
RoadwaySegment	postedSpeed	HPMS_SpeedLimit	PostedSpeed