Join attributes from XY table to point features in ArcGIS Pro and export as CSV

Summary

Joining attributes from an XY table to point features in ArcGIS Pro involves linking spatial data from a tabular format to geographic locations based on coordinates. This process integrates tabular data, such as survey results or GPS logs, with spatial data to analyze and visualize them in a geospatial context.

This article describes the workflow to join attributes from an XY table to point features in ArcGIS Pro and export them as a CSV file.

Procedure

1. Open the ArcGIS Pro project consisting of the point features.
2. Convert the XY table to point features using the Coordinate Table To Point tool.
   1. On the Analysis tab, in the Geoprocessing group, click Tools.
   2. In the Geoprocessing pane, search for and click Coordinate Table To Point (Defense Tools).
   3. In the Coordinate Table To Point pane, for Input Table, click Browse and select the Excel file containing the coordinate values.
   4. For Input Coordinate Format, specify the coordinate format for the input table. In this example, Degrees, Minutes, and Seconds - Two Fields is specified.
   5. For X Field (longitude, UTM, MGRS, USNG, GARS, GEOREF), select the longitude field from the drop-down list.
   6. For Y Field (latitude), select the latitude field from the drop-down list.
   7. For Output Point Feature Class, specify a name and location.
   8. For Input Coordinate System, click Select coordinate system to open the Input Coordinate System window.
   9. Expand Projected Coordinate System or Geographic Coordinate System to specify the coordinate system. In this example, WGS 1984 Web Mercator (auxiliary sphere) is specified. Click OK.
   10. Click Run.

Note:
Alternatively, use the XY Table To Point tool to convert tables containing x-, y-, and z-coordinates into point feature classes.

3. Combine the attributes based on spatial relationships using the Add Spatial Join tool.
   1. In the Contents pane, right-click the point feature layer and click Joins and Relates > Add Spatial Join.
   2. In the Add Spatial Join window, for Join Features, select the output point feature layer from Step 2.
   3. For Match Option, select the preferred criteria to match the rows. In this example, Are identical to is selected.
   4. Click OK.

4. Export the point feature attribute table to a CSV file using the Export Table tool.
   1. On the Analysis tab, in the Geoprocessing group, click Tools.
   2. In the Geoprocessing pane, search for and click Export Table (Conversion Tools).
   3. In the Export Table pane, for Input Table, select the output point feature layer in Step 3 from the drop-down list.
   4. For Output Table, specify a name and add the .csv file extension at the end of the name. Click Browse and specify its location.
   5. Click Run.

The CSV table is generated based on the spatial relationship of the XY table and point features.