Skip to main content
Question

Convert multiple points with the same geometry to single point containing all attributes

  • November 29, 2012
  • 4 replies
  • 237 views

Hi all,

 

 

I have a point dataset that in some cases contains multiple points in the same location. In those cases only , I would like to do two things: 1. merge the points in to a single point and 2. join the attributes of all the merged points and assign them to the attribute table of the single point (denormalize the data). 

 

 

The reason I am doing this is because I would like to add labels to the points in ArcMap 10.0 but Maplex does not have a clean way to label multiple points with the same geometry so I figure that if the data was denormalized I could then create a label that ecompasses many fields but that stacks them neatly.

 

 

Thank you very much in advance for any assistance you can provide.

 

 

4 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • November 29, 2012
Hi,

 

I would try the following:

 

Use a deaggregator to isolate the points (when having the same geometry) then use a sampler grouped by the ID to get 1 point. 

 

 

For the attribute I would try the attributeaccumulator grouped by the multipoint ID and merge it with the single point.

 

 

Hope this helps.

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 2, 2012
Hi,   I think getting the list containing all attributes of the points on the same location is suitable. How about the following way:   1. Create non-duplicated point features Aggregate multiple points on the same location by NeighborhoodFinder. Connects [NEIGHBORS] to AggregateFilter. Aggregated features comes from [AGGREGATE] of AggregateFilter, non-aggregated features (those are single points originally) comes from [NOT_AGGREAGTE]. Then, for extracting a point from each aggregated feature, use Deaggregator and Tester. Deaggregator sets "_part_number" (0-based index in the original aggregated feature) to each deaggregated feature, so it's possible to extract the first point of each aggregated feature by testing whether _part_number is 0 or not.   2. Get the list of the original point attributes in the same location Put a NeighborFinder. Connect both of AggregateFilter's [NOT_AGGREGATE] and Tester's [PASSED] to [BASE] of the NeighborFinder, and connect the stream of the original points to [CANDIDATE]. Set "Close Candidate List Name" parameter of the NeighborFinder (e.g. _points). Point features which come from [MATHCED] port are single points and they save the list containing attributes of the original points on the same location.

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 2, 2012
Oops!  there is an error.

 

 

error: "NeighborhoodFinder" --> correct: "NeighborhoodAggregator"

  • Author
  • December 5, 2012

Thank you both for your input. I tried both methods but couldn't replicate your ideas in to the model I was creating as there were just too many parameters that I couldn't decipher. Fortunately I was able to find a quick solution in ArcGIS Desktop in the time since. 

 

Thanks again

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings