Show/Hide Toolbars

Ultra Mileage

Navigation: Ultra Geocoder

Setting the Database Parameters

Scroll Prev Top Next More

The database parameters work in virtually the same way as Ultra One2OneMileage's Database Parameters. The input database has columns specifying the full or partial address data, and has columns which receive the geocoding results. The database can be in Microsoft Excel, Microsoft Access (64 bit only), SQL Server, or an ODBC-capable database. As with One2OneMileage, Microsoft Excel is not recommended due to data field formatting ambiguities.

 

The Database Parameters dialog box looks like this:

 

geocode_dbparam_access

 

Select the data source type and data source. See Ultra One2OneMileage's Database Parameters page for more details, as these are identical. You can enter a ODBC username/password if required.

 

Once the database has been opened, the Table drop-down list will be populated with available table names. Select the required table.

 

Next select the input columns for the components of the input data. Most of these fields have a '<none>' option. These can be used to provide a partial address. For example, if you were only geocoding zipcodes, you would specify the Postcode and Country, and set the remaining fields to '<none>'.

 

A country must be set. You can specify the country using a data field, or by setting a fixed country for all of the data. Set a fixed country by checking the Override Country checkbox, and then press the Change button to select thet country. The country will be displayed on the above dialog box using its ISO 2 character code.

 

You must also specify three output columns. Longitude and Latitude receive the geocoded geographic coordinate, and should be floating point data fields. Ideally they should be double precision. The Status field is a text field that stores a short message detailing the geocoding result quality. Example values include 'Okay', 'Not Found', and 'Ambiguous'.

 

Row Selection is used to select a subset of the data rows for geocoding. The default is for the Select option to be set to all rows. This tells Ultra Geocoder to geocode all rows in the database, irrespective of the status value.

 

The other two options (rows marked as, and rows not marked as) will enable the drop-down box to the right. These options allow you to select data rows which have an status value that is equal or not equal to a specific value. I.e. rows that are "marked" with this value. The drop down box will change to include appropriate options. A custom text value can also be typed into this box.

 

The special value "<empty>" is interpreted as representing an empty (null length) data field.

 

An example of how the row selection functionality could be used, would be in the use of two geocoders. A second geocoder could be used to only geocode rows that the first geocoder failed to geocode.