Federal Aviation Administration

• Airport R&D
• News
• R&D Review
• Conference & Workshop
• Personnel
• Visitors
• Search This Site
• Downloads
• Pavement
• Safety
• Pavement Design
• LEDFAA
• 3-D FEM
• DIA IPP
• DIA Database
• Introduction
• Field Survey
• Data Acquisition
• Sensors
• Data Structure
• Browse Database
• NAPTF
• Database Introduction
• Test Item Diagram
• Sensors
• Naptf Table Map
• Table Details
• SQl Help

---

• Daily Traffic repetition
• Search Profile Data
• Search Static Data
• Search Dynamic Data
• Search MDD Data
• Search Traffic Data
• Search FWD Data
• Custom Query

The database is organized into 13 tables as shown in the table map below.  Key fields in each table are indicated by a key symbol.  Lines represent links between tables.  In order to more clearly show the relationships between the tables, not all fields have been shown in this map. A short description of each table is provided below.  For a complete listing of the fields in each table, including SQL Server data types, see Table Details.

Table Descriptions:

Dynamic_data - Contains dynamic sensor responses, including peak values and full dynamic records.
FWD - Contains falling-weight deflectometer (FWD) test data.  FWD tests are conducted periodically on NAPTF test items to monitor changes in the pavement structural properties.
Gear - Contains information about the configured loads, including number of tires per carriage, applied tire loads (nominal), and tire spacings (dual and tandem).
MUX - Contains information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)
SPUs - Contains information about the dynamic sensors, including sensor type and location. (SPU refers to the 6 signal processing units, which acquire the dynamic sensor data.)
Static_data - Contains static sensor responses, including hourly temperature and moisture readings.
Test_Item - Contains engineering data about the pavement test items, including the pavement type (rigid or flexible), layer thicknesses and materials.  This information is useful for structural analysis.
Track - Identifies the north and south carriage positions corresponding to the 9 wander tracks.
Traffic - Contains information about the vehicle passes, including start and end times for each load event, gear configuration, applied loads (actual), and wander position.
Wander - Lists the track numbers and carriage positions corresponding to each sequence number in the wander pattern.

The following three tables are used to store pavement survey data:

Distress - Lists the standard distress types used to determine pavement condition index (PCI) and structural condition index (SCI).
PCI_summary - Contains summary data on PCI surveys conducted on the test items.
PCI_survey - Contains detailed data on PCI surveys, including the distresses and deduct values used to determine the PCI.

Last Update:01/21/03