Import AIXM 4.5 To AIS (Aviation Data Management)
Summary
Imports Aeronautical Information Exchange Model (AIXM) data into an Aeronautical Information System (AIS) geodatabase. This tool decodes the rules and relationships defined in an AIXM 4.5 XML message and re-creates them in the AIS data model. AIXM messages are XML documents that conform to the AIXM XML schema.
Usage
You can customize this tool. Right-click the tool in the ArcToolbox window and click Edit. The tool will open in the Data Interoperability Workbench.
This tool uses the Attribute Schema Mapper parameter to map AIXM elements to AIS attributes. Attribute Schema Mapper is a path to a .csv file that lists attribute mappings between the data models. You can use .csv files provided with the ArcGIS for Aviation: Charting. These files are installed in the AviationCharting\Desktop10.2\DataExchange\AIXM\SchemaMapper folder.
You can use the Subtype Schema Mapper parameter to map AICM features to subtypes in geodatabase feature classes. Subtype Schema Mapper is a path to a .csv file that lists the feature to subtype mapping. You can use example .csv files installed in the AviationCharting\Desktop10.2\DataExchange\AIXM\SchemaMapper folder.
This tool requires an ArcSDE geodatabase with the AIS schema. Use this geodatabase name in the Destination Enterprise Geodatabase parameter. This is the name of the geodatabase where the tool will create data.
All feature classes in the Destination Enterprise Geodatabase must be registered as versioned. The tool starts an edit session and writes into the geodatabase.
This tool is memory intensive. Contact Esri If you experience difficulties importing large files (200 MB or more) using the ArcGIS Data Interoperability extension.
Syntax
| Parameter | Explanation | Data Type |
SrcDataset_AIXM |
The AIXM-XML data. | File |
AttributeSchemaMapper |
The path to the .csv file that contains the AIXM element to AIS attribute schema mapping rules. You can use the AIXMtoESRI_Attribute.csv located in the ArcGIS for Aviation installation directory. | File |
SubtypeSchemaMapper |
The path to the .csv that contains the AICM feature to AIS subtype schema mapping rules. You can use the AIXMtoESRI_Subtype.csv file located in the ArcGIS for Aviation installation directory. | File |
SDEDestDataset |
This is the name of the destination geodatabase that contains the AIS schema. | String |
SDEServer |
The enterprise geodatabase server name. | String |
SDEInstance |
The port or instance number for the geodatabase. | String |
SDEUserName | A valid database user name. This user must have SELECT, INSERT, UPDATE, and DELETE permission in the SDEDestDataset. | String |
SDEPassword |
Database password. | String |
SDEVersion |
The geodatabase version name. | String |
destcoordsys (Optional) |
The spatial reference on the AIXM data in the Destination Enterprise Geodatabase. | Spatial Reference |
Code Sample
The following Python window script demonstrates how to use the ImportAIXM45toAIS function.
# source AIXM xml data
srcAIXM = "\\\\server_name/GNAV_Aero/AIXM_Update_Obstacles.xml"
# attribute schema map
attributeSchemaMap = "C:/Program Files/ArcGIS/ESRIAeronautical/Desktop10.1/DataExchange/AIXM/SchemaMapper/AIXMtoESRI_Attribute.csv"
# subtype schema map
subtypeSchemaMap = "C:/Program Files/ArcGIS/ESRIAeronautical/Desktop10.1/DataConversion/AIXM/SchemaMapper/AIXMtoESRI_Subtype.csv"
# destination dataset
sourceDataset = "ASP_PL"
# connection properties
server = "127.0.0.1"
instance = "sde:sqlserver:127.0.0.1/sqlexpress"
user = "username"
pwd = "password"
version = "DBO.DataUpdates"
# execute the import
arcpy.ImportAIXMtoAIS_aviationmanagement(srcAIXM,attributeSchemaMap,subtypeSchemaMap,sourceDataset,server,instance,user,pwd,version)