Storing coordinates in a geocoding database

You can use a geocoding database to store coordinate data that map to address data in your database. The geocoding database can be stored either in an iBase instance, or Microsoft Access. This enables you to plot entities and links without having to manually define coordinates in your database.

Procedure

To specify a geocoding database:
  1. In the DB path\name box specify the database that contains the geocode data or browse for it. The geocoding database must be either an iBase database or a Microsoft Access database.
  2. From the Table name drop-down list, select the name of the database table that contains the geocode data.
  3. From the X drop-down list, select the field in the geocoding table containing the x coordinates to be copied to the corresponding field for matching entities and links.
  4. From the Y drop-down list, select the field in the geocoding table containing the y coordinates to be copied to the corresponding field for matching entities and links
  5. Specify fields to accurately locate an entity or link. Typically two fields are required for this. If necessary, fields 3, 4, and 5 can be used to select other geocoding table fields to match with entity or link fields:
    1. From the Field 1 drop-down list, select the first field to be used to match the entity or link field to the corresponding field in the geocoding table.
    2. From the Field 2 drop-down list, select the second field to be used to match the entity or link field to the corresponding field in the geocoding table.