Prepare Aviation Data (Aviation)

获得 Aviation Charting 许可后可用。

摘要

Migrates attributes from main aviation data to their cartographic features based on specific JSON scripts. These attributes are used for labeling and symbolizing cartographic features. Attributes defined in the JSON will be copied from their locations in the main feature classes and formatted into output attributes also defined in the JSON.

使用情况

  • Attributes will be migrated to the cartographic features in the format || <> <value> <> || in which features are delimited by || and the attribute values of those features are delimited by <>.

    For example, to migrate the TYPE_CODE, IDENT_TXT, and MAGNETICVARIATION_VAL features from the main ADHP feature class, the output in the ADHP_C cartographic feature class will be <> TYPE_CODE <> IDENT_TXT <> MAGNETICVARIATION_VAL <>.

    注:

    The || symbols may not be included in the migrated information if there is a single feature being migrated from the main features to the cartographic features.

    提示:

    The ArcGIS Aviation Charting product data files contain Arcade scripts for parsing this delimited data. These scripts are in the following location: <installation location>\ArcGIS Aviation Charting\Product Files\<version>\SampleConfigs\ICAO\Enroute\ArcadeExpressions.

  • 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.

    注:

    To run the Prepare Aviation Data tool on an enterprise database, attributed relationships need to be fully qualified in the Prepare Aviation Data tool's JSON. 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.

  • The following sample configuration file can be used to populate the Configuration File (.json) parameter:

    {
        // CAUTION: Remove all comments before using this code sample in your project.
        "adhp_c":[{ // The target feature class that you want to migrate data to.
                "calcfield":"adhp_info", // The field where the migrated data will be stored.
                "fields": [ // The attributes you want to migrate into your target feature class.
                    "adhp.TYPE_CODE",
                    "adhp.IDENT_TXT",
                    "adhp.MAGNETICVARIATION_VAL"
                ],
                "tables": [
                    "adhp" // The main feature class that you want to migrate data from.
                ],
                "where": "Master_ID = adhp.gfid" // An SQL query joining the source and target features.
            },
            {
                "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"
            }
        ]
    }

参数

标注说明数据类型
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
(可选)

The names of the tables and feature classes that will be evaluated.

String

派生输出

标注说明数据类型
Output Workspace

The output aviation workspace containing the evaluation results.

Workspace

arcpy.aviation.PrepareAviationData(target_gdb, config_file, {in_dataset_names})
名称说明数据类型
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,...]
(可选)

The names of the tables and feature classes that will be evaluated.

String

派生输出

名称说明数据类型
out_workspace

The output aviation workspace containing the evaluation results.

Workspace

代码示例

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.aviation.PrepareAviationData(target_gdb, config_file, in_datasets)

arcpy.CheckInExtension("Aeronautical")

环境

此工具不使用任何地理处理环境。

许可信息

  • Basic: 否
  • Standard: 需要 ArcGIS Aviation Charting
  • Advanced: 需要 ArcGIS Aviation Charting

相关主题