TransWikia.com

Appending two Joined layers

Geographic Information Systems Asked on May 18, 2021

I have two polyline shapefiles, Green and Gold which are supposed to match but don’t. Gold is larger than green, and slightly offset. Some line IDs are a match, but other IDs have been changed.
enter image description here

I am trying to combine these in ArcGIS with the following steps:

  1. "Join" Gold to Green (Green target) on ID = segment_id
  2. Select all Green segments where segment_id is not null and create "matched_segments" layer
  3. Select all Green segments where segment_id is null and create "unmatched_segments" layer; delete joined attributes
  4. "Spatial Join" Gold to "unmatched_segments" layer to create "unmatched_spatial_map" layer
  5. Combine "unmatched_spatial_map" and "matched_segments" into one layer and export

At step 4 (completed) I have two layers where each segment is contained in either one layer or the other (not shared) and would like to combine them to one layer with Append (from Data Management Tools). This is not working. "pipes_matched" has the prefix ‘gold’ for all the field names which were joined from the input file, and the field name is greyed out and unable to edit. When I run Append with ‘Input fields must match target fields’ I get ERROR 000466 for schemas that don’t match. When I run with ‘Use the field map to reconcile field differences’ I also get an error.

How can I solve this so that I have a single layer (to export to a shape file) which is joined with the gold GIS data on ID when there is a map and on the closest pipe when there isn’t?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP