Workflow: Finding missing AIXM features when importing and visualizing data

This topic applies to ArcInfo only.

Finding missing features when importing

When AIXM data is not importing correctly into the AIS database, you can review the log files to see if the data being imported is valid. If you review the log file for the imported data and find that not all features were imported, you can review the warnings associated with the features that did not get imported to see what part of the import process was not complete. You can do this through the Data Interoperability workbench window.

For example, you may have a problem where there are three AD_HP features that are in the source data but only two are being imported into the AIS database. This may occur if one of the AD_HP is not related to an Org_Auth (which is a required relationship—See AICM relations definitions). The images of the log file below show that there are a total of three AD_HP features that are being read but there are two that are being written.

Features Read Summary
Features Written Summary

Below the Features Written Summary are several warnings in the log file. You would need to check if there are warnings related to AD_HP. In this example, there are four warnings that you can look at in the Navigator pane of the Data Interoperability workbench window to see where in the import process the missing feature is not being imported.

Features log file warnings
  1. Start ArcMap or ArcCatalog.
  2. Click the ArcToolbox Window button ArcToolbox Window on the Standard toolbar.

    The ArcToolbox window appears.

  3. Expand the tree view next to Aeronautical Tools > Data Exchange.
  4. Right-click the Import AIXM to AIS tool and click Edit.

    The tool opens in the Data Interoperability workbench window.

  5. Click File > Prompt and Run Translation from the main menu and enter import parameters.
  6. In the Navigator pane, expand the NULL Destination Dataset, then expand Feature Types.

    This shows you all the feature types that show up as warnings in the log file.

    Navigator pane
  7. Select the first warning that was in the log file (Warning - Bad AD_HP_ID Match in AD_HP_USAGE).

    It zooms into the feature type.

    Example of warning 1

    The Feature Merger shows that there are only two features going into the Supplier port, meaning that the missing AD_HP is dropping out before it gets to this point, and you need to look somewhere else.

  8. Select the second warning (Warning - Missing relationship - ADHP and StarSIDAIP).

    It zooms into the feature type.

    Example of warning 2

    The Feature Merger again shows that there are only two AD_HP features, so you will have to look at the third warning.

  9. Select the third warning (Warning - Missing relationship - AD_HP and Org_Auth).

    There are three AD_HP features coming in but only two are making it through the Complete port.

    Example of warning 3

    This is where one of the AD_HP features is not being imported. The warning tells you it is because there is a missing relationship between AD_HP and Org_Auth. To find out why these two features are not being related, you can insert a visualizer to look at the data.

Visualizing AIXM data

Visualizers help determine where data is being imported and how it will look once it is inside the geodatabase. Visualizers also help when trying to troubleshoot if there are missing features or relationships are failing when importing data. Since you know where the feature is failing, you can insert a visualizer to determine the problem.

  1. Right-click the INCOMPLETE port and choose Insert Visualizer.
    AIXM Visualizer
  2. Right-click the visualizer and choose Rename.
  3. Rename the visualizer ADHP_ORGAUTH.
  4. On the Main menu, click Writers > Redirect to Visualizer.

    This ensures that data does not write to the database.

  5. Run the translation using the Run translation button Run translation on the Main toolbar.

    You can also choose File > Prompt and Run Translation from the Main menu to enter or change tool parameters before running the translation.

    Once the import is complete, the FME Universal Viewer window appears. This comes up because the Destination Data was set to Redirect to Visualizer.

  6. In the FME Universal Viewer window, click the X that is next to Dataset: FFS (<name of temporary file>).

    All the features are turned off.

  7. Scroll until you see the name of the visualizer you added (ADHP_ORGAUTH) and turn it on by checking the box next to it.
    FME Universal Viewer
  8. Using your mouse pointer, drag a box over the point that appears in the view.

    The attributes appear on the right pane.

    Attributes for ADHP_ORGAUTH

    The FeatureMerger merges the AD_HP feature with the ORG_AUTH feature.

  9. You need to see why the OrgAuth listed in the AD_HP feature is not matching with the OrgAuth in the OrgAuth table. Common reasons this occurs are
    • OrgAuth indicated in the feature is not present in the OrgAuth table
    • OrgAuth name is misspelled in the OrgAuth table of the related feature
  10. In the Attribute Name list, scroll until you find the ORG_AUTH_ID attribute.

    The OrgAuth name is misspelled. It should be CIVIL AVIATION, not CIVIL AVIATIOM.

    ORG_AUTH_ID attribute for ADHP_ORGAUTH
  11. Change the OrgAuth name to CIVIL AVIATION in the source dataset.

The third AD_HP feature will now import correctly.