topic Re: Copy Attribute Data Between Similar Line Files in Data Management Questions

Copy Attribute Data Between Similar Line Files

JenniferBergstrom — Wed, 02 Mar 2022 19:46:37 GMT

I have a situation where I have 2 different road files (line files). One is the State road file, and one is our Highway Dept. road file. They were created separately by different organizations and do not spatially match each other, but are similar. I need to copy attribute fields from the State road file and copy into the Highway Dept. road file. Is there a way to do this?

I am using ArcGIS Desktop 10.5.1. Any help is appreciated!

Re: Copy Attribute Data Between Similar Line Files

DanPatterson — Wed, 02 Mar 2022 19:48:30 GMT

A spatial join might work if the geometry is similar

Re: Copy Attribute Data Between Similar Line Files

DavidPike — Wed, 02 Mar 2022 20:17:06 GMT

Same as Dan I can only think of a spatial join using the CLOSEST argument. You're still going to have a nightmare of incorrect segment attribution. Densifying the lines initially would help but there could be lots of potential issues.

Re: Copy Attribute Data Between Similar Line Files

JenniferBergstrom — Wed, 02 Mar 2022 20:50:15 GMT

Thank you! I will try this.

Re: Copy Attribute Data Between Similar Line Files

JenniferBergstrom — Wed, 02 Mar 2022 23:28:25 GMT

Unfortunately, the State Road layer that I need to copy attributes from is cut up into different segments (with unique fields) than my Hwy Road layer. I somehow need to cut my Hwy Road layer into segments to match the State Road layer and then copy the attributes.

Re: Copy Attribute Data Between Similar Line Files

DavidPike — Thu, 03 Mar 2022 13:06:17 GMT

Possibly Densify (Editing)—ArcGIS Pro | Documentation or generate points along lines then split line by point.

then re-run the spatial join. You may also want to dissolve by road name at the end.