This free service allows businesses to submit their motor and urban transportation database and receive the correct transportation type. Follow the instructions below to send us your motor and urban transportation database.
The results should be available within two business days. You will receive an email when the results are ready. The following files will be returned:
The links and files will remain available until the last day of the current quarter.
Field Name | Description | Format | Length |
---|---|---|---|
Record No or Customer Name | Field used to correlate the results back to your database. | alpha/numeric | n/a |
Origin Latitude | Latitude Coordinate | numeric | n/a |
Origin Longitude | Longitude Coordinate | numeric | n/a |
Origin Address | Number, street name, direction (Suite, Apt., Lot are not required) | alpha/numeric | n/a |
Origin City | Name of city | alpha | n/a |
Origin Zip Code and +4 | 5, 9, or 10 digits (i.c. 98513, 98513-2452, 985132452) | numeric/character | 10 |
Destination Latitude | Latitude Coordinate | numeric | n/a |
Destination Longitude | Longitude Coordinate | numeric | n/a |
Destination Address | Number, street name, direction (Suite, Apt., Lot are not required) | alpha/numeric | n/a |
Destination City | Name of city | alpha | n/a |
Destination Zip Code and +4 | 5, 9, or 10 digits (i.c. 98513, 98513-2452, 985132452) | numeric/character | 10 |
Cost | Cost Tracking Field | numeric | 10 |
Tab-delimited file
Comma-delimited file
XLSX file
XLSX template download file (XLT)
Comma delimited:
- Click FILE
- Choose SAVE AS
- In the SAVE AS TYPE drop-down box, select CSV (*.csv)
- Click the SAVE button
Tab delimited:
- Click FILE
- Choose SAVE AS
- In the SAVE AS TYPE drop-down box, select Text (*.txt)
- Click the SAVE button
Results file
Error file
Contact David Wright at (360) 596-3650, Monday - Friday 9:00 a.m. - 4:00 p.m. PST.