Display XY Data from table with 2 sets of lat/longs

12-12-2018 10:13 AM
Occasional Contributor III


I found the below info from ESRI technical support which has a similar example to what I want to do including the table below with start/stop lat/longs so essentially 1 start point and 1 stop point in the same row. The overall goal is similar to create lines between the start and stop points. What I'm having trouble understanding in this example is the procedure 2b only shows to 'Select the X and Y values in the X and Y Fields'. Unless I'm missing something you can only select 1 X field and 1 Y field correct? There is no mention of running the tool twice but yet the output shown below shows both the start/end points? Can someone let me know what I'm missing? Originally I was going to create start/end point feature classes but below is ideal to have the data as it is shown in the table so lines can be connected using that tool.

Thanks in advance!,


How To: Create connection lines between two or more points


The instructions provided describe how to create connection lines between two or more points in ArcMap. For example, seismic lines data spreadsheet usually consists of start and end point locations, representing the seismic lines to be shot in a survey. In ArcMap, it is possible to generate a set of lines from these points using the XY To Line tool.

To ensure the lines that generated in ArcMap are accurately located, the attribute table must contain the latitude and longitude of the start and end point features, as illustrated in the example below.

Excel table with required fields


Follow the steps below to create connection lines between two or more points on a map.

  1. Insert the XY data into ArcMap.
  2. Select the correct coordinate system and X and Y Fields.
    1. Right-click the particular layer in the data table, and select Display XY Data.

      Display XY data in ArcMap
    2. Select the X and Y values in the X and Y Fields.
    3. Click Edit to define a correct coordinate system.
    4. Click OK twice. The points are now added to the map as a layer in the Table of Contents.
  3. Save the points permanently.
    1. Right-click the event layer, and select Data > Export Data.
    2. Click the Browse button to select a location and name for the new file.
    3. Set the file type as shapefile or feature class.
    4. Click Save, and click OK.

      Points displayed after permanently saved with modified symbology as desired.
    5. Go to ArcToolbox > Data Management Tools > Features > XY to Line.
    6. Using the new shapefile or feature class created in Step 5, enter in the Start X-coordinate field, Start Y-coordinate field, End X-coordinate field, and End Y-coordinate field of the table.

      Parameters filled in the XY To Line tool
    7. Run the XY to Line tool.

      Output for the XY To Line tool
0 Kudos
1 Reply
MVP Emeritus

In your case do you have a table with 2 x and y fields?

If you have separate point files which represent 'from' and 'to' points that share a common id key, then you could join them, so that they are together and use the procedure.