Development of Analysis Methods Using Recent Data (2012) / Chapter Skim
Currently Skimming:
Pages 71-77
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 71... ...
71 A p p e n d i x B database Architecture This section gives a detailed description of the database schema and metadata used for each field site. The metadata are described first, followed by the associated schema that enables extraction of target tracking and raw sensor point tracking data.
|
From page 72... ...
72 Schema Presently, nine tables make up the database schema for each site: (1) gap_data, (2)
|
From page 73... ...
73 Table B.1. vehicle_acpt_lag Attribute Type Description/Comments targetid Double Primary key, target vehicle ID of tracked maneuver.
|
From page 74... ...
74 Currently Available Crash data The crashes involve two events from the Minnesota Highway 52 fixed site and one from the North Carolina site. The project team obtained four videos for the three crashes that were date-time stamped (one of the crashes had video from two camera perspectives)
|
From page 75... ...
75 Table B.3. sensor_collector Attribute Type Description/Comments date Date Primary key, date stamp.
|
From page 76... ...
76 Table B.6. gap_data Attribute Type Description/Comments date Date Primary key, date stamp.
|
From page 77... ...
77 Note that zones 9 and 17 represent the stop-bar and transition zone, respectively, for the given maneuver type. For the side-road maneuver crossing the other direction, maneuver=2, the stop-bar and exiting transition zones are 12 and 20, respectively.
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.