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 applicable column names and descriptions to query the RC database for Phase I data.

 

The testing parameter for Phase I is as follows:  Maximum joint opening 15 mils, (15 x 10-3 in).

 

 dbo.Response1

SensorID

Sequential number used for sensor identification

SensorName

Name assigned to the sensor. The first letters identify the sensor type:

 

T = Thermocouple

SG = Surface Strain Gage

LHDT = Potentiometer

CD = Crack Detector

COG = Crack Opening Gage

SensorType

Temperature (ºF), Microstrain (strain x 10-6), Displacement mils (inches x 10-3), Voltage (v)

 

TestSectionID

 

Unique number assigned to identify each of the two test sections.

1= North (North only for Phase I)

Phase I had one overlay.

The name North is used for database consistency of future Phases.

Each sensor for Phase I is located the “North” section.

Display only field mapped to testsectID = 1. Display name = 'North'

CycleNum

The number of the cycle.

ResponseType

(sensor response)

MR = Maximum Response

Only the maximum response of each load cycle was available for Phase I.

ResponseValue

The value associated with the response MR

 


Response Summary Table Data

 

Sensor Name :

Run


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.
  • TestParameters - Contains testing parameters for each phase.
  • TestSection - Contains data on each test section.