topic Re: Create lines at specific bearing in ArcGIS Pro Questions

Create lines at specific bearing

TinaKwitkoski — Wed, 25 Aug 2021 22:50:19 GMT

I am wondering if there is a script that will create multiple lines based on the bearing and coordinates of a point feature held in a XLS.

What I am trying to do is create slope arrows for a cruise plan map. I have a slope table (xls), with ID, Length, Bearing, Slope%, Easting, Northing. Currently I create each line using the create line => Direction, length using the xls which is fine if I have only a few. But when I have 50+ to create it is time consuming. It would be nice to run a script/tool to create my lines automatically.. is there such a thing out there? I searched online did not see anything helpful.

Any help much appreciated.

Tina

Re: Create lines at specific bearing

DanPatterson — Wed, 25 Aug 2021 23:17:53 GMT

perhaps Bearing Distance To Line (Data Management)—ArcGIS Pro | Documentation

if the data are in, or can be derived, in your table

Re: Create lines at specific bearing

JohannesLindner — Thu, 26 Aug 2021 08:32:46 GMT

Can you please provide an example table (snippet) and the result you want to create?

Re: Create lines at specific bearing

TinaKwitkoski — Fri, 27 Aug 2021 15:07:11 GMT

Johannes, I have attached a snip of the final product. Essentially I need to produce lines (in this case 40m long) starting at the plot drawn in the direction of the bearing given to me, then that line is displayed with a arrow symbol and labelled with the slope of the land in the direction of the line.

Currently the only way I know how is to create each line using the draw line tool => direction/distance.

Tina

Re: Create lines at specific bearing

TinaKwitkoski — Fri, 27 Aug 2021 15:10:17 GMT

I will try that one thanks..

Re: Create lines at specific bearing

TinaKwitkoski — Fri, 27 Aug 2021 15:47:11 GMT

I tried this tool and get an error message, not sure why.. any ideas?

Re: Create lines at specific bearing

DanLee — Fri, 27 Aug 2021 17:13:47 GMT

Hi Tina,

The csv screenshot seems fine, but the error message complains about OID -1. Would you be able to share the file so I can take a look? Thanks! - Dan

Re: Create lines at specific bearing

DanPatterson — Fri, 27 Aug 2021 17:51:53 GMT

Did you try converting the csv to a file geodatabase table?

Re: Create lines at specific bearing

TinaKwitkoski — Fri, 27 Aug 2021 19:10:19 GMT

Dan, here you go. As mentioned above I did try converting to a table in the geodatabase as well still same error.

Re: Create lines at specific bearing

DanLee — Fri, 27 Aug 2021 20:07:24 GMT

Hi Tina, which version of Pro are you using?

Re: Create lines at specific bearing

TinaKwitkoski — Fri, 27 Aug 2021 20:48:54 GMT

Dan

2.8.0 for Pro.

Re: Create lines at specific bearing

DanLee — Sat, 28 Aug 2021 21:39:28 GMT

Hi Tina,

Thanks for sharing the test data. We have tested in 2.6, 2.8, and our current development versions, but could not reproduce the problem.

I noticed the OBJECTID values are not sequential. That should not matter. But you can try using Copy Rows tool to turn it to a gdb table, then run Bearing Distance To Line. Hope that works.

Re: Create lines at specific bearing

JohannesLindner — Mon, 30 Aug 2021 07:09:56 GMT

Hmm, the tool worked for me...

Try constructing the lines yourself: edit the input and output parameters of this script and run it in the python window.

import logging # define input data in_table = "H:/testCruise_data_DDS.csv" field_x = "Long" field_y = "Lat" field_distance = "distance" field_bearing = "bearing" wkid = 4326 # wkid of your data's coordinate system # define output data out_path = "memory" out_name = "test" out_fields = [ # list of [field_name, field_type] ["PLOT_ID", "LONG"], ["TYPE", "TEXT"], ["slope", "FLOAT"], ["bearing", "FLOAT"], ["Long", "FLOAT"], ["Lat", "FLOAT"], ] # read data fields = [f.name for f in arcpy.ListFields(in_table)] data = [dict(zip(fields, row)) for row in arcpy.da.SearchCursor(in_table, fields)] # construct lines spatial_reference = arcpy.SpatialReference(wkid) for d in data: try: point = arcpy.Point(d[field_x], d[field_y]) point_geometry = arcpy.PointGeometry(point, spatial_reference) target_geometry = point_geometry.pointFromAngleAndDistance(d[field_bearing], d[field_distance]) point_array = arcpy.Array([point_geometry.firstPoint, target_geometry.firstPoint]) line_geometry = arcpy.Polyline(point_array, spatial_reference) d["SHAPE@"] = line_geometry except: # e.g. bearing or distance are empty logging.exception("Could not create line for this row: {}".format(d)) d["SHAPE@"] = None # create output fc # skip this if you already have a line fc that you want to append to out_fc = arcpy.management.CreateFeatureclass(out_path, out_name, "POLYLINE", spatial_reference=spatial_reference) for f in out_fields: arcpy.management.AddField(out_fc, f[0], f[1]) # write the lines into out_fc fields = ["SHAPE@"] + [f[0] for f in out_fields] with arcpy.da.InsertCursor(out_fc, fields) as cursor: for d in data: values = [d[f] for f in fields] cursor.insertRow(values)

Re: Create lines at specific bearing

BillFox — Mon, 30 Aug 2021 20:31:47 GMT

sounds similar to a COGO traverse file,

https://pro.arcgis.com/en/pro-app/latest/help/editing/import-or-export-a-traverse-file.htm

https://desktop.arcgis.com/en/arcmap/latest/manage-data/creating-new-features/traverse-file-format.htm

Re: Create lines at specific bearing

DanPatterson — Mon, 30 Aug 2021 22:35:42 GMT

As suggested earlier, excel to table or table-to-table tool with the output as a file geodatabase table, then run the tool which I suggested and Dan Lee confirmed works, unless the data fields are in the wrong format or the data content needs adjusting.