51ExportRelationships

Available with Aviation Charting license.

The 51ExportRelationships.json file defines the AIS table queries that produce the related table data used as input to the 51ExportTemplate.xml file. These AIS table queries must be organized around a primary AIS table. Related data is used to join the related tables in the 51ExportRelationships.json file.

51ExportRelationships.json

In the 51ExportRelationships.json file, queries are organized around a primary AIS table and joined with related tables to create related data. Combined with the primary table data, the data from these queries are converted to the 51ExportTemplate.xml file format.

Caution:

It is recommended that you create backup copies of the outlined configuration files before editing them to avoid data loss.

Each entry for a primary table is structured as follows:

{
  "primarytable_a": [
    {
      "fields": [
        "primarytable_a.objectid",
        "relatedtable_a_1.objectid",
        "relatedtable_a_1.field_1",
        "relatedtable_a_1.field_2"
      ],
      "tables": ["primarytable_a", "relatedtable_a_1"],
      "where": "primarytable_a.gfid = relatedtable_a_1.joining_id"
    },
    {
        "fields": [
          "primarytable_a.objectid",
          "relatedtable_a_2.objectid",
          "relatedtable_a_2.field_1"
        ],
        "tables": ["primarytable_a", "relatedtable_a_2"],
        "where": "primarytable_a.gfid = relatedtable_a_2.joining_id"
      }    
  ]
}

Example

The example below shows two queries organized around the adhp primary table. The first query creates related data from the adhp table joined with the address table. The second query creates related data from the adhp table joined with the orgauth table.

Note:

This example was shortened for clarity.

{
  "adhp": [
    {
      "fields": [
        "adhp.objectid",
        "address.objectid",
        "address.type_code",
        "address.title_txt",
        "address.name_txt",
        "address.clientkey_id"
      ],
      "tables": [
        "adhp",
        "address"
      ],
      "where": "adhp.gfid = address.addressee_id"
    },
    {
      "fields": [
        "adhp.objectid",
        "orgauth.ident_txt",
        "orgauth.name_txt",
        "orgauth.type_code",
        "orgauth.military_code",
        "orgauth.clientkey_id"
      ],
      "tables": [
        "adhp",
        "orgauth"
      ],
      "where": "adhp.orgauth_id = orgauth.gfid"
    }
  ]