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.
Follow the steps below to create connection lines between two or more points on a map.
- Insert the XY data into ArcMap.
- Select the correct coordinate system and X and Y Fields.
- Save the points permanently.
- Right-click the event layer, and select Data > Export Data.
- Click the Browse button to select a location and name for the new file.
- Set the file type as shapefile or feature class.
- Click Save, and click OK.
- Go to ArcToolbox > Data Management Tools > Features > XY to Line.
- 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.
- Run the XY to Line tool.