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 located at <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 this tool on an enterprise database, attributed relationships must be fully qualified in the 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
Area of Interest Features (可选)	An area of interest (AOI) polygon layer that will be used to spatially filter source features.	Feature Layer

派生输出

标注	说明	数据类型
Output Workspace	The output aviation workspace containing the evaluation results.	Workspace

Python

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

名称	说明	数据类型
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
aoi_features (可选)	An area of interest (AOI) polygon layer that will be used to spatially filter source features.	Feature Layer

派生输出

名称	说明	数据类型
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"

#Input your area of interest features
aoi_features = r"C:\data\MyData.gdb\AOI"

# Running tool
arcpy.aviation.PrepareAviationData(target_gdb, config_file, in_datasets, aoi_features)

arcpy.CheckInExtension("Aeronautical")

环境

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

许可信息

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