Motor/Urban Transportation Database Conversion Service

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.

What we’ll send you

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 results file will contain the original data with results for each record. The transportation tax type will be listed if found.
To make it easier for you to identify addresses that could not be found, an error file will be created that contains only those records where a transportation tax type could not be found. An explanation of why will be included.

The links and files will remain available until the last day of the current quarter.

File Format Requirements

File must be in a XLSX (Office 2007 or newer), comma or tab delimited text format.
Two locations per record - Origin and destination
Do not include column headers containing field names in the file.
All records must have the same number of fields.
Only the following fields will be accepted in the following order:

Field Name	Description	Format	Length
Field Name Record No or Customer Name	Description Field used to correlate the results back to your database.	Format alpha/numeric	Length n/a
Field Name Origin Latitude	Description Latitude Coordinate	Format numeric	Length n/a
Field Name Origin Longitude	Description Longitude Coordinate	Format numeric	Length n/a
Field Name Origin Address	Description Number, street name, direction (Suite, Apt., Lot are not required)	Format alpha/numeric	Length n/a
Field Name Origin City	Description Name of city	Format alpha	Length n/a
Field Name Origin Zip Code and +4	Description 5, 9, or 10 digits (i.c. 98513, 98513-2452, 985132452)	Format numeric/character	Length 10
Field Name Destination Latitude	Description Latitude Coordinate	Format numeric	Length n/a
Field Name Destination Longitude	Description Longitude Coordinate	Format numeric	Length n/a
Field Name Destination Address	Description Number, street name, direction (Suite, Apt., Lot are not required)	Format alpha/numeric	Length n/a
Field Name Destination City	Description Name of city	Format alpha	Length n/a
Field Name Destination Zip Code and +4	Description 5, 9, or 10 digits (i.c. 98513, 98513-2452, 985132452)	Format numeric/character	Length 10
Field Name Cost	Description Cost Tracking Field	Format numeric	Length 10

Examples of acceptable file formats:

Tab-delimited file
Comma-delimited file
XLSX file
XLSX template download file (XLT)

How to save your database in the correct format before submitting

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