MUX Table

Contains information about the static sensors, including sensor type and location. (MUX refers to the multiplexer units, which acquire the static sensor data.)

 

SensorID Sequential number used for sensor identification
SensorName Name assigned to the sensor.
Sensortype Gives information on the sensor type.
MUX Number assigned to the multiplexer used to acquire static data from SensorName.
TestItemID The test item where the sensor was located.
Item
Channel The channel number within the multiplexer (MUX) where data acquired from SensorName were stored.
X_FT
X_IN
X_FRACT
LOCATION_X Sensor location x coordinate.
Y_FT
Y_IN
Y_FRACT
LOCATION_Y Sensor location y coordinate.
Z_FT
Z_IN
Z_FRACT Sensor location y coordinate.
LOCATION_Z Sensor location z coordinate.
Comment May include specific information about a sensor, including dates for which sensor data are available in the database.
Modified Date the data was last updated/modified.

 


MUX Data Query

SensorIDSensorNamesensortypeMuxTestItemIDItemChannelX_FTX_INX_FRACTLOCATION_XY_FTY_INY_FRACTLOCATION_YZ_FTZ_INZ_FRACTLOCATION_ZCommentsModified
1LRTMoisture1LRS-1MG11A50  5033  0 28128.5location from CL 4/1/002/4/2000 2:50:00 PM
2N/A 1N/AN/A1B             2/4/2000 2:50:00 PM
3LSTMoisture1LFS-1MG22A163  162.550  -17 40 40location from CL 4/1/002/4/2000 2:50:00 PM
4N/A 1N/AN/A2B             2/4/2000 2:50:00 PM
5LR1Resistance1LRS-1RG13A40  4053  -20 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
6LR2Resistance1LRS-1RG23B60  6053  -20 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
7LR3Resistance1LRS-1RG34A30  3043  -10 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
8LR4Resistance1LRS-1RG44B50  5043  -10 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
9LR5Resistance1LRS-1RG55A70  7043  -10 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
10LR6Resistance1LRS-1RG65B20  2033  0 14 14location from CL 4/1/00, Disconnected since Nov-05-012/4/2000 2:50:00 PM
1 2 3 4 5 6 7 8 9 10 ...