Calculate the start and end points of line features using Arcade in Portal for ArcGIS and ArcGIS Online Map Viewer

Summary

It is sometimes necessary to calculate and populate the XY coordinate data of the start and end point of a line feature in an attribute table. However, this task is time-consuming if there are many line features in the web map. This task can be automated using an Arcade expression. This article provides the workflow to calculate the XY data of line features into an attribute table using an Arcade expression in Portal for ArcGIS and ArcGIS Online Map Viewer.

Procedure

1. Log in to Portal for ArcGIS or ArcGIS Online and click Content > My Content.
2. Browse to and click the hosted feature layer to open the item details page.
3. Add four new String or Double fields to populate the XY data of the line features. Refer to Portal for ArcGIS: Add a field or ArcGIS Online: Add a field for instructions. The fields are added to populate the values of the start point of the x-coordinate, start point of the y-coordinate, end point of the x-coordinate, and end point of the y-coordinate of the line features.

The following image shows the four newly created fields for the XY coordinates of the start and end points of the line features.

4. Configure the XY coordinates of the start point of the line features.
   1. Click the field header of the start point of the x-coordinate, select Calculate from the drop-down list and click Arcade.
   2. Copy and paste the following Arcade expression into the Expression box and click Test.

Geometry($feature).paths[0][0].x

3. When the Results tab displays the x-coordinate, click OK.

4. Repeat Step 4a to Step 4c for the start point of the y-coordinate. Replace 'x' with 'y' from the Arcade expression above.

5. Configure the XY coordinates for the end point of the line features.
   1. Click the field header of the end point of the x-coordinate, select Calculate from the drop-down list and click Arcade.
   2. Copy and paste the following Arcade expression into the expression box and click Test.

Geometry($feature).paths[-1][-1].x

3. When the Results tab displays the x-coordinate, click OK.

4. Repeat Step 5a to Step 5c for the end point of the y-coordinate. Replace 'x' with 'y' from the Arcade expression above.

The image below shows the XY coordinates of the start and end points of the line features in the attribute table in Portal for ArcGIS.