Airport Technology Research Home About ATR News Airport Technology Research Plan Contact Us Careers

Search Reflective Cracking Phase 2 Database

/ / / /

Response Summary View

Contains information summarizing the results of the Reflective Cracking Phase testing cycles, including Sensor id, sensor name, sensor type, test section id, cycle number, response, response value, and response time. Below are the column names and descriptions to query the RC database for Phase II.

The testing parameters for Phase II are as follows: Target temperature at overlay bottom 32 ºF, maximum joint opening 12 mils, (12 x 10^-3 in), cycle time 150 seconds and rest period 600 seconds.

dbo.Response2
SensorID	Sequential number used for sensor identification.
SensorName	Name assigned to the sensor. The first letters identify the sensor type: EG = Embedded Strain Gage JDG = Joint Displacement Gage LVDT = Linear Variable Differential Transducer SG = Surface Strain Gage T = Thermocouple
SensorType	Temperature (ºF), Microstrain (strain x 10^-6), Displacement mils (inches x 10^-3), Force (lbs)
TestSectionID	Unique number assigned to identify each of the two test sections. 1 = North and 2 = South
CycleNum	The number of the cycle.
ResponseType (sensor response) Refer to "Sample Strain Gage Response" image below	OL = offset left (first reading) MRL = Minimum Response Left MR = Maximum Response MRR = Minimum Response Right OR = Offset Right
ResponseValue	The value associated with the response.
ResponseTime	The time associated with the response.
TestParameterID	Unique id associated with the specific testing parameters for the corresponding phase.

Sample Strain Gage Response

Sensor Name :

Test Section :

Response :

Run

Sensor Table

SensorID	Column1	SensorName	SensorType	Unit	LocationX_IN	LocationY_IN	LocationZ_IN
1	South	EG3	Embedded Strain Gage	E-6	66.00	0.00	3.00
2	South	EG4	Embedded Strain Gage	E-6	66.00	0.00	0.50
3	North	EG6	Embedded Strain Gage	E-6	-12.00	0.00	3.00
4	North	EG7	Embedded Strain Gage	E-6	-66.00	0.00	3.00
5	North	EG8	Embedded Strain Gage	E-6	-66.00	0.00	0.50
6	North	EG9	Embedded Strain Gage	E-6	-62.00	0.00	0.50
7	South	EG11	Embedded Strain Gage	E-6	16.00	0.00	0.50
8	South	EG12	Embedded Strain Gage	E-6	62.00	0.00	0.50
9	South	JDG1	Displacement	mil	73.50	0.00	0.00
10	North	JDG2	Displacement	mil	-73.50	0.00	0.00
11	North	JDG3	Displacement	mil	-4.50	0.00	0.00
12	South	JDG4	Displacement	mil	4.50	0.00	0.00
13	North	LVDT-07	Displacement	mil	-84.00	156.00	-2.00
14	North	LVDT-08	Displacement	mil	-84.00	-156.00	-2.00
15	South	LVDT-09	Displacement	mil	84.00	-156.00	-2.00
16	South	LVDT-10	Displacement	mil	84.00	156.00	-2.00
17	South	SG1	Surface Strain Gage	E-6	6.00	0.00	2.50
18	South	SG2	Surface Strain Gage	E-6	6.00	0.00	5.00
19	South	SG3	Surface Strain Gage	E-6	18.00	0.00	5.00
20	South	SG4	Surface Strain Gage	E-6	30.00	0.00	5.00
1 2 3

Export to Excel

Custom SQL Query

Advanced users can query the Reflective Cracking database using Structured Query Language (SQL). The following resource is provided to help you better understand how to use SQL to query Reflective Cracking Data.

* Only read-only (select) queries are permitted. *

Sample Queries for Reflective Cracking database

SQL Query Dynamic Data

Enter SQL statement:

Submit

Export to Excel

Table Map

The database is organized into 7 tables as shown in the figure below. Key fields in each table are unique identifiers and are indicated by a key symbol. Lines represent links between tables.

Table Descriptions

Cycle - Contains data on the cycle number date and time.
Phase - Contains information about the phase name and ID.
Response - Contains response values from the sensors.
ResponseType - Contains name and ID of each response.
Sensor - Contains information about the sensors, including sensor type and location.
TestParameter - Contains testing parameters for each phase.
TestSection - Contains data on each test section.