SPU Table

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

 

SensorID Sequential number used for sensor identification
SensorName Name assigned to the sensor. The first letters identify the sensor type: VD = vertical displacement; EG = embedded (strain) gage.
TestItemID The test item where the sensor was located.
Location_X Sensor location x coordinate.
Location_Y Sensor location y coordinate.
Location_Z Sensor location z coordinate.
SPUNo Number of the signal processing unit (SPU) used to acquire dynamic data from SensorName. SPUs are numbered 1 – 6.
Card Data acquisition card within the SPU used to acquire data from SensorName. There are two acquisition cards in each SPU.
Channel Channel number on the data acquisition card corresponding to SensorName for dynamic data acquisition. There are 64 channels in each card.
Cal_2
Status Binary value. 1 = channel working, 0 = stop collection.
SensorType Gives information on the sensor type, including sensor units.
Comment May include specific information about a sensor, including dates for which sensor data are available in the database.

 


Query SPU Table

 

Sensor IDSensor NameTest ItemLocation XLocationYLocation ZSPUCardChannelCal 2StatusSensor TypeComment
1ASG-9LFC-115-150.42110596.81Asphalt Straintransverse
2ASG-10LFC-117.375-150.42111598.91Asphalt Strainlongitudinal
3ASG-11LFC-119.75-150.42112554.81Asphalt Strainlongitudinal
4ASG-12LFC-122.125-150.42113607.21Asphalt Strainlongitudinal
5ASG-8LFC-115-12.750.42114572.81Asphalt Straintransverse
6ASG-7LFC-115-10.50.42115611.21Asphalt Straintransverse
7ASG-6LFC-11519.50.42116576.11Asphalt Straintransverse
8ASG-5LFC-11517.250.42117603.21Asphalt Straintransverse
9ASG-1LFC-115150.42118590.31Asphalt Straintransverse
10ASG-2LFC-117.375150.42119638.81Asphalt Strainlongitudinal
1 2 3 4 5 6 7 8 9 10 ...