How do you connect SHL and BHL through an Excel import?

CarrieAlison

I'm using Arc Map 10.4.  I have the SHL (surface hole location) and BHL (Bottom hole location) for a series of wells I need to post on a map.  I need to draw a connecting line between the SHL and BHL.  What tool do I use to do this?  Instructions?  I can't seem to find a  video or instruction on how to do this.

curtvprice

There is no out of the box tool to do this.

Seems to me the best approach would be to

1) Plot the two sets of wells from Excel on the map using the table to XY event  (the tool or in ArcMap by right clicking the table view)

2) Copy the two point feature classes to GIS data sets (recommend: file GDB). If they are in lat long, make sure the output is in a projected coordinate system where distances make sense, like UTM or Albers. Also make sure the two feature classes have a common ID, like WELL_ID, so you can match each SHL to its corresponding SHL point.

3) Run the AddXY tool to add X_COORD and Y_COORD to both point feature classes.

4) Run Copy Rows to make two tables one from each point feature class.

5) Merge these two tables together (Merge tool).

6) Run the Points To Polylines tool. Specify well ID as the group field. This should make your lines.