Prepare Aviation Data (Aviation)

Available with Aviation Charting license.

Summary

Evaluates aviation data based on organizationally specific JSON scripts, returning values necessary for cartographic labeling and symbolization. Returned values are stored in a single attribute of your features.

Usage

• The optional Input Datasets parameter is populated by a list of tables and feature classes from the provided JSON. You can select specific tables and features classes for evaluation. If none are selected, they will all be evaluated.

  Note:

  Relationship class field names from enterprise geodatabases must be qualified with their schema and table names in the JSON config file. For example, GIS.NavaidAssociation.NAVAIDSYSTEM_ID includes the schema name GIS, the table name NavaidAssociation, and the field name NAVAIDSYSTEM_ID. Field names from other dataset types can also be qualified with their schema name, but it is only necessary to qualify them by table name, for example, NavaidSystem.GFID.

Parameters

Dialog

Label	Explanation	Data Type
Target Geodatabase	The ArcGIS Aviation Charting schema workspace on which the evaluation will be run.	Workspace
Configuration File (.json)	The JSON file containing the evaluation criteria.	File
Input Datasets (Optional)	The names of the tables and feature classes to be evaluated.	String

Derived Output

Label	Explanation	Data Type
Output Workspace	The output aviation workspace containing the evaluation results.	Workspace

Python

arcpy.aviation.PrepareAviationData(target_gdb, config_file, {in_dataset_names})

Name	Explanation	Data Type
target_gdb	The ArcGIS Aviation Charting schema workspace on which the evaluation will be run.	Workspace
config_file	The JSON file containing the evaluation criteria.	File
in_dataset_names [in_dataset_names,...] (Optional)	The names of the tables and feature classes to be evaluated.	String

Derived Output

Name	Explanation	Data Type
out_workspace	The output aviation workspace containing the evaluation results.	Workspace

Code sample

PrepareAviationData example (stand-alone script)

The following Python window script demonstrates how to use the PrepareAviationData function.

import arcpy

# set gp environment
arcpy.CheckOutExtension("Aeronautical")

# Input database where data 
target_gdb = r"C:\data\MyData.gdb"

# config file for data calculation
config_file = r"C:\data\config.json"

# subset of tables or feature classes that will be calculated
in_datasets = "adhp;navaidsystem"

# Running tool
arcpy.PrepareAviationData_aviation(target_gdb, config_file, in_datasets)

arcpy.CheckInExtension("Aeronautical")

Sample config file for the Input Datasets parameter

The following sample config file can be used to populate the in_datasets_names parameter.

{
    "adhp_c":[{
            "calcfield":"adhp_info",
            "fields": [
                "adhp.TYPE_CODE",
                "adhp.IDENT_TXT",
                "adhp.MAGNETICVARIATION_VAL"
            ],
            "tables": [
                "adhp"
            ],
            "where": "Master_ID = adhp.gfid"
        },
        {
            "calcfield":"airspace_lbl",
            "fields": [
                "airspace.class_code",
                "airspace.workhr_code"
            ],
            "tables": [
                "adhp",
                "airspace"
            ],
            "where": "Master_ID = adhp.gfid and adhp.gfid = airspace.adhp_id and airspace.class_code IN ('C', 'D')"
        }],
    "navaidsystem": [
        {
            "calcfield":"availability_lbl",
            "fields": [
                "availability.operationstatus_code"
            ],
            "tables": [
                "navaidsystem",
                "availability"
            ],
            "where": "navaidsystem.gfid = availability.predicated_id"
        },
        {
            "calcfield":"navaidcomponent_lbl",
            "fields": [
                "navaidcomponent.subtype_code",
                "navaidcomponent.slavedvariation_val",
                "navaidcomponent.channel_txt",
                "navaidcomponent.frequency_val",
                "navaidcomponent.status_code",
                "navaidcomponent.workhr_code",
                "navaidcomponent.voice_code"
            ],
            "tables": [
                "navaidsystem",
                "navaidassociation",
                "navaidcomponent"
            ],
            "where": "navaidsystem.gfid = navaidassociation.navaidsystem_id and navaidassociation.navaidcomponent_id = navaidcomponent.gfid"
        }
    ]
}

Environments

This tool does not use any geoprocessing environments.

Licensing information

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