Search

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

DB SPU

/ / / / /

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

SPU_ID	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.
LocationXFT	Sensor location x coordinate (feet). Refer to the test area diagram.
LocationYFT	Sensor location y coordinate (feet). Refer to the test area diagram.
LocationZFT	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 ID	Sensor Name	Sensor Type	Gage Type	Test Item ID	Location X ft	Location Y ft	Location Z in	Calibration Factor 1	Calibration Factor 2	Calibration Factor 3	SPU No	Card	Channel	Channel Status	SCP Type	Direction	Comment
63100	VD-1	POTENTIOMETER, Mils	Vertical Displacement	MRS1_north	329.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	0.00	1.00	2.00	NULL	Sensor not responding
63101	VD-2	POTENTIOMETER, Mils	Vertical Displacement	MRS1_north	330.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	1.00	1.00	2.00	NULL	Sensor not responding
63102	VD-3	POTENTIOMETER, Mils	Vertical Displacement	MRS1_north	344.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	2.00	1.00	2.00	NULL	Sensor not responding
63103	VD-4	POTENTIOMETER, Mils	Vertical Displacement	MRS1_south	344.50	15.50	12.00	1.00	23.00	1.00	3.00	1.00	3.00	1.00	2.00	NULL	Data available from 8/30/2011 to 12/20/2011
63104	VD-5	POTENTIOMETER, Mils	Vertical Displacement	MRS1_north	345.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	4.00	1.00	2.00	NULL	Data available from 8/30/2011 to 12/20/2011
63105	VD-6	POTENTIOMETER, Mils	Vertical Displacement	MRS1_south	345.50	15.50	12.00	1.00	23.00	1.00	3.00	1.00	5.00	1.00	2.00	NULL	Data available from 8/30/2011 to 12/15/2011
63106	VD-7	POTENTIOMETER, Mils	Vertical Displacement	MRS1_north	404.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	6.00	1.00	2.00	NULL	Data available from 8/30/2011 to 12/20/2011
63107	VD-8	POTENTIOMETER, Mils	Vertical Displacement	MRS1_south	404.50	15.50	12.00	1.00	23.00	1.00	3.00	1.00	7.00	1.00	2.00	NULL	Sensor not responding
63108	VD-9	POTENTIOMETER, Mils	Vertical Displacement	MRS2_north	405.50	-15.50	12.00	1.00	23.00	1.00	3.00	1.00	8.00	1.00	2.00	NULL	Data available from 8/30/2011 to 4/25/2012
63109	VD-10	POTENTIOMETER, Mils	Vertical Displacement	MRS2_south	405.50	15.50	12.00	1.00	23.00	1.00	3.00	1.00	9.00	1.00	2.00	NULL	Data available from 8/30/2011 to 10/6/2011
1 2 3 4 5 6 7 8 9 10 ...

Export to Excel