HOW TO

Join CSV data into a polygon feature layer and export the dataset as a GML file in ArcGIS Pro

Last Published: September 9, 2021

Summary

In ArcGIS Pro, multiple layers or tables can be joined into a single table. The joined dataset table can be exported into any format supported by the ArcGIS Data Interoperability extension. This article provides two workflows to first join data layers with data tables, then export the dataset as a GML file in ArcGIS Pro.

In this example, the user is joining the HK2016 Census CSV standalone table to the HKDistrict18 feature layer, then exporting the feature layer as a GML file.

Procedure

Use the Add Join (Data Management) tool to join the data layers to the data table

The Add Join (Data Management) tool joins a layer table to another layer table based on a similar field.

  1. Open the ArcGIS Pro project.
  2. In the Contents pane, right-click the feature layer and click Attribute Table to display the layer data.
  3. Right-click the CSV standalone table and click Open to display the census data.
Both tables of the feature layer and the CSV standalone table open in ArcGIS Pro to identify the two fields to be joined
  1. Ensure there are similar field data among the two field tables to join.
  2. In the Contents pane, right-click the feature layer and click Joins and Relates > Add Join.
Selecting Add Join from the feature layer in the Contents pane
  1. In the Add Join dialog box, configure the following parameters.
    1. For Input Table, select the feature layer.
    2. For Input Join Field, select the field with a similar field data to the standalone table.
    3. For Join Table, select the standalone table.
    4. For Join Table Field, select the field with a similar field data to the feature layer.
The Add Join dialog box with the parameters set
  1. Click OK.

The census data is added to the feature layer table as shown in the image below.

The updated feature layer table

Use the Quick Export (Data Interoperability) tool to export the dataset as a GML file

The Quick Export (Data Interoperability) tool converts the input feature layers into other formats supported by the ArcGIS Data Interoperability extension.

Note:
The Quick Export (Data Interoperability) tool has limited usage for Basic, Standard or Advanced licenses. The Data Interoperability license is required to install and run the extension tool.
  1. In the ArcGIS Pro ribbon, click View > Geoprocessing to open the Geoprocessing pane.
Selectign Geoprocessing from the View tab in the ArcGIS Pro ribbon
  1. In the Geoprocessing pane, click Toolboxes > Data Interoperability Tools > Quick Export.
Selecting the Quick Export tool from the Data Interoperability Tools toolbox in the Geoprocessing pane
  1. In the Quick Export tool pane, for Input Layer, select the joined feature layer.
  2. Click the folder icon of the Output Dataset to open the Specify Data Destination dialog box.
The Quick Export tool pane with the joined feature layer selected as the Input Layer and the folder icon to open the Specify Data Destination dialog box
  1. In the Specify Data Destination dialog box, for Format, click the drop-down menu, and select OGC CityGML.
  2. For the Dataset: description, click the ellipsis icon and define the export location of the GML file. Ensure CityGML Files (*.gml) is selected for Save as type:.
  3. Click Save.
  4. Click OK.
The Specify Data Destination and file folder dialog box with OGC CityGML selected as the format
  1. At the bottom of the Quick Export tool pane, click Run.
Clicking Run in the Quick Export tool pane

Article ID: 000026198

Software:
  • ArcGIS Pro 2 8 x
  • ArcGIS Pro 2 7 x
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options