# Connecting lines

388
1
04-24-2017 08:19 AM
Labels (1)
New Contributor

I have a lat long points and I need some script or some kind of function to connect this point from start to finish....??

61 12 44.4N 109 58 34.9W
62 18 02.1N 108 58 58.5W
63 10 48.9N 108 09 10.8W
64 13 07.0N 107 01 47.5W
64 37 51.2N 106 23 07.2W
64 46 07.3N 106 10 24.7W
64 00 17.5N 105 47 54.9W
64 05 05.0N 105 40 14.9W
65 17 50.5N 105 22 36.3W
65 35 10.7N 104 58 21.5W
65 44 58.9N 104 44 30.4W
65 57 28.9N 104 23 58.0W
65 19 09.4N 103 47 48.5W
65 27 02.8N 103 34 50.2W
65 38 48.0N 103 18 50.9W
65 06 27.6N 102 41 18.8W
66 13 55.7N 102 11 37.1W
66 31 26.8N 100 59 22.3W
66 39 52.2N 100 33 28.5W

MVP Frequent Contributor

There are several ways to do this.  Here's one workflow:

1.  Put the Lat Longs into an Excel spreadsheet.

2.  Convert the Lat Longs to decimal degrees.  Decimal Degrees = Degrees + (Minutes/60) + (Seconds/3600).

3.  Add a new field and then number the Lat Long coordinate pairs in the sequence they need to be connected.  For example, fieldname "SortOrder", then number each 1, 2, 3, etc in the order that they should be connected.

4.  Follow this process (Add XY Data) to add the data to ArcGIS.  This will create a point for each coordinate pair.

5.  The added data will be in what is called an Event layer in ArcGIS.  Note that this is a temporary layer.  Right-click and Data, Export Data to save off a permanent copy of the points.

6.  Run the Points To Line geoprocessing tool on the point features, being sure to specify for the Sort Field (optional) the field name that has the order of the points so the lines are drawn in the correct order (which was created in step 3 above).  For example, I called the field "SortOrder".

Note - places where things go awry commonly happen at step 4, as formatting in Excel can be a culprit.  If that happens, post here what went awry and we can troubleshoot it.

Also - an overview article of the same process:

Chris Donohue, GISP