If the mode of linking features being created with records of tables linked with geocoded feature type was set at the second step of geocoding wizard (the box With other tables was checked), one of next steps of geocoding setting will be setting a scheme of links (figure 77-4).
Figure 77-4. Geocoding wizard, page “Setting scheme of links”
A scheme of links defines associations between fields of control table with one or several fields of the linked table. The geocoded table itself or one of the tables linked with searching feature type can be chosen as the control table. For geocoding by coordinates searching feature type is not used, that is why geocoded table is always used as the control table. The view of the wizard page in this case slightly differs: control table is not mentioned.
For every feature of geocoding type being created the record of the control table belonging to it is determined. In case of using geocoded table as the control one – it is the record by which this feature is created. If the table linked with searching type is used, the record linked with searching type feature which is used for locating the geocoded feature is chosen.
The record of the linked table will be linked with the feature being created only in the case if values of all the fields of the linked table included into the scheme of links are equal to the values of record fields of the control table associated with them. Every pair of fields being associated should belong to one and the same data type.
The possibility of linking the feature being created with several records of one and the same linked table is not excluded. It will occur if firstly coincidence of field values takes place for several records of the linked table and secondly if the link between feature type and the table is multiple. In case of unique character of the link the first found record will be linked with the feature.
It should be emphasized that adding of new records to some table is never performed in the course of geocoding. Features being created can be linked only with existing table records.
To add an element into the scheme of links the following actions should be performed:
Select the table with records of which linking will be performed in the drop-down list in the field Linked table.
If geocoding by features or by address is performed then select the table in the drop-down list in the field Control table.
Select fields specifying correspondence of records of the linked table with records of geocoded table in drop-down lists Field of linked table and Field of control table (or Field of geocoded table).
Push the button Add. The system checks that there were no two identical link elements in the list, otherwise a message “Duplicated elements” is displayed.
To correct the scheme of links buttons: Change, Remove and Remove all can be used. To change the link element the user should select this element, change values in the fields Linked table, Control table, Field of linked table and Field of control table (or Field of geocoded table) and then push the button Change. The button Remove removes the link element selected in the list and Remove All – clears the scheme of links.
Next pages of geocoding wizard mainly depend on selected geocoding method and will be described in detail in the corresponding subsections.