Generate Summary Table Data (Aviation)

Available with Aviation Charting license.

Summary

Collects information from related tables in a selected aviation charting database and outputs the resulting information to a table.

Summary tables provide a compilation of information describing all the features of a given type that appear on an aviation chart. For example, they may provide information about all the airports that appear on the front and back of a two-sided chart. This tool gathers attribute information from various tables in the AIS that can be used to generate summary tables for aviation charts. Preferences can be created that determine which attributes are collected, allowing them to generate summary table data for various chart types.

Usage

• Preferences are stored in the AIS_Preferences table. To open the AIS_Preferences table, click the Aviation contextual tab and in Configuration group, click the Preferences button .

  You can also access references from the View tab. In the Windows group, click the Aviation drop-down arrow, and click the Preferences button .

• Chart information must be present in the AIS_Charts table.

• The selected output table must contain ChartID_Txt, Preference_Txt, and PanelID_Txt text fields.

• If you run the Generate Summary Table Data tool on an enterprise database connection, you must refresh the user-generated output table, or close and re-open the table from the table of contents to see the new rows.

Parameters

Dialog

Label	Explanation	Data Type
Target Geodatabase	The Aviation charting schema geodatabase.	Workspace
Input Preferences	The preferences stored in the database that control how, and for which charts, summary table information will be generated.	String
Charts Table	The table containing information specific to each chart processed by the tool according to preferences stored in the database.	Table View

Derived Output

Label	Explanation	Data Type
Output Workspace	The workspace populated with information from related tables in the database, based on preferences.	Workspace

Python

arcpy.aviation.GenerateSummaryTableData(target_geodatabase, in_preferences, in_charts_table)

Name	Explanation	Data Type
target_geodatabase	The Aviation charting schema geodatabase.	Workspace
in_preferences [in_preferences,...]	The preferences stored in the database that control how, and for which charts, summary table information will be generated.	String
in_charts_table	The table containing information specific to each chart processed by the tool according to preferences stored in the database.	Table View

Derived Output

Name	Explanation	Data Type
out_workspace	The workspace populated with information from related tables in the database, based on preferences.	Workspace

Code sample

GenerateSummaryTableData example (stand-alone script)

The following script demonstrates how to use the GenerateSummaryTableData function.

# Import system modules
import arcpy

# Check out Aeronautical extensions
arcpy.CheckOutExtension('Aeronautical')


# Set local variables
target_geodatabase = 'r"C:\data\AIS.gdb'
in_preferences = 'Preferences'
in_charts_table = r'c:\data\AIS.gdb\Charts'

# Call the GenerateSummaryTableData tool
arcpy.aviation.GenerateSummaryTableData(target_geodatabase, in_preferences,\
                                        in_charts_table)

# Check in extensions
arcpy.CheckInExtension('Aeronautical')

Environments

This tool does not use any geoprocessing environments.

Licensing information

• Basic: No
• Standard: Requires ArcGIS Aviation Charting
• Advanced: Requires ArcGIS Aviation Charting