Ultra One2OneMileage Walkthrough
This walkthrough shows you how to create process arbitrary point-to-point routes listed in a database using Ultra One2OneMileage. It is aimed at people who are new to the Ultra Mileage system. We also have a walkthrough for Ultra MileCharter.
There is a screenshot for each step of the walkthrough. Click on the small thumbnail on the right to open a new window with a full size version of the screenshot.
The following example uses the USA Contiguous; Fastest road pack and the one2one_samples.accdb database from Ultra Mileage Examples File. Other road packs will work in the same manner, but you will need to substitute different input data. The routes table in the one2one_samples.accdb input database will produce a list of calculated route distances and travel times between a series of longitude,latitude coordinates.
If you have not yet downloaded the USA Contiguous; Fastest road pack, then instructions on how to use the Ultra Download Manager can be found at the beginning of the Ultra MileCharter Walkthrough.
The Input Data
The sample database includes a number of tables. We will only use the routes table. This specifies a list of routes with start and end locations defined using longitude,latitude decimal coordinates. The image shows the Design View for the Microsoft Access table.
This has columns defining the source and destination coordinates, and four columns (distance, time, cost, and error) to receive the results. The error field is strongly recommended because this can be used to diagnose problems such as bad source/destination locations. The error field must be text, but the other result fields can be floating point (recommended) or text. You also need a primary key to be set. This can be an integer or a text field. All primary key values must be unique, and the field should have an index. Here, we have called the primary key ID.
Setting the Ultra One2OneMileage Parameters
Start Ultra One2OneMileage. The parameters may be different, but you will be presented by a dialog box that looks like this.
Press the "..." button in the Road Data box to select the Contiguous USA Fastest road pack (downloaded using the Download Manager).
Next press the Database Change button to display the Database Parameters dialog box. Set the database Type to Access 2007 onwards (accdb). Press the Data Source "..." button to select the Access ACCDB file that will be the data source. One2OneMileage will load this and scan it for the available tables.
Select the routes table from the list of available tables. This table contains our required routes and will store the results. One2OneMileage will scan the table and fill the remaining controls with the possible column options. Select the Locations are as Coordinates and press the Set Input Columns button to display the Input Locations dialog box. Set this to look like the image to the right.
This sets the primary key and the data fields that store the input coordinates.
Press OK to return the Database Parameters dialog box, and then select the required output columns. You must set at least one of the output columns, otherwise One2OneMileage will not have any work to process.
The resulting Database Parameters dialog box will look like the image to the right.
Press OK to return to the main dialog box.
Select the required routing parameters. Note that some of these options might be disabled if they are not required for your selected data. For example, the time units are not required if you have not selected route times. For this example we set the Distance Units to be Miles and the Time Units to Minutes. We also select Fastest Routes in the Find box.
Press the Rate Table Costs button to display the Costs and Rate Tables dialog box.
You can use this to define a rate table that applies a different cost according to the route distance. Here we simply apply a Constant Rate of 0.50 per mile.
Press OK to return to the main dialog box, which should now look like the image on the right.
Press Start to start processing. This is a very short database and should not take long to compute.
The resulting Routes table is shown on the right.
The exact numbers may vary according to the parameters that you have selected or the road pack version. The Cost field was created as a Currency type - hence the dollar signs.
Note that all rows were computed okay. One2OneMileage will add error notes in the Errors field if there were problems finding a location or calculating a route.
Congratulations! You have calculated your first routes with Ultra One2OneMileage!