topic Re: How to combine two road datasets with different attributes? in Geoprocessing Questions

How to combine two road datasets with different attributes?

GaryO_Brien — Wed, 06 Jul 2016 10:17:51 GMT

I'm using ArcGIS 10.3 for desktop.

I have two shapefiles, both with polyline vector data for roads in the same area. This area is quite large, approximately 7,500 km², so there are a lot of roads in both files. One of the datasets contains condition rating information for the roads, the other has the width of the roads. It is necessary for me to combine these two files together so as to have the attributes in the same shapefile to work on.

The width dataset contains more roads and is better in terms of connectivity than the condition dataset. I have tried creating a buffer around the condition data then using the Identity tool to combine that data with the width data that overlays it. However this creates a lot of slivers of road at junctions that need to be corrected manually. While this is okay for a small area it is unworkable if I scale up to the whole county area. Is there a way of fixing this? Or is there a better way to combine the line datasets?

Re: How to combine two road datasets with different attributes?

DanPatterson_Retired — Wed, 06 Jul 2016 11:54:03 GMT

Are you tryin to combine geometry as well as attributes?

Append—Help | ArcGIS for Desktop

Re: How to combine two road datasets with different attributes?

GaryO_Brien — Wed, 06 Jul 2016 12:03:43 GMT

Hi Dan,

No I'll use the width dataset for geometry as this is more complete and better in terms of connectivity. Therefore I want to move the attributes of the condition dataset over to the width dataset with the line vector split accordingly.

Re: How to combine two road datasets with different attributes?

George_Thompson — Wed, 06 Jul 2016 13:08:58 GMT

Hi Gary,

Maybe look at a join and then exporting the joined feature class.The you could modify the exported file as needed. This could then be scripted if needed.

About joining and relating tables—Help | ArcGIS for Desktop

Add Join—Help | ArcGIS for Desktop

Re: How to combine two road datasets with different attributes?

TedKowal — Wed, 06 Jul 2016 16:02:41 GMT

I would like to add on to George Thompson comment..

Some things to consider when planning on the joins ...

Common identifier between both roads sets (For the Join)
Segmentation of the road sets. (One may be split by change in width, the other split by intersections for example)
1. You may have to spent some effort in merging line segment into a "common rule" for both to avoid many to many relationships.
Need to identify how you are going to deal with road data/geometry found in one set and not in the other (Sorry you will still have to deal with geometries... at least the rules on how the data is applied over the geometries)

This can be a messy operation if the rules for both data sets are dramatically different. Outside of simple joins, there are no real templates to follow.