|
|
|
Appendix D: Untethered Trailer Tracking System Pilot Automated Data Capture Format
|
|
|
 Print
|
|
|
A tool was developed to collect UTT system data from the host application database. This tool was run on a weekly basis to collect UTT system data from each of the three participating carriers. The table on the following page is representative of the data collected automatically from the NOC showing a sample of the collected data and data descriptions. The actual data was provided in pipe-delimited format for parsing by analysis software. In addition, data was reviewed by QUALCOMM personnel to identify inconsistencies and verify customer participation. All data was archived. | Transaction Type | Date | Time | Time Zone | Vehicle ID | Comm. Unit# | Trailer ID | Trailer Serial No. | Cargo | Door | Macro No. | Macro Version | Event Type | Latitude | Longitude | Proximity | Msg Length | (B)inary/ (T)ext | Message Body |
|---|
| TRAILER EVENT | 12/19/04 | 00:26:46 | GMT | | 0 | XX1810005 | 1.2E+08 | EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 140021 | -0312914 | Crane IN 47522 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/20/04 | 00:26:46 | GMT | | 0 | XX1810005 | 1.2E+08 | EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 140021 | -0312914 | Crane IN 47522 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/21/04 | 00:26:46 | GMT | | 0 | XX1810005 | 1.2E+08 | EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 140024 | -0312914 | Crane IN 47522 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/21/04 | 18:30:21 | GMT | | 0 | XX1810005 | 1.2E+08 | NOT EMPTY | OPEN | 0 | 0 | CARGO LOADED | 139986 | -0312782 | 1 ESE Crane IN 47522 | 0 | B | | | TRAILER EVENT | 12/21/04 | 19:25:39 | GMT | | 0 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | DOOR SENSOR CLOSED | 139986 | -0312781 | 1 ESE Crane IN 47522 | 0 | B | | | TRAILER EVENT | 12/22/04 | 19:00:35 | GMT | | 0 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 140022 | -0312913 | Crane IN 47522 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/23/04 | 19:00:35 | GMT | | 0 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 140022 | -0312916 | Crane IN 47522 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/24/04 | 17:42:13 | GMT | 5885 | 717484 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | OMNI CONNECT (UTT) | 140022 | -0312927 | Crane IN 47522 | 0 | B | | | TRAILER EVENT | 12/24/04 | 19:00:35 | GMT | 5885 | 717484 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 138357 | -0312976 | 2 N Haysville IN 47546 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE | | TRAILER EVENT | 12/25/04 | 19:00:35 | GMT | 5885 | 717484 | XX1810005 | 1.2E+08 | NOT EMPTY | CLOSED | 0 | 0 | STATUS REPORT | 126395 | -0287253 | 3 NNW Ellerbe NC 28338 | 0 | B | GEO-FENCE STATUS: ACTIVE GEO-FENCE TYPE: LANDMARK INSIDE GEO-FENCE: NOT INSIDE |
Previous | Next
|
|
|
|
