topic Re: Multiple polyline vertex coordinates in single row in Data Management Questions

Multiple polyline vertex coordinates in single row

DavidPOLASEK — Thu, 02 Apr 2020 13:38:21 GMT

Hello,

I'm using Arcmap 10.4. and I'd like to add XY coordinates to my polyline feature vertices, without creating a row for every vertex (as with Feature Vertices To Points) or only adding start, mid and end coordinates of the lines (as with Add Geometry Attributes). The idea is to have curvilinear lines separated by rows, with all of the vertices coordinates in different columns, in order to group every vertex of a line on the same row.

Would anybody know how to do this?

Thank you

Re: Multiple polyline vertex coordinates in single row

JoshuaBixby — Thu, 02 Apr 2020 18:41:41 GMT

The idea is to have curvilinear lines separated by rows, with all of the vertices coordinates in different columns,

So, how many vertices are you talking about? If you have a lot, having different columns for each vertex will quickly lead to issues. Also, how do you plan to deal with lines that have different number of vertices?

Re: Multiple polyline vertex coordinates in single row

DavidPOLASEK — Fri, 03 Apr 2020 05:58:49 GMT

The polylines are interpreted fracture traces on remote sensing data. They don't contain more than 5 vertices, as they are usually quite straight, so the amount of columns wouldn't be so big.

If the fields can bear null values, the different number of vertices by polyline should not be a problem, shouldn't it? The next step of my workflow is to export the table as an excel file to further process it.

Re: Multiple polyline vertex coordinates in single row

DavidPOLASEK — Sat, 04 Apr 2020 06:52:59 GMT

Thank you for your answer Joshua Bixby. I finally found a solution by converting the vertices into points (Feature Vertices to Points), adding XY coordinates and converting the table in a .csv file that was processed with an R script.

I am sorry for the time you have lost. I should have thought about other solutions before asking this question!

Re: Multiple polyline vertex coordinates in single row

JoshuaBixby — Sat, 04 Apr 2020 12:42:25 GMT

David, glad you found a solution, and no worries about asking your question on GeoNet. Part of finding a solution can be having others ask you more questions to get you thinking about the problem differently, and GeoNet is here to help.