Edit Spatial Layer-- Fields and controls

Use this window to change geocoding properties for the selected layer. You cannot change any other properties of the spatial layer.

Layer column

Column type

Spatial reference name

Available columns

>, >>, <, <<

Selected columns

Enable automatic geocoder

Name

Precision level

Properties

OK

Cancel

Layer column

This box displays the name of the spatial data column for this spatial layer. You cannot change this field.

Column type

This box displays the spatial data type for the spatial data column in the Layer column field. You cannot change this field.

Spatial reference name

This box displays the spatial reference system for this spatial layer. You cannot change this field.

Available columns

This box lists all of the non-spatial columns defined for the source table for this spatial layer that are not already used as input to a geocoder. Use this box to select additional column or columns that you want to use as input to a geocoder and then click the > push button. You can select one or more columns at the same time.

You can define up to 10 columns to be used as input to a geocoder. The order in which you select the columns is not important.

>, >>, <, <<

Use these push buttons to change the list of columns displayed in the Available columns and Selected columns boxes. You can use:

>

To move the selected columns in the Available columns box to the Selected columns box.

>>

To move all columns displayed in the Available columns box to the Selected columns box.

<

To move the selected columns in the Selected columns box to the Available columns box.

<<

To move all columns displayed in the Selected columns box to the Available columns box.

Selected columns

This box lists all of the columns that are selected to be used as input to a geocoder. These source columns define the source data to be passed to the geocoder. The data can contain free-form text information. The order of these columns is not important.

Enable automatic geocoder

Use this box to specify whether automatic geocoding is enabled. Automatic geocoding ensures the consistency between the non-spatial data (for example, an address) and spatial data (for example, a location) by invoking triggers to populate the spatial data column whenever the source data for the selected columns is changed (inserted, deleted, or updated).

Name

Use this box to specify the name of the geocoder to be run for automatic geocoding. This box is only available when the Enable automatic geocoder check box is selected. The default value is the name of the geocoder that is shipped with the DB2 Universal Database Spatial Extender.

Use one of these methods:

• Select the name of a registered geocoder from the list.
• Type the name of a registered geocoder in the box.

Precision level

Use this box to specify the precision of the geocoding process. This box is available only when the Enable automatic geocoder check box is selected.

The range of the precision is from 1 (least precise; for example, city level) to 100 (most precise; for example the house number that is identical to the matched record in the reference data). The default value is the value that is the default for the geocoder that you selected.

Use one of these methods to change the precision:

• Select the up or down arrows to spin through the available choices.

• Type in a value.

Properties

Use this box to provide any vendor-specific switches to control the geocoder. This box is available only when the Enable automatic geocoder check box is selected. The default switches are those that are defaults for the selected geocoder.