Select to view content in your preferred language

Need Help - Combining 3 Point Different Point Layers

191
2
07-14-2025 01:02 PM
Labels (2)
bennein
New Contributor

Hello,

I have a problem I've been trying to find a solution to, and I was hoping I could find some extra help or direction.

Scenario

I have 3 different point feature layers. Each layers represents a location of a mobile home park in the state of Pennsylvania. Each layer also has valuable attribute information. My goal is to have 1 comprehensive point feature layer that has no identical points and all of the attribute information from each layer.

My Issues. Each layer was assembled using a different method. Layer A has points created by using parcel centroids for the state. Layer B was assembled using address points (placed on the street the parcel connects too). Layer C assembly method is unknown. From looking at aerial imagery and comparing it to the other two layers, it seems as though the points are randomly plotted anywhere inside the parcel of the mobile home park. 

Tools I've tried: Merge Append, Spatial Join.

More Issues. There is no identical field relating these three layers (No ID, ADDRESSES, ETC). Due to the position of the points 1 point might be closer to the parcel centroid of an entirely different mobile home park then it's matching mobile home park in another layer. This affects accuracy using a spatial join.

I'm attempting to find point features that aren't included across all three layers so I can have the most comprehensive layer. However, I can't use a buffer because the distance between matching mobile home parks between the three layers can range from 0 - unknown distance. There are over 2000 features in my dataset. 

I'd appreciate any help or advice.

 

2 Replies
DanPatterson
MVP Esteemed Contributor

Merge (Data Management)—ArcGIS Pro | Documentation  with field mapping specifications

and based on your criteria of what constitutes duplicates

Find Identical (Data Management)—ArcGIS Pro | Documentation

and if you want to get rid of them

Delete Identical (Data Management)—ArcGIS Pro | Documentation


... sort of retired...
0 Kudos
RTPL_AU
Honored Contributor

@bennein 
You only have 2000 points so don't over think it.
Take it step by step.

Create your destination layer schema with the attributes you want it to contain. Make sure it has a field to record where a point comes from.

Review your 3 layers and decide which seems the most accurate. Append it to the destination layer and use the field map to match source & destination fields.

Then overlay the second, use symbology and/or proximity tools to refine and select the next lot of points you want to append.

I would add a field to the 3 datasets that can be set to include/exclude/review or similar comments. 

Repeat and review until you have a complete set. This should take an hour or so to do.

Searching for the 'ideal' tool to do it automagically can take as long or longer, and you will still need to verify the result in some way.

If this was 20,000 points I would spend more time to develop a model as doing it the 'hard' way is then the slow way.

0 Kudos