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

Sample Strain Gage Response

 

Sensor Name :

Test Section :

Response :

Run


Sensor Table

 

SensorIDColumn1SensorNameSensorTypeUnitLocationX_INLocationY_INLocationZ_IN
1SouthEG3Embedded Strain GageE-666.000.003.00
2SouthEG4Embedded Strain GageE-666.000.000.50
3NorthEG6Embedded Strain GageE-6-12.000.003.00
4NorthEG7Embedded Strain GageE-6-66.000.003.00
5NorthEG8Embedded Strain GageE-6-66.000.000.50
6NorthEG9Embedded Strain GageE-6-62.000.000.50
7SouthEG11Embedded Strain GageE-616.000.000.50
8SouthEG12Embedded Strain GageE-662.000.000.50
9SouthJDG1Displacementmil73.500.000.00
10NorthJDG2Displacementmil-73.500.000.00
11NorthJDG3Displacementmil-4.500.000.00
12SouthJDG4Displacementmil4.500.000.00
13NorthLVDT-07Displacementmil-84.00156.00-2.00
14NorthLVDT-08Displacementmil-84.00-156.00-2.00
15SouthLVDT-09Displacementmil84.00-156.00-2.00
16SouthLVDT-10Displacementmil84.00156.00-2.00
17SouthSG1Surface Strain GageE-66.000.002.50
18SouthSG2Surface Strain GageE-66.000.005.00
19SouthSG3Surface Strain GageE-618.000.005.00
20SouthSG4Surface Strain GageE-630.000.005.00
1 2 3


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. *




SQL Query Dynamic Data
Enter SQL statement:
Submit


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.