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.
SensorType Gives information on the sensor type, including sensor units.
GageType Gage type, corresponding to the first letters of the SensorName field.
TestItemID The test item where the sensor was located. Refer to the test area diagram.
LocationX_ft Sensor location x coordinate (feet). Refer to the test area diagram.
LocationY_ft Sensor location y coordinate (feet). Refer to the test area diagram.
LocationZ_in Sensor location z coordinate (inches). Refer to the test area diagram.
CalibrationFactor1 Calibration factor 1 (for software data processing).
CalibrationFactor2 Calibration factor 2 (for hardware data processing).
CalibrationFactor3 Not used in CC6.
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.
ChannelStatus Binary value. 1 = channel working, 0 = stop collection.
SCPType Signal Conditioning Plug-On (SCP) types. Use 8 for EGs, 2 for other gages.
Direction Describes the installed orientation of strain gages relative to the traffic (transverse or longitudinal).
Comment May include specific information about a sensor, including dates for which sensor data are available in the database.

 


Query SPU Data

Sensor IDSensor NameSensor TypeGage TypeTest Item IDLocation X ftLocation Y ftLocation Z inCalibration Factor 1Calibration Factor 2Calibration Factor 3SPU NoCardChannelChannel StatusSCP TypeDirectionComment
63100VD-1POTENTIOMETER, MilsVertical DisplacementMRS1_north329.50-15.5012.001.0023.001.003.001.000.001.002.00NULLSensor not responding
63101VD-2POTENTIOMETER, MilsVertical DisplacementMRS1_north330.50-15.5012.001.0023.001.003.001.001.001.002.00NULLSensor not responding
63102VD-3POTENTIOMETER, MilsVertical DisplacementMRS1_north344.50-15.5012.001.0023.001.003.001.002.001.002.00NULLSensor not responding
63103VD-4POTENTIOMETER, MilsVertical DisplacementMRS1_south344.5015.5012.001.0023.001.003.001.003.001.002.00NULLData available from 8/30/2011 to 12/20/2011
63104VD-5POTENTIOMETER, MilsVertical DisplacementMRS1_north345.50-15.5012.001.0023.001.003.001.004.001.002.00NULLData available from 8/30/2011 to 12/20/2011
63105VD-6POTENTIOMETER, MilsVertical DisplacementMRS1_south345.5015.5012.001.0023.001.003.001.005.001.002.00NULLData available from 8/30/2011 to 12/15/2011
63106VD-7POTENTIOMETER, MilsVertical DisplacementMRS1_north404.50-15.5012.001.0023.001.003.001.006.001.002.00NULLData available from 8/30/2011 to 12/20/2011
63107VD-8POTENTIOMETER, MilsVertical DisplacementMRS1_south404.5015.5012.001.0023.001.003.001.007.001.002.00NULLSensor not responding
63108VD-9POTENTIOMETER, MilsVertical DisplacementMRS2_north405.50-15.5012.001.0023.001.003.001.008.001.002.00NULLData available from 8/30/2011 to 4/25/2012
63109VD-10POTENTIOMETER, MilsVertical DisplacementMRS2_south405.5015.5012.001.0023.001.003.001.009.001.002.00NULLData available from 8/30/2011 to 10/6/2011
1 2 3 4 5 6 7 8 9 10 ...