Custom Query (Phase II)  

You may query the NAPTF database by using Structured Query Language (SQL). Note that data are read-only. Only “select” queries will be recognized by the database. Refer to the table map and definitions when formulating queries.

SQL Query

To view sample queries select the Sample Queries link.

Table Map

The database is organized into 9 tables for both dynamic data and static data as shown in the figure. (Table Descriptions) To view sample queries select the Sample Queries link.

 .

Table Descriptions

• PII_Dynamic_data - Contains dynamic sensor responses, including peak values and full dynamic records.
• PII_Gear - Contains information about the configured loads, including number of tires per carriage, applied tire loads (nominal), and tire spacing (dual and tandem)
• PII_MUX - Contains information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)
• PII_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.)
• PII_Static_data - Contains static sensor responses, including hourly temperature and moisture readings.
• PII_Track - Identifies the north and south carriage positions corresponding to the 9 wander tracks.
• PII_Traffic - Contains information about the vehicle passes, including start and end times for each load event, gear configuration, applied loads (actual), and wander position.
• PII_Wander - Lists the track numbers and carriage positions corresponding to each sequence number in the wander pattern.